From 42d06bc2da87f2c7805c2e693dde9a90ca5476e1 Mon Sep 17 00:00:00 2001 From: schneefux Date: Tue, 21 Mar 2017 18:06:06 +0100 Subject: don't insert new grab jobs until compiler is done --- api.js | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'api.js') 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) { -- cgit v1.3.1