I am using a habtm relationship between two tables and the migration
fails when updating the join table. However, it works when doing it
step by step in the console!
Here is the code:
class User < ActiveRecord::Base
acts_as_authentic
belongs_to :role
has_and_belongs_to_many :dim_teams, :association_foreign_key
=> :team_id
end
class DimTeam < ActiveRecord::Base
set_primary_key “team_id”
has_and_belongs_to_many :users, :foreign_key => “team_id”
end
class AddUserData < ActiveRecord::Migration
def self.up
role = Role.find_by_role('User')
team1 = DimTeam.find_by_team_name('Essex')
user = User.new
user.login = "snapes"
user.email = "[email protected]"
user.password = "password"
user.password_confirmation = "password"
user.role = role
user.save
user = User.find_by_login("snapes")
user.dim_teams << team1
end
def self.down
end
end
When I run the code step by step in the console, it works. The final
user.dim_teams << team1 line produces the following output in
development.log:
SQL (2.8ms) INSERT INTO [dim_teams_users] ([team_id], [user_id])
VALUES (13, 2)
When I run it as a rake task, I get
SQL (0.0ms)[0m [0mDBI::DatabaseError: (102) [unixODBC][FreeTDS][SQL
Server]Incorrect syntax near ‘)’.: INSERT INTO [dim_teams_users] ()
VALUES ()[0m
Can anybody explain why the difference to me please?
thanks