No real introduction here today, just some sample Ruby code I want to have out here so I can remember some syntax for using Ruby to connect to a MySQL database.
In particular I am also using the here document syntax to simplify the writing and reading of a long database query.
Ruby MySQL DBI example
# require the dbi driver require 'dbi' # here is my long sample query query = <
and status = 1
and project like 'Quarry%'
and employee_full_name in ('Fred Flinstone', 'Barney Rubble', 'Wilma%')
order by name, date, project;
# mysql connect statement
dbh = DBI.connect('DBI:Mysql:the_database:localhost', 'root', 'the_password')
sth = dbh.prepare(query)
# print each database row
while row=sth.fetch do