don't insert new grab jobs until compiler is done

1 files changed, 6 insertions, 1 deletions

diff --git a/api.js b/api.js
index d81160a..48207bf 100644
--- a/api.js
+++ b/api.js
@@ -143,7 +143,12 @@ app.get("/api/player/:name", async (req, res) => {
 
     var job = await raw.query(`
         UPDATE jobs SET priority=0
-        WHERE payload=$1 AND status<>'finished'
+        WHERE
+        (
+            (type='grab' AND payload=$1) OR
+            (type='process' AND payload->>'playername'=$1->'params'->>'filter[playerNames]') OR
+            (type='compile' AND payload->>'type'='player' AND payload->>'id'=$1->'params'->>'filter[playerIds]')
+        ) AND status<>'finished' AND status<>'failed'
         RETURNING id
     `, [payload]);
     if (job.rows.length == 0) {