Just do SalesFact.first(:include => [:on_market_date_dimension, :sale_date_dimension]). Then you can access dates with sales_fact.on_market_date_dimension and sales_fact.sale_date_dimension.
On Mar 11, 6:54 am, Fearless Fool <[email protected]> wrote: > Andrius Chamentauskas wrote: > > Well first of all are you 100% sure you need OnMarketDateDimension and > > SaleDateDimension classes? If you don't have any custom logic in them > > you should probably remove them and change associations a bit: > > class SalesFact < ActiveRecord::Base > > ... > > belongs_to :on_market_date_dimension, :class_name => > > 'DateDimension', :foreign_key => 'on_market_date_dimension_id' > > belongs_to :sale_date_dimension, :class_name => > > 'DateDimension', :foreign_key => 'sale_date_dimension_id' > > end > > > And I see no reason why you can't just do: SalesFact.first :include => > > [:on_market_date_dimension, :sale_date_dimension]. Or did I > > misinterpret what you need? > > Andrius: I your solution is very close. I agree that it does not make > sense to create OnMarketDateDimension and SalesDateDimension classes (or > sql views onto a table, as I was suggesting). I've knocked together a > project implementing your approach, but I haven't grok'ed how to make a > query -- maybe you can help. > > If I try this: > > SalesFact.first(:include => [:on_market_date_dimension, > :sale_date_dimension]) > > I get an un-embellished SalesFact, which doesn't do me much good -- I'd > like join with the two dates to which it refers. If I try the same > thing with a :select: > > SalesFact.first(:select => 'sales_facts.*, on_market_date_dimensions.*, > sale_date_dimensions.*', :include => [:on_market_date_dimension, > :sale_date_dimension]) > > I get an SQL error because Rails is generating a query based on > "sales_fact.id", which we intentionally suppressed in the schema (:id => > false). > > So my question: Given a SalesFact (or a group of SalesFacts), what's the > AR.find() syntax for a query that does a join against > :on_market_date_dimension and :sale_date_dimension? > > Thanks in advance... > -- > Posted viahttp://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en.
