def _test_never_checked_nothing():
value_store: Dict[str, Any] = {}
assert list(
postgres_stats._check_never_checked("", [], {}, value_store, NOW)) == [
Result(state=State.OK, summary="No never checked tables"),
]
assert value_store["item"] == NOW
def test_check_postgres_stats_empty_data():
item = "ANALYZE this"
assert list(
postgres_stats._check_postgres_stats(
item=item,
params={},
section={"this": []},
value_store={},
now=NOW,
)) == list(postgres_stats._check_never_checked("", [], {}, {}, NOW))
def test_check_postgres_stats_oldest_table():
item = "ANALYZE adwebconnect"
assert list(
postgres_stats._check_postgres_stats(
item=item,
params={},
section=SECTION,
value_store={},
now=NOW,
)) == [
Result(state=State.OK, summary="Table: serveraktion"),
Result(state=State.OK,
summary="Not analyzed for: 11 days 2 hours"),
] + list(
postgres_stats._check_never_checked(
"analyzed", ["anrede", "auftrag_mediadaten"], {}, {}, NOW))
def _test_never_checked_tables_warn():
value_store: Dict[str, Any] = {"item": NOW - 24.23 * 3600}
assert list(
postgres_stats._check_never_checked(
"loved",
list("AB"),
{"never_analyze_vacuum": (10, 25 * 3600)},
value_store,
NOW,
)) == [
Result(state=State.OK, summary="2 tables were never loved: A / B"),
Result(
state=State.WARN,
summary="Never loved tables for: 1 day 23 minutes",
),
]
assert value_store == {"item": NOW - 24.23 * 3600}
def _test_never_checked_tables_never_seen():
value_store: Dict[str, Any] = {}
assert list(
postgres_stats._check_never_checked(
"loved",
list("ABCDE"),
{},
value_store,
NOW,
)) == [
Result(
state=State.OK,
summary="5 tables were never loved: A / B / C (first 3 shown)",
details="5 tables were never loved: A / B / C / D / E",
),
]
assert value_store["item"] == NOW
