From 86644ab8ab6e47d6ce3edaa18b6f8284d83c9816 Mon Sep 17 00:00:00 2001 From: Waqas Hussain Date: Mon, 27 Dec 2010 06:10:35 +0500 Subject: mod_storage_sql: Dynamically replace backquotes with double quotes when connecting to PostgreSQL... --- plugins/mod_storage_sql.lua | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'plugins') diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua index 12c8eebe..ca024329 100644 --- a/plugins/mod_storage_sql.lua +++ b/plugins/mod_storage_sql.lua @@ -29,12 +29,13 @@ local json = { stringify = function(s) return require"util.serialization".serial local connection = ...; local host,user,store = module.host; +local params = module:get_option("sql"); do -- process options to get a db connection local DBI = require "DBI"; - local params = module:get_option("sql") or { driver = "SQLite3", database = "prosody.sqlite" }; - assert(params and params.driver and params.database, "invalid params"); + params = params or { driver = "SQLite3", database = "prosody.sqlite" }; + assert(params.driver and params.database, "invalid params"); prosody.unlock_globals(); local dbh, err = DBI.Connect( @@ -85,6 +86,9 @@ local function deserialize(t, value) end local function getsql(sql, ...) + if params.driver == "PostgreSQL" then + sql = sql:gsub("`", "\""); + end -- do prepared statement stuff local stmt, err = connection:prepare(sql); if not stmt then return nil, err; end -- cgit v1.2.3