Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-187

Split the observation_fact_demo_insert_data script into smaller scripts

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: 1.7.06
    • Fix Version/s: 1.7.07
    • Component/s: Data
    • Labels:
      None
    • Rank:
      0|i0024v:
    • i2b2 Sponsored Project/s:
      i2b2 Core
    • Affects Database/s:
      All databases
    • Developer Notes:
      Hide
      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.
      Show
      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:
      Hide
      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
      Show
      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

      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.

        Attachments

          Activity

            People

            • Assignee:
              jmd86 Janice Donahoe
              Reporter:
              jmd86 Janice Donahoe
              Participant/s:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Git Source Code