EPrints Technical Mailing List Archive

Message: #04214

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: eprintid reassignment

On 11/05/15 15:19, Simon Jennings wrote:

One of our RDM project leaders who doesn't really want to see any gaps
in the id sequence. It's not really a functional requirement so I guess
its more of a question of how easy is it to do?


Is the repository used by just the one RDM Project?
If no, then their eprintids will be interspersed with other projects
Do they understand that eprintids are assigned when a new item is STARTED... so it that item doesn't complete, or get reviewed, there will be a gap between the prior and following [shown] records
There will be no *easy* way to do it.... it's basically assumed to be an auto-increment field - though I've not looked at the code that gets the next available ID to see: 
a) if it's a single core routine, or
b) how easy it would be to hack so it does some kind of lookup

..... but I raise the question "How will you find the first free hole?"
you'll either need to poke every eprintid from 1 until you find a hole, or do yet more hacking to somehow keep a track of ids that are made free 

--

Ian Stuart.
Developer: ORI, RJ-Broker, and OpenDepot.org
Bibliographics and Multimedia Service Delivery team,
EDINA,
The University of Edinburgh.

http://edina.ac.uk/

This email was sent via the University of Edinburgh.

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.