From 6ac4d07004c94cf73134580e7d104e514b17bf82 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Mon, 27 Feb 2017 18:40:33 +0100
Subject: allow writing web-web queries

---
 queries/player.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 queries/player.sql

(limited to 'queries/player.sql')

diff --git a/queries/player.sql b/queries/player.sql
new file mode 100644
index 0000000..e847de2
--- /dev/null
+++ b/queries/player.sql
@@ -0,0 +1,9 @@
+﻿-- count the number of matches we have from that player in the database
+-- UPDATE player SET "games_in_db"=
+SELECT
+COUNT(DISTINCT match."apiId") AS "games_in_db"
+FROM player
+JOIN participant ON player."apiId" = participant."player_apiId"
+JOIN roster ON participant."roster_apiId" = roster."apiId"
+JOIN match ON roster."match_apiId" = match."apiId"
+WHERE player.id=$1
-- 
cgit v1.3.1

