lib/simba/base_app/lib/tasks/db.rake in simba-0.0.4 vs lib/simba/base_app/lib/tasks/db.rake in simba-0.0.5

- old
+ new

@@ -3,31 +3,38 @@ namespace :db do database_url = YAML.load_file("./config/database.yml")["default"]["url"] desc "Perform migration reset (full erase and migration up)" - task :setup do + task :reset do puts `sequel -Etm ./db/migrations -M 0 #{database_url}` puts `sequel -Etm ./db/migrations #{database_url}` - puts "<= sq:migrate:reset executed" + puts "<= rake db:reset executed" end desc "Perform migration up/down to VERSION" task :version do version = ENV['VERSION'].to_i raise "No VERSION was provided" if version.nil? puts `sequel -Etm db/migrations -M #{version} #{database_url}` - puts "<= sq:migrate:to version=[#{version}] executed" + puts "<= rake db:version version=[#{version}] executed" end desc "Perform migration up to latest migration available" task :migrate do puts `sequel -Etm ./db/migrations #{database_url}` - puts "<= sq:migrate:up executed" + puts "<= rake db:migrate executed" end desc "Perform migration down (erase all data)" task :rollback do puts `sequel -Etm ./db/migrations -M 0 #{database_url}` - puts "<= sq:migrate:down executed" + puts "<= rake db:rollback executed" + end + + desc "Perform schema dump (dumping the current schema as a migration)" + task :dump do + raise "No FILENAME was provided" if ENV["FILENAME"].nil? + puts `sequel -Etd #{database_url} > ./db/migrations/#{ENV["FILENAME"]}` + puts "<= rake db:dump executed" end end