search

bowanddrape / couture

https://couture.bowanddrape.com
0 stars 0 forks source link

de-dupe olde haute orders #170

Closed graphicsforge closed 6 years ago

graphicsforge commented 6 years ago

Some old haute orders are showing up multiple times in the new system, find and purge these

graphicsforge commented 6 years ago

ran

DELETE from shipments where id in (SELECT CAST(id as uuid) from (select json_agg(id)#>>'{0}' AS id, count(1) as count, props#>>'{legacy_id}' as legacy_id from shipments where props#>>'{legacy_id}' is not null group by legacy_id) legacy where count>1);

a bunch of times