lib/simba/base_app/lib/tasks/db.rake in simba-0.0.3 vs lib/simba/base_app/lib/tasks/db.rake in simba-0.0.4
- old
+ new
@@ -1,32 +1,33 @@
+require "yaml"
+
namespace :db do
- require "sequel"
- Sequel.extension :migration
- DB = Sequel.sqlite('db/test.db')
+ database_url = YAML.load_file("./config/database.yml")["default"]["url"]
+
desc "Perform migration reset (full erase and migration up)"
task :setup do
- Sequel::Migrator.run(DB, "db/migrations", :target => 0)
- Sequel::Migrator.run(DB, "db/migrations")
+ puts `sequel -Etm ./db/migrations -M 0 #{database_url}`
+ puts `sequel -Etm ./db/migrations #{database_url}`
puts "<= sq:migrate: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?
- Sequel::Migrator.run(DB, "db/migrations", :target => version)
+ puts `sequel -Etm db/migrations -M #{version} #{database_url}`
puts "<= sq:migrate:to version=[#{version}] executed"
end
desc "Perform migration up to latest migration available"
task :migrate do
- Sequel::Migrator.run(DB, "db/migrations")
+ puts `sequel -Etm ./db/migrations #{database_url}`
puts "<= sq:migrate:up executed"
end
desc "Perform migration down (erase all data)"
task :rollback do
- Sequel::Migrator.run(DB, "db/migrations", :target => 0)
+ puts `sequel -Etm ./db/migrations -M 0 #{database_url}`
puts "<= sq:migrate:down executed"
end
end