That just does not make sense. When you do the: > p.names << Name.new(:title => "Name 1") > p.names << Name.new(:title => "Name 2") and the reverse for names I would think the join table would have the proper ids for the associations, but if you query the join table it is empty. You added a separate create on the join table, why was the entry not done when the initial join was created. Is there another magic table that is actually holding the joins and the through a secondary table?
Don French On May 24, 7:13 pm, Dan Sosedov <[email protected]> wrote: > If i understand correctly, you need to get data from this middle table > (PeopleName)? > > attr = Person.get(YOUR_ID).people_names.first.link_type > > So anyway you have to know what is your ID that refers to both > objects. > > But i see the problem here, since you have many-to-many rels, you > might want to add additional field to your Person model to store > current name. > So it might look like this. > > class Person > ... > property :id, Serial > property :current_name, Integer, :required => true, :index => true > > def current_name_attrs > self.names.get(self.current_name).person_names.first > end > end > > And, take a look at my example: > > ---------------------------------------------------------------------------------- > > require 'rubygems' > require 'dm-core' > require 'dm-types' > > DataMapper.setup(:default, 'sqlite3::memory:') > > class Person > include DataMapper::Resource > > property :id, Serial > property :title, String, :required => true > > has n, :person_names > has n, :names, :through => :person_names > > def pending_name > return self.person_names.first(:status => :pending).name > end > end > > class Name > include DataMapper::Resource > > property :id, Serial > property :title, String, :required => true > > has n, :person_names > has n, :persons, :through => :person_names > end > > class PersonName > include DataMapper::Resource > > property :id, Serial > property :status, Enum[:active, :pending], :default => :active > > belongs_to :person > belongs_to :name > end > > DataMapper.auto_migrate! > > # -------------------------------------------------------------------- > > p = Person.new(:title => "Person 1") > p.names << Name.new(:title => "Name 1") > p.names << Name.new(:title => "Name 2") > p.save > > p = Person.new(:title => "Person 2") > p.names << Name.new(:title => "Name 3") > p.names << Name.new(:title => "Name 4", :person_names => > [PersonName.new(:status => :pending, :person => p)]) > p.save > > people = Person.all > people.each do |p| > puts "#{p.id} - #{p.title}" > p.names.each do |n| > puts "-> #{n.title}, status => #{n.person_names.first.status}" > end > end > > puts Person.last.pending_name.inspect > > OR, you can write your own SQL query to reach your point. > > class Model > def custom_method > return adapter.query("SQL....") > end > end > > On May 24, 5:20 pm, Don French <[email protected]> wrote: > > > > > I have three tables: > > class Name > > include DataMapper::Resource > > > property :id, Serial > > property :normalized_name, String, :unique_index => > > true, :required => true > > property :name, String, :required => true > > property :link_status, Enum, :flags => > > [:new, :linked], :default => :new > > has n, :people_names > > has n, :people, :through => :people_names > > > def name=(value) > > attribute_set(:name, value.upcase) > > attribute_set(:normalized_name, Name.normalize(value)) > > end > > > def Name.normalize(orig_name) > > n = orig_name.upcase > > n.gsub!(',', '') > > n.gsub!('.', '') > > n.gsub!(' ', '') > > n > > end > > end > > > class Person > > include DataMapper::Resource > > property :id, Serial > > property :name, String > > has n, :people_names > > has n, :names, :through => :people_names > > end > > > class PeopleName > > include DataMapper::Resource > > property :id, Serial > > property :link_type, Enum, :flags => > > [:validated, :unvalidated], :default => :unvalidated > > belongs_to :person > > belongs_to :name > > end > > > I create a Person object as p and a Name object as n, when I assign > > p.names << name and n.person << person I can then do p.names and I get > > the name assigned, same with n.person I get the right person. But how > > do I access the :link_type property from the PeopleName table. If I > > do a PeopleName.all I get an empty array. > > > How do I access the additional information in the join table? > > > Don French > > > -- > > 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 > > athttp://groups.google.com/group/datamapper?hl=en. > > -- > 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 > athttp://groups.google.com/group/datamapper?hl=en. -- 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.
