[PR #69] [MERGED] Issue #67 #97

Closed
opened 2026-03-23 20:29:01 +00:00 by mirror · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/pull/69
Author: @pjlammertyn
Created: 6/3/2024
Status: Merged
Merged: 6/3/2024
Merged by: @pjlammertyn

Base: mainHead: issue-#67


📝 Commits (2)

📊 Changes

19 files changed (+144 additions, -515 deletions)

View changed files

📝 src/riab/etl/bigquery/cleanup.py (+6 -116)
src/riab/etl/bigquery/templates/cleanup/CONCEPT_ANCESTOR_remove_custom_concepts.sql.jinja (+0 -4)
src/riab/etl/bigquery/templates/cleanup/CONCEPT_ANCESTOR_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja (+0 -18)
src/riab/etl/bigquery/templates/cleanup/CONCEPT_RELATIONSHIP_remove_custom_concepts.sql.jinja (+0 -4)
src/riab/etl/bigquery/templates/cleanup/CONCEPT_RELATIONSHIP_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja (+0 -18)
📝 src/riab/etl/bigquery/templates/cleanup/SOURCE_ID_TO_OMOP_ID_MAP_remove_ids_by_omop_table.sql.jinja (+6 -1)
src/riab/etl/bigquery/templates/cleanup/VOCABULARY_remove_custom_concepts.sql.jinja (+0 -4)
src/riab/etl/bigquery/templates/cleanup/VOCABULARY_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja (+0 -11)
📝 src/riab/etl/bigquery/templates/cleanup/truncate.sql.jinja (+6 -1)
📝 src/riab/etl/cleanup.py (+106 -150)
📝 src/riab/etl/sql_server/cleanup.py (+8 -127)
src/riab/etl/sql_server/templates/cleanup/CONCEPT_ANCESTOR_remove_custom_concepts.sql.jinja (+0 -4)
src/riab/etl/sql_server/templates/cleanup/CONCEPT_ANCESTOR_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja (+0 -18)
src/riab/etl/sql_server/templates/cleanup/CONCEPT_RELATIONSHIP_remove_custom_concepts.sql.jinja (+0 -4)
src/riab/etl/sql_server/templates/cleanup/CONCEPT_RELATIONSHIP_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja (+0 -18)
📝 src/riab/etl/sql_server/templates/cleanup/SOURCE_ID_TO_OMOP_ID_MAP_remove_ids_by_omop_table.sql.jinja (+6 -1)
src/riab/etl/sql_server/templates/cleanup/VOCABULARY_remove_custom_concepts.sql.jinja (+0 -4)
src/riab/etl/sql_server/templates/cleanup/VOCABULARY_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja (+0 -11)
📝 src/riab/etl/sql_server/templates/cleanup/truncate.sql.jinja (+6 -1)

📄 Description

No description provided


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/pull/69 **Author:** [@pjlammertyn](https://github.com/pjlammertyn) **Created:** 6/3/2024 **Status:** ✅ Merged **Merged:** 6/3/2024 **Merged by:** [@pjlammertyn](https://github.com/pjlammertyn) **Base:** `main` ← **Head:** `issue-#67` --- ### 📝 Commits (2) - [`7cf0d45`](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/commit/7cf0d45c60e329e35fa726d27304fe75212c5b47) cleanup cascade of tables - [`4cd2fd7`](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/commit/4cd2fd7e012e5cb4d5c268dcec2a282371d01cd5) sped up cleanup ### 📊 Changes **19 files changed** (+144 additions, -515 deletions) <details> <summary>View changed files</summary> 📝 `src/riab/etl/bigquery/cleanup.py` (+6 -116) ➖ `src/riab/etl/bigquery/templates/cleanup/CONCEPT_ANCESTOR_remove_custom_concepts.sql.jinja` (+0 -4) ➖ `src/riab/etl/bigquery/templates/cleanup/CONCEPT_ANCESTOR_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja` (+0 -18) ➖ `src/riab/etl/bigquery/templates/cleanup/CONCEPT_RELATIONSHIP_remove_custom_concepts.sql.jinja` (+0 -4) ➖ `src/riab/etl/bigquery/templates/cleanup/CONCEPT_RELATIONSHIP_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja` (+0 -18) 📝 `src/riab/etl/bigquery/templates/cleanup/SOURCE_ID_TO_OMOP_ID_MAP_remove_ids_by_omop_table.sql.jinja` (+6 -1) ➖ `src/riab/etl/bigquery/templates/cleanup/VOCABULARY_remove_custom_concepts.sql.jinja` (+0 -4) ➖ `src/riab/etl/bigquery/templates/cleanup/VOCABULARY_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja` (+0 -11) 📝 `src/riab/etl/bigquery/templates/cleanup/truncate.sql.jinja` (+6 -1) 📝 `src/riab/etl/cleanup.py` (+106 -150) 📝 `src/riab/etl/sql_server/cleanup.py` (+8 -127) ➖ `src/riab/etl/sql_server/templates/cleanup/CONCEPT_ANCESTOR_remove_custom_concepts.sql.jinja` (+0 -4) ➖ `src/riab/etl/sql_server/templates/cleanup/CONCEPT_ANCESTOR_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja` (+0 -18) ➖ `src/riab/etl/sql_server/templates/cleanup/CONCEPT_RELATIONSHIP_remove_custom_concepts.sql.jinja` (+0 -4) ➖ `src/riab/etl/sql_server/templates/cleanup/CONCEPT_RELATIONSHIP_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja` (+0 -18) 📝 `src/riab/etl/sql_server/templates/cleanup/SOURCE_ID_TO_OMOP_ID_MAP_remove_ids_by_omop_table.sql.jinja` (+6 -1) ➖ `src/riab/etl/sql_server/templates/cleanup/VOCABULARY_remove_custom_concepts.sql.jinja` (+0 -4) ➖ `src/riab/etl/sql_server/templates/cleanup/VOCABULARY_remove_custom_concepts_by_{omop_table}__{concept_id_column}_usagi_table.sql.jinja` (+0 -11) 📝 `src/riab/etl/sql_server/templates/cleanup/truncate.sql.jinja` (+6 -1) </details> ### 📄 Description _No description provided_ --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
mirror 2026-03-23 20:29:01 +00:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
RADar-AZDelta/archived-Rabbit-in-a-Blender#97
No description provided.