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.

• Simple SQL code completion in source editor
• UI/Functional Spec for Testing a Query in a Code Editor
  
• Integration of other languages with the SQL editor
• Database-related PHP snippets
  

(T) Test Identification (Test Areas)

• Code Completion in Source Editor
• Test Query
• Integration with PHP
• Various

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