# HG changeset patch # User Matthew Wild # Date 1435182941 -3600 # Node ID 9f932a31eeba141f834a93a282804be7f105a9e9 # Parent 4aee55c0cc5c25accc4f35822a63f10c7ed85c63 mod_storage_sql2: Some reformatting and variable name improvements diff -r 4aee55c0cc5c -r 9f932a31eeba plugins/mod_storage_sql2.lua --- a/plugins/mod_storage_sql2.lua Wed Jun 24 22:54:17 2015 +0100 +++ b/plugins/mod_storage_sql2.lua Wed Jun 24 22:55:41 2015 +0100 @@ -197,7 +197,7 @@ local keyval_store = {}; keyval_store.__index = keyval_store; function keyval_store:get(username) - user,store = username,self.store; + user, store = username, self.store; local ok, result = engine:transaction(keyval_store_get); if not ok then return ok, result; end return result; @@ -361,13 +361,13 @@ end function driver:stores(username) - local sql = "SELECT DISTINCT `store` FROM `prosody` WHERE `host`=? AND `user`" .. + local query = "SELECT DISTINCT `store` FROM `prosody` WHERE `host`=? AND `user`" .. (username == true and "!=?" or "=?"); if username == true or not username then username = ""; end local ok, result = engine:transaction(function() - return engine:select(sql, host, username); + return engine:select(query, host, username); end); if not ok then return ok, result end return iterator(result); @@ -376,7 +376,7 @@ function driver:purge(username) return engine:transaction(function() local stmt,err = engine:delete("DELETE FROM `prosody` WHERE `host`=? AND `user`=?", host, username); - return true,err; + return true, err; end); end