#!/usr/bin/env ruby

require 'rubygems'
gem 'sequel', '~> 3.17.0'

$:.unshift File.dirname(__FILE__) + '/../lib'

require 'taps/schema'

cmd = ARGV.shift.strip rescue ''
database_url = ARGV.shift.strip rescue ''

def show_usage_and_exit
  puts <<EOTXT
  schema console <database_url>
  schema dump <database_url>
  schema dump_table <database_url> <table>
  schema indexes <database_url>
  schema indexes_individual <database_url>
  schema reset_db_sequences <database_url>
  schema load <database_url> <schema_file>
  schema load_indexes <database_url> <indexes_file>
EOTXT
  exit(1)
end

case cmd
when 'dump'
  puts Taps::Schema.dump(database_url)
when 'dump_table'
  table = ARGV.shift.strip
  puts Taps::Schema.dump_table(database_url, table)
when 'indexes'
  puts Taps::Schema.indexes(database_url)
when 'indexes_individual'
  puts Taps::Schema.indexes_individual(database_url)
when 'load_indexes'
  filename = ARGV.shift.strip rescue ''
  indexes = File.read(filename) rescue show_usage_and_exit
  Taps::Schema.load_indexes(database_url, indexes)
when 'load'
  filename = ARGV.shift.strip rescue ''
  schema = File.read(filename) rescue show_usage_and_exit
  Taps::Schema.load(database_url, schema)
when 'reset_db_sequences'
  Taps::Schema.reset_db_sequences(database_url)
when 'console'
  $db = Sequel.connect(database_url)
  require 'irb'
  require 'irb/completion'
  IRB.start
else
  show_usage_and_exit
end