def get_by_document(self, document):
ps = self.c.execute('SELECT * FROM document WHERE document=?',
(document, ))
try:
return CustomerModel.fromDB(c.fetchall()[0])
except IndexError:
return False
def search(self, **kwargs):
query = 'SELECT * FROM cutomers WHERE (' + self.build_query(
kwargs) + ')'
results = self.c.execute(query)
return [CustomerModel.fromDB(r) for r in results.fetchall()]
