implemented search by second name

diff --git a/database/SQLite.py b/database/SQLite.py
index e8d371b..2b6d3ab 100644 (file)
--- a/database/SQLite.py
+++ b/database/SQLite.py
@@ -178,8 +178,8 @@ class SQLite:
         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."""
@@ -191,4 +191,8 @@ class SQLite:
             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