[BioSQL-l] _removeSequence

Martina boehme at mpiib-berlin.mpg.de
Mon Jun 20 05:43:35 EDT 2005


Hi,

Im trying to delete a sequence and recursivly all its features.

So:

for (SequenceIterator si = db.sequenceIterator(); si.hasNext();) {
	Sequence s = si.nextSequence();
	String name = s.getName();
	s = null;
	db.removeSequence(name);
}

But if I look in the database (MySQL  4.1.12) I can still see plenty 
of entries and I have problems entering the same features again, 
because of dublicate key error. I would like to know if 
_removeSequence(String) in BioSQLSequenceDB is supposed to remove 
features recursivly or just the features of the removed sequence?
If so - what is the best way do delete the features of the features 
(and so on)? And how to empty the db completly?

Martina



More information about the BioSQL-l mailing list