http://hg.omfa.de/prosody-hg/ en-us prosody-hg: plugins/mod_storage_sql2.lua history plugins/mod_storage_sql2.lua revision history Merge 0.10->trunk http://hg.omfa.de/prosody-hg/log/d01c29b62b16/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Thu, 09 Jul 2015 00:14:27 +0100 mod_storage_sql2: Upgrade table if its charset does not match our connection's charset (thanks Zash) http://hg.omfa.de/prosody-hg/log/b20efae224c9/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Wed, 08 Jul 2015 15:07:23 +0100 mod_storage_sql2: Don't upgrade tables without admin intervention http://hg.omfa.de/prosody-hg/log/fc9c1a566a19/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Tue, 07 Jul 2015 17:42:29 +0100 mod_storage_sql2: Add prosodyctl command to upgrade tables from the command-line http://hg.omfa.de/prosody-hg/log/2e75b94e3a1e/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Tue, 07 Jul 2015 17:41:09 +0100 mod_storage_sql2: Add missing return to upgrade_table(), so we know if an upgrade is required http://hg.omfa.de/prosody-hg/log/b80202ad47e8/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Tue, 07 Jul 2015 17:40:23 +0100 mod_storage_sql2: Rename variable to avoid name clash http://hg.omfa.de/prosody-hg/log/c72b00dade25/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Tue, 07 Jul 2015 17:39:56 +0100 Merge 0.10->trunk http://hg.omfa.de/prosody-hg/log/9dc05d3efdc9/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Sun, 05 Jul 2015 18:00:05 +0200 mod_storage_sql2: Validate configuration after normalizing SQLite3 database path (fixes traceback with default config) http://hg.omfa.de/prosody-hg/log/5e8a8319699d/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Sat, 27 Jun 2015 15:59:37 +0200 Merge 0.10->trunk http://hg.omfa.de/prosody-hg/log/6728ad041761/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Thu, 25 Jun 2015 18:57:43 +0200 Merge with 0.10 http://hg.omfa.de/prosody-hg/log/99b3f29c3c71/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Wed, 24 Jun 2015 23:25:42 +0100 mod_storage_sql2: Break up monolithic code into functions, theoretically no functionality changes. http://hg.omfa.de/prosody-hg/log/6216743c188c/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Wed, 24 Jun 2015 23:24:32 +0100 mod_storage_sql2: Improve logging when database read fails http://hg.omfa.de/prosody-hg/log/845bc5ba306d/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Wed, 24 Jun 2015 22:56:50 +0100 mod_storage_sql2: Some reformatting and variable name improvements http://hg.omfa.de/prosody-hg/log/9f932a31eeba/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Wed, 24 Jun 2015 22:55:41 +0100 mod_storage_sql2: Add some comments http://hg.omfa.de/prosody-hg/log/4aee55c0cc5c/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Wed, 24 Jun 2015 22:54:17 +0100 Merge 0.10->trunk http://hg.omfa.de/prosody-hg/log/daa5c83b2879/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Thu, 21 May 2015 22:56:39 +0200 mod_storage_sql2: Fix argument compat thing from 41725f3df3cc, it was backwards http://hg.omfa.de/prosody-hg/log/db28b8639737/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Thu, 21 May 2015 12:11:08 +0200 Merge 0.10->trunk http://hg.omfa.de/prosody-hg/log/eb9c842b80fa/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Tue, 19 May 2015 23:23:44 +0200 mod_storage_sql2: Add a 'caps' table for indicating support for optional features http://hg.omfa.de/prosody-hg/log/e6e80ec50030/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Tue, 19 May 2015 18:24:53 +0200 mod_storage_sql2: Change order of arguments to :append to be the same as return values from :find iterator http://hg.omfa.de/prosody-hg/log/41725f3df3cc/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Tue, 19 May 2015 18:24:09 +0200 mod_storage_sql2: Include 'with' field from iterator like some 3rd party archive-capable storage modules http://hg.omfa.de/prosody-hg/log/a8dbfa14e1a8/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Tue, 19 May 2015 18:21:23 +0200 Merge 0.10 -> trunk http://hg.omfa.de/prosody-hg/log/b89406fa076c/plugins/mod_storage_sql2.lua Waqas Hussain <waqas20@gmail.com> Tue, 16 Dec 2014 18:33:54 -0500 mod_storage_sql2, util.sql: Set character encoding on every connect http://hg.omfa.de/prosody-hg/log/a966efeb6cb3/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Thu, 11 Dec 2014 09:18:39 +0100 mod_storage_sql2: DELETE then INSERT in map stores http://hg.omfa.de/prosody-hg/log/0cee68dd35f8/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Tue, 12 Aug 2014 11:38:12 +0200 plugins/mod_storage_sql2: Return correct arguments from map_store operations http://hg.omfa.de/prosody-hg/log/eaf6e7986934/plugins/mod_storage_sql2.lua daurnimator <quae@daurnimator.com> Thu, 07 Aug 2014 18:34:51 -0400 plugins/mod_storage_sql2: Add map store support http://hg.omfa.de/prosody-hg/log/fc5113a4540e/plugins/mod_storage_sql2.lua daurnimator <quae@daurnimator.com> Thu, 07 Aug 2014 12:16:16 -0400 mod_storage_sql2: Don't ignore failure in keyval_store:get() (thanks daurnimator) http://hg.omfa.de/prosody-hg/log/bce801e40484/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Fri, 20 Jun 2014 16:16:33 +0200 core.certmanager, core.moduleapi, mod_storage_sql, mod_storage_sql2: Import from util.paths http://hg.omfa.de/prosody-hg/log/6a184b16b717/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Fri, 09 May 2014 19:35:29 +0200 mod_storage_sql2: Build counter query without ORDER BY clause http://hg.omfa.de/prosody-hg/log/de4c83feb064/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Tue, 08 Apr 2014 19:23:11 +0200 mod_storage_sql2: archive:delete() with username = true deletes for all users http://hg.omfa.de/prosody-hg/log/918ab89cb68d/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Sun, 09 Feb 2014 15:12:13 +0100 mod_storage_sql2: Only attempt to delete conflicting items if an ID/key is given http://hg.omfa.de/prosody-hg/log/e7efa9703a3f/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Tue, 21 Jan 2014 01:51:13 +0100 mod_storage_sql2: Fix another SQL syntax error that slipped trough http://hg.omfa.de/prosody-hg/log/aa7534a877fe/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Tue, 21 Jan 2014 00:51:31 +0100 mod_storage_sql2: Fix SQL syntax http://hg.omfa.de/prosody-hg/log/98ed9fe368ac/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Sat, 18 Jan 2014 19:33:33 +0100 mod_storage_sql2: Fix syntax error in subquery (Thanks Lance) http://hg.omfa.de/prosody-hg/log/4c41404d9eec/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Sun, 05 Jan 2014 23:38:34 +0100 mod_storage_sql2: Expose the unique key argument, allowing arbitrary ids. Conflicting items are removed. http://hg.omfa.de/prosody-hg/log/0a3b8003ac9c/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 25 Dec 2013 22:37:52 +0100 mod_storage_sql2: Include user, host and store in id lookup http://hg.omfa.de/prosody-hg/log/e1e9f1411442/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 25 Dec 2013 15:28:55 +0100 mod_storage_sql2: Auto increment columns won't be NULL, so drop nullable=false http://hg.omfa.de/prosody-hg/log/6865eecaf5a5/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Mon, 11 Nov 2013 23:15:26 +0100 mod_storage_sql2: Fix backwards comparison of timestamp http://hg.omfa.de/prosody-hg/log/0e0aab930e10/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Thu, 07 Nov 2013 17:18:20 +0100 mod_storage_sql2: Switch to the util.sql table definition for the main table http://hg.omfa.de/prosody-hg/log/9e47ece9457c/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Thu, 31 Oct 2013 00:53:59 +0100 mod_storage_sql2: The prosodyarchive_index should be unique http://hg.omfa.de/prosody-hg/log/62ce0328fdfe/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 30 Oct 2013 22:37:07 +0100 mod_storage_sql2: Use primary_key and auto_increment flags instead of baking that into the type http://hg.omfa.de/prosody-hg/log/319ccceb1302/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 30 Oct 2013 22:27:22 +0100 mod_storage_sql2: Use MEDIUMTEXT fields for value columns (ie TEXT on non-MySQL) http://hg.omfa.de/prosody-hg/log/b6a56934338c/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 30 Oct 2013 14:33:15 +0100 mod_storage_sql2: Move checking of the sql_manage_tables option so it also includes table upgrades (again) http://hg.omfa.de/prosody-hg/log/9cb81a17ae23/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Mon, 28 Oct 2013 22:08:46 +0100 mod_storage_sql2, util.sql: Move code for setting encoding to util.sql http://hg.omfa.de/prosody-hg/log/39b187e7e892/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Mon, 28 Oct 2013 22:07:16 +0100 mod_storage_sql2: Move all schema upgrade code to the same place http://hg.omfa.de/prosody-hg/log/fbba2997aabb/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Mon, 28 Oct 2013 21:37:30 +0100 mod_storage_sql2: Split up setting of encoding and table upgrade code http://hg.omfa.de/prosody-hg/log/12d12bda4b8c/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Mon, 28 Oct 2013 21:34:55 +0100 mod_storage_sql2: Add method for deleting items from archives with same syntax as :find() http://hg.omfa.de/prosody-hg/log/06156bfd4eaf/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Sat, 28 Sep 2013 22:04:04 +0200 mod_storage_sql2: Split out code for building WHERE clauses into separate functions http://hg.omfa.de/prosody-hg/log/6aaa7ad4463c/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Sat, 28 Sep 2013 21:58:01 +0200 Remove all trailing whitespace http://hg.omfa.de/prosody-hg/log/bd0ff8ae98a8/plugins/mod_storage_sql2.lua Florian Zeitz <florob@babelmonkeys.de> Fri, 09 Aug 2013 17:48:21 +0200 mod_storage_sql2: Do an early return and drop an indentation level http://hg.omfa.de/prosody-hg/log/d854c17a45fd/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Fri, 02 Aug 2013 15:40:21 +0200 mod_storage_sql2: Add archive store with append and find methods http://hg.omfa.de/prosody-hg/log/c7a664e496b3/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Fri, 12 Jul 2013 02:53:24 +0200 mod_storage_sql2: Create an additional table `prosodyarchive` for chronological collections http://hg.omfa.de/prosody-hg/log/6fce00f61acf/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Fri, 12 Jul 2013 01:34:38 +0200 mod_storage_sql2: Support XML serialization for stanzas. http://hg.omfa.de/prosody-hg/log/24f4e73645fe/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 10 Jul 2013 13:19:33 +0200 mod_storage_sql2: Keep available store types in a table http://hg.omfa.de/prosody-hg/log/49f1fed6e25e/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 10 Jul 2013 13:18:10 +0200 mod_storage_sql2: Fix iteration over users and stores http://hg.omfa.de/prosody-hg/log/aeeced7b0149/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 10 Jul 2013 12:08:44 +0200 mod_storage_sql2: Make sure the user field is not NULL http://hg.omfa.de/prosody-hg/log/4aa1d6f5083a/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Wed, 10 Jul 2013 12:01:23 +0200 mod_storage_sql2: Use correct variable (Thanks SkyBlue and Florob) http://hg.omfa.de/prosody-hg/log/254a9420e53d/plugins/mod_storage_sql2.lua Kim Alvefur <zash@zash.se> Sun, 23 Jun 2013 19:27:49 +0200 mod_storage_sql2 (temporary name), sql.lib, util.sql: New SQL API supporting cross-module connection sharing, transactions and Things - a work in progress http://hg.omfa.de/prosody-hg/log/9916f0a2d178/plugins/mod_storage_sql2.lua Matthew Wild <mwild1@gmail.com> Thu, 18 Apr 2013 11:13:40 +0100