Software /
code /
prosody
Diff
plugins/mod_storage_sql.lua @ 7847:c430932b8113
mod_storage_sql: Return number of affected items from archive:delete
author | Kim Alvefur <zash@zash.se> |
---|---|
date | Tue, 22 Nov 2016 18:13:21 +0100 |
parent | 7757:437fb77e5ded |
child | 7857:db48b1697234 |
child | 7858:14fe60a65c69 |
line wrap: on
line diff
--- 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 = {