diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-05-01 13:45:11 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-05-01 13:45:11 +1000 |
| commit | 391987ac31afeffee7ba5f82b31d095cd0c9f59f (patch) | |
| tree | 5f305edaf25e72257e7821c32481a2cef3acd6ba /backend/server.py | |
| parent | 35ed1fc5bcd8a4f7dffa742946335a5f10051111 (diff) | |
Order search suggestions by num tips
Diffstat (limited to 'backend/server.py')
| -rwxr-xr-x | backend/server.py | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/backend/server.py b/backend/server.py index ef6d9cf..00bc853 100755 --- a/backend/server.py +++ b/backend/server.py @@ -68,9 +68,11 @@ def lookupName(name): cur = dbCon.cursor() results = [] hasMore = False - for row in cur.execute( - "SELECT DISTINCT name, alt_name FROM names WHERE alt_name LIKE ? LIMIT ?", - (name + "%", SEARCH_SUGG_LIMIT + 1)): + #nameQuery = "SELECT DISTINCT name, alt_name FROM names WHERE alt_name LIKE ? LIMIT ?" + nameQuery = "SELECT DISTINCT names.name, names.alt_name, nodes.tips FROM names" \ + " INNER JOIN nodes on names.name = nodes.name " \ + " WHERE alt_name LIKE ? ORDER BY nodes.tips DESC LIMIT " + str(SEARCH_SUGG_LIMIT + 1) + for row in cur.execute(nameQuery, (name + "%",)): results.append({"name": row[0], "altName": row[1]}) if len(results) > SEARCH_SUGG_LIMIT: hasMore = True |