Contents

class ClearanceUpdateUsers < ActiveRecord::Migration
  def self.up
<% 
      existing_columns = ActiveRecord::Base.connection.columns(:users).collect { |each| each.name }
      columns = [
        [:email,              't.string :email'],
        [:encrypted_password, 't.string :encrypted_password, :limit => 128'],
        [:salt,               't.string :salt, :limit => 128'],
        [:token,              't.string :token, :limit => 128'],
        [:token_expires_at,   't.datetime :token_expires_at'],
        [:email_confirmed,    't.boolean :email_confirmed, :default => false, :null => false'],
        [:admin, 't.boolean  :admin, :default => false, :null => false'],
        [:invitation_id,    't.integer :invitation_id'],
        [:invitation_limit,    't.integer :invitation_limit']
      ].delete_if {|c| existing_columns.include?(c.first.to_s)} 
-%>
    change_table(:users) do |t|
<% columns.each do |c| -%>
      <%= c.last %>
<% end -%>
    end
    
<%
    existing_indexes = ActiveRecord::Base.connection.indexes(:users)
    index_names = existing_indexes.collect { |each| each.name }
    new_indexes = [
      [:index_users_on_id_and_token, 'add_index :users, [:id, :token]'],
      [:index_users_on_email,        'add_index :users, :email'],
      [:index_users_on_token,        'add_index :users, :token']
    ].delete_if { |each| index_names.include?(each.first.to_s) }
-%>
<% new_indexes.each do |each| -%>
    <%= each.last %>
<% end -%>
  end
  
  def self.down
    change_table(:users) do |t|
<% unless columns.empty? -%>
      t.remove <%= columns.collect { |each| ":#{each.first}" }.join(',') %>
<% end -%>
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
tonkapark-clearance-0.6.9.3	generators/clearance/templates/migrations/update_users.rb