- sql_query = "SELECT user_id FROM users WHERE username = $1;"
-
- connection.query(sql_query, [account]) do |result|
- if result.num_tuples > 0
- user_id = result[0]['user_id']
- end
+ sql_query = "SELECT username FROM users;"
+ connection.query(sql_query) do |result|
+ usernames = result.field_values('username')