--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mod_mam_archive/mod_mam_archive.lua	Mon Jul 14 23:00:13 2014 +0200
@@ -0,0 +1,305 @@
+-- Prosody IM
+--
+-- This project is MIT/X11 licensed. Please see the
+-- COPYING file in the source package for more information.
+--
+local get_prefs = module:require"mod_mam/mamprefs".get;
+local set_prefs = module:require"mod_mam/mamprefs".set;
+local rsm = module:require "mod_mam/rsm";
+local jid_bare = require "util.jid".bare;
+local jid_prep = require "util.jid".prep;
+local date_parse = require "util.datetime".parse;
+
+local st = require "util.stanza";
+local archive_store = "archive2";
+local archive = module:open_store(archive_store, "archive");
+local global_default_policy = module:get_option("default_archive_policy", false);
+local default_max_items, max_max_items = 20, module:get_option_number("max_archive_query_results", 50);
+local conversation_interval = module:get_option_number("archive_conversation_interval", 86400);
+
+-- Feature discovery
+local xmlns_archive = "urn:xmpp:archive"
+local feature_archive = st.stanza('feature', {xmlns=xmlns_archive});
+feature_archive:tag('optional');
+if(global_default_policy) then
+    feature_archive:tag('default');
+end
+module:add_extension(feature_archive);
+module:add_feature("urn:xmpp:archive:auto");
+module:add_feature("urn:xmpp:archive:manage");
+module:add_feature("urn:xmpp:archive:pref");
+module:add_feature("http://jabber.org/protocol/rsm");
+-- --------------------------------------------------
+
+local function os_date()
+    return os.date("!*t");
+end
+local function date_format(s)
+    return os.date("%Y-%m-%dT%H:%M:%SZ", s);
+end
+
+local function prefs_to_stanza(prefs)
+    local prefstanza = st.stanza("pref", { xmlns='urn:xmpp:archive' });
+    local default = prefs[false] ~= nil and prefs[false] or global_default_policy;
+
+    prefstanza:tag('default', {otr='oppose', save=default and 'true' or 'false'}):up();
+    prefstanza:tag('method', {type='auto', use='concede'}):up();
+    prefstanza:tag('method', {type='local', use='concede'}):up();
+    prefstanza:tag('method', {type='manual', use='concede'}):up();
+
+    for jid, choice in pairs(prefs) do
+        if jid then
+            prefstanza:tag('item', {jid=jid, otr='prefer', save=choice and 'message' or 'false' }):up()
+        end
+    end
+
+    return prefstanza;
+end
+local function prefs_from_stanza(stanza)
+    local current_prefs = get_prefs(origin.username);
+
+    -- "default" | "item" | "session" | "method"
+    for elem in stanza:children() do
+        if elem.name == "default" then
+            current_prefs[false] = elem.attr['save'] == 'true';
+        elseif elem.name == "item" then
+            current_prefs[elem.attr['jid']] = not elem.attr['save'] == 'false';
+        elseif elem.name == "session" then
+            module:log("info", "element is not supported: " .. tostring(elem));
+--            local found = false;
+--            for child in data:children() do
+--                if child.name == elem.name and child.attr["thread"] == elem.attr["thread"] then
+--                    for k, v in pairs(elem.attr) do
+--                        child.attr[k] = v;
+--                    end
+--                    found = true;
+--                    break;
+--                end
+--            end
+--            if not found then
+--                data:tag(elem.name, elem.attr):up();
+--            end
+        elseif elem.name == "method" then
+            module:log("info", "element is not supported: " .. tostring(elem));
+--            local newpref = stanza.tags[1]; -- iq:pref
+--            for _, e in ipairs(newpref.tags) do
+--                -- if e.name ~= "method" then continue end
+--                local found = false;
+--                for child in data:children() do
+--                    if child.name == "method" and child.attr["type"] == e.attr["type"] then
+--                        child.attr["use"] = e.attr["use"];
+--                        found = true;
+--                        break;
+--                    end
+--                end
+--                if not found then
+--                    data:tag(e.name, e.attr):up();
+--                end
+--            end
+        end
+    end
+end
+
+------------------------------------------------------------
+-- Preferences
+------------------------------------------------------------
+local function preferences_handler(event)
+    local origin, stanza = event.origin, event.stanza;
+    local user = origin.username;
+    local reply = st.reply(stanza);
+
+    if stanza.attr.type == "get" then
+        reply:add_child(prefs_to_stanza(get_prefs(user)));
+    end
+    if stanza.attr.type == "set" then
+        local new_prefs = stanza:get_child("pref", xmlns_archive);
+        if not new_prefs then return false; end
+
+        local prefs = prefs_from_stanza(stanza);
+        local ok, err = set_prefs(user, prefs);
+
+        if not ok then
+            return origin.send(st.error_reply(stanza, "cancel", "internal-server-error", "Error storing preferences: "..tostring(err)));
+        end
+    end
+    return origin.send(reply);
+end
+local function auto_handler(event)
+    local origin, stanza = event.origin, event.stanza;
+    if not stanza.attr['type'] == 'set' then return false; end
+
+    local user = origin.username;
+    local prefs = get_prefs(user);
+    local auto = stanza:get_child('auto', xmlns_archive);
+
+    prefs[false] = auto.attr['save'] ~= nil and auto.attr['save'] == 'true' or false;
+    set_prefs(user, prefs);
+
+    return origin.send(st.reply(stanza));
+end
+
+-- excerpt from mod_storage_sql2
+local function get_db()
+    local mod_sql = module:require("sql");
+    local params = module:get_option("sql");
+    local engine;
+
+    params = params or { driver = "SQLite3" };
+    if params.driver == "SQLite3" then
+        params.database = resolve_relative_path(prosody.paths.data or ".", params.database or "prosody.sqlite");
+    end
+
+    assert(params.driver and params.database, "Both the SQL driver and the database need to be specified");
+    engine = mod_sql:create_engine(params);
+    engine:set_encoding();
+
+    return engine;
+end
+
+------------------------------------------------------------
+-- Collections. In our case there is one conversation with each contact for the whole day for simplicity
+------------------------------------------------------------
+local function list_stanza_to_query(origin, list_el)
+    local sql = "SELECT `with`, `when` / ".. conversation_interval .." as `day`, COUNT(0) FROM `prosodyarchive` WHERE `host`=? AND `user`=? AND `store`=? ";
+    local args = {origin.host, origin.username, archive_store};
+
+    local with = list_el.attr['with'];
+    if with ~= nil then
+        sql = sql .. "AND `with` = ? ";
+        table.insert(args, jid_bare(with));
+    end
+
+    local after = list_el.attr['start'];
+    if after ~= nil then
+        sql = sql .. "AND `when` >= ?";
+        table.insert(args, date_parse(after));
+    end
+
+    local before = list_el.attr['end'];
+    if before ~= nil then
+        sql = sql .. "AND `when` <= ? ";
+        table.insert(args, date_parse(before));
+    end
+
+    sql = sql .. "GROUP BY `with`, `when` / ".. conversation_interval .." ORDER BY `when` / ".. conversation_interval .." ASC ";
+
+    local qset = rsm.get(list_el);
+    local limit = math.min(qset and qset.max or default_max_items, max_max_items);
+    sql = sql..'LIMIT ?';
+    table.insert(args, limit);
+
+    table.insert(args, 1, sql);
+    return args;
+end
+local function list_handler(event)
+    local db = get_db();
+    local origin, stanza = event.origin, event.stanza;
+    local reply = st.reply(stanza);
+
+    local query = list_stanza_to_query(origin, stanza.tags[1]);
+    local list = reply:tag('list', {xmlns=xmlns_archive});
+
+    for row in db:select(unpack(query)) do
+        list:tag('chat', {
+            xmlns=xmlns_archive,
+            with=row[1],
+            start=date_format(row[2] * conversation_interval),
+            version=row[3]
+        }):up();
+    end
+
+    origin.send(reply);
+    return true;
+end
+
+------------------------------------------------------------
+-- Message archive retrieval
+------------------------------------------------------------
+
+local function retrieve_handler(event)
+    local origin, stanza = event.origin, event.stanza;
+    local reply = st.reply(stanza);
+
+    local retrieve = stanza:get_child('retrieve', xmlns_archive);
+
+    local qwith = retrieve.attr['with'];
+    local qstart = retrieve.attr['start'];
+
+    module:log("debug", "Archive query, with %s from %s)",
+        qwith or "anyone", qstart or "the dawn of time");
+
+    if qstart then -- Validate timestamps
+        local vstart = (qstart and date_parse(qstart));
+        if (qstart and not vstart) then
+            origin.send(st.error_reply(stanza, "modify", "bad-request", "Invalid timestamp"))
+            return true
+        end
+        qstart = vstart;
+    end
+
+    if qwith then -- Validate the 'with' jid
+        local pwith = qwith and jid_prep(qwith);
+        if pwith and not qwith then -- it failed prepping
+            origin.send(st.error_reply(stanza, "modify", "bad-request", "Invalid JID"))
+            return true
+        end
+        qwith = jid_bare(pwith);
+    end
+
+    -- RSM stuff
+    local qset = rsm.get(retrieve);
+    local qmax = math.min(qset and qset.max or default_max_items, max_max_items);
+    local reverse = qset and qset.before or false;
+    local before, after = qset and qset.before, qset and qset.after;
+    if type(before) ~= "string" then before = nil; end
+
+    -- Load all the data!
+    local data, err = archive:find(origin.username, {
+        start = qstart; ["end"] = qstart + conversation_interval;
+        with = qwith;
+        limit = qmax;
+        before = before; after = after;
+        reverse = reverse;
+        total = true;
+    });
+
+    if not data then
+        return origin.send(st.error_reply(stanza, "cancel", "internal-server-error", err));
+    end
+    local count = err;
+
+    local chat = reply:tag('chat', {xmlns=xmlns_archive, with=qwith, start=date_format(qstart), version=count});
+
+    module:log("debug", 'Count '..count);
+    for id, item, when in data do
+        local tag = jid_bare(item['attr']['from']) == jid_bare(origin.full_jid) and 'from' or 'to';
+        tag = chat:tag(tag, {secs = when - qstart});
+        tag:tag('body'):text(item[2][1]):up():up();
+    end
+
+    origin.send(reply);
+    return true;
+end
+
+local function not_implemented(event)
+    local origin, stanza = event.origin, event.stanza;
+    local reply = st.reply(stanza):tag('error', {type='cancel'});
+    reply:tag('feature-not-implemented', {xmlns='urn:ietf:params:xml:ns:xmpp-stanzas'}):up();
+    origin.send(reply);
+end
+
+-- Preferences
+module:hook("iq/self/urn:xmpp:archive:pref", preferences_handler);
+module:hook("iq/self/urn:xmpp:archive:auto", auto_handler);
+module:hook("iq/self/urn:xmpp:archive:itemremove", not_implemented);
+module:hook("iq/self/urn:xmpp:archive:sessionremove", not_implemented);
+
+-- Message Archive Management
+module:hook("iq/self/urn:xmpp:archive:list", list_handler);
+module:hook("iq/self/urn:xmpp:archive:retrieve", retrieve_handler);
+module:hook("iq/self/urn:xmpp:archive:remove", not_implemented);
+
+-- manual archiving
+module:hook("iq/self/urn:xmpp:archive:save", not_implemented);
+-- replication
+module:hook("iq/self/urn:xmpp:archive:modified", not_implemented);