AssociationTypeMismatch problem while saving data
in the previous question i was stumped .. but stack overflow provided a solution
my two models
class Team < ActiveRecord::Base
has_many :fixtures, :finder_sql => 'SELECT * FROM fixtures where (home_team = #{id} or away_team = #{id})'
has_many :home_fixtures, :class_name => "Fixtures", :foreign_key => :home_team
has_many :away_fixtures, :class_name => "Fixtures", :foreign_key => :away_team
has_many :teamalias
end
class Fixture < ActiveRecord::Base
belongs_to :league
belongs_to :selection
has_many :selection
named_scope :for_team_id, lambda{|team_id| {:conditions => ['(home_team = ? or away_team = ?)', team_id, team_id]} }
belongs_to :home_team, :class_name => "Team", :foreign_key => :home_team
belongs_to :away_team, :class_name => "Team", :foreign_key => :away_team
def fix_list
[home_team.title, "Draw", away_team.title]
end
end
taken from Multilevel associations in rails
but I'm confused again - I'm trying to save a fixture based on the last solution in the first answer above and I get typemismatch.
Command (# 38391330) expected, received string (# 1242130)
Not sure what to do here, please help.
edit-db migration
Listed below are migrations
class CreateFixtures <ActiveRecord :: Migration def self.up create_table: fixtures do | t | t.integer: home_team t.integer: away_team t.datetime: when t.integer: league_id
t.timestamps
end
end
def self.down drop_table: fixtures end end
class CreateTeams <ActiveRecord :: Migration def self.up create_table: do commands | t | t.string: title
t.timestamps
end
end
def self.down drop_table: commands end end
class AddResultToFixture <ActiveRecord :: Migration def self.up add_column: fixtures ,: result ,: integer end
def self.down remove_column: fixtures ,: result end end