[GH-ISSUE #67] Running the --cleanup on one table, should also cleanup the dependent tables in the ETL flow. #38

New issue

Closed

opened 2026-03-23 20:28:40 +00:00 by mirror · 1 comment

mirror commented

2026-03-23 20:28:40 +00:00

Owner

Originally created by @pjlammertyn on GitHub (May 23, 2024).
Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/67

Originally assigned to: @pjlammertyn on GitHub.

Because the --cleanup command triggers the generation of new auto numbered id's (in the next ETL run), the foreign keys of the dependent tables will have invalid wring foreign keys to that table.

So all the dependent tables should also be cleared!

Originally created by @pjlammertyn on GitHub (May 23, 2024). Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/67 Originally assigned to: @pjlammertyn on GitHub. Because the *--cleanup* command triggers the generation of new auto numbered id's (in the next ETL run), the foreign keys of the dependent tables will have invalid wring foreign keys to that table. So all the dependent tables should also be cleared!

mirror

2026-03-23 20:28:40 +00:00

closed this issue
added the
enhancement
label

mirror commented

2026-03-23 20:28:41 +00:00

Author

Owner

@pjlammertyn commented on GitHub (May 30, 2024):

For example if you cleanup the person table.

riab --cleanup person

All dependent tables in the ETL flow, must also be cleaned up!

└──person
  ├──condition_era
  ├──death
  ├──dose_era
  ├──drug_era
  ├──episode
  ├──observation_period
  ├──payer_plan_period
  ├──specimen
  └──visit_occurrence
    ├──episode_event
    └──visit_detail
      ├──condition_occurrence
      ├──device_exposure
      ├──drug_exposure
      ├──measurement
      ├──note
      ├──observation
      └──procedure_occurrence
        └──note_nlp

@pjlammertyn commented on GitHub (May 30, 2024): For example if you cleanup the **person** table. ```bash riab --cleanup person ``` All dependent tables in the ETL flow, must also be cleaned up! ``` └──person ├──condition_era ├──death ├──dose_era ├──drug_era ├──episode ├──observation_period ├──payer_plan_period ├──specimen └──visit_occurrence ├──episode_event └──visit_detail ├──condition_occurrence ├──device_exposure ├──drug_exposure ├──measurement ├──note ├──observation └──procedure_occurrence └──note_nlp ```