Uploaded image for project: 'i2b2 Web Client'
  1. i2b2 Web Client
  2. WEBCLIENT-191

ADMIN: Add the ability to view DB_LOOKUP settings for each cell

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: None
    • Fix Version/s: 1.7.08
    • Component/s: None
    • Labels:
      None
    • i2b2 Sponsored Project/s:
      i2b2 Core, i2b2 Web Client
    • Affects Web Browser/s:
      All Web Browsers
    • Testing Notes:
      Hide
      TEST STATUS: Completed
      COMPLETION DATE: 08/16/2016

      ** This enhancement will be closed and issues found will be tracked in a separate JIRA issue.

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      TEST DATE: 08/09/2016
      TESTED BY: Janice Donahoe
      BUILD NUMBER: 1.7.08.0001
      TEST STATUS:


      CLIENTS TESTED:
           i2b2 Web Client

      ENVIRONMENTS TESTED:
           Browsers: Chrome, Firefox, Internet Explorer, and Safari
           Databases: Not applicable for this test
           Client OS: Windows and Macintosh


      TEST COMMENTS:
      Tested with the latest build (1.7.08.0001) and there are some issues that are being addressed in the JIRA issues listed in the ISSUES FOUND section.


      ISSUES FOUND:

      WEBCLIENT-194: Cancel button is no working.
      WEBCLIENT-195: Synchronize names that appear on the different db_lookup pages.

      Show
      TEST STATUS: Completed COMPLETION DATE: 08/16/2016 ** This enhancement will be closed and issues found will be tracked in a separate JIRA issue. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ TEST DATE: 08/09/2016 TESTED BY: Janice Donahoe BUILD NUMBER: 1.7.08.0001 TEST STATUS: CLIENTS TESTED:      i2b2 Web Client ENVIRONMENTS TESTED:      Browsers: Chrome, Firefox, Internet Explorer, and Safari      Databases: Not applicable for this test      Client OS: Windows and Macintosh TEST COMMENTS: Tested with the latest build (1.7.08.0001) and there are some issues that are being addressed in the JIRA issues listed in the ISSUES FOUND section. ISSUES FOUND: WEBCLIENT-194 : Cancel button is no working. WEBCLIENT-195 : Synchronize names that appear on the different db_lookup pages.

      Description

      Each cell in the i2b2 hive has a DB_LOOKUP table that contains the information it needs to connect to the appropriate database for that cell and project. Currently, there is no easy way to view or edit the information in these tables. This enhancement will allow administrators to view and edit the database settings defined for each cell.

      As part of this enhancement, 3 new pages have been created. These pages will contain the following fields:

      1. Name
      2. DB Schema
      3. JNDI Data Source
      4. DB Server
      5. Project Path
      6. Owner ID
      7. Tooltip
      8. Comment

      The fields on the pages are equivalent to the following columns in the DB_LOOKUP tables:

      1. Name = C_DB_NICENAME
      2. DB Schema = C_DB_FULLSCHEMA
      3. JNDI Data Source = C_DB_DATASOURCE
      4. DB Server = C_DB_SERVERTYPE
      5. Project Path = C_PROJECT_PATH
      6. Owner ID = C_OWNER_ID
      7. Tooltip = C_DB_TOOLTIP
      8. Comment = C_COMMENT


      3 New Pages and Expected Behavior

      1. DB Lookup List
           * This page displays the settings for all the databases setup for that cell.
           * This is a view only page. Information cannot be edited
           * Button: Add New DB Lookup
                   Behavior: displays the DB Lookup Add New page


      2. DB Lookup Add New
           * This page is used to add a new entry into the DB_LOOKUP table for that cell.
           * It is accessed by clicking on the Add New DBLookup button.
           * Button: Save
                   Behavior:
                                   - Saves the information into the appropriate DB_LOOKUP table.
                                   - Closes the page and returns to the DB Lookup List.
           * Button: Cancel
                    Behavior:
                                   - Does NOT save the information into the DB_LOOKUP table.
                                   - Closes the page and returns to the DB Lookup List.


      2. DB Lookup Details
           * This page displays the details for a single database connection.
           * The data on this page can be edited for all pages EXCEPT for the Project Path.
           * All edits will be saved to the appropriate db_lookup table.
           * Button: Save
                   Behavior:
                                   - Saves the edits into the appropriate DB_LOOKUP table.
                                   - Closes the page and returns to the DB Lookup List.
           * Button: Cancel
                    Behavior:
                                   - Does NOT save the information into the DB_LOOKUP table.
                                   - Closes the page and returns to the DB Lookup List.
           * Button: Delete
                    Behavior:
                                   - Clicking on it will display a new dialog window asking if your are sure you want to delete the DB Lookup.
                                                 ~ Cancel will close the dialog window and return to the DB Lookup Details page
                                                 ~ Ok will continue with the deletion process in which the database connection will be removed from the database lookup table
                                   - The page will close and return to the DB Lookup List page.

      WARNING: The Delete button will remove the database connection settings from the DB_LOOKUP table so you need to make sure you are deleting the correct one.
       

      New Services
      Several new services were developed in order to accommodate this new feature.

           * getALLDBLookup: retrieves all the database configurations for that cell
           * setDBLookup: saves new database entries into the appropriate DB_LOOKUP table
           * getDBLookup: retrieves the configuration of a single database connection
           * deleteDBLookup: deletes the database configuration from the appropriate DB_LOOKUP table

      Information about these new services can be found in CORE-218.

        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