search

ices-eg / WK_RDBES

3 stars 6 forks source link

Make function to filter rdbesRawObject by arbitrary fields. #94

Closed davidcurrie2001 closed 2 years ago

davidcurrie2001 commented 2 years ago

Make function to filter rdbesRawObject by arbitrary fields. After filtering any orphan rows should also be removed e.g. if you remove some SA rows, then any child SA rows, FM rows, or BV rows connected to the removed rows should also be removed.

davidcurrie2001 commented 2 years ago

Created filterRDBESRawObject() function and tests. Now need to remove any orphan records that are created due to the filtering.

davidcurrie2001 commented 2 years ago

The function findAndKillOrphans() removes any orphan records. The function removeBrokenVesselLinks() removes any records not correctly linked to a row in the VD table.

davidcurrie2001 commented 2 years ago

removeBrokenSpeciesListLinks() function and tests added