From: Thufir <hawat.thufir@...>
Date: 2009-11-16T03:50:11+09:00
Subject: Re: Using activerecord with mysql

Dunno if this helps, but the following works for me:

thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$ nl query.rb
     1	require 'rubygems'
     2	require 'activerecord'
     3	require 'yaml'
     4	require 'item'
     5	require 'open-uri'
     6	require 'pp'


     7	db = YAML::load(File.open('database.yml'))

     8	ActiveRecord::Base.establish_connection(
     9	:adapter  => db["development"]["adapter"],
    10	:host   => db["development"]["host"],
    11	:username => db["development"]["username"],
    12	:password => db["development"]["password"],
    13	:database => db["development"]["database"])


    14	items = Item.find(:all)

    15	items.each do |item|
    16	  pp "************************"
    17	  pp "************************"
    18	  pp "************************"
    19	  pp "************************"
    20	  pp "************************"
    21	  pp "************************"
    22	  pp "************************"
    23	  pp item.url
    24	end
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$ nano query.rb
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$ nl query.rb
     1	require 'rubygems'
     2	require 'activerecord'
     3	require 'yaml'
     4	require 'item'
     5	require 'open-uri'
     6	require 'pp'


     7	db = YAML::load(File.open('database.yml'))

     8	ActiveRecord::Base.establish_connection(
     9	:adapter  => db["development"]["adapter"],
    10	:host   => db["development"]["host"],
    11	:username => db["development"]["username"],
    12	:password => db["development"]["password"],
    13	:database => db["development"]["database"])


    14	items = Item.find(:all)

    15	items.each do |item|
    16	  pp item.url
    17	end
thufir@ARRAKIS:~/projects/rss2mysql$
thufir@ARRAKIS:~/projects/rss2mysql$ nl database.yml
     1	development:
     2	 adapter: mysql
     3	 host: 127.0.0.1
     4	 database: rss2mysql
     5	 username: ruby
     6	 password: password

     7	test:
     8	 adapter: mysql
     9	 host: 127.0.0.1
    10	 database: rss2mysql
    11	 username: ruby
    12	 password: password
thufir@ARRAKIS:~/projects/rss2mysql$



you can always try with sqlite first, which requires little to no
configuration.  Also, see:

http://blog.aizatto.com/2007/05/21/activerecord-without-rails/



HTH,


Thufir