78def search(query, params):
83 'wildcard':
r'%' + query.replace(
' ',
r'%') +
r'%',
85 'offset': (params[
'pageno'] - 1) * limit,
87 query_to_run = query_str +
' LIMIT :limit OFFSET :offset'
91 cur.execute(query_to_run, query_params)
92 col_names = [cn[0]
for cn
in cur.description]
94 for row
in cur.fetchall():
95 item = dict(zip(col_names, map(str, row)))
96 item[
'template'] = result_template
97 logger.debug(
"append result --> %s", item)