# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1479834801 -3600
# Node ID c430932b81134f68ca5ede6a4d3c572e4732321c
# Parent  22275bc5744a5f9bae01d83edf3db61af01e9a54
mod_storage_sql: Return number of affected items from archive:delete

diff -r 22275bc5744a -r c430932b8113 plugins/mod_storage_sql.lua
--- a/plugins/mod_storage_sql.lua	Sat Nov 19 18:29:08 2016 +0100
+++ b/plugins/mod_storage_sql.lua	Tue Nov 22 18:13:21 2016 +0100
@@ -287,7 +287,7 @@
 function archive_store:delete(username, query)
 	query = query or {};
 	local user,store = username,self.store;
-	return engine:transaction(function()
+	local stmt, err = engine:transaction(function()
 		local sql_query = "DELETE FROM `prosodyarchive` WHERE %s;";
 		local args = { host, user or "", store, };
 		local where = { "`host` = ?", "`user` = ?", "`store` = ?", };
@@ -300,6 +300,7 @@
 		sql_query = sql_query:format(t_concat(where, " AND "));
 		return engine:delete(sql_query, unpack(args));
 	end);
+	return stmt and stmt:affected() or nil, err;
 end
 
 local stores = {