Testing Data Service Builder

Version 4

         TESTING SCENARIOS

     

    • User preferences

      • Teiid Connection settings
        • Verify setting invalid Administration User Name and Password fails Test Admin Connection
        • Verify setting correct Administration User Name and Password and Test Admin Connection works
        • Verify setting invalid JDBC User Name and Password fails Test JDBC Connection
        • Verify setting correct JDBC User Name and Password and Test JDBC Connection works
          • Do we want to add validation for any of these 4 text entry widgets?
            • BL: Not sure if we've added validation or not.  Probably a TBD item.
        • Select the ? context help button and verify the help page contains proper contents
        • Select Return
        • Verify changes by returning to preferences and checking edited values

     

    • Git Repo connections

      • Create new Git Repo (+ button)
        • Enter valid values for Name, Repository URL, Branch, Author Name/Email Adddress
          • Do we want to add validation for any of these 4 text entry widgets?
            • BL: Not sure if we've added validation or not.  Probably a TBD item.
          • Do we want to add a "Test Connection/URL" button to verify the GIT repo config exists?
            • BL: Not sure if we've added validation or not.  Probably a TBD item.
          • Click Save Button
            • Save button is probably needs a better icon.. looks like download
          • Enter separate invalid values for each text widget
      • Select existing GIT Repo and Delete via "-" button
        • Verify the repo entry is removed from the drop-down
      • Select the ? context help button and verify the help page contains proper contents
      • Select Return
      • Verify changes by returning to preferences and checking edited values

     

    • Configure, Edit, Delete Data Source and other actions

      • JDBC data sources only
      • Set filter properties (schema, table pattern, etc.)
      • deploy a simple dynamic VDB
      • view/show Teiid DDL for source
        • view tables and columns for source

     

      • Configure Data Source
        • Select a Connection and verify the Translator selector is displayed
        • Select a compatible translator type and verify the Filter Connection check-box and name/description widgets appear
        • Enter a data source name and verify the Save button enables and disabled if name is empty
          • Enter text for description
        • Click Save and verify that you return to the Data Sources page where your new data source will be displayed
        • Use Show Filter Options (optional test)
          • Check the Filter Connection option and verify that schema(s) show up in Schemas table
          • Select the desired Schema and verify Tables show up in Tables table.

     

      • Edit Existing Data Source
        • Click on link to show Data Sources page
        • Select a Data Source
        • Click Edit and verify the widget states are properly re-set for:
          • Data Source Name
          • Data Source Description
          • Connection
          • Translator type
          • Filter Condition check-box
          • Selected schema is preselected
        • Verify that name is READ-ONLY
        • Change connection, schema, filter condition etc...
          • Save and re-edit to verify changes are saved

     

      • Copy Existing Data Source
        • Select Data Source and click Copy
          • Enter unique name
          • Verify data source is added to summary page
          • Optionally select the copied data source and Edit to verify same properties

     

      • Display DDL for Data Source
        • Select Display DDL action from menu options
        • Verify Data Source Schema DDL is displayed
        • Click the X to close the DDL display panel

     

      • Download Data Source
        • Select Download action from menu options
          • Verify standard web-download dialog is displayed with Open with and Save file options;

     

      • Copy Data Source
        • Select Copy action from menu options
          • Enter unique name for copied data source and click Save
          • Verify copied data source information (name, connection, translator and description) are same as original data source
      • Delete Data Source
        • Delete and verify it is removed from Data Sources list

     

      • Filter and Sort Data Sources list
        • Requires multiple data sources defined
        • Enter various name filters.. A*, zyiopoauer, etc... and click Enter to engage the filters
          • Verify they perform desired filtering
        • Sort by Name and Description
        • Click A-Z sort button and verify it changes alphabetical ordering of data sources
        • Click "Clear all Filters" and verify all data sources displayed

     

    • New, Edit, Copy, Delete, Test, Export Data Service

        

      • Create/New Data Service Wizard
        • Single Source option
          • Click New button
            • verify Wizard tab is selected and Expert tab visible
            • Enter unique Name for data service and optionally a Description
            • Open a data source schema and select a table
              • verify the table is added to the Selected Tables widget
              • verify Include All Columns is checked
              • click Finish
                • verify the new data services is shown in summary
                • select this data service and Edit to verify values are restored
        • 2 Source tables option
          • Click New button
            • Enter unique Name for data service and optionally a Description
            • Open a data source schema and select 2 tables
              • verify the tables are added to the Selected Tables widget
              • verify Include All Columns is not in the panel
              • click Next
                • verify wizard shows columns for both selected tables
                • deselect 0 or more columns
                • verify that at least one column needs to be selected from each table or Next button disabled
                • verify Check All and Uncheck All buttons perform correctly for each table
                • Select Join Type
              • click Next
                • Specify zero or more Criteria by adding AND/OR Conditions
                  • For each condition, select left & right columns and condition operator
                  • repeat (optional)
              • click Finish
              • Verify the new data services is shown in the summary table
              • Edit the data service to verify values are restored

     

      • Edit Data Service
        • Single Table
          • select a single source data service and click Edit
          • verify data service Name is read-only
          • verify selected table in Data Sources list is selected and is displayed in Selected Tables box
          • verify Include All Columns check-box is checked
        • Two Tables
          • select a 2 table data service and click Edit
          • verify data service Name is read-only
          • verify 2 tables are displayed in Selected Tables boxes
          • verify Include All Columns check-box is not shown
          • click Next
          • verify check-box state is restored for columns from both tables
          • click Next
          • verify Join Criteria is restored to original settings
          • click Cancel
        • Expert DDL Editor
          • Click on Expert tab
            • verify DDL is displayed in text editor
            • verify correct source table(s) is displayed
            • (DDL editing validation and additional support not yet implemented...further testing will probably result in errors)

     

      • Copy Data Service
        • Select Copy action from menu options
          • Enter unique name for copied data service and click Save
          • Verify copied data service information contains the same as original data service
          • Verify copied DS can be Tested with same results as original

     

      • Documentation for Data Services
        • Select Documentation action from menu options
          • Verify Documentation for "<myDataService>" is opened
          • click on Connecting and Client Code Examples
            • Verify text and examples are updated to reflect any info generated by the specific data service information
            • Java example, for instance, should contain a "url = jdbc:teiid:<dataservicename>VDB@mm://xxxxxxxxx:31000;version=1" variable

     

      • Download Data Service
        • Select Download action from menu options
          • Verify standard web-download dialog is displayed with Open with and Save file options
          • Current format for the data service is a ZIP file containing the data service vdb.xml file

     

      • Git Export of Data Service
        • Select Git Export action from menu options
          • Select previously defined GIT configuration
            • Enter required information including passwords
          • Click Next
          • Click Export
            • Verify OK is displayed
          • Click Finish
          • Verify data service was exported to your actual GIT repo

     

      • Filter and Sort Data Services list
        • Requires multiple data services defined
        • Enter various name filters.. A*, zyiopoauer, etc... and click Enter to engage the filters
          • Verify they perform desired filtering
        • Sort by Name and Description
        • Click A-Z sort button and verify it changes alphabetical ordering of data services
        • Click "Clear all Filters" and verify all data services displayed

     

    • Test data service

      • OData query builder
        • select Test button on data service
        • verify OData tab is selected and SQL tab is visible
        • verify field level help exists for widgets (hover over blue "i" icon)
        • Tabular results
          • execute queries by clicking Submit
          • verify setting count/limit value works
            • select count only and verify # rows result
            • select top 10 and verify 10 rows returned
          • verify de-slecting column returns the selected column data only
          • define a where clause and verify results are correctly filtered
          • select Order by options and verify results are correct
        • Raw (JSON) results
          • select the Raw tab and verify JSON results are displayed for a given OData query

     

      • SQL query builder
        • Tabular results
          • select SQL tab
          • verify default SQL query is generated and visible (i.e. SELECT * FROM views.PartsDataView;)
          • click Submit

     

    • Help

      • Note that help content for all pages will start to be added once the UI layout changes have settled down/stablized
      • Field level help
        • combination of tooltips and clickable info icons
      • Context sensitive help
        • hideable Help panel sensitive to focused UI panel/widget and selection
      • Internationalization...