"""Command-line helpers (optional — everything can also be done in the web app).

    python manage.py set-password            # set or reset the login password
    python manage.py import Tasks.md         # import Obsidian Tasks markdown
"""
import getpass
import secrets
import sys
from datetime import datetime
from zoneinfo import ZoneInfo

from werkzeug.security import generate_password_hash

import config
import db
import quickadd


def today():
    return datetime.now(ZoneInfo(config.TIMEZONE)).date()


def set_password():
    pw = getpass.getpass("New password: ")
    if len(pw) < 8 or pw != getpass.getpass("Again: "):
        sys.exit("Passwords must match and be at least 8 characters.")
    with db.connect() as conn:
        db.set_setting(conn, "password_hash", generate_password_hash(pw))
        if not db.get_setting(conn, "widget_key"):
            db.set_setting(conn, "widget_key", secrets.token_urlsafe(24))
    print("Password saved.")


def import_file(path):
    import importer
    tasks, skipped = importer.parse_markdown(open(path, encoding="utf-8").read(), today())
    now = db.now_iso()
    with db.connect() as conn:
        for t in tasks:
            conn.execute(
                "INSERT INTO tasks(title, due_date, rrule, recur_from, priority, tags, created_at, updated_at) "
                "VALUES(?,?,?,?,?,?,?,?)",
                (t["title"], t["due_date"], t["rrule"], t["recur_from"], t["priority"],
                 quickadd.tags_to_db(t["tags"]), now, now))
    print(f"Imported {len(tasks)} tasks ({skipped} completed/cancelled skipped).")


def main():
    db.init_db()
    if len(sys.argv) < 2:
        sys.exit(__doc__)
    cmd = sys.argv[1]
    if cmd == "set-password":
        set_password()
    elif cmd == "import" and len(sys.argv) == 3:
        import_file(sys.argv[2])
    else:
        sys.exit(__doc__)


if __name__ == "__main__":
    main()
