From 433ad25335b94876710ea27fc0d0173f951a8440 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Sat, 12 Jan 2019 00:16:29 +0100 Subject: sql name search many terms --- megapixels/app/models/sql_factory.py | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'megapixels/app/models') diff --git a/megapixels/app/models/sql_factory.py b/megapixels/app/models/sql_factory.py index a580f28e..82e59b22 100644 --- a/megapixels/app/models/sql_factory.py +++ b/megapixels/app/models/sql_factory.py @@ -101,10 +101,12 @@ class SqlDataset: def search_name(self, q): table = self.get_table('identity_meta') uuid_table = self.get_table('uuids') + identity_list = table.query.filter(table.fullname.like(q)).order_by(table.fullname.desc()).limit(10) + return identity_list - identity = table.query.filter(table.fullname.like(q)).order_by(table.fullname.desc()).limit(30) + def get_uuids_for_identities(self, identity_list): identities = [] - for row in identity: + for row in identity_list: uuid = uuid_table.query.filter(uuid_table.id == row.image_id).first() identities.append({ 'uuid': uuid.toJSON(), -- cgit v1.2.3-70-g09d2