# HG changeset patch
# User Matthew Wild <mwild1@gmail.com>
# Date 1698668892 0
# Node ID 7c264a2cb970c917603003d91b1cf8caa7e97b61
# Parent  c69320fc438b21f4b1fb90a0ca8b1201bd6e13ff
mod_storage_ejabberdsql_readonly: Don't use MySQL-specific syntax

util.sql should take care of transformation when MySQL is in use.

diff -r c69320fc438b -r 7c264a2cb970 mod_storage_ejabberdsql_readonly/mod_storage_ejabberdsql_readonly.lua
--- a/mod_storage_ejabberdsql_readonly/mod_storage_ejabberdsql_readonly.lua	Sun Oct 29 12:41:56 2023 +0100
+++ b/mod_storage_ejabberdsql_readonly/mod_storage_ejabberdsql_readonly.lua	Mon Oct 30 12:28:12 2023 +0000
@@ -25,9 +25,9 @@
 
 local function keyval_store_get()
 	if store == "accounts" then
-		--for row in engine:select("SELECT `password`,`created_at` FROM `users` WHERE `username`=?", user or "") do
+		--for row in engine:select("SELECT \"password\",\"created_at\" FROM \"users\" WHERE \"username\"=?", user or "") do
 		local result;
-		for row in engine:select("SELECT `password` FROM `users` WHERE `username`=? LIMIT 1", user or "") do result = row end
+		for row in engine:select("SELECT \"password\" FROM \"users\" WHERE \"username\"=? LIMIT 1", user or "") do result = row end
 		local password = result[1];
 		--local created_at = result[2];
 		return { password = password };
@@ -35,8 +35,8 @@
 	elseif store == "roster" then
 		local roster = {};
 		local pending = nil;
-		--for row in engine:select("SELECT `jid`,`nick`,`subscription`,`ask`,`askmessage`,`server`,`subscribe`,`type`,`created_at` FROM `rosterusers` WHERE `username`=?", user or "") do
-		for row in engine:select("SELECT `jid`,`nick`,`subscription`,`ask` FROM `rosterusers` WHERE `username`=?", user or "") do
+		--for row in engine:select("SELECT \"jid\",\"nick\",\"subscription\",\"ask\",\"askmessage\",\"server\",\"subscribe\",\"type\",\"created_at\" FROM \"rosterusers\" WHERE \"username\"=?", user or "") do
+		for row in engine:select("SELECT \"jid\",\"nick\",\"subscription\",\"ask\" FROM \"rosterusers\" WHERE \"username\"=?", user or "") do
 			local contact = row[1];
 			local name = row[2];
 			if name == "" then name = nil; end
@@ -72,7 +72,7 @@
 			--local created_at = row[9];
 
 			local groups = {};
-			for row in engine:select("SELECT `grp` FROM `rostergroups` WHERE `username`=? AND `jid`=?", user or "", contact) do
+			for row in engine:select("SELECT \"grp\" FROM \"rostergroups\" WHERE \"username\"=? AND \"jid\"=?", user or "", contact) do
 				local group = row[1];
 				groups[group] = true;
 			end
@@ -83,7 +83,7 @@
 
 	elseif store == "vcard" then
 		local result = nil;
-		for row in engine:select("SELECT `vcard` FROM `vcard` WHERE `username`=? LIMIT 1", user or "") do result = row end
+		for row in engine:select("SELECT \"vcard\" FROM \"vcard\" WHERE \"username\"=? LIMIT 1", user or "") do result = row end
 		if not result then
 			return nil;
 		end
@@ -95,7 +95,7 @@
 	elseif store == "private" then
 		local private = nil;
 		local result;
-		for row in engine:select("SELECT `namespace`,`data` FROM `private_storage` WHERE `username`=?", user or "") do
+		for row in engine:select("SELECT \"namespace\",\"data\" FROM \"private_storage\" WHERE \"username\"=?", user or "") do
 			if private == nil then private = {} end;
 			local namespace = row[1];
 			local data, err = xml_parse(row[2]);
@@ -125,7 +125,7 @@
 
 function keyval_store:users()
 	local ok, result = engine:transaction(function()
-		return engine:select("SELECT `username` FROM `users`");
+		return engine:select("SELECT \"username\" FROM \"users\"");
 	end);
 	if not ok then return ok, result end
 	return iterator(result);