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