migrate database from sqlite3 to postgresql on development of rails 4

http://stackoverflow.com/questions/6710654/how-do-you-easily-change-from-sqlite-to-postgresql-in-rails

http://railscasts.com/episodes/342-migrating-to-postgresql

http://www.gotealeaf.com/blog/how-to-install-postgresql-on-a-mac


download postgresql  from postgresql.org

1	initdb /usr/local/var/postgres

install  postgresql

$ createuser f3 -d -s

$ createdb -Of3 -Eutf8 f3_development
$ createdb -Of3 -Eutf8 f3_test

Update the Gemfile
gem 'sqlite3'
gem 'pg'
gem 'taps'
$ bundle

Update database.yml
#development:
#  adapter: sqlite3
#  database: db/development.sqlite3
#  pool: 5
#  timeout: 5000

development:
  adapter: postgresql
  encoding: unicode
  database: f3_development
  pool: 5
  username: f3
  password:

#test:
#  adapter: sqlite3
#  database: db/test.sqlite3
#  pool: 5
#  timeout: 5000

test:
  adapter: postgresql
  encoding: unicode
  database: f3_test
  pool: 5
  username: f3
  password:

Start the taps server on the sqlite database
$ taps server sqlite://db/development.sqlite3 user password

Migrate the data
$ taps pull postgres://f3@localhost/f3_development http://user:password@localhost:5000

Restart the Rails webserver
$ rails s

Cleanup the Gemfile
#gem 'sqlite3'
gem 'pg'
#gem 'taps'
$ bundle

friendly_id + 中文顯示

http://waynechu.logdown.com/posts/205700-rails-web-site-no-longer-displays-only-id

rails generate friendly_id
rails generate migration add_slug_to_products slug:string:uniq
rake db:migrate

class Product < ActiveRecord::Base
  extend FriendlyId
  friendly_id :name, use: :slugged
end
接著到config/initializers/friendly_id.rb下把自動查找的功能打開，將config.use :finders這段解除註解就可以了。
（不打開finders也可以，但就必須要把Product.find(params[:id])的地方改寫成Product.friendly.find(params[:id])）
class Product < ActiveRecord::Base
 
  # 原本是input.to_s.parameterize，但是parameterize只支援英文跟數字，所以改用babosa的to_slug
  def normalize_friendly_id(input)
    input.to_s.to_slug.normalize.to_s
  end

Adding Custom Fields to Devise User Model in Rails 4

http://www.jacopretorius.net/2014/03/adding-custom-fields-to-your-devise-user-model-in-rails-4.html

 create the migration

class AddFieldsToUsers < ActiveRecord::Migration

  def change

    add_column :users, :first_name, :string

    add_column :users, :last_name, :string

  end

end

Customizing the RegistrationsController

creating our own registrations controller (which extends Devise) and then customizing these methods as we choose.

class RegistrationsController < Devise::RegistrationsController

 

  private

 

  def sign_up_params

    params.require(:user).permit(:first_name, :last_name, :email, :password,:password_confirmation)

  end

 

  def account_update_params

    params.require(:user).permit(:first_name, :last_name, :email, :password,:password_confirmation, :current_password)

  end

end




Now we need to tell Devise to use our registrations controller - we can do this in ourconfig/routes.rb file.

devise_for :users, :controllers => { registrations: 'registrations' }