Skip to main content

Adding Column to rails 2 and rails3

##add cloumn to rails

rails g  migration AddStatusToUsers
class AddStatusToUser < ActiveRecord::Migration
  def change
          #add_column :table_name, :column_name, :type, default: "Your value"
        add_cloumn :users,:status,:string
  end
end
###############change column names to rails
rails g migration ChangeNameToUsers
class RenameStatusToUser < ActiveRecord::Migration
  def change
      #rename_column :table_name, :old_column1, :new_column1
    rename_column :users,:name,:full_name
  end
end
  (or)
class RenameStatusToUser < ActiveRecord::Migration
  def change
    change_table :table_name do |t|
      t.rename :old_column1, :new_column1
      t.rename :old_column2, :new_column2
    end
end

########ROR migration change a column type from Date to DateTime
rails g migration change_date_format_in_my_table
class ChangeFormatInUser< ActiveRecord::Migration
  def change
    #change_column :my_table, :my_column, :my_new_type
    change_column :users
  end
end


##for rails2 adding column
ruby script/generate migration AddIsAdminToUsers
class AddIsAdminToUser < ActiveRecord::Migration
  def self.up
   add_column :users, :is_admin, :boolean, :default=>false, :null=>false
  end
 def self.down
   remove_column :users, :is_admin
  end
end

Comments

Popular posts from this blog

Gem::LoadError (Specified 'mysql2' for database adapter, but the gem is not loaded. Add `gem 'mysql2'` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord).?

Gem::LoadError (Specified 'mysql2' for database adapter, but the gem is not loaded. Add `gem 'mysql2'` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord).) In rails?


1)change the gemfile in mysql version
 gem 'mysql2'

2)Change to mysql2 version
 gem 'mysql2','0.3.20'

Active Scaffold : Add radio buttons to your form ruby on rails ?

Active Scaffold : Add radio buttons to your form ruby on rails ?

The way to add radio buttons to your active scaffold create/update from is as shown below

#Controller

class UsersController < ApplicationController
active_scaffold :user do |config|
config.label = “Users”
config.columns = [:name, :gender]
config.columns[:gender].form_ui = :radio
config.columns[:gender].options[:options] = [['Male', '1'], ['Female','2']]
end
end

Get user accessing ip address in rails?

Get user accessing ip address rails?

request.ip ->returns the ip, whether is is a local proxy ip (localhost address) or not.
*request.remote_ip -> is smarter and gets the ip address of the client outside of local proxies.
3)If you are using apache in front of a mongrel, then remote_ip will return the source address of the request, which in this case will be local host because the Apache web server is making the request, so instead put this in your controller:

@remote_ip = request.env["HTTP_X_FORWARDED_FOR"]