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:
thufir@ARRAKIS:~/rb$
thufir@ARRAKIS:~/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
thufir@ARRAKIS:~/rb$
Basically, how to I make the above more db independant with some form of
ORM?
thanks,
Thufir