Contents

# frozen_string_literal: true

require 'sequel'
require_relative '../../config/db'

namespace :db do
  desc 'Create database'
  task create: :config do
    cmd = "PGPASSWORD=#{DB_CONF[:password]} createdb" \
          " --username=#{DB_CONF[:username]}" \
          " --host=#{DB_CONF[:host]}" \
          " #{DB_CONF[:database]}"
    puts "Database `#{DB_CONF[:database]}` successfully created" if system(cmd)
  end

  desc 'Drop database'
  task drop: :config do
    cmd = "PGPASSWORD=#{DB_CONF[:password]} dropdb" \
          " --username=#{DB_CONF[:username]}" \
          " --host=#{DB_CONF[:host]}" \
          " #{DB_CONF[:database]}"
    puts "Database `#{DB_CONF[:database]}` successfully dropped" if system(cmd)
  end

  desc 'Database console'
  task console: :config do
    cmd = "PGPASSWORD=#{DB_CONF[:password]} psql" \
          " --username=#{DB_CONF[:username]}" \
          " --host=#{DB_CONF[:host]}" \
          " --port=#{DB_CONF[:port]}" \
          " #{DB_CONF[:database]}"
    puts "Database `#{DB_CONF[:database]}` says 'bye-bye'" if system(cmd)
  end

  desc 'Reset database - drop, create, & migrate'
  task :reset do
    Rake::Task['db:drop'].invoke
    Rake::Task['db:create'].invoke
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version	Path
cyclone_lariat-1.0.0	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc9	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc8	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc7	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc6	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc5	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc4	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc3	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc2	lib/tasks/db.rake
cyclone_lariat-1.0.0.rc1	lib/tasks/db.rake