# encoding: utf-8

##############
# nb: for local testing use:
#    
#  ruby -I ../../github/sport.db.ruby/lib
#        ../../github/sport.db.ruby/lib/sportdb.rb
#        setup --delete --sport
#        --include ../../github/football.db


require 'commander/import'

# our own code / additional for cli only

require 'logutils/db'
require 'sportdb/cli/opts'

LogUtils::Logger.root.level = :info   # set logging level to info 

program :name,  'sportdb'
program :version, SportDB::VERSION
program :description, "sport.db command line tool, version #{SportDB::VERSION}"


# default_command :help
default_command :load

program :help_formatter, Commander::HelpFormatter::TerminalCompact

## program :help, 'Examples', 'yada yada -try multi line later'

=begin
### add to help use new sections

Examples:
    sportdb cl/teams cl/2012_13/cl                     # import champions league (cl)
    sportdb --create                                   # create database schema

More Examples:
    sportdb                                            # show stats (table counts, table props)
    sportdb -i ../sport.db/db cl/teams cl/2012_13/cl   # import champions league (cl) in db folder

Further information:
  http://geraldb.github.com/sport.db
=end


## todo: find a better name e.g. change to settings? config? safe_opts? why? why not?
myopts = SportDB::Opts.new

### global option (required)
## todo: add check that path is valid?? possible?

global_option '-i', '--include PATH', String, "Data path (default is #{myopts.data_path})"
global_option '-d', '--dbpath PATH', String, "Database path (default is #{myopts.db_path})"
global_option '-n', '--dbname NAME', String, "Database name (datault is #{myopts.db_name})"

global_option '-q', '--quiet', "Only show warnings, errors and fatal messages"
### todo/fix: just want --debug/--verbose flag (no single letter option wanted) - fix
global_option '-w', '--verbose', "Show debug messages"


def connect_to_db( options )
  puts SportDB.banner

  puts "working directory: #{Dir.pwd}"

  db_config = {
    :adapter  => 'sqlite3',
    :database => "#{options.db_path}/#{options.db_name}"
  }

  puts "Connecting to db using settings: "
  pp db_config

  ActiveRecord::Base.establish_connection( db_config )
  
  LogDb.setup  # start logging to db
end


command :create do |c|
  c.syntax = 'sportdb create [options]'
  c.description = 'Create DB schema'
  c.action do |args, options|
    
    LogUtils::Logger.root.level = :warn    if options.quiet.present?
    LogUtils::Logger.root.level = :debug   if options.verbose.present?
    
    myopts.merge_commander_options!( options.__hash__ )
    connect_to_db( myopts )
    
    LogDB.create
    WorldDB.create
    SportDB.create
    puts 'Done.'
  end # action
end # command create

command :setup do |c|
  c.syntax = 'sportdb setup [options]'
  c.description = "Create DB schema 'n' load all data"

  c.option '--world', 'Populate world tables'
  ## todo: use --world-include - how? find better name?
  c.option '--worldinclude PATH', String, 'World data path'

  c.option '--sport', 'Populate sport tables'
  c.option '--delete', 'Delete all records'

  c.action do |args, options|

    LogUtils::Logger.root.level = :warn    if options.quiet.present?
    LogUtils::Logger.root.level = :debug   if options.verbose.present?

    myopts.merge_commander_options!( options.__hash__ )
    connect_to_db( myopts )
    
    if options.world.present? || options.sport.present?
      
      ## todo: check order for reference integrity
      #  not really possible to delete world data if sport data is present
      #   delete sport first
      
      if options.delete.present?
        SportDB.delete! if options.sport.present?
        WorldDB.delete! if options.world.present?
      end
      
      if options.world.present?
        WorldDB.read_all( myopts.world_data_path )
      end
      if options.sport.present?
        SportDB.read_all( myopts.data_path )
      end

    else  # assume "plain" regular setup
      LogDB.create
      WorldDB.create
      SportDB.create
    
      WorldDB.read_all( myopts.world_data_path )
      SportDB.read_all( myopts.data_path )
    end
    puts 'Done.'
  end # action
end  # command setup

command :load do |c|
  ## todo: how to specify many fixutes <>... ??? in syntax
  c.syntax = 'sportdb load [options] FIXTURE...'
  c.description = 'Load fixtures'

  c.option '-e', '--event KEY', String, 'Event to load'
  c.option '--delete', 'Delete all records'

  c.action do |args, options|

    LogUtils::Logger.root.level = :warn    if options.quiet.present?
    LogUtils::Logger.root.level = :debug   if options.verbose.present?

    myopts.merge_commander_options!( options.__hash__ )
    connect_to_db( myopts )
    
    SportDB.delete! if options.delete.present?

    reader = SportDB::Reader.new

    args.each do |arg|
      name = arg     # File.basename( arg, '.*' )

      if myopts.event.present?
        ## fix: rename to load_event_fixtures_w... or similar
        reader.load_fixtures( myopts.event, name, myopts.data_path )
      else
        ## fix> add a convenience method for loading single fixture
        ary = []
        ary << name
        reader.load( ary, myopts.data_path )
      end
    end # each arg

    puts 'Done.'
  end
end # command load


command :logs do |c|
  c.syntax = 'sportdb logs [options]'
  c.description = 'Show logs'
  c.action do |args, options|

    LogUtils::Logger.root.level = :warn    if options.quiet.present?
    LogUtils::Logger.root.level = :debug   if options.verbose.present?

    myopts.merge_commander_options!( options.__hash__ )
    connect_to_db( myopts ) 
    
    LogDB::Models::Log.all.each do |log|
      puts "[#{log.level}] -- #{log.msg}"
    end
    
    puts 'Done.'
  end
end


command :stats do |c|
  c.syntax = 'sportdb stats [options]'
  c.description = 'Show stats'
  c.action do |args, options|

    LogUtils::Logger.root.level = :warn    if options.quiet.present?
    LogUtils::Logger.root.level = :debug   if options.verbose.present?

    myopts.merge_commander_options!( options.__hash__ )
    connect_to_db( myopts ) 
    
    SportDB.tables
    
    puts 'Done.'
  end
end


command :props do |c|
  c.syntax = 'sportdb props [options]'
  c.description = 'Show props'
  c.action do |args, options|

    LogUtils::Logger.root.level = :warn    if options.quiet.present?
    LogUtils::Logger.root.level = :debug   if options.verbose.present?

    myopts.merge_commander_options!( options.__hash__ )
    connect_to_db( myopts ) 
    
    SportDB.props
    
    puts 'Done.'
  end
end


command :test do |c|
  c.syntax = 'sportdb test [options]'
  c.description = 'Debug/test command suite'
  c.action do |args, options|

    LogUtils::Logger.root.level = :warn    if options.quiet.present?
    LogUtils::Logger.root.level = :debug   if options.verbose.present?

    puts "hello from test command"
    puts "args (#{args.class.name}):"
    pp args
    puts "options:"
    pp options
    puts "options.__hash__:"
    pp options.__hash__
    
    LogUtils::Logger.root.debug 'test debug msg'
    LogUtils::Logger.root.info 'test info msg'
    LogUtils::Logger.root.warn 'test warn msg'
    
    puts 'Done.'
  end
end