rails_db_patch

Manage tool for one-time ruby script which executed to DB in Rails application.

You write one-time script for manipulate db. then you'll test it in your environment. if it is OK, now you execute it to production environment.

by the way, where the script should be commit to? Surely the script was finished the role(rest in peace..)

but.

Any chance. it the customer request you to create new environment? if your colleague destroyed Database?

the script will called from hell to revive the environment.

and, you'll say "I trashed that script!!!!"

you'll think "I wish I can also manage one-time script also like migration file."

DMLを実行するrubyスクリプトをmigrationファイルのように管理するRailsプラグインを作った

First after installed, you need to initialize database. it creates 'patch_versions' table to DB.

rake db:patch:init

Craete new blank script file.

rake db:patch:new

and execute the script to DB.

rake db:patch:execute

if you want to clear add patch history. execute this command.

rake db:patch:clear

add Gemfile.

gem "db_patch"

and install.

bundle install

then, It enable to use db_patch tasks.

$ rake -T
rake db:patch:clear                       # clear database
rake db:patch:execute                     # execute patch
rake db:patch:history                   	# show patch history
rake db:patch:init                        # initialize database
rake db:patch:new                         # create new patch file

MIT

jacoyutroius