[Task]: Delete old WRF datasets

[adamscarberry]

Need to cleanup existing WRF datasets from Cumulus before new WRF is added/processed.

WRF-COLUMBIA AIRTEMP 1hr

acquirable_id = 552bf762-449f-4983-bbdc-9d89daada260 product_id = 793e285f-333b-41a3-b4ab-223a7a764668

WRF-COLUMBIA PRECIP 1hr

acquirable_id = ec926de8-6872-4d2b-b7ce-6002221babcd product_id = b50f29f4-547b-4371-9365-60d44eef412e

[adamscarberry]

deletion plan:

WRF-COLUMBIA AIRTEMP 1hr

-- delete from download_product delete from cumulus.download_product where product_id = '793e285f-333b-41a3-b4ab-223a7a764668';

-- delete acquirablefiles delete from cumulus.acquirablefile where acquirable_id = '552bf762-449f-4983-bbdc-9d89daada260';

-- delete acquirable delete from cumulus.acquirable where id = '552bf762-449f-4983-bbdc-9d89daada260';

-- delete productfiles delete from cumulus.productfile where product_id = '793e285f-333b-41a3-b4ab-223a7a764668';

-- delete product delete from cumulus.product where id = '793e285f-333b-41a3-b4ab-223a7a764668';

WRF-COLUMBIA PRECIP 1hr

-- delete from download_product delete from cumulus.download_product where product_id = 'b50f29f4-547b-4371-9365-60d44eef412e';

-- delete acquirablefiles delete from cumulus.acquirablefile where acquirable_id = 'ec926de8-6872-4d2b-b7ce-6002221babcd';

-- delete acquirable delete from cumulus.acquirable where id = 'ec926de8-6872-4d2b-b7ce-6002221babcd';

-- delete productfiles delete from cumulus.productfile where product_id = 'b50f29f4-547b-4371-9365-60d44eef412e';

-- delete product delete from cumulus.product where id = 'b50f29f4-547b-4371-9365-60d44eef412e';

[adamscarberry]

applied to:

• [x] develop
• [ ] stable

cc @jeffsuperglide