diff options
| author | Munyoki Kilyungi | 2023-09-13 15:28:29 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2023-09-13 15:28:29 +0300 |
| commit | 3662069bb6390d7a386d280aeeed540b8b24746d (patch) | |
| tree | ca264789a02a9c6df14c8a2a7c1144339de2e303 | |
| parent | 1bca6bdc93f3f5b6f5fe82613113cf7ab6410c92 (diff) | |
| download | genenetwork2-3662069bb6390d7a386d280aeeed540b8b24746d.tar.gz | |
Patch MySQLdb.escape_string to use use a connection.
* wqflask/utility/db_tools.py: Delete MySQLdb.escape_. Import
get_setting, database_connection.
(escape_): New function.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rw-r--r-- | wqflask/utility/db_tools.py | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/wqflask/utility/db_tools.py b/wqflask/utility/db_tools.py index 6e19778f..98da33f2 100644 --- a/wqflask/utility/db_tools.py +++ b/wqflask/utility/db_tools.py @@ -1,4 +1,10 @@ -from MySQLdb import escape_string as escape_ +from utility.tools import get_setting +from wqflask.database import database_connection + + +def escape_(string): + with database_connection(get_setting("SQL_URI")) as conn: + return conn.escape_string(str(string)) def create_in_clause(items): |