Ruby on Rails - Useful Commands

Rails DB Rebuilding

rake db:drop && rake db:create && rake db:migrate && rake db:seed (Windows)

rake db:drop;rake db:create;rake db:migrate;rake db:seed (Unix)

rake db:drop RAILS_ENV=production; rake db:create RAILS_ENV=production;rake db:migrate RAILS_ENV=production;rake db:seed RAILS_ENV=production

  

rake db:drop RAILS_ENV=development; rake db:create RAILS_ENV=development;rake db:migrate RAILS_ENV=development

Rails precompile

rake assets:clean && rake assets:precompile environment=development

rake assets:clean && rake tmp:clear && rake assets:clobber && rake assets:precompile

Rails Generate artifacts

rails generate scaffold Promotion name:string code:string startdate:datetime enddate:datetime

rails generate migration AddColumnToAppointments

Rails DB Console

rails dbconsole

.headers on

select * from users where profile_id = 17;