While it’s trivial to connect to the db with ActiveRecord:
This call creates a connection to our database.
ActiveRecord::Base.establish_connection(
:adapter => “mysql”,
:host => “127.0.0.1”,
:username => “ruby”,
:password => “password”,
:database => “rss2mysql”)
class Items < ActiveRecord::Base
end
It’s unclear to me how to get an array/queue/whatever of each of the
Item
instances in the db into memory. Do you first create an array, and then
how do you populate it? I’m not tied to ActiveRecord, that’s just what
I’ve been using so far. My code:
[email protected]:~/rb$
[email protected]:~/rb$ cat mysql.rb
#!/usr/bin/ruby
require ‘rubygems’
require ‘active_record’ #well, would like to use it
require ‘mysql’ #want to drop this
require ‘net/http’
$maxwidth = 12 # MAXIMUM WIDTH OF FIELD DISPLAYS
INITIALIZE AND CONNECT TO DATABASE test
mysql = Mysql.init()
mysql.connect(‘localhost’, ‘ruby’, ‘password’)
mysql.select_db(‘rss2mysql’)
PRINT OUT FIELD NAMES AND VALUES
puts
results = mysql.query(“describe rss2mysql.items;”)
results.each do |row|
column = row[0]
print column
($maxwidth - column.length).times {print " "}
end
puts
puts
urls = Queue.new
results = mysql.query(“SELECT url from rss2mysql.items;”)
results.each do |row|
row.each do |column|
print column
($maxwidth - column.length).times {print " "}
urls.push(Net::HTTP.new(column, 80)) #wrong loop
end
puts
end
SHUT DOWN THE DATABASE CONNECTION
mysql.close()
#####surely there’s a better way to iterate
#####need to process the queue of url’s
x = urls.length
x.times do
html = urls.pop
puts html
end
[email protected]:~/rb$
Basically, how to I make the above more db independant with some form of
ORM?
thanks,
Thufir