From bbfc647cff598cda5d82d1baee2b3d97b4b551e1 Mon Sep 17 00:00:00 2001 From: schneefux Date: Sat, 1 Apr 2017 12:42:23 +0200 Subject: calculate player.last_match_created_date --- worker.js | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'worker.js') diff --git a/worker.js b/worker.js index 6d05e24..79b385b 100644 --- a/worker.js +++ b/worker.js @@ -59,6 +59,27 @@ var RABBITMQ_URI = process.env.RABBITMQ_URI || "amqp://localhost", let player_api_id = player.api_id, player_ext = {}; + // set last_match_created_date + let lmcd = (await model.Participant.findOne({ + where: { + player_api_id: player_api_id + }, + attributes: [ [seq.col("roster.match.created_at"), "last_match_created_date"] ], + include: [ { + model: model.Roster, + attributes: [], + include: [ { + model: model.Match, + attributes: [] + } ] + } ], + order: [ + [seq.col("last_match_created_date"), "DESC"] + ] + })).get("last_match_created_date"); + await model.Player.update({ last_match_created_date: lmcd }, { where: { api_id: player_api_id } }); + + // calculate "extended" player_ext fields like wins per patch player_ext.player_api_id = player_api_id; //player_ext.series = "" -- cgit v1.3.1