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...