mod_debug_sql: Small plugin that enables raw SQL query logging (for debugging)

[prosody.git] / plugins / mod_storage_sql.lua

diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua
index 50d34a23c15cea615489c4140e9fea8f9a0acd58..af2bcef419d9ca428f869d15efafb041b61daf04 100644 (file)
--- a/plugins/mod_storage_sql.lua
+++ b/plugins/mod_storage_sql.lua
@@ -275,7 +275,6 @@ function archive_store:find(username, query)
                end
 
                sql_query = sql_query:format(t_concat(where, " AND "), query.reverse and "DESC" or "ASC", query.limit and " LIMIT ?" or "");
-               module:log("debug", sql_query);
                return engine:select(sql_query, unpack(args));
        end);
        if not ok then return ok, result end
@@ -301,7 +300,6 @@ function archive_store:delete(username, query)
                archive_where(query, args, where);
                archive_where_id_range(query, args, where);
                sql_query = sql_query:format(t_concat(where, " AND "));
-               module:log("debug", sql_query);
                return engine:delete(sql_query, unpack(args));
        end);
 end
@@ -453,7 +451,7 @@ function module.load()
        local params = normalize_params(module:get_option("sql", default_params));
        engine = engines[sql.db2uri(params)];
        if not engine then
-               module:log("info", "Creating new engine");
+               module:log("debug", "Creating new engine");
                engine = sql:create_engine(params, function (engine)
                        if module:get_option("sql_manage_tables", true) then
                                -- Automatically create table, ignore failure (table probably already exists)