Hi folks -
After getting my installation worked out, I’m having an error in my test
code that I just don’t understand. I am running on OS X (PowerPC).
Ruby 1.8.4
mySQL 5.0.27
I’m using DBI to access the database, borrowing code from the Ruby
Cookbook. The connection routine:
####################################################################
dbconnect.rb:
####################################################################
#!/usr/bin/ruby -w
require ‘rubygems’
require ‘dbi’
def with_db
DBI.connect(“DBI:Mysql:iskme_import:localhost”, “ISKME”,
“oerportal”) do |c|
yield c
end
end
And my test code:
####################################################################
#!/usr/bin/ruby -w
require ‘pp’
require ‘dbconnect’
sql = “SELECT * FROM AddItems”
sql = "INSERT INTO AddItems(type, iskme_id, native_id, title, url,
institution, collection, submitter) " +
“VALUES (‘C’,‘C000000299634946873’, ‘11’, ‘Too High for the
Supermarket’, +
" ‘http://www.diamondw.net/index.html’, " +
" ‘The Uninvited’, ‘13 Ways to Feel the Love’,
‘andyw’)”
with_db do |c|
c.execute(sql).each do |row|
pp [“GOT:”, row]
end
print “found #{rows} rows\n”
end
If I run the INSERT statement, I get this error:
/usr/local/lib/ruby/site_ruby/1.8/DBD/Mysql/Mysql.rb:601:in fetch': undefined method fetch_row’ for nil:NilClass (NoMethodError)
from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:659:in fetch' from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:684:in each’
from dbtest.rb:14
from ./dbconnect.rb:9:in with_db' from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:429:in connect’
from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:214:in connect' from ./dbconnect.rb:8:in with_db’
from dbtest.rb:11
BUT, the record gets inserted (I use phpMyAdmin to administer the DB,
and I see the record). I just can’t figure out what’s happening here.
All help will be greatly appreciated.
Thanks,
Andy