X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=lib%2Fcommon%2Froundcube_plugin.rb;h=6d522bb371847e433906af3792f74545916bd7cc;hp=a4300c4a016bcd8f85d6177edd76f1ee51378426;hb=fa7782720ff15fce29b6f875678e9fd0c197485a;hpb=b947ef8844f090eedd50be0383abe417d910bb1a diff --git a/lib/common/roundcube_plugin.rb b/lib/common/roundcube_plugin.rb index a4300c4..6d522bb 100644 --- a/lib/common/roundcube_plugin.rb +++ b/lib/common/roundcube_plugin.rb @@ -47,12 +47,12 @@ module RoundcubePlugin def list_users() usernames = [] - connection = PG::Connection.connect(@db_hash) + connection = PG::Connection.new(@db_hash) sql_query = 'SELECT username FROM users;' begin - connection.query(sql_query) do |result| + connection.sync_exec(sql_query) do |result| usernames = result.field_values('username') end ensure @@ -79,7 +79,7 @@ module RoundcubePlugin sql_query = 'SELECT user_id FROM users WHERE username = $1;' begin - connection.query(sql_query, [user.to_s()]) do |result| + connection.sync_exec_params(sql_query, [user.to_s()]) do |result| if result.num_tuples > 0 user_id = result[0]['user_id'] end