Sun Microsystems / Rave QE

Databases Support Test Specification

Contents
Test Specification Identifier
       Features to be tested
       Approach Refinements
       Related documentation
       Test Identification
       Test Cases
Approvals
Revision History

Test Specification identifier
http://qa.netbeans.org/modules/webapps/promo-h/DBSupport.html


(F) Features to be tested

Features that will be Implemented and Tested for NetBeans 6.5 release

  • Tight integration with SQL editor
  • Code snippets for PHP queries
  • Various enhancements of SQL editor
  • Various enhancements of DB explorer

(A) Approach refinements

   This exercise would comprise of :
  • integration with source editor
  • PHP code snippets
  • various enhancements of DB explorer

  • (D) Related documentation.

    (T) Test Identification (Test Areas)


    Test Cases Detail/Procedure

    Code Completion in Source Editor

    Setup (e): 

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    source_editor_001
    Invoke popup menu with DB tables names
    1. Create project (for example PHP).
    2. Type in source editor "$sql = "SELECT".
    3. Choose the menu item "View DB Tables".
    3. A popup menu, similar to a code-completion menu, is displayed, showing all the tables available for the current connection.
    Will be implemented in the future
    source_editor_002 Matching of tables in DB tables list
    1. Create project (for example PHP).
    2. Type in source editor "$sql = "SELECT".
    3. Choose the menu item "View DB Tables".
    4. Type some letter.
    4. Only matching tables are shown.
    Will be implemented in the future
    source_editor_003 Show table fields
    1. Create project (for example PHP).
    2. Type in source editor "$sql = "SELECT".
    3. Choose the menu item "View DB Tables".
    4. Select table.
    5. Press the right-arrow key.
    5. The columns for the selected table are shown.
    Will be implemented in the future
    source_editor_004 Enter selected table and column in source ediotr
    1. Create project (for example PHP).
    2. Type in source editor "$sql = "SELECT".
    3. Choose the menu item "View DB Tables".
    4. Select table and press the right-arrow key.
    5. Select column and press Enter.
    5. Selected table and filed names are pasted at the point of the cursor (as "$sql = "SELECT PERSON.PERSONID").
    Will be implemented in the future


    Test Query

    Setup (e): 

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    test_query_001
    Test query with invalid parameters
    1. Create project (for example PHP).
    2. Compose a SQL query.
    3. Select the query string, including all newlines and substitution variables.
    4. Rightclicks and chooses "Test SQL".
    5. Specify invalid parameters and click "Test Query".
    4. Dialog to provide values for all substitution variables/parameters should appear.
    5. A new SQL Editor is brought up with the query text pasted in and the query is executed, showing error.

    Will be implemented in the future
    test_query_002 Test query with valid parameters 1. Create project (for example PHP).
    2. Compose a SQL query.
    3. Select the query string, including all newlines and substitution variables.
    4. Rightclicks and chooses "Test SQL".
    5. Specify valid parameters and click "Test Query".
    4. Dialog to provide values for all substitution variables/parameters should appear.
    5. A new SQL Editor is brought up with the query text pasted in and the query is executed, showing the results.

    Will be implemented in the future
    test_query_003 Test query and close SQL editor
    1. Create project (for example PHP).
    2. Compose a SQL query.
    3. Select the query string, including all newlines and substitution variables.
    4. Rightclicks and chooses "Test SQL".
    5. Specify valid parameters and click "Test Query".
    6. Close SQL editor.
    6. Nothing should be changed in source editor.

    Will be implemented in the future
    test_query_004 Decline changes in a query
    1. Create project (for example PHP).
    2. Compose a SQL query.
    3. Select the query string, including all newlines and substitution variables.
    4. Rightclicks and chooses "Test SQL".
    5. Specify valid parameters and click "Test Query".
    6. Change query and close SQL editor.
    7. In appeared dialog click "No".
    6. Confirmation dialog should appear.
    7. Nothing should be changed in source editor.

    Will be implemented in the future
    test_query_005 Accept changes in a query 1. Create project (for example PHP).
    2. Compose a SQL query.
    3. Select the query string, including all newlines and substitution variables.
    4. Rightclicks and chooses "Test SQL".
    5. Specify valid parameters and click "Test Query".
    6. Change query and close SQL editor.
    7. In appeared dialog click "Yes".
    6. Confirmation dialog should appear.
    7. Query should be changed in source editor.

    Will be implemented in the future


    Integration with PHP

    Setup (e): 

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    php_001
    Integration with PHP editor
    1. Create PHP project.
    2. Choose "Create SQL statement".
    3. Edit statement and click "Update PHP editor".
    2. SQL editor should be opened.
    3. The statement should be inserted in the PHP editor.

    Will be implemented in the future
    php_002
    "Connect to Database" PHP snippets
    1. Create PHP project.
    2. Invoke "Connect to Database" action.
    3. Specify necessary parameters and click "OK".
    2. "Connect to Database" dialog should appear.
    3. Code for connecting to database with specified parameters should be generated in PHP editor.


    php_003
    "Display Database Table" PHP snippet
    1. Create PHP project.
    2. Invoke "Display Database Table" action.
    3. Specify necessary parameters and click "OK".
    2. "Display Database Table" dialog should appear.
    3. Code for displaying the data as HTML table should be generated in PHP editor.


    php_004
    "Connect to Database" PHP snippets
    1. Create PHP project.
    2. Invoke "Connect to Database" action.
    3. Choose non MySQL connection.
    2. "Connect to Database" dialog should appear.
    3. Error message that only MySQL connections can be used appears at the bottom of the dialog..


    php_005
    "Connect to Database" PHP snippets
    1. Create PHP project.
    2. Rightclick in PHP code.
    2. Context menu should contain items for work with DB.


    php_006
    "Connect to Database" PHP snippets
    1. Create PHP project.
    2. Invoke "Connect to Database" action.
    3. Press "Cancel" button.
    3. Dialog should disappear.


    php_007
    "Connect to Database" PHP snippets
    1. Create PHP project.
    2. Invoke "Connect to Database" action.
    3. Choose connection and click "OK".
    4. Invoke "Connect to Database" action.
    5. Choose another connection and click "OK".
    3. Code for connecting to database with specified parameters should be generated in PHP editor.
    5. Code for connecting to database with specified parameters should be generated in PHP editor. But this code should contain name forthe connection as previous with next number.



    Various

    Setup (e): 

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    auto_incr_001
    Support of auto-incremented fields
    1. Open "Create Table" dialog.
    1. There should be checkbox to specify that field should be auto-incremented.

    Will be implemented in the future


    Approvals

    Reviewer Name & Title

    Date

    Status




    Revision History

    Author

    Date

    Revision

    Roman Mostyka

    June-29-2008

    First Draft

    Project Features

    About this Project

    QA was started in November 2009, is owned by Jiří Kovalský, and has 97 members.
    By use of this website, you agree to the NetBeans Policies and Terms of Use (revision 20160708.bf2ac18). © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo
     
     
    Close
    loading
    Please Confirm
    Close