From 9b12691ad66269ca8b67e80516548e8ae10bd7b2 Mon Sep 17 00:00:00 2001 From: RaNaN Date: Tue, 5 Mar 2013 23:21:44 +0100 Subject: working search suggestions --- module/database/FileDatabase.py | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'module/database') diff --git a/module/database/FileDatabase.py b/module/database/FileDatabase.py index 9d11ffe46..557d9c034 100644 --- a/module/database/FileDatabase.py +++ b/module/database/FileDatabase.py @@ -163,6 +163,18 @@ class FileMethods(DatabaseMethods): return data + @queue + def getMatchingFilenames(self, pattern, owner=None): + """ Return matching file names for pattern, useful for search suggestions """ + qry = 'SELECT name FROM files WHERE name LIKE ?' + args = ["%%%s%%" % pattern.strip("%")] + if owner: + qry += " AND owner=?" + args.append(owner) + + self.c.execute(qry, args) + return [r[0] for r in self.c] + @queue def getAllPackages(self, root=None, owner=None, tags=None): """ Return dict with package information -- cgit v1.2.3