From 656c5d45a1bfd3d53a2e3b675fbd95c870b170aa Mon Sep 17 00:00:00 2001 From: Kim Alvefur Date: Thu, 13 Apr 2017 22:37:35 +0200 Subject: util.sql: Produce more SQL-standard-like debug messages --- util/sql.lua | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/util/sql.lua b/util/sql.lua index f7c68ed3..15749911 100644 --- a/util/sql.lua +++ b/util/sql.lua @@ -161,7 +161,14 @@ local result_mt = { __index = { local function debugquery(where, sql, ...) local i = 0; local a = {...} sql = sql:gsub("\n?\t+", " "); - log("debug", "[%s] %s", where, sql:gsub("%?", function () i = i + 1; local v = a[i]; if type(v) == "string" then v = ("%q"):format(v); end return tostring(v); end)); + log("debug", "[%s] %s", where, sql:gsub("%?", function () + i = i + 1; + local v = a[i]; + if type(v) == "string" then + v = ("'%s'"):format(v:gsub("'", "''")); + end + return tostring(v); + end)); end function engine:execute_query(sql, ...) -- cgit v1.2.3