def get_by_genus_species(cls, genus=None, species=None): query = session().query(GenBankEntry) if genus is not None: query = query.filter(GenBankEntry.Genus == genus) if species is not None: query = query.filter(GenBankEntry.Species == species) return query.all()
def get_next_sequence_id(genbank_id): previous_entries = session().query(Sequence).filter(Sequence.GenBank_ID == genbank_id).all() if len(previous_entries): next_sequence_id = max([entry.Sequence_ID for entry in previous_entries]) + 1 else: next_sequence_id = 0 return next_sequence_id
def get_for_genbank_id(cls, genbank_id): return session().query(Sequence).filter(Sequence.GenBank_ID == genbank_id).all()
def insert(self): session().add(self) session().commit()
def exists(genbank_id): query = session().query(GenBankEntry).filter(GenBankEntry.GenBank_ID == genbank_id) return query.count() == 1
def get_by_silk_type(cls, silk_type=None): query = session().query(GenBankEntry) if silk_type is not None: query = query.filter(GenBankEntry.Silk_Type == silk_type) return query.all()
def all(self): return session().query(GenBankEntry).all()