failry simple(?) active record question.

[Kyle Schmitt]

I'm plodding my way through active record right now, and running into
some things that seem odd.

Take a really simple example
#!/usr/bin/ruby
require 'rubygems'
require 'active_record'

ActiveRecord::Base.establish_connectionadapter => "sqlite3",
:database => "foo.db")

ActiveRecord::Schema.define() do
create_table :containers do |table|
table.column :name, :string
end
create_table :things do |table|
table.column :description, :string
end
end

class Container<ActiveRecord::Base
has_many :things
end

class Thing<ActiveRecord::Base
belongs_to :container
end

Container.createname=>"Bucket")
bucket=Container.find_by_name("Bucket")
pocket=Container.createname=>"Pocket")

bucket.save
pocket.save

Container.findall)
#this will find both containers

Thing.findall)
#empty, as expected

bucket.things.createdescription=>"fish")
pocket.things.createdescription=>"lint")

Thing.findall)
#looks good...

#but howcome
pocket.things.findall)
#throws some huge error instead of finding the things in the pocket?


Sorry for the overly newbie type question I just really thought
ActiveRecord was supposed to take care of all this stuff.

Thanks,
Kyle

 

[yermej]

I'm plodding my way through active record right now, and running into
some things that seem odd.

Take a really simple example
#!/usr/bin/ruby
require 'rubygems'
require 'active_record'

ActiveRecord::Base.establish_connectionadapter => "sqlite3",
:database => "foo.db")

ActiveRecord::Schema.define() do
create_table :containers do |table|
table.column :name, :string
end
create_table :things do |table|
table.column :description, :string
end
end

class Container<ActiveRecord::Base
has_many :things
end

class Thing<ActiveRecord::Base
belongs_to :container
end

Container.createname=>"Bucket")
bucket=Container.find_by_name("Bucket")
pocket=Container.createname=>"Pocket")

bucket.save
pocket.save

Container.findall)
#this will find both containers

Thing.findall)
#empty, as expected

bucket.things.createdescription=>"fish")
pocket.things.createdescription=>"lint")

Thing.findall)
#looks good...

#but howcome
pocket.things.findall)
#throws some huge error instead of finding the things in the pocket?

Sorry for the overly newbie type question I just really thought
ActiveRecord was supposed to take care of all this stuff.

Thanks,
Kyle

What error do you get? That would help in diagnosing the problem.

You might also want to ask the Ruby on Rails list. I know ActiveRecord
doesn't have to be used with Rails, but they probably have more people
there with ActiveRecord experience.

Jeremy

 

[Ryan Davis]

I'm plodding my way through active record right now, and running into
some things that seem odd.

AR questions should go to the rails list... that's the group that
writes and supports AR.

 

[Kyle Schmitt]

OK. I'll repost it there. As I really wanna just use AR and not
rails I had hopes for this list.

Heck maybe this just means if I'm having this much trouble I should
write all my findings up as a few good examples and howto's.

Thanks
--Kyle