How do I add some inserts in rails migration?

by

Don’t. If you’re looking for seed data, you should use db/seeds.rb and rake db:seed instead. More info in this Railscast.

Side note: Always make sure that the code in db/seeds.rb is idempotent. i.e. It should always be safe to re-run your seeds.

But, if you must insert or modify data inside a migration (there are legitimate use-cases for this), it’s best to use SQL statements instead. Your model class isn’t guaranteed to still be around in the same form in a future version of your application, and running the migrations from scratch in the future might yield errors if you reference the model class directly.

execute "insert into system_settings (name, label, value) values ('notice', 'Use notice?', 1)"

More Related Contents:

  1. Using Rails, how can I set my primary key to not be an integer-typed column?
  2. How can I rename a database column in a Ruby on Rails migration?
  3. Rails DB Migration – How To Drop a Table?
  4. rake db:schema:load vs. migrations
  5. Rails migration for change column
  6. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  7. How do I handle too long index names in a Ruby on Rails ActiveRecord migration?
  8. Rails migration for has_and_belongs_to_many join table
  9. Using Rails Migration on different database than standard “production” or “development”
  10. Add a default value to a column through a migration
  11. How can I rollback a specific migration?
  12. Run a single migration file
  13. Rails 3 migrations: Adding reference column?
  14. Adding foreign key to a rails model
  15. Ruby on rails Failed to precompile
  16. ActiveModel::ForbiddenAttributesError when creating new user
  17. A cron job for rails: best practices?
  18. How to change Rails 3 server default port in develoment?
  19. How to extract URL parameters from a URL with Ruby or Rails?
  20. Rails Polymorphic Association with multiple associations on the same model
  21. Rails config.assets.precompile setting to process all CSS and JS files in app/assets
  22. Rails, Devise authentication, CSRF issue
  23. Rails 3 – select with Include?
  24. How to pass parameters to ActiveModel serializer
  25. rails dates with json
  26. Heroku not sending email with Gmail SMTP
  27. How to set default values in Rails?
  28. association named not found perhaps misspelled issue in rails association
  29. Rails (or Ruby): Yes/No instead of True/False
  30. Rails: store translations in database

Leave a Comment