From f96085e5b3ec8931cf6eb06c4b1dae3b82967340 Mon Sep 17 00:00:00 2001
From: Kapil Viren Ahuja <k.v.ahuja@gmail.com>
Date: Tue, 21 Feb 2017 14:09:09 +0530
Subject: reference queries for updating roster with match's FK

---
 ref_queries/update_roster_match_relationship.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 ref_queries/update_roster_match_relationship.sql

(limited to 'ref_queries/update_roster_match_relationship.sql')

diff --git a/ref_queries/update_roster_match_relationship.sql b/ref_queries/update_roster_match_relationship.sql
new file mode 100644
index 0000000..a9c8cdc
--- /dev/null
+++ b/ref_queries/update_roster_match_relationship.sql
@@ -0,0 +1,21 @@
+-- i am thinking how fast slow this will be and if we should do this in DB.
+-- maybe we need a script to run a cursor and update records - dont know...
+-- a few runs on 35K records was closing my server connection on my shitty laptop
+
+-- this will update all roster with match_apiId
+update "roster" 
+set "match_apiId" = match."apiId"
+from match
+where (roster."apiId" = roster_1 or roster."apiId" = roster_2)
+
+
+-- this is same as before however should only pick empty records
+update "roster" 
+set "match_apiId" = match."apiId"
+from match
+where roster."match_apiId" is not null and (roster."apiId" = roster_1 or roster."apiId" = roster_2)
+
+
+
+-- this should always return a count of 2 for each match_apiId :)
+select "match_apiId", count(*) from roster group by "match_apiId"
-- 
cgit v1.3.1

