X-Git-Url: http://git.maemo.org/git/?a=blobdiff_plain;ds=sidebyside;f=database%2FSQLite.py;h=2b6d3abc41e073aaca08c7930f142ae73a2a8475;hb=2b43c8f8e9d5f748b29a47f5d6fd7c0ca3722aaf;hp=e8d371b85fb045ef955d5c42f1f85594dd391082;hpb=cd16bb8f17c9b60994407f6a86352d11f7824536;p=meabook

diff --git a/database/SQLite.py b/database/SQLite.py
index e8d371b..2b6d3ab 100644
--- 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