From 2b43c8f8e9d5f748b29a47f5d6fd7c0ca3722aaf Mon Sep 17 00:00:00 2001 From: Max Usachev Date: Mon, 21 Jun 2010 13:33:56 +0300 Subject: [PATCH] implemented search by second name --- database/SQLite.py | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) 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 -- 1.7.9.5