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