diff options
| author | Frederick Muriuki Muriithi | 2026-01-08 10:58:56 -0600 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2026-01-08 10:58:56 -0600 |
| commit | 7b12d6f0180fb8e807f2854689abf5fa682e5a1e (patch) | |
| tree | ef33f3a553b1a88847cd44937747c11020106f7a | |
| parent | 0c1a27ec9d27cf2fefe47386ddf39d23a50f3628 (diff) | |
| download | gn-libs-7b12d6f0180fb8e807f2854689abf5fa682e5a1e.tar.gz | |
Order user jobs from newest to oldest.
| -rw-r--r-- | gn_libs/jobs/jobs.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/gn_libs/jobs/jobs.py b/gn_libs/jobs/jobs.py index 1ef6c0c..cee6e7e 100644 --- a/gn_libs/jobs/jobs.py +++ b/gn_libs/jobs/jobs.py @@ -66,7 +66,8 @@ def jobs_by_external_id(conn: DbConnection, external_id: Union[str, uuid.UUID]) cursor.execute( "SELECT jeids.external_id, jobs.* FROM jobs_external_ids AS jeids " "INNER JOIN jobs ON jeids.job_id=jobs.job_id " - "WHERE jeids.external_id=?", + "WHERE jeids.external_id=? " + "ORDER BY jobs.created DESC", (str(external_id),)) _jobs = {row["job_id"]: {**dict(row), "metadata": {}} for row in cursor.fetchall()} _jobs_ids = tuple(_job["job_id"] for _job in _jobs.values()) |