Hi Dave Did you get any further with this? I'm afraid I've not had any inspiration.
-- Pat On 10/02/2011, at 7:17 AM, gerberdata wrote: > maybe it is database related. I now have no problems except for this > association > has_many :schools,:through=>:league_associations, :source > => :league_associator, :source_type => "School", :class_name => > "School", :uniq => true > I have one record in the league_associations table for object School > but the league_core is only written to file if this line is commented > out > in my League model. Any ideas? > > On Feb 9, 10:33 am, gerberdata <[email protected]> wrote: >> They are quite a few but here they are >> >> belongs_to :address >> belongs_to :parent_league, :class_name=> >> "League", :foreign_key=>:parent_id >> has_one :wall, :as=>:wallable, :dependent => :destroy >> has_one :background, :as => :background_holder, :dependent >> => :destroy >> has_many :sub_leagues, :class_name => >> "League", :foreign_key=>:parent_id, :dependent => :nullify >> has_many :league_championships, :dependent => :delete_all >> has_many :championships, :through => :league_championships, :uniq >> => true >> has_many :league_associations, :dependent => :delete_all >> has_many :events, :through => :league_associations, :source >> => :league_associator, :source_type => "Event", :class_name => >> "Event", :uniq => true >> has_many :teams, :through=>:league_associations, :source >> => :league_associator, :source_type => "Team", :class_name => >> "Team", :uniq => true >> has_many :athletes, :through=>:league_associations, :source >> => :league_associator, :source_type => "Athlete", :class_name => >> "Athlete", :uniq => true >> has_many :clubs, :through=>:league_associations, :source >> => :league_associator, :source_type => "Club", :class_name => >> "Club", :uniq => true >> has_many :schools, :through=>:league_associations, :source >> => :league_associator, :source_type => "School", :class_name => >> "School", :uniq => true >> has_many :rss_links, :as=>:rss_holder, :dependent => :destroy >> has_many :images, :as => :image_holder, :dependent => :destroy >> has_many :videos, :as => :video_holder, :dependent => :destroy >> has_many :sponsorships, :as => :sponsored, :dependent => :delete_all >> has_many :brands, :through => :sponsorships, :uniq => true >> has_many :profile_links, :as => :profile_link_holder, :dependent >> => :delete_all >> has_many :product_associations, :as => :associator, :dependent >> => :delete_all >> has_many :products, :through => :product_associations, :uniq => true >> has_many :roles, :as => :authorization >> has_many :league_sports, :dependent =>:destroy >> has_many :sports, :through => :league_sports, :uniq => true >> has_many :favorites, :as => :favorited, :dependent => :delete_all >> has_many :users, :through => :favorites, :uniq => true >> has_many :statistics, :finder_sql => 'SELECT * FROM statistics WHERE >> ( >> (statistic_holder_id IN (SELECT DISTINCT >> athletes.id FROM athletes INNER JOIN league_associations ON >> athletes.id = league_associations.league_associator_id AND >> league_associations.league_associator_type = "Athlete" WHERE >> ((league_associations.league_id = #{id})) ) AND statistic_holder_type >> = "Athlete") >> OR (statistic_holder_id IN (SELECT DISTINCT >> teams.id FROM teams INNER JOIN league_associations ON teams.id = >> league_associations.league_associator_id AND >> league_associations.league_associator_type = "Team" WHERE >> ((league_associations.league_id = #{id})) ) AND statistic_holder_type >> = "Team")) >> ', >> :counter_sql => 'SELECT count(*) FROM statistics WHERE ( >> (statistic_holder_id IN (SELECT DISTINCT >> athletes.id FROM athletes INNER JOIN league_associations ON >> athletes.id = league_associations.league_associator_id AND >> league_associations.league_associator_type = "Athlete" WHERE >> ((league_associations.league_id = #{id})) ) AND statistic_holder_type >> = "Athlete") >> OR (statistic_holder_id IN (SELECT DISTINCT >> teams.id FROM teams INNER JOIN league_associations ON teams.id = >> league_associations.league_associator_id AND >> league_associations.league_associator_type = "Team" WHERE >> ((league_associations.league_id = #{id})) ) AND statistic_holder_type >> = "Team")) >> ' do >> >> def find(* args) >> options = args.extract_options! >> sql = @finder_sql >> >> sql += sanitize_sql [" LIMIT ?", options[:limit]] if >> options[:limit] >> sql += sanitize_sql [" OFFSET ?", options[:offset]] if >> options[:offset] >> >> Statistic.find_by_sql(sql) >> end >> end >> >> has_many :records, :finder_sql => 'SELECT * FROM records WHERE ( >> (record_holder_id IN (SELECT DISTINCT >> athletes.id FROM athletes INNER JOIN league_associations ON >> athletes.id = league_associations.league_associator_id AND >> league_associations.league_associator_type = "Athlete" WHERE >> ((league_associations.league_id = #{id})) ) AND record_holder_type = >> "Athlete") >> OR (record_holder_id IN (SELECT DISTINCT >> teams.id FROM teams INNER JOIN league_associations ON teams.id = >> league_associations.league_associator_id AND >> league_associations.league_associator_type = "Team" WHERE >> ((league_associations.league_id = #{id})) ) AND record_holder_type = >> "Team")) >> ', >> :counter_sql => 'SELECT count(*) FROM records WHERE ( >> (record_holder_id IN (SELECT DISTINCT >> athletes.id FROM athletes INNER JOIN league_associations ON >> athletes.id = league_associations.league_associator_id AND >> league_associations.league_associator_type = "Athlete" WHERE >> ((league_associations.league_id = #{id})) ) AND record_holder_type = >> "Athlete") >> OR (record_holder_id IN (SELECT DISTINCT >> teams.id FROM teams INNER JOIN league_associations ON teams.id = >> league_associations.league_associator_id AND >> league_associations.league_associator_type = "Team" WHERE >> ((league_associations.league_id = #{id})) ) AND record_holder_type = >> "Team")) >> ' do >> >> def find(* args) >> options = args.extract_options! >> sql = @finder_sql >> >> sql += sanitize_sql [" LIMIT ?", options[:limit]] if >> options[:limit] >> sql += sanitize_sql [" OFFSET ?", options[:offset]] if >> options[:offset] >> >> Record.find_by_sql(sql) >> end >> end >> >> has_many :tickets, :finder_sql => 'select distinct tickets.* from >> tickets INNER JOIN league_associations ON tickets.event_id = >> league_associations.league_associator_id >> where >> (league_associations.league_id = #{id} AND >> league_associations.league_associator_type = "Event" ) >> ', >> :counter_sql => 'select count(*) from tickets INNER JOIN >> league_associations ON tickets.event_id = >> league_associations.league_associator_id >> where >> (league_associations.league_id = #{id} AND >> league_associations.league_associator_type = "Event" ) >> ' do >> >> def find(* args) >> options = args.extract_options! >> sql = @finder_sql >> >> sql += sanitize_sql [" LIMIT ?", options[:limit]] if >> options[:limit] >> sql += sanitize_sql [" OFFSET ?", options[:offset]] if >> options[:offset] >> >> Ticket.find_by_sql(sql) >> end >> end >> define_index do >> indexes :name, :sortable=> true >> indexes :description >> indexes :short_name >> indexes :other_names >> indexes >> address.geography.country_name, :as=>:country_name, :sortable=> true >> indexes >> address.geography.region_name, :as=>:region_name, :sortable=> true >> indexes address.geography.city_name, :as=>:city_name, :sortable=> >> true >> indexes sub_leagues.name, :as=>:league_names >> indexes teams.name, :as=>:team_names >> indexes clubs.name, :as=>:club_names >> indexes sports.name, :as=>:sport_names >> >> has :id, :parent_id, :created_at, :updated_at, :hit_count, :address_id >> has address(:geography_id), :as=>:geography_id, :facet=>true >> >> has address.geography(:country_id), :as=>:country_id, :facet=>true >> has address.geography(:region_id), :as=>:region_id, :facet=>true >> has address.geography(:city_id), :as=>:city_id, :facet=>true >> >> has sports(:id), :as=>:sport_ids, :facet=>true >> has sports.sport_family(:id), :as=>:sport_family_ids, :facet=>true >> has "3", :as => :custom_model_sort, :type => :integer >> set_property :delta => :delayed >> end >> >> On Feb 2, 5:35 pm, Pat Allan <[email protected]> wrote: >> >>> Hi Dave >> >>> Can you show us what the associations and define_index block on the League >>> model are? >> >>> Cheers >> >>> -- >>> Pat >> >>> On 03/02/2011, at 4:44 AM, gerberdata wrote: >> >>>> Hello Group, >> >>>> I am using thinking sphinx 1.3.20 and when >>>> running ts:conf I am not seeing one of my models in the config file >>>> unless I remove two associations. Please have a look at this >> >>>> has_many :sub_leagues, :class_name => >>>> "League", :foreign_key=>:parent_id, :dependent => :nullify >>>> has_many :profile_links, :as => :profile_link_holder, :dependent >>>> => :delete_all >> >>>> this is in league model. There is no defined indexes on these in the >>>> define_index method if I comment out these two associations no problem >>>> the config file gets generated. I have tried to remove each one and >>>> run seperately but the config file still does not generate the >>>> league_core as expected. These relationships look pretty run of the >>>> mill to me. I have a table profile_links with profile_link_holder_id >>>> and profile_link_holder_type. >>>> anyway anyone's help would be appreciated. >> >>>> Thanks >>>> Dave >> >>>> -- >>>> You received this message because you are subscribed to the Google Groups >>>> "Thinking Sphinx" 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/thinking-sphinx?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" 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/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" 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/thinking-sphinx?hl=en.
