aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBonfaceKilz2020-08-27 01:23:29 +0300
committerBonfaceKilz2020-08-27 01:42:45 +0300
commit391c1681eaeabfdbe65a64a1bb8b05beca30141e (patch)
tree087912b1d68dcbc2f29fa3c1631e6e38d915c32c
parent958972339e6c244ebedaf494bf43ca1eecabe6c4 (diff)
downloadgenenetwork2-391c1681eaeabfdbe65a64a1bb8b05beca30141e.tar.gz
Add global method to convert binary string to plain string
* wqflask/utility/db_tools.py: escape_string returns a binary string which introduces a bug when composing sql query string. The escaped strings have to be converted to plain text.
-rw-r--r--wqflask/utility/db_tools.py12
1 files changed, 8 insertions, 4 deletions
diff --git a/wqflask/utility/db_tools.py b/wqflask/utility/db_tools.py
index 92bde505..6e19778f 100644
--- a/wqflask/utility/db_tools.py
+++ b/wqflask/utility/db_tools.py
@@ -1,4 +1,5 @@
-from MySQLdb import escape_string as escape
+from MySQLdb import escape_string as escape_
+
def create_in_clause(items):
"""Create an in clause for mysql"""
@@ -6,8 +7,11 @@ def create_in_clause(items):
in_clause = '( {} )'.format(in_clause)
return in_clause
+
def mescape(*items):
"""Multiple escape"""
- escaped = [escape(str(item)) for item in items]
- #print("escaped is:", escaped)
- return escaped
+ return [escape_(str(item)).decode('utf8') for item in items]
+
+
+def escape(string_):
+ return escape_(string_).decode('utf8')