diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-02-28 18:01:50 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-02-28 18:01:50 +0100 |
| commit | c1f3ee04077420be4ac016d9fc8af9f1ccc8d787 (patch) | |
| tree | b82c40806871eaaeac06d268ab994550e1309711 /queries | |
| parent | 7d34e23ecda9c1bdb5f822d90142d51cf81c0681 (diff) | |
| download | compiler-c1f3ee04077420be4ac016d9fc8af9f1ccc8d787.tar.gz compiler-c1f3ee04077420be4ac016d9fc8af9f1ccc8d787.zip | |
support split queries
Diffstat (limited to 'queries')
| -rw-r--r-- | queries/player.sql | 9 |
1 files changed, 0 insertions, 9 deletions
diff --git a/queries/player.sql b/queries/player.sql deleted file mode 100644 index e847de2..0000000 --- a/queries/player.sql +++ /dev/null @@ -1,9 +0,0 @@ --- 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 |