# 项目文件：quality_project/tests/integration/test_library.py
# 两条 Python 日志只计一次；两个标签不能把 55 放大为 110。
import sqlite3
from datetime import date

import pytest

from bookdata.library import Library
from bookdata.models import Book


def test_tag_filter_does_not_double_total(library):
    library.record_reading("Python", date(2026, 10, 19), 20)
    library.record_reading("Python", date(2026, 10, 20), 35)
    rows = library.search("基础")
    assert [(row["title"], row["total"]) for row in rows] == [("Python", 55)]


def test_reimport_preserves_id_and_logs(library):
    original_id = library.search()[0]["id"]
    library.record_reading("Python", date(2026, 10, 19), 20)
    library.import_books([Book("Python", True, ["更新标签"])])
    row = library.search("更新标签")[0]
    assert (row["id"], row["finished"], row["total"]) == (original_id, 1, 20)

# 续写同一文件：quality_project/tests/integration/test_library.py
# 约束失败应撤回本批所有修改，连接也应能继续执行查询。
def test_failed_batch_rolls_back(library):
    before = library.export_books()
    with pytest.raises(sqlite3.IntegrityError):
        library.import_books([Book("Python", True, ["被撤回"]), Book("")])
    assert library.export_books() == before
    assert [row["title"] for row in library.search()] == ["Python", "NumPy", "Pygame"]


def test_commit_survives_close_and_connection_is_closed(tmp_path):
    path = tmp_path / "library.sqlite3"
    with Library(path) as first:
        first.import_books([Book("Python")])
        first.record_reading("Python", date(2026, 10, 19), 20)
    with pytest.raises(sqlite3.ProgrammingError):
        first.connection.execute("SELECT 1")
    with Library(path) as second:
        row = second.search()[0]
        assert (row["title"], row["total"]) == ("Python", 20)