That worked! Makes a bit of sense looking at it too. Thanks!
On Apr 21, 8:50 am, eltiare <[email protected]> wrote: > Try Categorization.all(:category_id => catID).url > > On Apr 20, 11: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 -~----------~----~----~----~------~----~------~--~---
