Re: [Treebase-devel] [Treebase-guts] SF.net SVN: treebase:[687] trunk/treebase-core/db/cleaning

[William P. <wil...@ya...>]

On Apr 15, 2010, at 12:56 PM, Vladimir Gapeyev wrote:

> check that the PKids did not yet run past the ones that your script assigns

I see -- so you need to do a "SELECT max(taxon_id) from taxon" and check that it is less than my starting PK.  That sounds pretty easy to me -- I think I gave a fairly wide birth to insure that ongoing activity would not catch up to my starting PKs. 

> If ubio IDs are not unique enough

Unfortunately they are not because animal and plant names can share the exact same string, and uBio issues namebankids for each unique string. 

> If you can truly say this is the first and last request of this kind

Yes I can, in that for all future updates I'll use Hilmar's fancy SQL (once I learn from him how to do that).

In terms of your fte vs mine, how would you compare the effort required to reset Hibernate's two sequences (taxonvariant_id and taxon_id) at new levels vs the effort required to edit my 100+ lines of SQL?  It took me from 8 PM to 2 AM last night to write my SQL list (with several episodes of Mad Men running in the background). 

bp