Log

util/sql.lua @ 13265:6ac5ad578565

description author age
util.sql: Remove unused String() and Integer() functions Kim Alvefur Sat, 22 Jul 2023 14:55:27 +0200
util: Prefix module imports with prosody namespace Kim Alvefur Fri, 17 Mar 2023 16:23:16 +0100
mod_storage_sql: Record connection to database as module status Kim Alvefur Mon, 30 Jan 2023 00:38:26 +0100
util.sql: Handle failure to detect connection encoding Kim Alvefur Mon, 23 Dec 2019 21:13:27 +0100
util.sql: Preserve 3rd and 4th return values from transaction (fixes #1434) (thanks mrdoctorwho) Kim Alvefur Sat, 28 Sep 2019 18:24:28 +0200
util.sql: Remove tostring call from logging Kim Alvefur Tue, 30 Jul 2019 02:23:44 +0200
util.sql: Ignore if tables and indices already exist on creation (fixes #1064) 0.11 Kim Alvefur Thu, 30 May 2019 23:50:28 +0200
util.sql: Switch from hacky multi-arg xpcall implementation to util.xpcall 0.11 Kim Alvefur Sun, 11 Nov 2018 02:26:40 +0100
vairious: Add annotation when an empty environment is set [luacheck] Kim Alvefur Wed, 28 Feb 2018 20:06:26 +0100
util: Ignore some Lua 5.1 vs 5.2 compat things [luacheck] Kim Alvefur Fri, 10 Nov 2017 17:47:11 +0100
util: Various minor changes to please [luacheck] Kim Alvefur Fri, 10 Nov 2017 05:42:32 +0100
util.sql: Discard useless substitution count from string.gsub in SQL debug logs Kim Alvefur Wed, 08 Nov 2017 10:45:58 +0100
util.sql: Return an error message when a SQL commit fails (LuaDBI doesn't) (Thanks Ge0rG) Kim Alvefur Tue, 07 Nov 2017 09:26:48 +0100
util.sql: Don't log at error level if a transaction failed and was retried ok Matthew Wild Wed, 04 Oct 2017 10:16:42 +0100
util.sql: Greedily read all rows so we can close queries early (fixes #391) Matthew Wild Fri, 04 Aug 2017 18:52:15 +0100
util.sql: Produce more SQL-standard-like debug messages Kim Alvefur Thu, 13 Apr 2017 22:37:35 +0200
util.sql: Strip indentation from queries for debug logging Kim Alvefur Wed, 12 Apr 2017 18:57:40 +0200
util.sql: Apply quote transform in engine:execute so it is applied to eg encoding checks in mod_storage_sql (thanks Martin) Kim Alvefur Wed, 12 Apr 2017 17:26:44 +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
util.sql: remove unused one-letter loop variables [luacheck] Anton Shestakov Sat, 23 Jul 2016 18:22:05 +0800
util.sql: Import type too (fix global access) Kim Alvefur Sun, 22 May 2016 14:37:52 +0200
util.sql: Import pcall (fixes #677) Matthew Wild Sun, 22 May 2016 02:16:11 +0100
util.sql: Log errors in transaction to error level with traceback but return only error message (fixes #464) Kim Alvefur Fri, 25 Mar 2016 16:09:34 +0100
util.sql: Charset should be innocent until proven guilty (initialize charset_ok to true), fixes bug introduced in 187ba2e9c012 Matthew Wild Wed, 23 Mar 2016 12:17:28 +0000
util.sql: Catch errors from LuaDBI connect (Fixes #568) Kim Alvefur Mon, 21 Mar 2016 09:50:52 +0100
util.sql: Remove unused arguments [luacheck] Kim Alvefur Sun, 13 Mar 2016 18:35:00 +0100
util.sql: Don't break out of result retreival loops Kim Alvefur Sun, 13 Mar 2016 18:31:53 +0100
util.sql: Move per-driver (currenly only PostgreSQL) query transform into its own method Kim Alvefur Sun, 13 Mar 2016 17:38:49 +0100
util.sql: Localize unpack() in Lua 5.2 compatible way Kim Alvefur Mon, 22 Feb 2016 17:30:12 +0100
util.sql: Raw query debug logging (needs to be explicitly enabled by a plugin) Kim Alvefur Sun, 21 Feb 2016 19:25:01 +0100
util.sql: Export db2uri (mod_storage_sql2 command uses it) (thanks mike) Kim Alvefur Wed, 02 Sep 2015 14:14:22 +0200
util.sql: Log when transactions begin Kim Alvefur Sun, 30 Aug 2015 13:45:36 +0200
util.*: Remove use of module() function, make all module functions local and return them in a table at the end Kim Alvefur Sat, 21 Feb 2015 10:36:37 +0100
util.{interpolation,prosodyctl,sql}: Trim trailing whitespace Kim Alvefur Fri, 17 Jul 2015 12:43:04 +0200
util.sql: Add safety check to ensure our chosen connection charset is actually being used (MySQL) Matthew Wild Wed, 08 Jul 2015 15:25:42 +0100
util.sql: Fix log level of debug message Matthew Wild Wed, 08 Jul 2015 15:16:17 +0100
util.sql: Log debug message when connecting to database Matthew Wild Wed, 08 Jul 2015 15:15:32 +0100
util.sql: Make set_encoding() return failure of SET NAMES Matthew Wild Wed, 08 Jul 2015 15:14:24 +0100
util.sql: Return failure if set_encoding() fails Matthew Wild Wed, 08 Jul 2015 15:10:25 +0100
util.sql: Use appropriate collation for the chosen character set - fixes MySQL silently ignoring our SET NAMES command when we use utf8mb4 Matthew Wild Wed, 08 Jul 2015 15:06:20 +0100
util.sql: Create table with same charset as the charset we selected for our connection, also use corresponding _bin collation Matthew Wild Wed, 08 Jul 2015 15:04:23 +0100
util.sql: Allow onconnect callback to fail connection to the DB by returning false, err Matthew Wild Tue, 07 Jul 2015 17:43:14 +0100
util.sql: Call onconnect, provide noop dummy if not set Kim Alvefur Thu, 02 Jul 2015 22:32:44 +0200
util.sql: Remove built-in engine caching. This is the wrong layer to do this, and unintentionally sharing connections could cause problems (e.g. when interleaving multiple queries and result fetching) Matthew Wild Wed, 03 Jun 2015 15:57:46 +0100
util.sql: Expose db2uri helper function Matthew Wild Wed, 03 Jun 2015 15:55:43 +0100
util.sql: Rename some variable to match conventions Matthew Wild Wed, 03 Jun 2015 15:54:52 +0100
util.sql: Remove unused functions and unused commented code Matthew Wild Sat, 30 May 2015 22:23:19 +0100
mod_storage_sql2, util.sql: Set character encoding on every connect Kim Alvefur Thu, 11 Dec 2014 09:18:39 +0100
util.sql: Fix previous commit Kim Alvefur Tue, 12 Nov 2013 11:38:52 +0100
util.sql: Get character set info from the correct database. Kim Alvefur Tue, 12 Nov 2013 11:13:45 +0100
util.sql: Rewrite auto increment columns to SERIAL for PostgreSQL Kim Alvefur Mon, 11 Nov 2013 23:09:18 +0100
util.sql: Fix to call execute on 'self' rather than 'engine' (thanks eisensheng) Matthew Wild Sun, 10 Nov 2013 23:10:27 +0000
util.sql: Rewrite MEDIUMTEXT to TEXT for drivers other than MySQL Kim Alvefur Wed, 30 Oct 2013 10:24:35 +0100
util.sql: Check what encoding SQLite3 uses Kim Alvefur Tue, 29 Oct 2013 11:43:49 +0100
util.sql: Find out if MySQL supports utf8mb4 and use that Kim Alvefur Tue, 29 Oct 2013 11:42:55 +0100
util.sql: Support incrementing columns Kim Alvefur Mon, 28 Oct 2013 23:20:25 +0100
util.sql: Allow columns to be marked the primary key Kim Alvefur Mon, 28 Oct 2013 23:19:47 +0100
util.sql: Allow creating unique indices Kim Alvefur Mon, 28 Oct 2013 23:18:54 +0100
mod_storage_sql2, util.sql: Move code for setting encoding to util.sql Kim Alvefur Mon, 28 Oct 2013 22:07:16 +0100
Remove all trailing whitespace Florian Zeitz Fri, 09 Aug 2013 17:48:21 +0200
util.sql: Do lazy fetching of affected/rowcount Kim Alvefur Fri, 12 Jul 2013 17:44:30 +0200
Backed out changeset 3c57c2281087 Kim Alvefur Fri, 12 Jul 2013 17:41:54 +0200
util.sql: Don't fetch row count of result sets for queries that don't have result sets Kim Alvefur Fri, 12 Jul 2013 17:03:09 +0200
util.sql: Set charset and collation for MySQL when creating tables Kim Alvefur Thu, 11 Jul 2013 22:07:55 +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 Matthew Wild Thu, 18 Apr 2013 11:13:40 +0100