Everyone is familiar with db:migrate, db:drop, db:create, and db:seed. What about some of the other database-related Rake tasks? It turns out that some of them are combinations of others:
- db:setup = db:create + db:schema:load + db:seed
- db:reset = db:drop + db:setup
- db:migrate:reset = db:drop + db:create + db:migrate (= db:reset - db:seed)
- db:test:purge = dependent on adapter but basically db:drop + db:create [as test]
- db:test:load = db:test:purge + db:schema:load [as test]
- db:test:prepare = db:test:load [by default]
If you use the trick in http://errtheblog.com/posts/31-rake-around-the-rosie, then the :test tasks aren't necessary and it reduces the list to:
- db:setup = db:create + db:schema:load + db:seed
- db:reset = db:drop + db:setup
- db:migrate:reset = db:drop + db:create + db:migrate (= db:reset - db:seed)
So then, if you want to reset the test database:
rake env:test db:reset