def search(query, cursor):
try:
cursor.execute("""SELECT name, hex, entity, icon FROM
(SELECT rank(matchinfo(chars))
AS r, name, hex, entity, icon
FROM chars WHERE chars MATCH ?)
ORDER BY r DESC LIMIT ?""", (query, config.MAX_RESULTS))
results = cursor.fetchall()
except sqlite3.OperationalError as err:
if b'malformed MATCH' in err.message:
wf.add_item('Invalid query', icon=ICON_WARNING)
wf.send_feedback()
return
else:
raise err
log.debug('{:d} results for `{}`'.format(len(results), query))
return results
评论列表
文章目录