tasks/db.rake in pact_broker-2.0.2 vs tasks/db.rake in pact_broker-2.0.3

@@ -18,10 +18,48 @@
     raise "Please specify RACK_ENV" unless ENV['RACK_ENV']
     RACK_ENV = ENV['RACK_ENV']
     require File.dirname(__FILE__) + '/database.rb'
   end
 
+  task :create do
+    Rake::Task["db:create:#{ENV.fetch('DATABASE_ADAPTER', 'default')}"].invoke
+  end
+
+  namespace :create do
+    task :default do
+    end
+
+    task :postgres do
+      puts `psql postgres -c "CREATE DATABASE pact_broker;"`
+      puts `psql postgres -c "GRANT ALL PRIVILEGES ON DATABASE pact_broker TO pact_broker;"`
+    end
+
+    task :mysql do
+      puts `mysql -h localhost -u root -e "CREATE DATABASE IF NOT EXISTS pact_broker"`
+      puts `mysql -h localhost -u root -e "GRANT ALL PRIVILEGES ON pact_broker.* TO 'pact_broker'@'localhost' identified by 'pact_broker';"`
+    end
+  end
+
+  task :drop do
+    Rake::Task["db:drop:#{ENV.fetch('DATABASE_ADAPTER', 'default')}"].invoke
+  end
+
+  namespace :drop do
+    desc 'Delete the dev/test database - uses RACK_ENV, defaulting to "development"'
+    task :default => 'db:env' do
+      PactBroker::Database.delete_database_file
+    end
+
+    task :postgres do
+      puts `psql postgres -c "drop DATABASE pact_broker;"`
+    end
+
+    task :mysql do
+      puts `mysql -h localhost -u root -e "DROP DATABASE IF EXISTS pact_broker"`
+    end
+  end
+
   desc 'Print current schema version'
   task :version => 'db:env' do
     puts "Schema Version: #{PactBroker::Database.version}"
   end
 
@@ -51,12 +89,12 @@
   # Private: Ensure the dev/test database directory exists
   task 'prepare_dir' => 'db:env' do
     PactBroker::Database.ensure_database_dir_exists
   end
 
-  task :create => 'db:env' do
-    PactBroker::Database.create
-  end
+  # task :create => 'db:env' do
+  #   PactBroker::Database.create
+  # end
 
   # Private
   task :set_test_env do
     ENV['RACK_ENV'] = 'test'
   end