aboutsummaryrefslogtreecommitdiffstats
path: root/plugins/mod_storage_sql.lua
Commit message (Collapse)AuthorAgeFilesLines
* mod_storage_sql: Move update limit check back one step, fixes tracebackKim Alvefur2020-02-221-6/+6
| | | | | 0c00274528a4 moved it one step too far, so the check was performed before connecting to the database instead of after.
* mod_storage_sql: Fix check for deletion limits (fixes #1494)Kim Alvefur2020-02-211-7/+7
| | | | | The check was only performed if sql_manage_tables was set to true (the default) It should always be performed
* mod_storage_sql: Handle SQLite DELETE with LIMIT being optional (fixes #1359)Kim Alvefur2019-05-131-6/+15
|
* mod_storage_sql: Move code out of if-else chainKim Alvefur2019-05-131-9/+8
|
* mod_storage_sql: Catch errors during schema upgrade (thanks Nothing4You)Matthew Wild2018-11-151-4/+4
|
* mod_storage_sql: Handle Lua 5.3 move of unpack functionKim Alvefur2018-10-211-1/+1
|
* mod_storage_sql: Fix issue number in comment that was fixed by 55b40f3fa659 ↵Matthew Wild2018-10-131-1/+1
| | | | (fixes #1073)
* mod_storage_sql: Keep prosodyarchive_index unique constraint on non-MySQL DBsMatthew Wild2018-10-121-1/+1
|
* mod_storage_sql: Change prosodyarchive_index to be non-unique (fixes #1087)Matthew Wild2018-10-111-8/+25
| | | | | | MySQL requires that the first 20 bytes are unique, even if they differ after the first 20 bytes. This breaks e.g. pubsub/PEP nodes longer than 20 characters that have common prefixes.
* mod_storage_sql: Have :users() throw an error on failure instead of ↵Matthew Wild2018-10-111-1/+1
| | | | returning non-iterator values
* mod_storage_sql: Workaround MySQL not supporting LIMIT subquery in archive ↵Matthew Wild2018-10-111-3/+9
| | | | truncate operations, fixes #1200
* mod_storage_sql: Remove unused function argument [luacheck]Kim Alvefur2018-10-101-1/+1
| | | | What was the intent of this argument anyways?
* mod_storage_sql: Catch and report value deserialization errorsKim Alvefur2018-02-241-8/+19
|
* Merge 0.10->trunkKim Alvefur2017-12-221-1/+1
|\
| * mod_storage_sql: Index over contact and timestamp (happy now Ge0rg?)Kim Alvefur2017-12-121-1/+1
| |
* | mod_storage_sql: Remove ability to override name of key-value table ↵Kim Alvefur2017-12-111-1/+1
| | | | | | | | (unreachable and would not work)
* | Merge 0.10->trunkKim Alvefur2017-11-211-0/+2
|\|
| * mod_storage_sql: Add indices that include the with and when columns of archivesKim Alvefur2017-11-211-0/+2
| |
* | mod_storage_sql: Add support for truncating deletionKim Alvefur2017-11-091-1/+29
| |
* | Merge 0.10->trunkKim Alvefur2017-10-051-2/+2
|\|
| * mod_storage_sql: Also clear the prosodyarchive table when an user is deleted ↵Kim Alvefur2017-10-051-0/+1
| | | | | | | | (fixes #1009)
| * mod_storage_sql: Remove return values from purge methodKim Alvefur2017-10-051-2/+1
| |
* | Merge 0.10->trunkKim Alvefur2017-05-171-1/+1
|\|
| * mod_storage_sql: Fix logic error introduced by variable rename in ↵Matthew Wild2017-04-301-1/+1
| | | | | | | | aa9f198cb3c9 (thanks waqas)
* | Merge 0.10->trunkKim Alvefur2017-04-131-6/+10
|\|
| * mod_storage_sql: Limit encoding check to current databaseKim Alvefur2017-04-131-2/+4
| |
| * mod_storage_sql: Break long linesKim Alvefur2017-04-121-2/+5
| |
| * mod_storage_sql: Pass charset and collation names via variable bindingKim Alvefur2017-04-121-4/+3
| |
| * mod_storage_sql: Quote some field namesKim Alvefur2017-04-121-2/+2
| |
* | Merge 0.10->trunkKim Alvefur2017-04-121-1/+1
|\|
| * mod_storage_sql: Raise error if encoding check query failsKim Alvefur2017-04-121-1/+1
| |
* | Merge 0.10->trunkKim Alvefur2017-04-101-54/+54
|\|
| * SQL: Use standard quotes for columns and other identifiers, rewrite to grave ↵Kim Alvefur2017-04-101-54/+54
| | | | | | | | accents for MySQL only (fixes #885)
* | Merge 0.10->trunkKim Alvefur2017-04-031-1/+1
|\|
| * mod_storage_sql: Fix to use correct SQL query (thanks carlos)Kim Alvefur2017-04-031-1/+1
| |
* | Merge 0.10->trunkKim Alvefur2017-04-011-44/+126
|\|
| * mod_storage_sql: Remove unused return values (should those actually be used?)Kim Alvefur2017-04-011-1/+2
| |
| * mod_storage_sql: Ignore name clash [luacheck]Kim Alvefur2017-04-011-1/+1
| |
| * mod_storage_sql: Split long lines [luacheck]Kim Alvefur2017-04-011-2/+4
| |
| * mod_storage_sql: Ignore name clash [luacheck]Kim Alvefur2017-04-011-1/+1
| |
| * mod_storage_sql: Pass SQL engine as an argument to upgrade and table creator ↵Kim Alvefur2017-04-011-6/+6
| | | | | | | | functions
| * mod_storage_sql: Move SQL queries into multiline strings for readability ↵Kim Alvefur2017-04-011-21/+101
| | | | | | | | [luacheck]
| * mod_storage_sql: Rename variables to avoid name clashes [luacheck]Kim Alvefur2017-04-011-11/+11
| |
| * mod_storage_sql: Sensible defaults for 'when' and 'with' argumentsKim Alvefur2017-04-011-0/+2
| |
| * mod_storage_sql: Remove compat for argument order changeKim Alvefur2017-04-011-3/+0
| |
* | Merge 0.10->trunkKim Alvefur2017-02-201-1/+3
|\|
| * mod_storage_sql: Make archive:append() to return the id (or key) as first ↵Kim Alvefur2017-02-201-1/+3
| | | | | | | | return value
* | Merge 0.10->trunkKim Alvefur2017-01-241-2/+2
|\|
| * mod_storage_sql: Fix to use correct order for return values from transaction ↵Kim Alvefur2017-01-241-2/+2
| | | | | | | | (thanks postblue)
* | Merge 0.10->trunkKim Alvefur2017-01-231-1/+2
|\|