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