From: Max Usachev <maxusachev@gmail.com>
Date: Mon, 21 Jun 2010 10:33:56 +0000 (+0300)
Subject: implemented search by second name
X-Git-Url: http://git.maemo.org/git/?p=meabook;a=commitdiff_plain;h=2b43c8f8e9d5f748b29a47f5d6fd7c0ca3722aaf;hp=cd16bb8f17c9b60994407f6a86352d11f7824536

implemented search by second name
---

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