summaryrefslogtreecommitdiff
path: root/searx/engines/mysql_server.py
diff options
context:
space:
mode:
authorAlexandre Flament <alex@al-f.net>2021-12-27 19:11:01 +0100
committerGitHub <noreply@github.com>2021-12-27 19:11:01 +0100
commitc6922ae7c5e53f695d5f5f8704b10b4e2815cda4 (patch)
tree9c0456ad1a1d9d375311ccd8c9bd3eafd0779114 /searx/engines/mysql_server.py
parent54bce130f9074c3d63009237b014c727a1443cc5 (diff)
parentd84226bf63757b1d4245ab26e9c081daf42389aa (diff)
Merge pull request #619 from dalf/apply-black
Apply black
Diffstat (limited to 'searx/engines/mysql_server.py')
-rw-r--r--searx/engines/mysql_server.py11
1 files changed, 7 insertions, 4 deletions
diff --git a/searx/engines/mysql_server.py b/searx/engines/mysql_server.py
index be89eb86e..d949ee0bc 100644
--- a/searx/engines/mysql_server.py
+++ b/searx/engines/mysql_server.py
@@ -20,6 +20,7 @@ paging = True
result_template = 'key-value.html'
_connection = None
+
def init(engine_settings):
global _connection # pylint: disable=global-statement
@@ -30,13 +31,14 @@ def init(engine_settings):
raise ValueError('only SELECT query is supported')
_connection = mysql.connector.connect(
- database = database,
- user = username,
- password = password,
- host = host,
+ database=database,
+ user=username,
+ password=password,
+ host=host,
auth_plugin=auth_plugin,
)
+
def search(query, params):
query_params = {'query': query}
query_to_run = query_str + ' LIMIT {0} OFFSET {1}'.format(limit, (params['pageno'] - 1) * limit)
@@ -46,6 +48,7 @@ def search(query, params):
return _fetch_results(cur)
+
def _fetch_results(cur):
results = []
for res in cur: