:host => cfg.davical_dbhost,
:port => cfg.davical_dbport,
:options => cfg.davical_dbopts,
- :tty => cfg.davical_dbtty,
:dbname => cfg.davical_dbname,
:user => cfg.davical_dbuser,
:password => cfg.davical_dbpass }
sql_query = 'SELECT username FROM usr WHERE user_no > 1;'
begin
- connection.query(sql_query) do |result|
+ connection.sync_exec(sql_query) do |result|
usernames = result.field_values('username')
end
ensure
sql_query += 'WHERE usr.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
principal_id = result[0]['principal_id']
end