[BioSQL-l] update seqfeature

Martina boehme at mpiib-berlin.mpg.de
Wed Jun 22 05:24:08 EDT 2005


Hi Simon,

I'm changing the FeatureSource and in setFeatureSource an update on 
the source_term_id happens. In the case the combination is already 
there, I get an Exception. The proper way to deal with that would be 
to get the seqfeature_id of the entry already there and use that, or 
try to update the rank unless its a unique combination? Or should I 
rather not mess with the BioJava and delete that entry and insert it 
as new to let BioJava handle the rank increase?

Thanks for any advise

Martina

Simon Foote wrote:

> Hi Martina,
> 
> In fact you can, as rank is the field that allows this to happen.  In 
> Biojava, currently it's just a linearily incremented number such that 
> you can have the same type and source IDs for a given bioentry.
> 
> For example, adding a Genbank entry with 10 CDS features for 1 bioentry 
> will give you identical keys for bioentry_id, type_term_id and 
> source_term_id, but will have a rank of 1 - 10 for each.
> 
> Simon
> 



More information about the BioSQL-l mailing list