Update coderd/database/queries/provisionerjobs.sql

kylecarbs · coadler · web-flow · commit f4d194b9aa1b · 2023-06-20T12:54:10.000-05:00
Co-authored-by: Colin Adler &lt;colin1adler@gmail.com&gt;
diff --git a/coderd/database/queries/provisionerjobs.sql b/coderd/database/queries/provisionerjobs.sql
@@ -59,23 +59,25 @@ WITH unstarted_jobs AS (
 queue_position AS (
     SELECT
         id,
-        ROW_NUMBER() OVER (ORDER BY created_at) AS queue_position
+        ROW_NUMBER() OVER (ORDER BY created_at ASC) AS queue_position
     FROM
         unstarted_jobs
 ),
 queue_size AS (
-		SELECT COUNT(*) as count FROM unstarted_jobs
+	SELECT COUNT(*) as count FROM unstarted_jobs
 )
 SELECT
-		sqlc.embed(pj),
+	sqlc.embed(pj),
     COALESCE(qp.queue_position, 0) AS queue_position,
     COALESCE(qs.count, 0) AS queue_size
 FROM
-    provisioner_jobs pj
+	provisioner_jobs pj
 LEFT JOIN
-    queue_position qp ON qp.id = pj.id
-LEFT JOIN queue_size qs ON TRUE
-WHERE pj.id = ANY(@ids :: uuid [ ]);
+	queue_position qp ON qp.id = pj.id
+LEFT JOIN
+	queue_size qs ON TRUE
+WHERE
+	pj.id = ANY(@ids :: uuid [ ]);
 
 -- name: GetProvisionerJobsCreatedAfter :many
 SELECT * FROM provisioner_jobs WHERE created_at > $1;
