prosody
7ec7dba7ba8b
plugins/mod_storage_sql.lua

Find changesets by keywords by author, files, the commit message, revision number or hash, or revset expression.

Software / code / prosody

Log

plugins/mod_storage_sql.lua @ 11109:7ec7dba7ba8b 0.11

less more | (0) tip
description author age
mod_storage_sql: Add index covering sort_id to improve performance (fixes #1505) 0.11 Kim Alvefur Sun, 22 Mar 2020 21:05:59 +0100
storagemanager, mod_storage_sql: Rename methods to :get_all() and :delete_all() Matthew Wild Wed, 11 Mar 2020 16:32:41 +0000
mod_storage_sql: Add map_store:find_key() and map_store:delete_key() (+ tests) Matthew Wild Wed, 11 Mar 2020 15:57:53 +0000
Merge 0.11->trunk Kim Alvefur Sat, 22 Feb 2020 16:26:20 +0100
mod_storage_sql: Move update limit check back one step, fixes traceback 0.11 Kim Alvefur Sat, 22 Feb 2020 16:23:43 +0100
Merge 0.11->trunk Kim Alvefur Fri, 21 Feb 2020 23:01:43 +0100
mod_storage_sql: Fix check for deletion limits (fixes #1494) 0.11 Kim Alvefur Fri, 21 Feb 2020 23:00:44 +0100
mod_storage_sql: Remove unused and not actually returned return value [luacheck] Kim Alvefur Tue, 24 Dec 2019 00:49:43 +0100
mod_storage_*: Also include timestmap of first message in :summary API Kim Alvefur Fri, 23 Aug 2019 01:15:44 +0200
mod_storage_*: Include timestamp of latest message in :summary API Kim Alvefur Fri, 23 Aug 2019 01:10:27 +0200
mod_storage_*: Tweak :summary API to allow future expansion with more fields Kim Alvefur Fri, 23 Aug 2019 01:04:00 +0200
mod_storage_sql: Ignore shadowed error variable [luacheck] Kim Alvefur Tue, 28 May 2019 00:56:30 +0200
mod_storage_sql: Fix to use correct arguments to archive id lookup Kim Alvefur Tue, 28 May 2019 00:47:50 +0200
mod_storage_sql: Correctly return item-not-found error Kim Alvefur Tue, 28 May 2019 00:46:24 +0200
mod_storage_sql: Look up archive IDs in separate queries (fixes #1325) Kim Alvefur Sat, 23 Mar 2019 00:51:10 +0100
Merge 0.11->trunk Kim Alvefur Sun, 26 May 2019 19:41:58 +0200
mod_storage_sql: Handle SQLite DELETE with LIMIT being optional (fixes #1359) 0.11 Kim Alvefur Mon, 13 May 2019 14:39:38 +0200
mod_storage_sql: Move code out of if-else chain 0.11 Kim Alvefur Mon, 13 May 2019 14:47:41 +0200
mod_storage_sql: Add support for iterating over users in archive stores Kim Alvefur Sun, 05 May 2019 16:26:01 +0200
mod_storage_sql: Implement archive summary API Kim Alvefur Mon, 25 Feb 2019 15:51:55 +0100
mod_storage_sql: No archive item limit by default Kim Alvefur Fri, 22 Mar 2019 16:30:53 +0100
mod_storage_sql: Return cached count if only this is queried for Kim Alvefur Fri, 22 Mar 2019 02:18:54 +0100
mod_storage_sql: Cache total count if it's calculated as part of the current query Kim Alvefur Fri, 22 Mar 2019 02:13:27 +0100
mod_storage_sql: Skip cache write Kim Alvefur Fri, 22 Mar 2019 02:12:02 +0100
mod_storage_sql: Fix to use currently queried store Kim Alvefur Fri, 22 Mar 2019 02:10:46 +0100
mod_storage_sql: Don't increment counter twice (fixes accounting error) Kim Alvefur Fri, 22 Mar 2019 02:09:38 +0100
mod_storage_internal,_sql: Key item count cache on both username and store Kim Alvefur Fri, 22 Mar 2019 18:02:27 +0100
mod_storage_internal,_sql: Expose archive capabilities feature set Kim Alvefur Fri, 22 Mar 2019 18:01:24 +0100
mod_storage_internal,_sql: Add limit to number of items in an archive store (fixes #733) Matthew Wild Fri, 20 Oct 2017 12:53:53 +0200
various: Don't rely on _G.unpack existing Kim Alvefur Sat, 08 Dec 2018 17:09:55 +0100
mod_storage_sql: Catch errors during schema upgrade (thanks Nothing4You) 0.11 Matthew Wild Thu, 15 Nov 2018 21:55:16 +0000
mod_storage_sql: Handle Lua 5.3 move of unpack function Kim Alvefur Sun, 21 Oct 2018 21:12:38 +0200
mod_storage_sql: Fix issue number in comment that was fixed by 55b40f3fa659 (fixes #1073) Matthew Wild Sat, 13 Oct 2018 08:17:58 +0100
mod_storage_sql: Keep prosodyarchive_index unique constraint on non-MySQL DBs Matthew Wild Fri, 12 Oct 2018 21:59:15 +0100
mod_storage_sql: Change prosodyarchive_index to be non-unique (fixes #1087) Matthew Wild Thu, 11 Oct 2018 19:23:21 +0100
mod_storage_sql: Have :users() throw an error on failure instead of returning non-iterator values Matthew Wild Thu, 11 Oct 2018 19:15:46 +0100
mod_storage_sql: Workaround MySQL not supporting LIMIT subquery in archive truncate operations, fixes #1200 Matthew Wild Thu, 11 Oct 2018 18:20:09 +0100
mod_storage_sql: Remove unused function argument [luacheck] Kim Alvefur Wed, 10 Oct 2018 21:23:35 +0200
mod_storage_sql: Catch and report value deserialization errors Kim Alvefur Sat, 24 Feb 2018 11:50:08 +0100
Merge 0.10->trunk Kim Alvefur Fri, 22 Dec 2017 01:02:05 +0100
mod_storage_sql: Index over contact and timestamp (happy now Ge0rg?) Kim Alvefur Tue, 12 Dec 2017 01:40:09 +0100
mod_storage_sql: Remove ability to override name of key-value table (unreachable and would not work) Kim Alvefur Mon, 11 Dec 2017 22:45:03 +0100
Merge 0.10->trunk Kim Alvefur Tue, 21 Nov 2017 23:16:16 +0100
mod_storage_sql: Add indices that include the with and when columns of archives Kim Alvefur Tue, 21 Nov 2017 14:46:21 +0100
mod_storage_sql: Add support for truncating deletion Kim Alvefur Thu, 09 Nov 2017 16:50:36 +0100
Merge 0.10->trunk Kim Alvefur Thu, 05 Oct 2017 18:06:04 +0200
mod_storage_sql: Also clear the prosodyarchive table when an user is deleted (fixes #1009) Kim Alvefur Thu, 05 Oct 2017 17:44:47 +0200
mod_storage_sql: Remove return values from purge method Kim Alvefur Thu, 05 Oct 2017 17:22:42 +0200
Merge 0.10->trunk Kim Alvefur Wed, 17 May 2017 01:06:20 +0200
mod_storage_sql: Fix logic error introduced by variable rename in aa9f198cb3c9 (thanks waqas) Matthew Wild Sun, 30 Apr 2017 10:44:53 +0100
Merge 0.10->trunk Kim Alvefur Thu, 13 Apr 2017 01:30:24 +0200
mod_storage_sql: Limit encoding check to current database Kim Alvefur Thu, 13 Apr 2017 01:29:35 +0200
mod_storage_sql: Break long lines Kim Alvefur Wed, 12 Apr 2017 23:16:23 +0200
mod_storage_sql: Pass charset and collation names via variable binding Kim Alvefur Wed, 12 Apr 2017 21:53:21 +0200
mod_storage_sql: Quote some field names Kim Alvefur Wed, 12 Apr 2017 21:51:17 +0200
Merge 0.10->trunk Kim Alvefur Wed, 12 Apr 2017 20:59:18 +0200
mod_storage_sql: Raise error if encoding check query fails Kim Alvefur Wed, 12 Apr 2017 17:26:13 +0200
Merge 0.10->trunk Kim Alvefur Mon, 10 Apr 2017 23:16:13 +0200
SQL: Use standard quotes for columns and other identifiers, rewrite to grave accents for MySQL only (fixes #885) Kim Alvefur Mon, 10 Apr 2017 23:13:39 +0200
Merge 0.10->trunk Kim Alvefur Mon, 03 Apr 2017 00:59:44 +0200
mod_storage_sql: Fix to use correct SQL query (thanks carlos) Kim Alvefur Mon, 03 Apr 2017 00:34:37 +0200
Merge 0.10->trunk Kim Alvefur Sat, 01 Apr 2017 21:48:54 +0200
mod_storage_sql: Remove unused return values (should those actually be used?) Kim Alvefur Sat, 01 Apr 2017 19:47:02 +0200
mod_storage_sql: Ignore name clash [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:45:47 +0200
mod_storage_sql: Split long lines [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:45:37 +0200
mod_storage_sql: Ignore name clash [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:45:20 +0200
mod_storage_sql: Pass SQL engine as an argument to upgrade and table creator functions Kim Alvefur Sat, 01 Apr 2017 19:39:20 +0200
mod_storage_sql: Move SQL queries into multiline strings for readability [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:26:27 +0200
mod_storage_sql: Rename variables to avoid name clashes [luacheck] Kim Alvefur Sat, 01 Apr 2017 19:25:34 +0200
mod_storage_sql: Sensible defaults for 'when' and 'with' arguments Kim Alvefur Sat, 01 Apr 2017 19:04:54 +0200
mod_storage_sql: Remove compat for argument order change Kim Alvefur Sat, 01 Apr 2017 19:02:27 +0200
Merge 0.10->trunk Kim Alvefur Mon, 20 Feb 2017 01:46:54 +0100
mod_storage_sql: Make archive:append() to return the id (or key) as first return value Kim Alvefur Mon, 20 Feb 2017 01:26:03 +0100
Merge 0.10->trunk Kim Alvefur Tue, 24 Jan 2017 19:27:17 +0100
mod_storage_sql: Fix to use correct order for return values from transaction (thanks postblue) Kim Alvefur Tue, 24 Jan 2017 19:26:40 +0100
Merge 0.10->trunk Kim Alvefur Mon, 23 Jan 2017 19:34:14 +0100
mod_storage_sql: Return number of affected items from archive:delete Kim Alvefur Tue, 22 Nov 2016 18:13:21 +0100
Merge 0.10->trunk Kim Alvefur Fri, 02 Dec 2016 11:13:05 +0100
mod_storage_sql: Normalize parameters for upgrade command Kim Alvefur Thu, 01 Dec 2016 10:02:57 +0100
mod_storage_sql: List available commands if no commands given (currenly only one available) Kim Alvefur Thu, 01 Dec 2016 10:02:26 +0100
mod_storage_sql: Don't say 'Unknown command' if no command was given (fixes attempt to concatenate nil) Kim Alvefur Thu, 01 Dec 2016 10:02:01 +0100
mod_storage_sql: Include missing parameter table key 'port' Kim Alvefur Thu, 01 Dec 2016 03:22:42 +0100
mod_storage_sql: Create a new table to hold normalized database parameters (fixes #636) Kim Alvefur Tue, 29 Nov 2016 08:20:42 +0100
mod_storage_sql: Use is_stanza() from util.stanza Kim Alvefur Mon, 28 Nov 2016 07:30:39 +0100
Update every link to the documentation to use HTTPS Emmanuel Gil Peyrot Sat, 16 Apr 2016 21:08:05 +0100
mod_storage_sql: Make sure all serialization errors are propagated Kim Alvefur Mon, 21 Mar 2016 09:33:12 +0100
mod_storage_sql: Allow loops over results to end on their own Kim Alvefur Sun, 13 Mar 2016 17:43:33 +0100
mod_storage_sql: Add LIMIT clause to queries where only a single row is expected Kim Alvefur Sun, 13 Mar 2016 17:42:22 +0100
mod_storage_sql: Treat non-existent archive IDs as beyound the end of the archive (fixes #624) (tested on sqlite3 only) Kim Alvefur Mon, 22 Feb 2016 15:23:27 +0100
mod_storage_sql: Remove debug logging of archive queries Kim Alvefur Sun, 21 Feb 2016 19:29:00 +0100
mod_storage_sql: Lower message about new engine creation to debug level Kim Alvefur Sun, 21 Feb 2016 19:01:26 +0100
mod_storage_sql: Share SQL connections with same parameters across VirtualHosts (fixes #576) Kim Alvefur Sun, 21 Feb 2016 14:53:19 +0100
mod_storage_sql: Fix setting value to false in map store Kim Alvefur Fri, 19 Feb 2016 19:22:18 +0100
mod_storage_sql: Silence some harmless luacheck warnings Kim Alvefur Tue, 09 Feb 2016 17:24:04 +0100
mod_storage_sql: Implement map:set_keys, allowing multiple keys to be set in the same transaction Kim Alvefur Tue, 09 Feb 2016 16:56:27 +0100
mod_storage_sql: Support non-string keys in map store Kim Alvefur Mon, 08 Feb 2016 20:23:12 +0100
mod_storage_sql: Fix use of SQLite3 in-memory database (no path expansion) Kim Alvefur Tue, 15 Dec 2015 13:15:30 +0100
mod_storage_sql: Add map store (backported from trunk) Matthew Wild Thu, 03 Dec 2015 15:03:24 +0000
mod_storage_sql: Whitespace fix (backported from trunk) Matthew Wild Thu, 03 Dec 2015 15:02:50 +0000
storagemanager, mod_storage_sql, mod_storage_sql2: Rename mod_storage_sql2 -> mod_storage_sql, mod_storage_sql -> mod_storage_sql1 (temporarily), and emit warning for configs using sql2 Matthew Wild Thu, 03 Dec 2015 14:57:49 +0000
mod_storage_{none,internal,sql}: Return error for unsupported (everything but keyval) store types Kim Alvefur Fri, 20 Jun 2014 16:22:23 +0200
core.certmanager, core.moduleapi, mod_storage_sql, mod_storage_sql2: Import from util.paths Kim Alvefur Fri, 09 May 2014 19:35:29 +0200
Remove all trailing whitespace Florian Zeitz Fri, 09 Aug 2013 17:48:21 +0200
mod_storage_sql: Return actual error string on commit failure. Waqas Hussain Fri, 30 Nov 2012 08:50:03 +0500
mod_storage_sql: Add support for iterating over users with data in a store Kim Alvefur Fri, 21 Sep 2012 17:24:06 +0200
Merge 0.9->trunk Matthew Wild Wed, 19 Sep 2012 12:14:08 +0100
mod_storage_sql: Remove obsolete comment Matthew Wild Wed, 19 Sep 2012 12:09:27 +0100
storagemanager, datamanager, mod_storage_{internal,sql}: Replace list_stores() with an iterator version Kim Alvefur Mon, 17 Sep 2012 05:42:10 +0200
mod_storage_*: Don't explicitly set driver name, to ease copying/renaming modules. Waqas Hussain Wed, 12 Sep 2012 23:46:10 +0500
core.storagemanager, mod_storage_*: "data-driver" -> "storage-provider", to allow using module:provides(). Waqas Hussain Wed, 12 Sep 2012 23:41:28 +0500
mod_storage_sql: Return connection from connect even if already connected (thanks IRON) Matthew Wild Mon, 30 Jul 2012 18:50:46 +0100
mod_storage_sql: Complete transactions in list_stores and purge Kim Alvefur Mon, 30 Jul 2012 06:01:41 +0200
mod_storage_sql: Keep connections in a shared cache table Kim Alvefur Mon, 30 Jul 2012 01:54:07 +0200
mod_storage_sql: Add method for removing all data belonging to a user Kim Alvefur Sat, 28 Jul 2012 21:36:42 +0200
mod_storage_sql: Add method for listing stores Kim Alvefur Sat, 28 Jul 2012 21:27:45 +0200
mod_storage_sql: Split out query handling logic from getsql() into a separate function Kim Alvefur Sat, 28 Jul 2012 21:26:33 +0200
mod_storage_sql: Add extra logging and error handling around table creation 0.8.2 Matthew Wild Sat, 11 Jun 2011 02:16:26 +0100
mod_storage_sql: Add sql_manage_tables to disable table creation/updating. Matthew Wild Sat, 11 Jun 2011 02:15:38 +0100
mod_storage_sql: Fix commit c806a599224a for compatibility with non-MySQL databases (thanks Ognyan Kulev) Matthew Wild Sun, 05 Jun 2011 11:53:29 +0100
mod_storage_sql: Log error when failing to update MySQL schema 0.8.1 Matthew Wild Fri, 03 Jun 2011 05:34:22 +0100
mod_storage_sql: Switch to MEDIUMTEXT for the 'value' column when using MySQL, as it imposes a 64K limit otherwise, potentially truncating data. Automatically upgrades existing tables. Matthew Wild Thu, 02 Jun 2011 02:30:26 +0100
mod_storage_sql: Display friendlier error when LuaDBI is missing Matthew Wild Tue, 01 Mar 2011 06:12:43 +0000
mod_storage_sql: Create index when creating a new table Matthew Wild Tue, 11 Jan 2011 04:19:26 +0000
mod_storage_sql: Reconnect in all cases, and rollback on error. Waqas Hussain Mon, 10 Jan 2011 21:07:59 +0500
mod_storage_sql: Create table automatically for all databases now, not just SQLite. Also rename table from Prosody -> prosody. Matthew Wild Sat, 08 Jan 2011 23:09:21 +0000
mod_storage_sql: Make the 'database' value for the SQLite3 driver relative to the data path Matthew Wild Fri, 07 Jan 2011 11:57:48 +0000
mod_storage_sql: Catch Lua errors during SQL transactions, and rollback. Waqas Hussain Wed, 05 Jan 2011 06:56:36 +0500
mod_storage_sql: Removed unnecessary initialization of a variable. Waqas Hussain Wed, 05 Jan 2011 06:23:58 +0500
mod_storage_sql: Use util.json instead of util.serialization. Waqas Hussain Mon, 27 Dec 2010 19:43:57 +0500
mod_storage_sql: Log an error on query failure. Waqas Hussain Mon, 27 Dec 2010 06:10:35 +0500
mod_storage_sql: Remove the subkey column from the Prosody table, and make the map store compatible with the key-value store. Waqas Hussain Mon, 27 Dec 2010 06:10:35 +0500
mod_storage_sql: Dynamically replace backquotes with double quotes when connecting to PostgreSQL... Waqas Hussain Mon, 27 Dec 2010 06:10:35 +0500
mod_storage_sql: Call commit() after all SQL statements, including SELECT, to get SQLite to drop its locks. Waqas Hussain Mon, 27 Dec 2010 06:10:35 +0500
mod_storage_sql: Quote identifiers in SQL with backquotes, and use the empty string for NULL, and '=' instead of 'IS' for comparison, to work with MySQL's limitations... Waqas Hussain Mon, 27 Dec 2010 06:10:35 +0500
mod_storage_sql: Fix a couple of bugs in "JSON" decoding Matthew Wild Sat, 18 Dec 2010 03:25:31 +0000
mod_storage_sql: Use 'IS' for comparison instead of '=', to avoid SQL's NULL insanity. Waqas Hussain Mon, 13 Dec 2010 19:28:57 +0500
mod_storage_sql: Fixed the deserialization of string-typed values. Waqas Hussain Mon, 13 Dec 2010 19:27:14 +0500
mod_storage_sql: Auto-initialize SQLite3 database. Waqas Hussain Sun, 12 Dec 2010 05:39:24 +0500
mod_storage_sql: Default value for option sql = { driver = "SQLite3", database = "prosody.sqlite" }. Waqas Hussain Sun, 12 Dec 2010 05:38:48 +0500
mod_storage_sql: Fixed a typo. Waqas Hussain Sun, 12 Dec 2010 05:38:08 +0500
mod_storage_sql: Initial commit of new SQL data driver. Waqas Hussain Sun, 12 Dec 2010 05:18:36 +0500
less more | (0) tip