X-Git-Url: https://vcs.maemo.org/git/?a=blobdiff_plain;f=database%2FSQLite.py;h=a38a7068edeb12b932b7a8aa97841ba2566a2685;hb=9b60aeea042273bde435eb9b4f5d96d2090766f6;hp=3b10611bb32d06292f583f504125b2eaeafc1988;hpb=577803de0c30366fd3f02c715e22641b394f4b0b;p=meabook

diff --git a/database/SQLite.py b/database/SQLite.py
index 3b10611..a38a706 100644
--- a/database/SQLite.py
+++ b/database/SQLite.py
@@ -1,3 +1,7 @@
+#!/usr/bin/python
+# -*- coding: utf-8 -*-
+
+
 import os
 import sqlite3
 
@@ -169,6 +173,17 @@ class SQLite:
                 items_dict[data_id][field_name] = field_value
         return items_dict
 
+    def get_files_by_pattern(self, pattern):
+        """Returns list of all files, matched pattern string."""
+
+        if not pattern:
+            return []
+        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()
+
     def get_entry(self, _id):
         """Returns full entry by it id."""