How to use active record without rails

Question

Folks Im trying to use active record without rails and cant seem to get has_many working properly. Ive never tried using active record without rails. I can query from single tables but the relationships dont seem to be working. Could anyone take a quick glance and see if im missing anything. Here is the stub ``` #!/usr/bin/ruby require 'rubygems' gem 'activerecord' require 'sqlite3' require 'active_record' ActiveRecord::Base.establish_connection( :adapter => 'sqlite3', :database => 'test.db' ) class User < ActiveRecord::Base has_many :problems end class Problem < ActiveRecord::Base belongs_to :users end def show_single_item pr = Problem.find(:first) puts "showing first problem from the db below", pr.desc end def show_all_items pr = Problem.find(:all) puts "showing all problems from the db below" pr.each do |a| puts a.desc end end def check_has_many user = User.find(:first) puts user.problem.desc end # run some methods show_single_item # works show_all_items # works check_has_many # no…

Accepted Answer

I think I know what you're trying to do. If I'm not mistaken you want to display the desc value of every problem for a given user.

An easy way to accomplish what you need is a combination of your last 2 methods:

```
user = User.first
user.problems.each do |pr|
  puts pr.desc
end
```

The problem you are having in your code is that semantically you are saying something like "display the description of the problem (notice it's singular) of the user" instead of saying "display the description of each problem the user has", which if it were possible should be something like this:

```
puts user.problems.descs  # This will not work
```

But that is just not the way it works. There is, though, a new method that you could use:

```
puts user.problems.pluck(:desc)
```

That method will produce an array of the desc value of each problem for the user. You can probably play with the output to get it printed the way you like.

How to use active record without rails

Solution

Problem