view plugins/mod_debug_sql.lua @ 14020:3c2bfa6a69df

prosodyctl shell: Move non-error result lines back to stdout, suppress with --quiet We're figuring out how to keep usability and support machine-readability too. We moved the status line (repl-result) to stderr so that when parsing something like a table, it didn't get in the way. However sometimes the status line is the thing we want to parse (e.g. invite creation). Parsing stderr loses one of the purposes of stderr - to have an error-only channel to emit stuff out of band (such as error messages). So the new approach is: - Status line on stdout, unless it's an error - If you're parsing the output ("content") of the command, pass --quiet to suppress the status line.
author Matthew Wild <mwild1@gmail.com>
date Tue, 30 Dec 2025 16:30:43 +0000
parents 5edb0d01a94f
children
line wrap: on
line source

-- Enables SQL query logging
--
-- luacheck: ignore 213/uri

module:set_global();

local engines = module:shared("/*/sql/connections");

for uri, engine in pairs(engines) do
	engine:debug(true);
end

setmetatable(engines, {
	__newindex = function (t, uri, engine)
		engine:debug(true);
		rawset(t, uri, engine);
	end
});

function module.unload()
	setmetatable(engines, nil);
	for uri, engine in pairs(engines) do
		engine:debug(false);
	end
end