# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1487550363 -3600
# Node ID 8e2446cdf6fa51f1b94b6931141a702927a8d342
# Parent  aa6b036150ebddbee42bc017ac93256e35540d0a
mod_storage_sql: Make archive:append() to return the id (or key) as first return value

diff -r aa6b036150eb -r 8e2446cdf6fa plugins/mod_storage_sql.lua
--- a/plugins/mod_storage_sql.lua	Mon Feb 20 00:51:12 2017 +0100
+++ b/plugins/mod_storage_sql.lua	Mon Feb 20 01:26:03 2017 +0100
@@ -187,7 +187,7 @@
 		when, with, value = value, when, with;
 	end
 	local user,store = username,self.store;
-	return engine:transaction(function()
+	local ok, key = engine:transaction(function()
 		if key then
 			engine:delete("DELETE FROM `prosodyarchive` WHERE `host`=? AND `user`=? AND `store`=? AND `key`=?", host, user or "", store, key);
 		else
@@ -197,6 +197,8 @@
 		engine:insert("INSERT INTO `prosodyarchive` (`host`, `user`, `store`, `when`, `with`, `key`, `type`, `value`) VALUES (?,?,?,?,?,?,?,?)", host, user or "", store, when, with, key, t, value);
 		return key;
 	end);
+	if not ok then return ok, key; end
+	return key;
 end
 
 -- Helpers for building the WHERE clause