"""A person marks a report's fiscal year as checked (POST .../year/{fy}/verify); every verify / unverify is an event."""
import sqlite3

from app.ocr import config, database
from tests.test_ocr import ocr  # noqa: F401  (fixture)

APIKEY = {"X-API-Key": "k3y"}
ALICE = {**APIKEY, "X-Username": "alice"}
BOB = {**APIKEY, "X-Username": "bob"}
PDF = b"%PDF-1.4\n%fake\n"


def _register(ocr, code, fy, file=False):
    kw = {"files": {"file": ("a.pdf", PDF, "application/pdf")}} if file else {}
    r = ocr.post("/ocr/register-document", headers=ALICE,
                 data={"instrument_code": code, "fiscal_year": fy, "filename": "a.pdf", "total_pages": 3}, **kw)
    assert r.status_code == 200, r.text
    return r.json()


def _doc(ocr, code, fy):
    docs = ocr.get(f"/ocr/company/{code}/status", headers=APIKEY).json()["documents"]
    return next(d for d in docs if d["fiscal_year"] == fy)


def _events(ocr, code, **params):
    return ocr.get("/ocr/events", headers=APIKEY, params={"instrument_code": code, **params}).json()["events"]


def test_a_new_report_is_pending(ocr):
    reg = _register(ocr, "VCO1", "2023")
    d = _doc(ocr, "VCO1", "2023")
    assert (d["verified"], d["verified_by"], d["verified_at"], d["verify_note"]) == (False, None, None, None)
    assert reg["verification_cleared"] is False
    pages = ocr.get("/ocr/company/VCO1/year/2023/pages?include_markdown=false", headers=APIKEY).json()
    assert pages["verified"] is False and pages["verified_by"] is None


def test_verify_records_who_when_and_the_note(ocr):
    _register(ocr, "VCO2", "2023-24")
    r = ocr.post("/ocr/company/VCO2/year/2023-24/verify", headers=ALICE, json={"verified": True, "note": "year matches the cover"})
    assert r.status_code == 200, r.text
    body = r.json()
    assert (body["instrument_code"], body["fiscal_year"], body["verified"], body["verified_by"], body["verify_note"]) == \
        ("VCO2", "2023-24", True, "alice", "year matches the cover")
    assert body["verified_at"].endswith("Z")
    d = _doc(ocr, "VCO2", "2023-24")
    assert d["verified"] is True and d["verified_by"] == "alice" and d["verify_note"] == "year matches the cover"
    pages = ocr.get("/ocr/company/VCO2/year/2023-24/pages?include_markdown=false", headers=APIKEY).json()
    assert pages["verified_by"] == "alice"
    (ev,) = _events(ocr, "VCO2", action="REPORT_VERIFY")
    assert (ev["username"], ev["status"], ev["fiscal_year"], ev["target_type"]) == ("alice", "SUCCEEDED", "2023-24", "document")
    assert ev["details"]["note"] == "year matches the cover" and ev["details"]["was_verified"] is False


def test_unverify_clears_the_mark_and_is_recorded_with_who_had_verified(ocr):
    _register(ocr, "VCO3", "2023")
    ocr.post("/ocr/company/VCO3/year/2023/verify", headers=ALICE, json={"verified": True})
    r = ocr.post("/ocr/company/VCO3/year/2023/verify", headers=BOB, json={"verified": False, "note": "wrong year, it is 2022"})
    assert r.status_code == 200
    assert (r.json()["verified"], r.json()["verified_by"], r.json()["verified_at"], r.json()["verify_note"]) == (False, None, None, None)
    assert _doc(ocr, "VCO3", "2023")["verified"] is False
    (un,) = _events(ocr, "VCO3", action="REPORT_UNVERIFY")
    assert un["username"] == "bob" and un["details"]["note"] == "wrong year, it is 2022"
    assert un["details"]["was_verified"] is True and un["details"]["previous_verified_by"] == "alice"


