dcramer / peated

https://peated.com
Apache License 2.0
64 stars 13 forks source link

Disassociate reviews/prices without matching alias #215

Closed dcramer closed 3 months ago

dcramer commented 3 months ago

Some db cleanup that needs done.

dcramer commented 3 months ago

https://peated.com/bottles/42817/prices

dcramer commented 3 months ago
update store_price
set bottle_id = null
where exists (
    select from bottle_alias where lower(bottle_alias.name) = lower(store_price.name) and bottle_id is null
);