[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

Rank: 0|i0024v:
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.
Generated at Fri Jun 05 16:08:02 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.