How to acces a MySQL table with ActiveRecord

ruby-talk
1

# require AR
require 'rubygems'
require_gem 'activerecord'

ActiveRecord::Base.establish_connection({
      :adapter => "mysql",
      :database => "cocoa",
      :socket => "/tmp/mysql.socket",
      :username => <myusername>,
      :password => <mypassword>
})

# define a simple model
class Task < ActiveRecord::Base
end

I am trying to run this script in ruby that reads a MySQL table, called
Tasks, like in this example:

I got the following error message:
irb(main):001:0> Task.create "title" => "Item #1"
NameError: uninitialized constant Task
        from (irb):1

···

--
Posted via http://www.ruby-forum.com/.

2

here is the solution:
http://vsbabu.org/mt/archives/2005/07/19/oracle_with_active_record.html

Jose Pepe wrote:

···

# require AR
require 'rubygems'
require_gem 'activerecord'

ActiveRecord::Base.establish_connection({
      :adapter => "mysql",
      :database => "cocoa",
      :socket => "/tmp/mysql.socket",
      :username => <myusername>,
      :password => <mypassword>
})

# define a simple model
class Task < ActiveRecord::Base
end

I am trying to run this script in ruby that reads a MySQL table, called
Tasks, like in this example:

http://wiki.rubyonrails.com/rails/pages/HowToUseActiveRecordOutsideRails

I got the following error message:
irb(main):001:0> Task.create "title" => "Item #1"
NameError: uninitialized constant Task
        from (irb):1

--
Posted via http://www.ruby-forum.com/\.