diff options
| author | Frederick Muriuki Muriithi <fredmanglis@gmail.com> | 2026-11-11 17:14:45 +0000 |
|---|---|---|
| committer | Frederick Muriuki Muriithi <fredmanglis@gmail.com> | 2026-11-11 13:12:20 -0600 |
| commit | 1cb56e96f9d748ff7a18a5e845a246ff4ee53b41 (patch) | |
| tree | 908fee52ef724c752dffe838d7ce8458aab5dc39 /tests/unit | |
| parent | cf930d1335d894b468e8e0d8f600a50515ecee36 (diff) | |
| download | gn-libs-1cb56e96f9d748ff7a18a5e845a246ff4ee53b41.tar.gz | |
Index the jobs metadata by key and value
Add a `(metadata_key, metadata_value)` index to `jobs_metadata` so jobs can be looked up by their metadata without scanning the table. Co-authored-by: pi coding agent <pi@pi.dev>
Diffstat (limited to 'tests/unit')
| -rw-r--r-- | tests/unit/test_jobs.py | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/tests/unit/test_jobs.py b/tests/unit/test_jobs.py new file mode 100644 index 0000000..c949dcf --- /dev/null +++ b/tests/unit/test_jobs.py @@ -0,0 +1,37 @@ +"""Tests for background jobs storage helpers.""" +import time +import uuid + +import pytest + +from gn_libs import sqlite3 +from gn_libs.jobs import jobs +from gn_libs.jobs.migrations import run_migrations + + +@pytest.fixture() +def jobsdb(tmp_path): + """Create a migrated jobs database.""" + db = tmp_path / "jobs.db" + run_migrations(str(db)) + return db + + +def _job(conn, job_type, **metadata): + """Create a job with the given type and metadata.""" + return jobs.initialise_job( + conn, str(uuid.uuid4()), ["true"], job_type, extra_meta=metadata) + + +@pytest.mark.unit_test +def test_jobs_metadata_has_key_value_index(jobsdb): + """ + GIVEN: a migrated jobs database + WHEN: the schema is inspected + THEN: the metadata key/value index exists + """ + with sqlite3.connection(str(jobsdb)) as conn, sqlite3.cursor(conn) as cursor: + cursor.execute( + "SELECT name FROM sqlite_master WHERE type='index' " + "AND name='idx_tbl_jobs_metadata_cols_key_value'") + assert cursor.fetchone() is not None |
