execute = self.conn.execute
field_id = execute("SELECT id FROM fields WHERE name=?", \
('cn',)).fetchone()[0]
- return execute("SELECT id, value FROM data WHERE value LIKE '%%%s%%' \
- AND field_id=? LIMIT 50" % pattern, (field_id,)).fetchall()
+ return execute("SELECT id, value FROM data WHERE value LIKE '%s%%' \
+ AND field_id=? LIMIT 50" % pattern.capitalize(), (field_id,)).fetchall()
def get_entry(self, _id):
"""Returns full entry by it id."""
field_name = execute("SELECT name FROM fields WHERE id=?", \
(field_id,)).fetchone()[0]
entry_dict[field_name] = value
+ sql_res = execute('select photo from photo where data_id=?', \
+ (_id,)).fetchone()
+ if sql_res is not None:
+ entry_dict['image'] = sql_res[0]
return entry_dict