From 3662069bb6390d7a386d280aeeed540b8b24746d Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Wed, 13 Sep 2023 15:28:29 +0300 Subject: 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 --- wqflask/utility/db_tools.py | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) 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): -- cgit 1.4.1