CODEWITHSUNDEEP
rubysqlite
marinatedpork
marinatedpork

Reputation: 189

Preparing and executing SQLite Statements in Ruby

I have been trying to puts some executed statements after I prepare them. The purpose of this is to sanitize my data inputs, which I have never done before. I followed the steps here, but I am not getting the result I want.

Here's what I have:

require 'sqlite3'

$db = SQLite3::Database.open "congress_poll_results.db"

def rep_pull(state)
  pull = $db.prepare("SELECT name, location FROM congress_members WHERE location = ?")
  pull.bind_param 1, state
  puts pull.execute
end

rep_pull("MN")

=> #<SQLite3::ResultSet:0x2e69e00>

What I am expecting is a list of reps in MN, but instead I just get "SQLite3::ResultSet:0x2e69e00" thing.

What am I missing here? Thanks very much.

Upvotes: 1

Views: 1768

Answers (1)

usha
usha

Reputation: 29349

Try this

def rep_pull(state)
  pull = $db.prepare("SELECT name, location FROM congress_members WHERE location = ?")
  pull.bind_param 1, state
  pull.execute do |row|
     p row
  end
end

Upvotes: 2

Related Questions