def test_verifying_again_replaces_the_verifier_and_every_call_is_an_event(ocr):
    _register(ocr, "VCO4", "2023")
    ocr.post("/ocr/company/VCO4/year/2023/verify", headers=ALICE, json={"verified": True})
    ocr.post("/ocr/company/VCO4/year/2023/verify", headers=BOB, json={"verified": True, "note": "rechecked"})
    ocr.post("/ocr/company/VCO4/year/2023/verify", headers=BOB, json={"verified": False})
    ocr.post("/ocr/company/VCO4/year/2023/verify", headers=BOB, json={"verified": False})          # nothing to clear
    d = _doc(ocr, "VCO4", "2023")
    assert d["verified"] is False
    evs = _events(ocr, "VCO4")
    assert [(e["action"], e["username"]) for e in reversed(evs)] == [
        ("REPORT_REGISTER", "alice"), ("REPORT_VERIFY", "alice"), ("REPORT_VERIFY", "bob"),
        ("REPORT_UNVERIFY", "bob"), ("REPORT_UNVERIFY", "bob")]
    second = [e for e in evs if e["action"] == "REPORT_VERIFY"][0]
    assert second["details"]["was_verified"] is True and second["details"]["previous_verified_by"] == "alice"
    assert [e for e in evs if e["action"] == "REPORT_UNVERIFY"][0]["details"]["was_verified"] is False


def test_unknown_report_is_404_and_the_failed_attempt_is_recorded(ocr):
    r = ocr.post("/ocr/company/VCO5/year/2023/verify", headers=ALICE, json={"verified": True})
    assert r.status_code == 404
    (ev,) = _events(ocr, "VCO5")
    assert (ev["action"], ev["status"], ev["username"]) == ("REPORT_VERIFY", "FAILED", "alice") and ev["details"]["status_code"] == 404


def test_username_is_required_and_bad_bodies_are_refused(ocr):
    _register(ocr, "VCO6", "2023")
    assert ocr.post("/ocr/company/VCO6/year/2023/verify", headers=APIKEY, json={"verified": True}).status_code == 400
    assert ocr.post("/ocr/company/VCO6/year/2023/verify", headers=ALICE, json={}).status_code == 422
    assert ocr.post("/ocr/company/VCO6/year/2023/verify", headers=ALICE, json={"verified": True, "note": "x" * 501}).status_code == 422
    assert ocr.post("/ocr/company/VCO6/year/2023-2024/verify", headers=ALICE, json={"verified": True}).status_code == 422
    assert _doc(ocr, "VCO6", "2023")["verified"] is False


def test_a_new_pdf_clears_the_mark_but_registering_without_a_file_keeps_it(ocr):
    _register(ocr, "VCO7", "2023", file=True)
    ocr.post("/ocr/company/VCO7/year/2023/verify", headers=ALICE, json={"verified": True})
    again = _register(ocr, "VCO7", "2023")                       # no new file (page count correction)
    assert again["verification_cleared"] is False and _doc(ocr, "VCO7", "2023")["verified"] is True
    replaced = _register(ocr, "VCO7", "2023", file=True)         # a different file
    assert replaced["verification_cleared"] is True
    assert _doc(ocr, "VCO7", "2023")["verified"] is False
    reg = [e for e in _events(ocr, "VCO7") if e["action"] == "REPORT_REGISTER"]
    assert reg[0]["details"]["verification_cleared"] is True and "verification_cleared" not in reg[1]["details"]


def test_other_reports_of_the_company_are_not_affected(ocr):
    _register(ocr, "VCO8", "2022")
    _register(ocr, "VCO8", "2023")
    ocr.post("/ocr/company/VCO8/year/2023/verify", headers=ALICE, json={"verified": True})
    assert [d["verified"] for d in ocr.get("/ocr/company/VCO8/status", headers=APIKEY).json()["documents"]] == [False, True]


def test_an_older_database_gets_the_columns():
    path = config.DB_PATH.parent / "old_documents.db"
    path.unlink(missing_ok=True)
    conn = sqlite3.connect(path)
    conn.row_factory = sqlite3.Row
    conn.execute("CREATE TABLE documents (id INTEGER PRIMARY KEY, instrument_code TEXT, fiscal_year TEXT)")
    database._add_missing_columns(conn.cursor(), "documents", {"verified_by": "TEXT", "verified_at": "TEXT", "verify_note": "TEXT"})
    database._add_missing_columns(conn.cursor(), "documents", {"verified_by": "TEXT"})            # idempotent
    assert {r["name"] for r in conn.execute("PRAGMA table_info(documents)")} >= {"verified_by", "verified_at", "verify_note"}
    conn.close()
    path.unlink()
