Tips appreciated, I tried those and a couple other variations, but
still not working:
irb(main):065:0> urls = Url.all('category.id' => catID)
NoMethodError: undefined method `category' for Url:Class
irb(main):066:0> urls = Url.all(:category.id => catID)
(irb):66: warning: Object#id will be deprecated; use Object#object_id
ArgumentError: Condition type 785788 not supported
irb(main):067:0> urls = Url.all(:category.category_id => catID)
NoMethodError: undefined method `category_id' for :category:Symbol
from (irb):67
irb(main):069:0> urls = Url.all('categorization.category_id' =>
catID)
NoMethodError: undefined method `categorization' for Url:Class
On Apr 21, 12:47 am, Chris Van Pelt <[email protected]> wrote:
> That should be 'categories.id'
>
> On Tue, Apr 21, 2009 at 12:46 AM, Chris Van Pelt <[email protected]> wrote:
>
> > I'm sorry, I just glanced at the question. I'm not super familiar
> > with DM's facility for has_many_through relationships. I would try
>
> > Url.all('categories'.id => catID) or
> > Url.all('categorization.category_id' => catID)
>
> > I could be way off here though :)
>
> > Chris
>
> > On Tue, Apr 21, 2009 at 12:27 AM, Dan D <[email protected]> wrote:
>
> >> Thanks, but didn't work.
>
> >> irb(main):064:0> urls = Url.all(:category_id => catID)
> >> ArgumentError: Unknown property 'category_id'
> >> from
> >> /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/query.rb:
> >> 462:in `append_condition'
> >> from
> >> /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/query.rb:
> >> 246:in `initialize'
> >> from
> >> /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/query.rb:
> >> 245:in `each'
> >> from
> >> /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/query.rb:
> >> 245:in `initialize'
> >> from
> >> /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/model.rb:
> >> 431:in `new'
> >> from
> >> /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/model.rb:
> >> 431:in `scoped_query'
> >> from
> >> /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/model.rb:
> >> 256:in `all'
> >> from (irb):64
>
> >> irb(main):065:0> urls = Url.all(:category_id => 1)
> >> ArgumentError: Unknown property 'category_id'
>
> >> On Apr 20, 11:01 pm, Chris Van Pelt <[email protected]> wrote:
> >>> urls = Url.all(:category => catID)
>
> >>> Should be:
>
> >>> urls = Url.all(:category_id => catID)
>
> >>> On Mon, Apr 20, 2009 at 10:44 PM, Dan D <[email protected]> wrote:
>
> >>> > Please help, I'm sure I'm over looking something silly, but I cannot
> >>> > query by category. Everything works great except the last line returns
> >>> > " Unknown property 'category'" error. Same if I use the (:conditions
> >>> > => ...... ) syntax.
>
> >>> > Thanks,
> >>> > Dan
>
> >>> > require 'rubygems'
> >>> > require 'dm-core'
>
> >>> > DataMapper.setup(:default, "sqlite3://#{Dir.pwd}/test.sqlite3")
>
> >>> > DataMapper::Logger.new(STDOUT, :debug)
> >>> > # :off, :fatal, :error, :warn, :info, :debug
> >>> > DataObjects::Sqlite3.logger = DataObjects::Logger.new(STDOUT, 0)
>
> >>> > class Url
> >>> > include DataMapper::Resource
>
> >>> > property :id, Integer, :serial => true
> >>> > property :url, Text, :nullable => false
>
> >>> > has n, :categorizations
> >>> > has n, :categories,
> >>> > :through => :categorizations,
> >>> > :class_name => 'Category',
> >>> > :mutable => true
> >>> > end
>
> >>> > class Category
> >>> > include DataMapper::Resource
> >>> > property :id, Serial
> >>> > property :name, String
>
> >>> > has n, :categorizations
> >>> > has n, :urls, :through => :categorizations, :mutable => true
> >>> > end
>
> >>> > class Categorization
> >>> > include DataMapper::Resource
> >>> > property :id, Serial
>
> >>> > belongs_to :category
> >>> > belongs_to :url
> >>> > end
>
> >>> > DataMapper.auto_migrate!
>
> >>> > cat1 = Category.new
> >>> > cat1.name = "Cat1"
> >>> > cat1.save
>
> >>> > cat2 = Category.new
> >>> > cat2.name = "Cat2"
> >>> > cat2.save
>
> >>> > Category.all
>
> >>> > url1 = Url.new
> >>> > url1.url = "http://yahoo.com";
> >>> > url1.save
>
> >>> > url2 = Url.new
> >>> > url2.url = "http://google.com";
> >>> > url2.save
>
> >>> > catID = Category.first.id
> >>> > urlID = Url.first.id
>
> >>> > Categorization.create(:category_id => catID, :url_id => urlID)
>
> >>> > urls = Url.all(:category => catID)
> >>> > ArgumentError: Unknown property 'category'
> >>> > from
> >>> > /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/query.rb:
> >>> > 462:in `append_condition'
> >>> > from
> >>> > /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/query.rb:
> >>> > 246:in `initialize'
> >>> > from
> >>> > /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/query.rb:
> >>> > 245:in `each'
> >>> > from
> >>> > /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/query.rb:
> >>> > 245:in `initialize'
> >>> > from
> >>> > /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/model.rb:
> >>> > 431:in `new'
> >>> > from
> >>> > /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/model.rb:
> >>> > 431:in `scoped_query'
> >>> > from
> >>> > /usr/lib/ruby/gems/1.8/gems/dm-core-0.9.11/lib/dm-core/model.rb:
> >>> > 256:in `all'
> >>> > from (irb):66
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DataMapper" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/datamapper?hl=en
-~----------~----~----~----~------~----~------~--~---
