#!/usr/bin/env python3

"""Convert a GECAS-AMS date string to a sqlite date column."""

import sys

import datasimple.sqlite as sqlite3  # Use our standin helper


def log(msg, *args):
    """Simple output function."""
    if args:
        msg = msg.format(*args)
    print(msg)


def main():
    """Entry point."""
    args = sys.argv[1:]
    if len(args) != 3:
        log('Usage: sqlite-date.py db table column')
        return

    dbname, tabname, colname = args
    log('Database: {}', dbname)
    conn = sqlite3.connect(dbname)
    sql = 'UPDATE {t} SET {c} = ds_datetime({c})'.format(t=tabname, c=colname)
    log('Execute:  {}', sql)

    with conn:
        conn.execute(sql)


if __name__ == '__main__':
    main()
