build.py: prefer older buildrequests
authorHelmut Grohne <helmut@subdivi.de>
Sat, 23 Mar 2019 11:48:09 +0000 (12:48 +0100)
committerHelmut Grohne <helmut@subdivi.de>
Sat, 23 Mar 2019 11:48:09 +0000 (12:48 +0100)
build.py

index 8e1d763..d83686c 100755 (executable)
--- a/build.py
+++ b/build.py
@@ -54,7 +54,7 @@ def main():
                     JOIN depcheck
                         ON d.architecture = depcheck.architecture
                 WHERE d.satisfiable = 1 AND depcheck.giveback = 0
-                ORDER BY r.priority DESC, random() LIMIT 1;""")
+                ORDER BY r.priority DESC, r.requesttime ASC LIMIT 1;""")
         row = cur.fetchone()
         if not row:
             cur.execute("""