Spaces:
Configuration error
Configuration error
File size: 6,175 Bytes
546c207 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 | """Persistence and the runtime lookup path, against the built database.
These run on `data/catalog.db`; they are skipped if the index has not been built.
"""
from pathlib import Path
import pytest
from spareparts import config, index_db
pytestmark = pytest.mark.skipif(
not config.DB_PATH.exists(), reason="run `python -m spareparts.build_index` first"
)
@pytest.fixture(scope="module")
def conn():
connection = index_db.connect()
yield connection
connection.close()
def _annotated(conn):
return conn.execute("SELECT COUNT(*) FROM labels").fetchone()[0] > 0
def test_labels_and_components_are_paired(conn):
if not _annotated(conn):
pytest.skip("annotation stage has not been run")
counts = index_db.annotation_counts(conn)
assert counts["labels"] > 800
# Every label gets exactly one component row, even when unresolved.
assert conn.execute(
"SELECT COUNT(*) FROM labels l"
" LEFT JOIN components c ON c.label_id = l.id WHERE c.label_id IS NULL"
).fetchone()[0] == 0
def test_every_label_references_a_known_part_and_page(conn):
if not _annotated(conn):
pytest.skip("annotation stage has not been run")
assert conn.execute(
"SELECT COUNT(*) FROM labels l"
" LEFT JOIN parts p ON p.part_no = l.part_no WHERE p.part_no IS NULL"
).fetchone()[0] == 0
assert conn.execute(
"SELECT COUNT(*) FROM labels l"
" LEFT JOIN pages g ON g.pdf_page = l.pdf_page WHERE g.pdf_page IS NULL"
).fetchone()[0] == 0
def test_boxes_lie_inside_their_diagram(conn):
if not _annotated(conn):
pytest.skip("annotation stage has not been run")
bad = conn.execute(
"""
SELECT COUNT(*) FROM components c
JOIN labels l ON l.id = c.label_id
JOIN pages p ON p.pdf_page = l.pdf_page
WHERE c.cx0 IS NOT NULL AND (
c.cx0 < 0 OR c.cy0 < 0 OR c.cx1 > p.img_w OR c.cy1 > p.img_h
OR c.cx1 <= c.cx0 OR c.cy1 <= c.cy0)
"""
).fetchone()[0]
assert bad == 0
def test_every_method_is_a_known_tier(conn):
if not _annotated(conn):
pytest.skip("annotation stage has not been run")
methods = set(index_db.method_counts(conn))
assert methods <= {"leader", "assembly", "capped", "nearest", "override", "none"}
def test_lookup_answers_part_to_page_box_method_confidence(conn):
"""The one query the runtime needs, with no OCR or image work repeated."""
if not _annotated(conn):
pytest.skip("annotation stage has not been run")
rows = index_db.lookup(conn, "30642")
assert rows, "30642 is a real part with a callout on page 34"
row = rows[0]
assert row["pdf_page"] == 34
assert row["section_code"] == "07"
assert row["method"] in {"leader", "assembly", "capped", "nearest", "override"}
assert row["cx0"] is not None and row["cx1"] > row["cx0"]
assert 0.0 <= row["confidence"] <= 1.0
assert Path(row["png_path"]).name == "p34.png"
# The whole point of the phase: the box is the worm gear, not the digits.
# A box may legitimately abut the callout it belongs to, so the test is that
# it is a different, much larger region centred elsewhere -- not that the two
# are disjoint.
label_box = (row["lx0"], row["ly0"], row["lx1"], row["ly1"])
comp_box = (row["cx0"], row["cy0"], row["cx1"], row["cy1"])
label_area = (label_box[2] - label_box[0]) * (label_box[3] - label_box[1])
comp_area = (comp_box[2] - comp_box[0]) * (comp_box[3] - comp_box[1])
assert comp_area > 4 * label_area
label_centre = ((label_box[0] + label_box[2]) / 2, (label_box[1] + label_box[3]) / 2)
comp_centre = ((comp_box[0] + comp_box[2]) / 2, (comp_box[1] + comp_box[3]) / 2)
assert not (
label_box[0] <= comp_centre[0] <= label_box[2]
and label_box[1] <= comp_centre[1] <= label_box[3]
), "component box is centred on the printed number"
assert abs(comp_centre[1] - label_centre[1]) > 50
def test_multi_page_part_returns_every_page(conn):
if not _annotated(conn):
pytest.skip("annotation stage has not been run")
# 73290 is listed on nine pages. Callouts exist on a subset of those, and
# also on page 44, where the part is drawn but absent from that page's table
# (PSD.md 4.10 records this happening). Such a callout is still valid -- it
# is snapped against the global part set -- but must be flagged.
rows = index_db.lookup(conn, "73290")
pages = {r["pdf_page"] for r in rows}
listed = {
r[0] for r in conn.execute(
"SELECT pdf_page FROM occurrences WHERE part_no = '73290'"
)
}
assert pages
for page in pages - listed:
flag = conn.execute(
"SELECT in_page_table FROM labels WHERE part_no = '73290' AND pdf_page = ?",
(page,),
).fetchone()[0]
assert flag == 0, f"page {page} is not in the table but was not flagged"
# Every page it points at is a real catalogue page.
catalogue = {r[0] for r in conn.execute("SELECT pdf_page FROM pages")}
assert pages <= catalogue
def test_normalized_view_is_resolution_independent(conn):
if not _annotated(conn):
pytest.skip("annotation stage has not been run")
row = conn.execute(
"SELECT * FROM normalized_boxes WHERE part_no = '30642' AND pdf_page = 34"
).fetchone()
assert row is not None
for field in ("label_x0", "label_y1", "comp_x0", "comp_y1"):
assert 0.0 <= row[field] <= 1.0
page = conn.execute("SELECT img_w, img_h FROM pages WHERE pdf_page = 34").fetchone()
native = conn.execute(
"SELECT c.cx0 FROM labels l JOIN components c ON c.label_id = l.id"
" WHERE l.part_no = '30642' AND l.pdf_page = 34"
).fetchone()[0]
assert abs(row["comp_x0"] * page["img_w"] - native) < 1.0
def test_reannotation_does_not_duplicate(conn):
if not _annotated(conn):
pytest.skip("annotation stage has not been run")
dupes = conn.execute(
"SELECT COUNT(*) FROM (SELECT 1 FROM labels"
" GROUP BY pdf_page, part_no, instance HAVING COUNT(*) > 1)"
).fetchone()[0]
assert dupes == 0
|