10/10: Sort the pending builds by timestamp

[Christopher Baines]

cbaines pushed a commit to branch master
in repository data-service.

commit 63fc1917f89453c1072cb6972d4c512b9fc1391b
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Wed Oct 21 20:49:58 2020 +0100

    Sort the pending builds by timestamp
    
    So that builds that have been pending for a longer time are fetched first.
---
 guix-data-service/builds.scm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/guix-data-service/builds.scm b/guix-data-service/builds.scm
index 4afd362..4f2e5ed 100644
--- a/guix-data-service/builds.scm
+++ b/guix-data-service/builds.scm
@@ -493,7 +493,8 @@ WHERE builds.build_server_id = $1 AND
       latest_build_status.status IN (
         'scheduled', 'started'
       )
-ORDER BY latest_build_status.status DESC -- 'started' first
+ORDER BY latest_build_status.status DESC, -- 'started' first
+         latest_build_status.timestamp ASC
 LIMIT 10000")
 
   (map