diff options
| author | Kim Alvefur <zash@zash.se> | 2019-05-13 14:47:41 +0200 |
|---|---|---|
| committer | Kim Alvefur <zash@zash.se> | 2019-05-13 14:47:41 +0200 |
| commit | bb5a09ed708d6d82d477998fd8261d3164dc3c11 (patch) | |
| tree | 37b8ec274c2f8c0074f5184e8c1f82195b97f4bb /plugins/mod_storage_sql.lua | |
| parent | 85723ef8471270a831a4b3c261f0cd2ef48ff4b3 (diff) | |
| download | prosody-bb5a09ed708d6d82d477998fd8261d3164dc3c11.tar.gz prosody-bb5a09ed708d6d82d477998fd8261d3164dc3c11.zip | |
mod_storage_sql: Move code out of if-else chain
Diffstat (limited to 'plugins/mod_storage_sql.lua')
| -rw-r--r-- | plugins/mod_storage_sql.lua | 17 |
1 files changed, 8 insertions, 9 deletions
diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua index 56cef569..dbf5e2da 100644 --- a/plugins/mod_storage_sql.lua +++ b/plugins/mod_storage_sql.lua @@ -390,6 +390,14 @@ function archive_store:delete(username, query) else args[#args+1] = query.truncate; local unlimited = "ALL"; + sql_query = [[ + DELETE FROM "prosodyarchive" + WHERE "sort_id" IN ( + SELECT "sort_id" FROM "prosodyarchive" + WHERE %s + ORDER BY "sort_id" %s + LIMIT %s OFFSET ? + );]]; if engine.params.driver == "SQLite3" then sql_query = [[ DELETE FROM "prosodyarchive" @@ -407,15 +415,6 @@ function archive_store:delete(username, query) LIMIT %s OFFSET ? ) AS limiter on result.sort_id = limiter.sort_id;]]; unlimited = "18446744073709551615"; - else - sql_query = [[ - DELETE FROM "prosodyarchive" - WHERE "sort_id" IN ( - SELECT "sort_id" FROM "prosodyarchive" - WHERE %s - ORDER BY "sort_id" %s - LIMIT %s OFFSET ? - );]]; end sql_query = string.format(sql_query, t_concat(where, " AND "), query.reverse and "ASC" or "DESC", unlimited); |