cornercorner
FeaturesPluginsDocs & SupportCommunityPartners

rSun Microsystems / Rave QE

Databases Integration 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/DBIntegration.html


(F) Features to be tested

Features that will be Implemented and Tested for NetBeans 6.5 release

  • Integration of MySQL DB
  • Integration of PostgreSQL DB
  • Integration with SQL Workbench
  • Integration of "Sakila Sample Database" plugin

(A) Approach refinements

   This exercise would comprise of :
  • tight integration with MySQL
  • tight integration with PostgreSQL
  • tight integration with SQL Workbench

    • (D) Related documentation.

    (T) Test Identification (Test Areas)


    Test Cases Detail/Procedure

    Integration with MySQL

    Registration of MySQL

    Setup (e): Install MySQL server

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    reg_mysql_001

    Existence of necessary popup menu item

    		1. Rightclick "Databases" node.
    		 1. "Register MySQL Server" popup menu item should eixst.

    reg_mysql_002

    Register invalid MySQL

    		1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify invalid MySQL server parameters and click "OK".    		 2. MySQL server node with specified parameters should appear, but with mark '(not connected)'.

    reg_mysql_003

    Register valid MySQL

    		1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid MySQL server parameters and click "OK".    		 2. MySQL server node with specified parameters should appear, but without mark '(not connected)'.

    reg_mysql_004

    Add new MySQL connection with admin user

    		1. Rightclick "Databases" node and choose "New Connection".
    2. Specify valid MySQL server parameters and enter admin login/password and click "OK".     		2. MySQL connection should appear and also MySQL server node with specified parameters should appear, without mark '(not connected)'.

    reg_mysql_005

    Add new MySQL connection with non admin user

    		1. Rightclick "Databases" node and choose "New Connection".
    2. Specify valid MySQL server parameters and enter non admin login/password and click "OK".     		2. Only MySQL connection should appear and no MySQL server node.

    reg_mysql_006

    		 Detection of running server
    		 1. Run MySQL on the local host at the default port of 3306.
    2. Start IDE with fresh userdir.
    		 2. MySQL server node should be automatically registered.

    reg_mysql_007 Detection of existing MySQL connection
    		 1. Registered MySQL connection with the Database Explorer.
    2. Start IDE with fresh userdir.
    		 2. MySQL connetion node should be automatically registered using the properties defined on the connection..

    reg_mysql_008 Detection of a standard installation
    		 1. Install MySQL on default path (see default path, which can be used in this test case).
    2. Start IDE with fresh userdir. Note that MySQL server have to be shutdown.
    		 2. MySQL server node should be automatically registered and should appear with mark '(not connected)'.

    reg_mysql_009

    		 Disabling of auto-registration after removing of server
    		 1. Run MySQL on the local host at the default port of 3306.
    2. Start IDE with fresh userdir.
    3. Delete auto-registered MySQL server.
    4. Restart IDE.
    		 4. MySQL server shouldn't be auto-registered.

    reg_mysql_010

    Cancel

    		1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Press "Cancel" button.
    		 2. "Register MySQL Server" dialog should disappear.

    reg_mysql_011

    Help

    		1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Press "Help" button.
    		 2. Help window should appear with appropriatetopic in it..

    reg_mysql_012

    Save password

    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid MySQL server parameters, check "Remember Password" checkbox and click "OK".
    3. Disconnect from the server and reconnect again.
    		 2. MySQL server node with specified parameters should appear and connection should be established.
    3. Connection should be established.

    reg_mysql_013

    Don't save password

    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid MySQL server parameters, uncheck "Remember Password" checkbox and click "OK".
    3. Disconnect from the server and reconnect again.
    		 2. MySQL server node with specified parameters should appear and connection should be established.
    3. Dialog with field for password should appear for establishing connection.

    reg_mysql_014

    Register MySQL with admin properties

    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid MySQL server parameters and specify admin properties.
    3. Rightclick MySQL server's node.
    		 3. "Start" and "Stop" menu should be enabled.

    reg_mysql_015

    Register MySQL without admin properties

    		1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid MySQL server parameters, but don't specify admin properties.
    3. Rightclick MySQL server's node.
    		 3. "Start" and "Stop" menu should be disabled.


    Work with MySQL

    Setup (e): Install MySQL server

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    work_mysql_001

    Existence of necessary popup menu item

    		1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid MySQL server parameters and click "OK".
    3. Rightclick MySQL server node.
    		 3. Popup menu item should contain following items: "Create Database...", "Start", "Stop", "Connect", "Disconnect", "Delete", "Run Administration Tool", "Properties".

    work_mysql_002

    Existence of certain databases

    		1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid MySQL server parameters and click "OK".
    3. Expand MySQL server node.    		 3. Databases, which exist on server, should be available as subnodes.

    work_mysql_003

    Wrong MySQL server admin properties

    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify invalid admin properties.    		 2. OK button should be disabled..

    work_mysql_004

    Start MySQL server

    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid admin properties for MySQL server and click "OK".
    3. Rightclick MySQL server node and choose "Start".     		3. MySQL server should be started.

    work_mysql_005

    		 Stop MySQL server 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid admin properties for MySQL server and click "OK".
    3. Rightclick MySQL server node and choose "Start".
    4. Rightclick MySQL server node and choose "Stop".
    		 4. MySQL server should be stopped.

    work_mysql_006

    		 Run Administration Tool without set admin properties
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server, but don't specify admin properties and click "OK".
    3. Rightclick MySQL server node and choose "Run Administration Tool".
    		 3. Dialog should appear with proposal to set admin properties.

    work_mysql_007 Run Administration Tool with set admin properties 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server, specify admin properties and click "OK".
    3. Rightclick MySQL server node and choose "Run Administration Tool".    		 3. Administration Tool should be invoked.

    work_mysql_008 MySQL properties
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server and click "OK".
    3. Rightclick MySQL server node and choose "Properties".    		 3. Properties dialog should appear.

    work_mysql_009

    		 Delete MySQL server
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server and click "OK".
    3. Rightclick MySQL server node and choose "Delete".    		 3. After confirmation MySQL server node should be deleted.

    work_mysql_010

    		 Create standard DB with user, who hasn't admin privilegies
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server, but with user, who hasn't admin privilegies, and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Choose database "sample" and click OK.
    		 4. Message that user aren't granted should appear.

    work_mysql_011

    		 Create standard DB without data for user, who has admin privilegies
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Choose database "sample" and click OK.
    5. In appeared dialog click "No".
    		 5. Database "sample" should be created, but it shouldn't contain any data.

    work_mysql_012 Create standard DB with data for user, who has admin privilegies 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Choose database "sample" and click OK.
    5. In appeared dialog click "Yes".
    		 5. Database "sample" should be created and it should contain data.

    work_mysql_013 Create standard DB with user, who has admin privilegies 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Choose database "sample" and click OK.    		 4. Database "sample" should be created.

    work_mysql_014

    		 Create existing database
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with admin user and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Choose database "sample" and click OK.
    5. Rightclick MySQL server node again and choose "Create Database...".
    6. Choose database "sample" and click OK.
    		 6. Message that database exists should appear.

    work_mysql_015

    		 List of standard databases
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with admin user and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    		 3. Dropdown List should contain 'sample', 'vir' and 'travel' databases.

    work_mysql_016

    		 Create non standard DB with admin user 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with admin user and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Enter "test" in "Database Name" field and click OK.    		 4. Database "test" should be created.

    work_mysql_017

    		 Connect to database
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with admin user and click "OK".
    3. Expand MySQL server node, rightclick one of database from the list and choose "Connect".
    4. Specify password and click "OK".
    		 4. Selected database should appear in connections tree as a node and it should be connected.

    work_mysql_018

    		 Disconnect from database 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with admin user and click "OK".
    3. Expand MySQL server node, rightclick one of database from the list and choose "Connect".
    4. Specify password and click "OK".
    5. Rightclick database and click "Disconnect".
    		 5. Selected database should be disconnected.

    work_mysql_019

    		 Delete database
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with admin user and click "OK".
    3. Expand MySQL server node, rightclick one of database from the list and choose "Connect".
    4. Specify password and click "OK".
    5. Rightclick database and click "Delete".     		5. Selected database should be deleted.

    work_mysql_020

    		 Invoke MySQL Workbench 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with admin user and click "OK".
    3. Invoke MySQL Workbench.     		3. MySQL Workbench should be invoked.
    		Will be implemented in the future

    work_mysql_021

    		 Show execution plan for MySQL 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with admin user and click "OK".
    3. Connect to some MySQL database and open SQL editor for it.
    4. Execute some query.
    5. Invoke "Execution plan" for the result of the query.
    		 5. The execution plan visually should be represented as a depth-first tree. The output will appear in a pane below the Table Properties in the right bottom pane.
    		Will be implemented in the future
    work_mysql_022 Create standard DB without data by typing it's name
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Enter database name "sample" and click OK.
    5. In appeared dialog click "No".
    		 5. Database "sample" should be created, but it shouldn't contain any data.

    work_mysql_023 Create standard DB with data by typing it's name 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Enter database name "sample" and click OK.
    5. In appeared dialog click "Yes".
    		 5. Database "sample" should be created and it should contain data.

    work_mysql_024 Disconnect from DBs after stopping server
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Start MySQL server.
    4. Expand MySQL server node, rightclick some DB node and choose "Connect".
    5. Stop MySQL server.
    		 4. Connection should appear.
    5. DB connection should be broken.

    work_mysql_025 Removing connection after removing DB from the server
    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Start MySQL server.
    4. Expand MySQL server node, rightclick some DB node and choose "Connect".
    5. Rightclick DB node under MySQL server node and choose "Delete".
    		 4. Connection should appear.
    5. DB should be removed and it's connection also should be removed.

    work_mysql_026

    Start MySQL server without admin properties

    		 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server and click "OK".
    3. Rightclick MySQL server node and choose "Start".     		3. Dialog should appear with proposal to set admin properties.

    work_mysql_027

    Stop MySQL server without admin properties

    		 1. Start MySQl server.
    2. Rightclick "Databases" node and choose "Register MySQL Server".
    3. Specify valid basic properties for MySQL server and click "OK".
    4. Rightclick MySQL server node and choose "Start".     		4. Dialog should appear with proposal to set admin properties.

    work_mysql_028

    Stop MySQL server without admin properties

    		 1. Start MySQl server.
    2. Rightclick "Databases" node and choose "Register MySQL Server".
    3. Specify valid basic properties for MySQL server and click "OK".
    4. Remove some database with MySQL tools, rightclick MySQL server node and choose "Refresh".     		4. List of availalbe DBs should be refreshed.

    Work with "Sakila Sample Database" plugin

    Setup (e): Install "Sakila Sample Database" plugin

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    sakila_001 Create sakila DB without data
    		1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Choose database "sakila" and click OK.
    5. In appeared dialog click "No".
    		 5. Database "sakila" should be created, but it shouldn't contain any data.

    sakila_002 Create sakila DB with data 1. Rightclick "Databases" node and choose "Register MySQL Server".
    2. Specify valid basic properties for MySQL server with user, who has admin privilegies, and click "OK".
    3. Rightclick MySQL server node and choose "Create Database...".
    4. Choose database "sakila" and click OK.
    5. In appeared dialog click "Yes".
    		 5. Database "sakila" should be created and it should contain data.

    Integration with PostgreSQL

    Registration of PostgreSQL

    Setup (e): Install PostgreSQL server

    Test Id

    (t) Test Item

    (i) Input Spec

    (o) Output Spec

    (e) Env needs

    (d) Dependencies/ Notes

    reg_postgresql_001

    		 Detection of running server
    		 1. Run PostgreSQL on the local host at the default port of 5432
    2. Start IDE with fresh userdir.
    		 2. PostgreSQL server node should be automatically registered with user of 'postgres' and an empty password.
    		Will be implemented in the future


    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