From 3b3af5c75ef16eafb104e518a87a532b50bb5fc7 Mon Sep 17 00:00:00 2001 From: Kim Alvefur Date: Fri, 21 Sep 2012 17:24:06 +0200 Subject: mod_storage_sql: Add support for iterating over users with data in a store --- plugins/mod_storage_sql.lua | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua index c9a45fca..f6fa94e7 100644 --- a/plugins/mod_storage_sql.lua +++ b/plugins/mod_storage_sql.lua @@ -298,6 +298,17 @@ function keyval_store:set(username, data) end if success then return ret, err; else return rollback(nil, ret); end end +function keyval_store:users() + local stmt, err = dosql("SELECT DISTINCT `user` FROM `prosody` WHERE `host`=? AND `store`=?", host, self.store); + if not stmt then + return rollback(nil, err); + end + local next = stmt:rows(); + return commit(function() + local row = next(); + return row and row[1]; + end); +end local function map_store_get(key) local stmt, err = getsql("SELECT * FROM `prosody` WHERE `host`=? AND `user`=? AND `store`=? AND `key`=?", key or ""); -- cgit v1.2.3