cornercorner
FeaturesPluginsDocs & SupportCommunityPartners

Sun Microsystems / Rave QE

SQL Editor 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/SQLEditor.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 SQL
  • Solid code completion in SQL editor
  • History in SQL editor
  • Various enhancements of SQL editor

(A) Approach refinements

   This exercise would comprise of :
  • various enhancements of SQL editor

    • (D) Related documentation.

    (T) Test Identification (Test Areas)


    Test Cases Detail/Procedure

    Code Completion

    Setup (e): 

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    code_compl_001
    		 SQL keywords
    		 1. Open SQL editor.
    2. Invoke code completion.
    		 2. SELECT, INSERT, UPDATE, DELETE keyword should be in the list
    		Will be implemented in the future
    code_compl_002 Complete SQL keyword
    		 1. Open SQL editor.
    2. Type 'S'.
    3. Invoke code completion.     		3. SELECT keyword should be in the list. Repeat also for INSERT, UPDATE, DELETE.
    		Will be implemented in the future
    code_compl_003 Complete DB scheme name
    		 1. Open SQL editor.
    2. Type 'SELECT '.
    3. Invoke code completion.     		3. Names of schemes should appear in the code completion list.

    code_compl_004 Complete DB table name 1. Open SQL editor.
    2. Type 'SELECT $SCHEME', where $SCHEME is a real scheme name.
    3. Invoke code completion.     		3. Names of tables in specified scheme should appear in the code completion list.

    code_compl_005 Complete DB field name 1. Open SQL editor.
    2. Type 'SELECT $SCHEME.$TABLE', where $SCHEME and $TABLE are real names of scheme and table.
    3. Invoke code completion.     		3. Names of fields in specified scheme and table should appear in the code completion list.

    code_compl_006 Complete table alias
    		 1. Open SQL editor.
    2. Type 'SELECT  FROM $SCHEME.$TABLE tbl', where $SCHEME and $TABLE are real names of scheme and table.
    3. Place cursor between keywords SELECT and FROM and invoke code completion.     		3. Alias tbl should be available in the list.

    code_compl_007 Order in CC list
    		 1. Open SQL editor.
    2. Type 'SELECT  FROM $SCHEME.$TABLE tbl', where $SCHEME and $TABLE are real names of scheme and table.
    3. Place cursor between keywords SELECT and FROM and invoke code completion.     		3. In code completion fields should have following order: schema names, aliases, table names, field names.

    code_compl_008 Complete table alias after GROUP BY 1. Open SQL editor.
    2. Type 'SELECT  FROM $SCHEME.$TABLE tbl GROUP BY 1', where $SCHEME and $TABLE are real names of scheme and table.
    3. Place cursor between keywords SELECT and FROM and invoke code completion.     		3.Alias tbl should be available in the list.

    code_compl_009 Complete table alias used twice 1. Open SQL editor.
    2. Type 'SELECT * FROM $SCHEME.$TABLE tbl WHERE tbl.$FIELD=$VALUE and ', where $SCHEME, $TABLE and $FIELD are real names of scheme, table and field and $VALUE is valid value.
    3. Invoke code completion.     		3.Alias tbl should be available in the list for next clause.

    code_compl_010 Complete after quoting 1. Open SQL editor.
    2. Type 'SELECT  FROM $SCHEME.$TABLE tbl GROUP BY 1', where $SCHEME and $TABLE are real names of scheme and table.
    3. Place cursor between keywords SELECT and FROM, type ' " ' and invoke code completion.     		3.CC list should contain available data after quoting.

    code_compl_011 No suggestions
    		 1. Connect to "travel" and open SQL editor.
    2. Type "SELECT * FROM PERSON "and press Ctrl+Space.
    		 2.CC list should contain only message "No suggestions".

    code_compl_012 Cancel code completion 1. Connect to "travel" and open SQL editor.
    2. Type "SELECT * FROM "and press Ctrl+Space.
    3. Press Esc button.
    		 2.CC list should disappear.


    SQL History

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    history_001

    		 Add SQL statement
    		 1. Open an SQL editor.
    2. Enter and execute SQL statements.
    3. Open SQL History dialog.
    		 3. Executed statement should be there.

    history_003

    		 Add more than 100 SQL statements to SQL History with default limit
    		 1. Open SQL editor.
    2. Enter SQL and execute.
    3. Repeat step 2 100 times and open SQL History.
    		 3. All SQL are added to SQL History.

    history_004

    		 Add more than 100 SQL statements to SQL History with changed limit 1. Open SQL editor
    2. Enter SQL and execute
    3. Set in Options limit of SQL statements in SQL History to 150 and press Apply.
    5. Repeat step 2 100 times.     		5. All SQL are added to SQL History.

    history_005

    		 Add more than 100 SQL statements to SQL History with changed limit 1. Open SQL editor
    2. Enter SQL and execute
    3. Set in Options limit of SQL statements in SQL History to 50 and press Apply.
    5. Repeat step 2 100 times.     		5. Only 50 SQL are added to SQL History.

    history_006

    		 Insert statement from the history
    		 1. Open SQL editor open
    2. In the History pane select a statement and click the Insert button.
    		 2.The selected statement from History is added to the SQL editor at the cursor location.

    history_007 View Data
    		 1. In Services, for a connection, expand the connection node.
    2. Select a Table and choose View Data.
    		 2. "SELECT * FROM Table" should appear in SQL History.

    history_008

    		 Create Table
    		 1. In Services, for a connection, expand the connection node.
    2. Rightclick the connection and choose "Create Table", specify necessary parameters and click "OK".
    		 2. No change to History.

    history_009

    		 Delete Table
    		 1. In Services, for a connection, expand the connection node.
    2. Rightclick the connection and choose "Create Table", specify necessary parameters and click "OK".
    3. Rightclick added table and choose "Delete".
    		 3. No change to History.

    history_010

    		 Sort by date
    		 1. Open an SQL editor.
    2. Execute several SQL statements.
    3. Open SQL History dialog.
    4. Click header of Date column
    		 4. All statements are sorted by date.

    history_011

    		 Sort by statement
    		 1. Open an SQL editor.
    2. Execute several SQL statements.
    3. Open SQL History dialog.
    4. Click header of SQL column
    		 4. All statements are sorted by SQL.

    history_012

    		 Show SQL for chosen connection
    		 1. Open an SQL editor.
    2. Execute several SQL statements against several DBs.
    3. Open SQL History dialog.
    4. Choose particular connection.
    		 4. Statements only for this connection should be dispalyed.

    history_013

    		 Show matched SQL
    		 1. Open an SQL editor.
    2. Execute several SQL statements against several DBs.
    3. Open SQL History dialog.
    4. Write something for matching in Match Box.
    		 4. Only matched statements should be dispalyed.

    history_014

    		 Show matched SQL for chosen connection 1. Open an SQL editor.
    2. Execute several SQL statements against several DBs.
    3. Open SQL History dialog.
    4. Choose particular connection and write something for matching in Match Box.
    		 4. Only matched statements for chosen connection should be dispalyed.

    history_015

    		 Reset of matchbox 1. Open an SQL editor.
    2. Execute several SQL statements against several DBs.
    3. Open SQL History dialog.
    4. Write something for matching in Match Box.
    5. Choose particular connection.
    		 4. Only matched statements should be dispalyed.
    5. Matchbox should be reseted.

    history_016

    		 Close 1. Open an SQL editor.
    2. Execute several SQL statements against several DBs.
    3. Open SQL History dialog.
    4. Press "Close" button.
    		 4. "SQL History" dialog should disappear.

    history_017

    		 Help 1. Open an SQL editor.
    2. Execute several SQL statements against several DBs.
    3. Open SQL History dialog.
    4. Press "Help" button.
    		 4. "SQL History" dialog should disappear.

    history_018

    		 Insert statement from the history by double-click
    		 1. Open SQL editor open
    2. In the History pane and double-click some statement.
    		 2.The clicked statement from History is added to the SQL editor at the cursor location.


    Snippets

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    snippet_001
    		 Save SQL snippet
    		 1. Open SQL editor.
    2. Type some query.
    3. Save it as snippet.     		3. SQL code should be saved as snippet
    		Will be implemented in the future
    snippet_002 Add SQL snippet 1. Open SQL editor.
    2. Type some query.
    3. Save it as snippet.
    4. Add saved snippet to the SQL editor
    		 4. Snippet should be added to the editor.
    		Will be implemented in the future

    Various

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    basic_action_001
    		 Run statement
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.     		1. Statement should be executed and results for this statement should be shown.

    basic_action_002
    		 Run selection
    		 1. Open SQL editor.
    2. Type some query and select only some part of it (better which also presents valid statement).
    3. Run it.     		1. Selected statement should be executed and results for this statement should be shown.

    basic_action_003
    		 Select in Services
    		 1. Open SQL editor.
    2. Type some query.
    3. Select it, rightclick and choose "Select In > Services".     		1. Services window should be opened and connection for the selected statement should be selected.
    		Redundant action
    records_number_001
    		 Display number of returned records/impacted rows 1. Open SQL editor.
    2. Type some query.
    3. Run it.     		3. Number of returned records and pages should be displayed.

    show_info_001
    		 Quick view of table info
    		 1. Rightclicking database table and choose "Properties". 1. Information about tables should be displayed.

    show_info_002 Quick view of column info
    		 1. Place cursor above column header and wait some time.
    		 1. Information about columns in the table should be displayed.

    sort_001
    		 Ability to sort results based on column
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Click header of some column.
    		 4. Data should be sorted by this column.

    set_size_001
    		 Ability to set page size
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Change value for "Page Size" field from 20 to 10 and press Enter.
    		 4. Data should be displayed 10 records per page.

    work_DB_001
    		 Insert new valid record
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Press "Insert Record" button, specify necessary values and click OK.
    		 4. New row should be added.

    work_DB_002
    		 Insert new invalid record
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Press "Insert Record" button, specify invalid values and click OK.
    		 4. Error message should appear in the bottom of dialog and new row shouldn't be added.

    work_DB_003
    		 Cancel insert new record
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Press "Insert Record" button and press "Cancel" button.
    		 4. New row should be added.

    work_DB_004
    		 Show script for inserting of a new record
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Press "Insert Record" button, specify valid values and click "Show SQL".
    		 4. SQL Script for insert specified data should be shown.

    work_DB_005
    		 Show script for inserting of a invalid record
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Press "Insert Record" button, specify invalid values and click "Show SQL".
    		 4. Error message should appear in the bottom of dialog.

    work_DB_006
    		 Show script for inserting of a invalid record
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Press "Insert Record" button, specify values and click "Clear".
    		 4. All fields should be cleared.

    work_DB_007
    		 Remove record
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightlcick some record and choose "Delete Selected Record" and press "Yes" in confirmation dialog.
    		 4. Record should be deleted.

    work_DB_008
    		 Don't remove record
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightlcick some record and choose "Delete Selected Record" and press "No" in confirmation dialog.
    		 4. Record shouldn't be deleted.

    work_DB_009
    		 Remove several records
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Select several records, rightlcick and choose "Delete Selected Record".
    		 4. All records should be deleted.

    work_DB_010
    		 Cancel Edits
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Edit data in some cell.
    5. Click "Cancel Edits" button.
    		 4. Data should be changed.
    5. All changes should be canceled.

    work_DB_011
    		 Commit Edits
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Edit data in some cell.
    5. Click "Commit Selected Records" button.     		4. Data should be changed.
    5. All changes should be commited to DB.

    work_DB_012
    		 Commit not all edits
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Edit data in cells of several records.
    5. Select only some of them and click "Commit Selected Records" button.     		4. Data should be changed.
    5. Changes only for selected recrods should be commited to DB.

    work_DB_013
    		 Cancel truncate table
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightlcick and choose "Truncate Table".
    5. In appeared dialog click "Cancel".
    		 5. Data should be available in the table.

    work_DB_014
    		 Truncate table
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightlcick and choose "Truncate Table".
    5. In appeared dialog click "OK".
    		 5. Table shouldn't contain any data.

    work_DB_015
    		 Refresh records
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Change data outside IDE.
    5. Press "Refresh Records" button.
    		 5. Data should be refreshed.

    work_DB_016
    		 Print Table Data
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightclick results and choose "Pring Table Data".
    		 4. Data should be printed.

    work_DB_017
    		 Copy Cell Value
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightclick some cell and choose "Copy Cell Value".
    		 4. Data from the cell should be copied.

    work_DB_018
    		 Copy Row Values
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightclick some row and choose "Copy Row Values".
    		 4. Data from the row should be copied.

    work_DB_019
    		 Copy Row Values (With Header)
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightclick some row and choose "Copy Row Values (With Header)".
    		 4. Data with header from the row should be copied.

    work_DB_020
    		 Show SQL Script for CREATE
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightclick some row and choose "Show SQL Script for CREATE".
    		 4. Script for creation of the table should be displayed.

    work_DB_021
    		 Show SQL Script for INSERT
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightclick some row and choose "Show SQL Script for INSERT".
    		 4. Script for inserting of data should be displayed.

    work_DB_022
    		 Show SQL Script for DELETE
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Rightclick some row and choose "Show SQL Script for DELETE".
    		 4. Script for deletion of the row should be displayed.

    work_DB_023
    		 Show SQL Script for UPDATE 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Change some data in some row, rightclick this row and choose "Show SQL Script for UPDATE".
    		 4. Script for update of the row should be displayed.

    work_DB_024
    		 Navigation between records
    		 1. Open SQL editor.
    2. Type some query.
    3. Run it.
    4. Click "Next Page", "Previous Page", "First Page", "Last Page" buttons.
    		 5. It should be possible to navigate between records with these buttons.


    Approvals

    Reviewer Name & Title

    Date

    Status




    Revision History

    Author

    Date

    Revision

    Roman Mostyka

    June-29-2008

    First Draft
    Companion
    Projects:     		MySQL Database Server   GlassFish Community: an Open Source Application Server   Open Solaris  Open JDK: an Open SourceJDK   Mobile & Embedded Community     Sponsored by 
    Sponsored by Sun Microsystems