blob: a9c8cdce62b2ae4130a66bbd3f2fc6a9514608bf (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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"
|
