developer toolbox » ruby » rails

hernad@desk-13:~/devel/ruby$ irb
irb(main):001:0> require "rubygems" 
=> true
irb(main):002:0> require "activerecord" 
=> true
irb(main):003:0> ActiveRecord::Base.establish_connection(
irb(main):004:1* :adapter => "mysql",
irb(main):005:1* :host => "localhost",
irb(main):006:1* :username => "root",
irb(main):007:1* :password => "",
irb(main):008:1* :database => "redmine_development",
irb(main):009:1* :socket => "/var/run/mysqld/mysqld.sock" 
irb(main):010:1> )
=> #<ActiveRecord::Base::ConnectionSpecification:0xb77c7ccc @config={:database=>"redmine_development", :host=>"localhost", :socket=>"/var/run/mysqld/mysqld.sock", :adapter=>"mysql", :username=>"root", :password=>""}, @adapter_method="mysql_connection">
irb(main):011:0> class Issues < ActiveRecord::Base
irb(main):012:1> end
=> nil
irb(main):013:0> class Issue < ActiveRecord::Base
irb(main):014:1> end
=> nil
irb(main):015:0> issue = Issue.find(1)
=> #<Issue id: 1, tracker_id: 1, project_id: 7, subject: "ScInfrastructure serveri, UPS", description: "Prikopcati sve ScInfrastructure servere na UPS-ove", due_date: nil, category_id: 7, status_id: 3, assigned_to_id: 11, priority_id: 2, fixed_version_id: nil, author_id: 3, lock_version: 1, created_on: "2004-06-22 15:19:35", updated_on: "2008-02-03 21:23:05", start_date: nil, done_ratio: 0, estimated_hours: nil>
irb(main):016:0> issue.updated_on
=> Sun Feb 03 21:23:05 +0100 2008
irb(main):017:0> issue = Issue.new
=> #<Issue id: nil, tracker_id: 0, project_id: 0, subject: "", description: nil, due_date: nil, category_id: nil, status_id: 0, assigned_to_id: nil, priority_id: 0, fixed_version_id: nil, author_id: 0, lock_version: 0, created_on: nil, updated_on: nil, start_date: nil, done_ratio: 0, estimated_hours: nil>
irb(main):018:0> issue.subject = "test" 
=> "test" 
irb(main):019:0> issue.author_id=1
=> 1
irb(main):020:0> issue.save
=> true
irb(main):021:0> Issue.count
=> 1296
irb(main):022:0> issue = Issue.find_by_description("test")
=> nil
irb(main):023:0> issue = Issue.new
=> #<Issue id: nil, tracker_id: 0, project_id: 0, subject: "", description: nil, due_date: nil, category_id: nil, status_id: 0, assigned_to_id: nil, priority_id: 0, fixed_version_id: nil, author_id: 0, lock_version: 0, created_on: nil, updated_on: nil, start_date: nil, done_ratio: 0, estimated_hours: nil>
irb(main):024:0> issue.author_id=1
=> 1
irb(main):025:0> issue.subject="test_2" 
=> "test_2" 
irb(main):026:0> issue.save
=> true
irb(main):027:0> issue = Issue.find_by_subject("test")
=> #<Issue id: 1296, tracker_id: 0, project_id: 0, subject: "test", description: nil, due_date: nil, category_id: nil, status_id: 0, assigned_to_id: nil, priority_id: 0, fixed_version_id: nil, author_id: 1, lock_version: 0, created_on: "2008-02-04 18:06:21", updated_on: "2008-02-04 18:06:21", start_date: nil, done_ratio: 0, estimated_hours: nil>
irb(main):028:0> issue = Issue.find_by_subject("test_2")
=> #<Issue id: 1297, tracker_id: 0, project_id: 0, subject: "test_2", description: nil, due_date: nil, category_id: nil, status_id: 0, assigned_to_id: nil, priority_id: 0, fixed_version_id: nil, author_id: 1, lock_version: 0, created_on: "2008-02-04 18:07:59", updated_on: "2008-02-04 18:07:59", start_date: nil, done_ratio: 0, estimated_hours: nil>
irb(main):029:0> issue.count
NoMethodError: undefined method @count' for #<Issue:0xb795b00c>
        from /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/attribute_methods.rb:205:in @method_missing'
        from (irb):29
irb(main):030:0> Issue.count
=> 1297