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

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Completed
    • 1.7.06
    • 1.7.07
    • Data
    • None
    • i2b2 Core
    • All databases
    • 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.
    • 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

          Ascending order - Click to sort in descending order
          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Fix Version/s 1.7.07 [ 10201 ]
          Assignee Janice Donahoe [ jmd86 ]
          i2b2 Sponsored Project/s i2b2 Core [ 10196 ]
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jmd86 Janice Donahoe made changes -
          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.
          Status In Progress [ 3 ] In Progress [ 3 ]
          jmd86 Janice Donahoe made changes -
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          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
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Completed [ 10000 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe added a comment - - edited
          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.
          jmd86 Janice Donahoe added a comment - - edited 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.
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: