stefandesu
commented
2 years ago This could be done in MongoDB like this:
db.getCollection('terminologies').aggregate([
{
$set: {
uriSuffixNumber: {
$function: {
body: function(uri) {
return parseInt(uri.substring(uri.lastIndexOf("/") + 1))
},
args: [ "$uri" ],
lang: "js"
}
}
}
},
{
$sort: { uriSuffixNumber: -1 }
},
{ $limit: 1 }
])This is O(N) though, so it has to go through all vocabularies in the database and is not using an index (currently taking about 160 ms in our BARTOC database, so it's not a big deal as long as the query is only used whenever a vocabulary is added). Also, the above query removes all additional fields, so if this is just an option for the sort parameter, it needs to return all data, of course. I will look into it tomorrow.
Edit: We can just use $set instead of $project to add a property.
Creation of new vocabulary entries in BARTOC requires to mint a new URI in the form
http://bartoc.org/en/$NUMBERwhere $NUMBER is guessed to be numerically the next (causing an error if the guessing did not work). I am not sure whether it makes sense to add support of such auto-increment URIs for concept schemes to jskos-server.As far as I remember, URIs are only minted (unless the new record already contains field
uri) for mappings and annotations based on UUID (in the client, seebin/import.jsor on the server, seeservice/{mappings,annotations}.js).Proposed solution: Support reverse sorting by numerical URI element at
GET /voc. The string used for numerical sorting (counter) isuri.substring(uri.lastIndexOf('/') + 1)and sorting is alway numerical descending, soGET /voc?limit=1&sort=counterwill return the vocabulary with highest counter in its URI.This allows client applications to assign numerically incrementing URIs to vocabularies.