CODEWITHSUNDEEP
ruby-on-railsdevise
Matt Thomas
Matt Thomas

Reputation: 1115

Migration error when adding a column to an existing table

I'm trying to add a users username to a song.

app/models/user.rb

class User < ActiveRecord::Base
  has_many :songs 
  ...
end

app/models/song.rb

class Song < ActiveRecord::Base
  belongs_to :user
  ...
end

I'm trying to make a migration to add a username table to my songs table

class AddUsernameToSongs < ActiveRecord::Migration
  def change
    add_column :songs, :username, :string
  end
end

But I keep getting an uninitialized constant error when I try to run rake db:migrate

I want to be able to on each song call

<%= song.username %>

To post the author of the track.

I'm using devise to set up my users and the devise table already has a username field.

Upvotes: 0

Views: 66

Answers (1)

MZaragoza
MZaragoza

Reputation: 10111

Its a better idea to link to the song to a user by id than just the username.

if you don't already have this. I think that you do as you say you have an association.

class AddUserToSongs < ActiveRecord::Migration
  def change
    add_column :songs, :user_id, :integer
  end
end

In your song model you can add a method called ** author **

class Song < ActiveRecord::Base
  belongs_to :user
  ...
  def author
    user.name # this can be username or what ever field in the user's table you want 
  end
end

Now in your views you can do something like this. 

- songs.each do |song|
  = song.author
  %br

I hope that this helps. Happy Hacking

Upvotes: 1

Related Questions