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

          • Type: New Feature
          • Status: Closed
          • Priority: Major
          • Resolution: Completed
          • Affects Version/s: None
          • Fix Version/s: 1.7.08
          • Component/s: CRC Cell
          • Labels:
            None
          • Rank:
            0|i002x3:
          • i2b2 Sponsored Project/s:
            i2b2 Core
          • i2b2 Related Project/s:
            PCORI
          • Affects Database/s:
            All databases
          • 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
          • Testing Notes:
            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

                  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