def test_has_motif(self): engine = get_engine('bio') load_regex_support(engine) p = Protein(refseq='NM_007', id=1, sequence='ABCDEFGHIJKLMNOPQRSTUVWXYZ') s = Site(position=3, residue='C', protein=p) db.session.add(s) db.session.commit() # Python side assert s.has_motif('.{7}C[DX].{6}') assert not s.has_motif('.{7}C[XY].{6}') # SQL side assert Site.query.filter(Site.has_motif('.{7}C[DX].{6}')).one() assert not Site.query.filter(Site.has_motif('.{7}C[XY].{6}')).all()