[CORE-187] Split the observation_fact_demo_insert_data script into smaller scripts Created: 03/Sep/15 Updated: 25/Jan/16 Resolved: 07/Dec/15 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Data |
| Affects Version/s: | 1.7.06 |
| Fix Version/s: | 1.7.07 |
| Type: | Improvement | Priority: | Major |
| Reporter: | Janice Donahoe | Assignee: | Janice Donahoe |
| Resolution: | Completed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| i2b2 Sponsored Project/s: |
i2b2 Core
|
| Affects Database/s: |
All databases
|
| Developer Notes: | The observation_fact_demo_insert_data.sql script has been split into 7 smaller files. The names of these files are:
observation_fact_demo_affy_insert_data.sql observation_fact_demo_birn_insert_data.sql observation_fact_demo_demographics_insert_data.sql observation_fact_demo_diagnoses_insert_data.sql observation_fact_demo_labTests_insert_data.sql observation_fact_demo_medications_insert_data.sql observation_fact_demo_reports_insert_data.sql The above script changes were done for Oracle, PostgreSQL, and SQL Server. The build.xml file has been updated to run the new scripts when installing the data from the ant scripts. |
| Testing Notes: | TEST STATUS: Completed
COMPLETION DATE: 12/07/2015 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Test Date:12/07/2015 Test Status: Completed (Passed Testing) Clients Tested : Not applicable for this test Environments Tested : Browsers: Not applicable for this test Databases: Oracle, PostgreSQL, and SQL Server Client OS: Not applicable for this test Test Comments: Tested install scripts for Oracle, PostgreSQL and SQL Server ISSUES FOUND: No issues found |
| Participant/s: |
| Description |
|
Currently the observation_fact_demo_insert_data.sql script is getting too large, which make it difficult to maintain. Also when all the observations are in one file it doesn't allow for sites to easily choose the type of observations they want added to their observation_fact table in their demo database. For instance, if sites do not want to have any patient demographics in their observation_fact table they need to manually remove them from the script before running it.
SOLUTION: Split the one script into smaller more manageable scripts. |
| Comments |
| Comment by Janice Donahoe [ 25/Jan/16 ] |
|
On 01/22/2016, the 1.7.07 Release was made available at the following locations.
https://www.i2b2.org/software/ - zip files for release 1.7.07 are available on this site. This includes both the code and documentation. https://github.com/i2b2 - source code has been tagged with v1.7.07. |