fishbowl icon indicating copy to clipboard operation
fishbowl copied to clipboard

add constraint for turn_scorings, and use upsert

Open avimoondra opened this issue 4 years ago • 4 comments

Need to clear these out first, otherwise migration will fail in prod...

with counts as (select turn_id, card_id, count(1) as count from turn_scorings group by turn_id, card_id)
select * from counts where count > 1;

avimoondra avatar May 19 '20 21:05 avimoondra

related to #77

avimoondra avatar May 20 '20 05:05 avimoondra

with counts as (select turn_id, card_id, count(1) as count from turn_scorings group by turn_id, card_id)
select count(1) from counts where count > 1;

as of wed may 20, 10:46am PST - 609

avimoondra avatar May 20 '20 17:05 avimoondra