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()
