diff options
| author | schneefux <schneefux+github@schneefux.xyz> | 2017-03-05 10:36:28 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-03-05 10:36:28 +0100 |
| commit | 259dc118f12083fb3040bf8407e903e02579fe57 (patch) | |
| tree | ca3b422d7a2e46c7b7f3e2cc806a0f3f305c14ac /queries/player/count_player_matches.sql | |
| parent | d6d94e86c7b44c99dd6974453ba27637e8fb7196 (diff) | |
| download | shrinker-259dc118f12083fb3040bf8407e903e02579fe57.tar.gz shrinker-259dc118f12083fb3040bf8407e903e02579fe57.zip | |
run jobs in batches (#7)
* run jobs in batches
* upsert player_stats
Diffstat (limited to 'queries/player/count_player_matches.sql')
| -rw-r--r-- | queries/player/count_player_matches.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/queries/player/count_player_matches.sql b/queries/player/count_player_matches.sql index fbdd283..226cacc 100644 --- a/queries/player/count_player_matches.sql +++ b/queries/player/count_player_matches.sql @@ -25,3 +25,5 @@ select ) INSERT INTO player_stats(player_api_id, patch_version, played, wins, casual_played, casual_wins, ranked_played, ranked_wins, streak) SELECT * FROM stats +ON CONFLICT(player_api_id) DO + UPDATE SET (player_api_id, patch_version, played, wins, casual_played, casual_wins, ranked_played, ranked_wins, streak) = (SELECT * FROM stats) |