"""A user can switch merged rows (series) on and off; the off ones are left out of the Excel downloads."""
import io

from openpyxl import load_workbook

from app.ocr import database
from tests.test_ocr import KEY, full_results, merge_and_find, ocr, seeded  # noqa: F401  (fixtures)


def _sheet_fields(content):
    wb = load_workbook(io.BytesIO(content))
    return [row[0].value for ws in wb.worksheets for row in ws.iter_rows(min_row=3) if row[0].value]


def test_series_can_be_switched_off_and_on_and_the_downloads_follow(seeded):  # noqa: F811
    row = merge_and_find(seeded, "SEEDCO", "Total assets")
    sid = row["series_id"]
    assert row["active"] is True
    assert "Total assets" in _sheet_fields(seeded.get("/ocr/company/SEEDCO/download/merged.xlsx", headers=KEY).content)

    r = seeded.put(f"/ocr/company/SEEDCO/series/{sid}/active", headers=KEY, json={"active": False})
    assert r.status_code == 200 and r.json() == {"active": False, "updated": [sid], "unchanged": [], "unknown": [],
                                                  "inactive_series_count": 1}
    # still in the results, flagged; out of both workbooks; the CSV is not changed
    merged = full_results(seeded, "SEEDCO")
    assert merged["inactive_series_count"] == 1
    assert next(x for x in merged["merged_rows"] if x["series_id"] == sid)["active"] is False
    assert "Total assets" not in _sheet_fields(seeded.get("/ocr/company/SEEDCO/download/merged.xlsx", headers=KEY).content)
    assert seeded.get("/ocr/company/SEEDCO/download/raw.xlsx", headers=KEY).status_code in (200, 404)
    assert [s for s in seeded.get("/ocr/company/SEEDCO/series", headers=KEY).json()["series"] if s["id"] == sid][0]["active"] is False

    # the same state again changes nothing; a second merge keeps the choice
    assert seeded.put(f"/ocr/company/SEEDCO/series/{sid}/active", headers=KEY, json={"active": False}).json()["unchanged"] == [sid]
    again = merge_and_find(seeded, "SEEDCO", "Total assets")
    assert again["series_id"] == sid and again["active"] is False

    r = seeded.put(f"/ocr/company/SEEDCO/series/{sid}/active", headers=KEY, json={"active": True})
    assert r.json()["updated"] == [sid] and r.json()["inactive_series_count"] == 0
    assert "Total assets" in _sheet_fields(seeded.get("/ocr/company/SEEDCO/download/merged.xlsx", headers=KEY).content)


def test_bulk_and_unknown_series_and_the_event_log(seeded):  # noqa: F811
    sid = merge_and_find(seeded, "SEEDCO", "Total assets")["series_id"]
    assert seeded.put("/ocr/company/SEEDCO/series/999999/active", headers=KEY, json={"active": False}).status_code == 404
    r = seeded.put("/ocr/company/SEEDCO/series-active", headers=KEY, json={"series_ids": [sid, 999999], "active": False})
    assert r.status_code == 200 and r.json()["updated"] == [sid] and r.json()["unknown"] == [999999]
    assert seeded.put("/ocr/company/SEEDCO/series-active", headers=KEY, json={"series_ids": [], "active": False}).status_code == 422
    # another company's series id is unknown here
    assert database.get_inactive_series_ids("OTHERCO") == set()
    events = seeded.get("/ocr/events", headers=KEY, params={"instrument_code": "SEEDCO"}).json()["events"]
    assert {e["action"] for e in events} >= {"SERIES_DEACTIVATE"}
    assert all(e["username"] == "tester" for e in events if e["action"] == "SERIES_DEACTIVATE")


def test_a_username_is_required(seeded):  # noqa: F811
    sid = merge_and_find(seeded, "SEEDCO", "Total assets")["series_id"]
    no_user = {"X-API-Key": KEY["X-API-Key"]}
    assert seeded.put(f"/ocr/company/SEEDCO/series/{sid}/active", headers=no_user, json={"active": False}).status_code == 400
    assert seeded.put("/ocr/company/SEEDCO/series-active", headers=no_user,
                      json={"series_ids": [sid], "active": False}).status_code == 400
