"""
CLI for the csvw package.
"""
import sys
import json
import shutil
import pathlib
import argparse
import subprocess

from termcolor import colored

from csvw import CSVW, TableGroup
from csvw.db import Database
from csvw.metadata_utils import metadata2markdown


def parsed_args(desc, args, *argspecs):
    """Add custom arguments to the parser and parse."""
    if args is None:  # pragma: no cover
        parser = argparse.ArgumentParser(description=desc)
        for kw, kwargs in argspecs:
            parser.add_argument(*kw, **kwargs)
        return parser.parse_args()
    return args


def exit(ret, test=False):  # pylint: disable=redefined-builtin
    """We don't want to exit the test suite"""
    if test:
        return ret
    sys.exit(ret)  # pragma: no cover


def csvwdescribe(args=None, test=False):
    """Describe a (set of) CSV file(s) with basic CSVW metadata."""
    frictionless = shutil.which('frictionless')
    if not frictionless:  # pragma: no cover
        raise ValueError('The frictionless command must be installed for this functionality!\n'
                         'Run `pip install frictionless` and try again.')

    args = parsed_args(
        csvwdescribe.__doc__,
        args,
        (['--delimiter'], {'default': None}),
        (['csv'], {'nargs': '+', 'help': "CSV files to describe as CSVW TableGroup"}),
    )
    fargs = ['describe', '--json']
    if args.delimiter:
        fargs.extend(['--dialect', '{"delimiter": "%s"}' % args.delimiter])
    onefile = False
    if len(args.csv) == 1 and '*' not in args.csv[0]:
        onefile = True
        # Make sure we infer a tabular-data schema even if the file suffix does not suggest a CSV
        # file.
        fargs.extend(['--format', 'csv'])
    else:
        fargs.extend(['--type', 'package'])

    dp = json.loads(subprocess.check_output([frictionless] + fargs + args.csv))
    if onefile:
        dp = {'resources': [dp], 'profile': 'data-package'}

    tg = TableGroup.from_frictionless_datapackage(dp)
    print(json.dumps(tg.asdict(), indent=4))
    return exit(0, test=test)  # pylint: disable=R1722


def csvwvalidate(args=None, test=False):
    """Validate a (set of) CSV file(s) described by CSVW metadata."""
    args = parsed_args(
        csvwvalidate.__doc__,
        args,
        (['url'], {'help': 'URL or local path to CSV or JSON metadata file.'}),
        (['-v', '--verbose'], {'action': 'store_true', 'default': False}),
    )
    ret = 0
    try:
        csvw = CSVW(args.url, validate=True)
        if csvw.is_valid:
            print(colored('OK', 'green', attrs=['bold']))
        else:
            ret = 1
            print(colored('FAIL', 'red', attrs=['bold']))
            if args.verbose:
                for w in csvw.warnings:
                    print(colored(str(w.message), 'blue'))
    except ValueError as e:
        ret = 2
        print(colored('FAIL', 'red', attrs=['bold']))
        if args.verbose:
            print(colored(str(e), 'blue'))
    return exit(ret, test=test)  # pylint: disable=R1722


def csvw2datasette(args=None, test=False):
    """Convert CSVW to data for datasette (https://datasette.io/)."""
    args = parsed_args(
        csvw2datasette.__doc__,
        args,
        (['url'], {'help': 'URL or local path to CSV or JSON metadata file.'}),
        (['-o', '--outdir'], {'type': pathlib.Path, 'default': pathlib.Path('.')}),
    )
    dbname, mdname = 'datasette.db', 'datasette-metadata.json'
    csvw = CSVW(args.url)
    db = Database(csvw.tablegroup, fname=args.outdir / dbname)
    db.write_from_tg()
    md = {}
    for k in ['title', 'description', 'license']:
        if f'dc:{k}' in csvw.common_props:
            md[k] = csvw.common_props[f'dc:{k}']
    args.outdir.joinpath(mdname).write_text(json.dumps(md, indent=4))
    for line in [
        "Run",
        f"    datasette {args.outdir / dbname} --metadata {args.outdir / mdname}",
        "and open your browser at",
        "    http://localhost:8001/",
        "to browse the data.",
    ]:
        print(line)
    return exit(0, test=test)  # pylint: disable=R1722


def csvw2json(args=None, test=False):
    """Convert CSVW to JSON, see https://w3c.github.io/csvw/csv2json/"""
    args = parsed_args(
        csvw2json.__doc__,
        args,
        (['url'], {'help': 'URL or local path to CSV or JSON metadata file.'}),
    )
    csvw = CSVW(args.url)
    print(json.dumps(csvw.to_json(), indent=4))
    return exit(0, test=test)  # pylint: disable=R1722


def csvw2sqlite(args=None, test=False):
    """Convert CSVW to SQLite"""
    args = parsed_args(
        csvw2sqlite.__doc__,
        args,
        (
            ['url'],
            {'help': 'URL or local path to CSVW metadata file describing a TableGroup.\n\n'
                     'Note that not all valid CSVW datasets can be converted to SQLite. One '
                     'limitation is that all tables which are referenced by foreign keys must '
                     'have a primary key.'}),
        (
            ['output'],
            {'help': 'Path for the generated SQLite database file.'}),
    )
    tg = TableGroup.from_file(args.url)
    db = Database(tg, args.output)
    db.write_from_tg(_force=True)
    return exit(0, test=test)  # pylint: disable=R1722


def csvw2markdown(args=None, test=False):
    """Create a Markdown document containing the CSVW metadata in human readable form."""
    args = parsed_args(
        "Convert CSVW to JSON, see https://w3c.github.io/csvw/csv2json/",
        args,
        (
            ['url'],
            {'help': 'URL or local path to CSVW metadata file describing a TableGroup.\n\n'
                     'Note that not all valid CSVW datasets can be converted to SQLite. One '
                     'limitation is that all tables which are referenced by foreign keys must '
                     'have a primary key.'}),
    )
    tg = TableGroup.from_file(args.url)
    print(metadata2markdown(tg, link_files=True))
    return exit(0, test=test)  # pylint: disable=R1722


if __name__ == '__main__':  # pragma: no cover
    csvw2json()