Have you ever gone to test a specific or develop a feature, except it requires use of data that currently only exists in production?
Instead of going through a very time-consuming database dump and load process, you can use this gem instead.
It works by dumping certain tables you want into some yaml files in db/data. You can then easily load them into your database.
This works a an alternative to ludicast/yaml_db for some use cases.
Add this line to your application's Gemfile:
gem 'db_sync'
And in config/initializers/db_sync.rb
DbSync.configure do |config|
config.sync_tables = ["TABLE_NAME"]
#DEFAULT is db/data/
config.db_data_folder = "overide/the/folder/path/to/load/the/data" #OPTIONAL
end
Run this to dump the tables you specified in the initializer to db/data
bundle exec rake db_sync:dump_data
Or run against a specific rails environment
bundle exec rake db_sync:dump_data RAILS_ENV=production
Run this to load the tables back in. WARNING: this overwrites the contents of this existing table.
bundle exec rake db_sync:load_data
Or run this to load the tables back in the order specified in the sync_tables array. WARNING: this overwrites the contents of this existing table.
bundle exec rake db_sync:load_data_order
- Fork it
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create new Pull Request