aboutsummaryrefslogtreecommitdiffstats
path: root/plugins/mod_storage_sql.lua
diff options
context:
space:
mode:
authorKim Alvefur <zash@zash.se>2015-12-03 16:17:40 +0100
committerKim Alvefur <zash@zash.se>2015-12-03 16:17:40 +0100
commitc24e8f3738599d7b954003bcbdb8eee20b108c5d (patch)
treec03492afc44cd6ca75160619982fc3ecc4defdfd /plugins/mod_storage_sql.lua
parentb810e6f3e14ac89c4f7d4477196a81740eb9a2a3 (diff)
parent8b1e8e2e6ba562f0e59d36ea190ed50eef749af8 (diff)
downloadprosody-c24e8f3738599d7b954003bcbdb8eee20b108c5d.tar.gz
prosody-c24e8f3738599d7b954003bcbdb8eee20b108c5d.zip
Merge
Diffstat (limited to 'plugins/mod_storage_sql.lua')
-rw-r--r--plugins/mod_storage_sql.lua36
1 files changed, 35 insertions, 1 deletions
diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua
index 7695e15d..adf9f9b6 100644
--- a/plugins/mod_storage_sql.lua
+++ b/plugins/mod_storage_sql.lua
@@ -107,7 +107,7 @@ function keyval_store:get(username)
module:log("error", "Unable to read from database %s store for %s: %s", store, username or "<host>", result);
return nil, result;
end
- return result;
+ return result;
end
function keyval_store:set(username, data)
user,store = username,self.store;
@@ -125,6 +125,39 @@ end
--- Archive store API
+local map_store = {};
+map_store.__index = map_store;
+function map_store:get(username, key)
+ local ok, result = engine:transaction(function()
+ if type(key) == "string" and key ~= "" then
+ for row in engine:select("SELECT `type`, `value` FROM `prosody` WHERE `host`=? AND `user`=? AND `store`=? AND `key`=?", host, username or "", self.store, key) do
+ return deserialize(row[1], row[2]);
+ end
+ else
+ error("TODO: non-string keys");
+ end
+ end);
+ if not ok then return nil, result; end
+ return result;
+end
+function map_store:set(username, key, data)
+ local ok, result = engine:transaction(function()
+ if type(key) == "string" and key ~= "" then
+ engine:delete("DELETE FROM `prosody` WHERE `host`=? AND `user`=? AND `store`=? AND `key`=?",
+ host, username or "", self.store, key);
+ if data ~= nil then
+ local t, value = assert(serialize(data));
+ engine:insert("INSERT INTO `prosody` (`host`,`user`,`store`,`key`,`type`,`value`) VALUES (?,?,?,?,?,?)", host, username or "", self.store, key, t, value);
+ end
+ else
+ error("TODO: non-string keys");
+ end
+ return true;
+ end);
+ if not ok then return nil, result; end
+ return result;
+end
+
local archive_store = {}
archive_store.caps = {
total = true;
@@ -253,6 +286,7 @@ end
local stores = {
keyval = keyval_store;
+ map = map_store;
archive = archive_store;
};