"""Maintenance helper (run from SSH / terminal in the app folder).

  python manage.py set-password USERNAME     set or reset any login password (asks for it)
  python manage.py backup [FOLDER]           zip of database + agreement files (default: ./backups)
"""
import getpass
import os
import sqlite3
import sys
import zipfile
from datetime import datetime
from pathlib import Path

import app as A
from werkzeug.security import generate_password_hash


def set_password(username):
    con = sqlite3.connect(A.DB_PATH)
    row = con.execute("SELECT id FROM users WHERE lower(username)=lower(?)", (username,)).fetchone()
    if not row:
        sys.exit(f"No user named {username!r}")
    pw = getpass.getpass("New password (min 8 characters): ")
    if len(pw) < 8 or pw != getpass.getpass("Repeat password: "):
        sys.exit("Password too short or does not match. Nothing changed.")
    con.execute("UPDATE users SET password_hash=?, must_change=0, active=1 WHERE id=?",
                (generate_password_hash(pw), row[0]))
    con.commit()
    print("Password updated.")


def backup(dest):
    dest = Path(dest)
    dest.mkdir(parents=True, exist_ok=True)
    stamp = datetime.now().strftime("%Y%m%d-%H%M")
    snap = dest / f"portal-{stamp}.db"
    src, dst = sqlite3.connect(A.DB_PATH), sqlite3.connect(snap)
    src.backup(dst)           # consistent copy even while the site is in use
    dst.close(); src.close()
    out = dest / f"backup-{stamp}.zip"
    with zipfile.ZipFile(out, "w", zipfile.ZIP_DEFLATED) as z:
        z.write(snap, "portal.db")
        for f in A.UPLOADS.glob("*"):
            z.write(f, f"agreements/{f.name}")
    snap.unlink()
    print("Backup written:", out)


if __name__ == "__main__":
    if len(sys.argv) >= 3 and sys.argv[1] == "set-password":
        set_password(sys.argv[2])
    elif len(sys.argv) >= 2 and sys.argv[1] == "backup":
        backup(sys.argv[2] if len(sys.argv) > 2 else "backups")
    else:
        print(__doc__)
