I actually just created this for a tweepository last night:

 

http://websci-tweets.ecs.soton.ac.uk/cgi/tweepository/highest_tweetid

 

Here’s what’s in the cgi scrtipt directory (you’ll just need to globally replace ‘tweet’ with ‘eprint’ in the mysql query):

 

use EPrints;

use strict;

 

my $eprints = EPrints->new;

my $repo = $eprints->current_repository;

exit( 0 ) unless( defined $repo );

 

my $format = $repo->param( "format" );

$format = "default" if( !defined $format );

 

my $sql = 'SELECT MAX(tweetid) FROM tweet';

 

my $sth = $repo->database->prepare($sql);

$sth->execute;

 

my $high_id = $sth->fetchrow_arrayref->[0];

 

 

if ($format eq 'commas')

{

        print scalar reverse join ',', unpack '(A3)*', reverse $high_id;

}

else

{

        print $high_id;

}

 

 

 

Try the database:

mysql> SELECT MAX(eprintid) FROM eprint;

mysql> SELECT counter FROM counters WHERE counterid = 'eprintid';

 

There's probably a way to get this via an EPrints session too if you need that?

 

Cheers,

John

 

 

 

Hello again!

 

New one here, related to a different project! So, I’m trying to find the HIGHEST EPrint ID that we have in our live system. I was doing this by taking the “Latest Additions” atom feed and looking at the topmost entry, however I have now realised this isn’t accurate as this could be representative of an item that has been sat in a work area for a number of weeks or even months. Is there an easy way, via endpoint or API access, that I could use to derive the highest number?

 

Andrew