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

New web service to retrieve the db lookup settings in the configuration files

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Completed
    • None
    • 1.7.08
    • CRC Cell
    • None
    • i2b2 Core
    • PCORI
    • All databases
    • The 4 CRC DBlookup WS Msgs (getAllDblookups, setDblookup, getDblookup, and deleteDblookup) have been checked into GitHUB for 1.7.0.8, and are ready to be tested. Refer to the CRC_Messaging_1-7-0-8.docx
    • Hide
      While testing the new db lookup services I verified the following:

      1. The get_all_dblookups message returns all the appropriate data for each cell (individual lookups performed).
      2. The set_dblookups message enabled me to add a new entry into each of the DB_LOOKUP tables as well as edit existing entries.
      3. The get_dblookups message returned all the appropriate data for a single entry in the DB_LOOKUP tables.
      4. The delete_dblookups message allowed me to remove an entry from the DB_LOOKUP tables.


      These messages are specific to the cell, therefore when testing I ran each of the above services / messages against the following DB_LOOKUP tables:

      1. CRC_DB_LOOKUP
      2. FR_DB_LOOKUP
      3. IM_DB_LOOKUP
      4. ONT_DB_LOOKUP
      5. WORK_DB_LOOKUP
      Show
      While testing the new db lookup services I verified the following: 1. The get_all_dblookups message returns all the appropriate data for each cell (individual lookups performed). 2. The set_dblookups message enabled me to add a new entry into each of the DB_LOOKUP tables as well as edit existing entries. 3. The get_dblookups message returned all the appropriate data for a single entry in the DB_LOOKUP tables. 4. The delete_dblookups message allowed me to remove an entry from the DB_LOOKUP tables. These messages are specific to the cell, therefore when testing I ran each of the above services / messages against the following DB_LOOKUP tables: 1. CRC_DB_LOOKUP 2. FR_DB_LOOKUP 3. IM_DB_LOOKUP 4. ONT_DB_LOOKUP 5. WORK_DB_LOOKUP

    Description

      Develop a new web service to retrieve the db lookup settings from the cell's configuration files.

      Requirements: This service is only available to users who have "admin" privileges.

      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
          Affects Database/s All databases [ 10219 ]
          Fix Version/s 1.7.08 [ 10204 ]
          Assignee Wayne Chan [ waynec ]
          i2b2 Related Project/s PCORI [ 10201 ]
          i2b2 Sponsored Project/s i2b2 Core [ 10196 ]
          Status New [ 10000 ] Open [ 1 ]
          waynec Wayne Chan made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          waynec Wayne Chan made changes -
          Developer Notes The 4 CRC DBlookup WS Msgs (getAllDblookups, setDblookup, getDblookup, and deleteDblookup) have been checked into GitHUB for 1.7.0.8, and are ready to be tested. Refer to the CRC_Messaging_1-7-0-8.docx
          Assignee Wayne Chan [ waynec ] Janice Donahoe [ jmd86 ]
          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 Verified the DB_LOOKUP messages are returning the appropriate data for each cell.
          jmd86 Janice Donahoe made changes -
          Testing Notes Verified the DB_LOOKUP messages are returning the appropriate data for each cell. Verified the DB_LOOKUP messages are returning the appropriate data for each cell. The four new messages / services are:

          1. get_all_dblookups
          2. set_dblookup
          3. get_dblookup
          4. delete_dblookup
          jmd86 Janice Donahoe made changes -
          Testing Notes Verified the DB_LOOKUP messages are returning the appropriate data for each cell. The four new messages / services are:

          1. get_all_dblookups
          2. set_dblookup
          3. get_dblookup
          4. delete_dblookup
          		While testing the new db lookup services I verified the following:

          1. The get_all_dblookups message returns all the appropriate data for each cell (individual lookups performed).
          2. The set_dblookups message enabled me to add a new entry into each of the DB_LOOKUP tables as well as edit existing entries.
          3. The get_dblookups message returned all the appropriate data for a single entry in the DB_LOOKUP tables.
          4. The delete_dblookups message allowed me to remove an entry from the DB_LOOKUP tables.


          These messages are specific to the cell, therefore when testing I ran each of the above services / messages against the following DB_LOOKUP tables:

          1. CRC_DB_LOOKUP
          2. FR_DB_LOOKUP
          3. IM_DB_LOOKUP
          4. ONT_DB_LOOKUP
          5. WORK_DB_LOOKUP
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          jmd86 Janice Donahoe made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          jmd86 Janice Donahoe made changes -
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Resolution Completed [ 10000 ]
          Status Ready to Test [ 10001 ] Resolved [ 5 ]
          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: