[PR #56] [MERGED] Issue #55: Speed up import of vocabularies on SQL Server #90

New issue

Closed

opened 2026-03-23 20:28:59 +00:00 by mirror · 0 comments

mirror commented

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

Owner

📋 Pull Request Information

Original PR: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/pull/56
Author: @pjlammertyn
Created: 4/25/2024
Status: ✅ Merged
Merged: 4/25/2024
Merged by: @pjlammertyn

Base: main ← Head: issue-#55

📝 Commits (2)

52df56d sorting the vocabulary CSV's befor importing speeds up the import process more than twice
70a97b1 solved regex error in DDL for SQL Server

📊 Changes

7 files changed (+116 additions, -27 deletions)

View changed files

📝 src/riab/etl/import_vocabularies.py (+24 -9)
📝 src/riab/etl/sql_server/import_vocabularies.py (+4 -8)
📝 src/riab/etl/sql_server/templates/ddl/OMOPCDM_sql_server_5.4_ddl.sql.jinja (+78 -0)
📝 src/riab/etl/sql_server/templates/ddl/result_table_ddl_concept.sql.jinja (+3 -3)
📝 src/riab/etl/sql_server/templates/ddl/result_table_ddl_field.sql.jinja (+3 -3)
📝 src/riab/etl/sql_server/templates/ddl/result_table_ddl_table.sql.jinja (+3 -3)
📝 tasks/generate_queries.py (+1 -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/56 **Author:** [@pjlammertyn](https://github.com/pjlammertyn) **Created:** 4/25/2024 **Status:** ✅ Merged **Merged:** 4/25/2024 **Merged by:** [@pjlammertyn](https://github.com/pjlammertyn) **Base:** `main` ← **Head:** `issue-#55` --- ### 📝 Commits (2) - [`52df56d`](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/commit/52df56da05c80f786b749b08bb3c9b5ead69b982) sorting the vocabulary CSV's befor importing speeds up the import process more than twice - [`70a97b1`](https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/commit/70a97b1c050ee4517efe5f47302824aac05dd22f) solved regex error in DDL for SQL Server ### 📊 Changes **7 files changed** (+116 additions, -27 deletions) <details> <summary>View changed files</summary> 📝 `src/riab/etl/import_vocabularies.py` (+24 -9) 📝 `src/riab/etl/sql_server/import_vocabularies.py` (+4 -8) 📝 `src/riab/etl/sql_server/templates/ddl/OMOPCDM_sql_server_5.4_ddl.sql.jinja` (+78 -0) 📝 `src/riab/etl/sql_server/templates/ddl/result_table_ddl_concept.sql.jinja` (+3 -3) 📝 `src/riab/etl/sql_server/templates/ddl/result_table_ddl_field.sql.jinja` (+3 -3) 📝 `src/riab/etl/sql_server/templates/ddl/result_table_ddl_table.sql.jinja` (+3 -3) 📝 `tasks/generate_queries.py` (+1 -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>