import 'package:args/args.dart';
import 'package:knex_dart/knex_dart.dart';
import 'package:knex_dart_sqlite/knex_dart_sqlite.dart';


const String version = '1.0.0';

ArgParser buildParser() {
  return ArgParser()
    ..addFlag(
      'help',
      abbr: 'h',
      negatable: false,
      help: 'Print this usage information.',
    )
    ..addFlag(
      'verbose',
      abbr: 'v',
      negatable: false,
      help: 'Show additional command output.',
    )
    ..addFlag('version', negatable: false, help: 'Print the tool version.')
    ..addOption(
      'database',
      abbr: 'd',
      help: 'Path to the database',
    )
    ..addOption(
      'add',
      abbr: 'a',
      help: 'Add updates from supplied Tab-Separated Value (TSV).',
    );


}

void printUsage(ArgParser argParser) {
  print('Usage: dart cohab_updater.dart <flags> [arguments]');
  print(argParser.usage);
}

// Straight up gemini
void openDatabase(String path) async {
  print("Opening the database $path ...");
  final db = await KnexSQLite.connect(filename: 'Test.db');

  try {

 // final grab = await db.query
 //   .select(['name', 'comment', 'type'])
 //   .table('ProcessInformation')
 //   .limit(5);

 //   print(grab);
  } catch (e) {
    print("Query failed: $e");
  }
}

void main(List<String> arguments) {
  String dbpath;
  final ArgParser argParser = buildParser();
  try {
    final ArgResults results = argParser.parse(arguments);
    bool verbose = false;

    // Process the parsed arguments.
    if (results.flag('help')) {
      printUsage(argParser);
      return;
    }
    
    if (results.flag('version')) {
      print('cohab_updater version: $version');
      return;
    }
    
    if (results.flag('verbose')) {
      verbose = true;
    }

    // Act on the arguments provided.
    //print('Positional arguments: ${results.rest}');
    //if (verbose) {
    //  print('[VERBOSE] All arguments: ${results.arguments}');
    //}

    if (!results.wasParsed('database')) {
	print('No database was supplied!');
	return;
    }

    if (!results.wasParsed('add')) {
	print('Missing Tab-Separate Values sheet!');
	return;
    }

    dbpath = results["database"];
    openDatabase(dbpath);


  } on FormatException catch (e) {
    // Print usage information if an invalid argument was provided.
    print(e.message);
    print('');
    printUsage(argParser);
  }
}