Formatting SQL output in Ruby

Question

How can I add characters and chain two db queries in the puts statement of Ruby? I'm using sqlite 3

The desired output I want is

Sam - 32

I imagine the code would look something like this:

puts $db.execute(SELECT first_name FROM info) + " - " + $db.execute(SELECT age FROM info)

I know that there is an issue with converting the string to an array. Any help would be appreciated!

usha · Accepted Answer · 2013-11-21 17:13:26Z

1

Is this what you are looking for?

$db.execute("SELECT CONCAT(first_name, ' - ', age) as name_and_age FROM info")

answered Nov 21, 2013 at 17:13

usha

29.4k5 gold badges75 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Denis de Bernardy · Accepted Answer · 2013-11-21 17:21:08Z

1

It's unclear which SQL library you're using, but I suspect this should get you in the right direction:

$db.execute( "select * from table" ) do |row|
  p row
end

answered Nov 21, 2013 at 17:21

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

Using sqlite3. Thanks for the comment. This is what helped me most, but I ended up monkey-patching it a little bit. Thank you.

stevenspiel · Accepted Answer · 2013-11-21 18:15:52Z

1

At least with sqlite3, this is what gives the desired output:

puts $db.execute(SELECT first_name || ' - ' || age FROM info)

answered Nov 21, 2013 at 18:15

stevenspiel

6,04914 gold badges66 silver badges90 bronze badges