Difference between revisions of "QA/Tescase"
Liupingtan (talk | contribs) |
Liupingtan (talk | contribs) |
||
Line 1: | Line 1: | ||
− | == | + | |
+ | ==General Testing Test Cases == | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| | | | ||
− | <center>'''Component'''</center> | + | <center>'''''''''Component'''</center> |
| | | | ||
− | <center>'''Function Category'''</center> | + | <center>'''Function Category(top suite)'''</center> |
| | | | ||
− | <center>'''Function | + | <center>'''Function(2nd suite)'''</center> |
| | | | ||
− | <center>'''Test Case Design/Summary'''</center> | + | <center>'''Function Point(3rd suite)'''</center> |
+ | | | ||
+ | <center>'''Test Case Design/Summary(test case)'''</center> | ||
|- | |- | ||
| | | | ||
Line 17: | Line 20: | ||
| | | | ||
Database Wizard | Database Wizard | ||
+ | | | ||
+ | <center>Create Embedded database</center> | ||
| | | | ||
Create embedded database | Create embedded database | ||
Line 34: | Line 39: | ||
| | | | ||
+ | | | ||
+ | <center>Connect to External business database</center> | ||
| | | | ||
Connect to an existing database via JDBC | Connect to an existing database via JDBC | ||
Line 52: | Line 59: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Connect to an existing database via ODBC | Connect to an existing database via ODBC | ||
Line 66: | Line 75: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Connect to an existing Speadsheet | Connect to an existing Speadsheet | ||
Line 79: | Line 90: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Connect to an existing Text | Connect to an existing Text | ||
Line 97: | Line 110: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Connect to an existing Microsoft Access 2007 | Connect to an existing Microsoft Access 2007 | ||
Line 109: | Line 124: | ||
| | | | ||
− | Connect to | + | <center></center> |
+ | | | ||
+ | Connect to address book''' '''(Microsoft Outlook) | ||
| | | | ||
The testing cover: | The testing cover: | ||
Line 121: | Line 138: | ||
| | | | ||
+ | | | ||
+ | <center>Register databse</center> | ||
| | | | ||
Register a databse and Use it | Register a databse and Use it | ||
Line 135: | Line 154: | ||
| | | | ||
− | Database design entry | + | Database design entry |
| | | | ||
− | Entry | + | <center>Entry</center> |
+ | | | ||
+ | Database objects | ||
| | | | ||
The testing cover: | The testing cover: | ||
# Database objects: Table, Query, Form, Report | # Database objects: Table, Query, Form, Report | ||
− | |||
# Report: | # Report: | ||
# Tasks zone | # Tasks zone | ||
# Description | # Description | ||
# Object Zone | # Object Zone | ||
− | |||
− | |||
# Preview | # Preview | ||
# Status bar: include info about DataBase type, database name/database file path, user, IP. | # Status bar: include info about DataBase type, database name/database file path, user, IP. | ||
Line 154: | Line 172: | ||
| | | | ||
− | + | ||
| | | | ||
− | Create | + | <center>Table</center> |
+ | | | ||
+ | Create table in design view | ||
| | | | ||
The testing cover: | The testing cover: | ||
Line 168: | Line 188: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Use Wizard to create table | Use Wizard to create table | ||
Line 184: | Line 206: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Create View | Create View | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Total same as Query Design Windows | Total same as Query Design Windows | ||
can edit and edit in SQL view. | can edit and edit in SQL view. | ||
Line 197: | Line 220: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Table Data View | Table Data View | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Provide Data Filter and Data Statistics | Provide Data Filter and Data Statistics | ||
Line 208: | Line 232: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Relation</center> | ||
| | | | ||
− | Relation | + | Relation View |
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Tools->Relationships to pop up Relationship Design Window | Tools->Relationships to pop up Relationship Design Window | ||
Drag and Drop or insert->New Relation | Drag and Drop or insert->New Relation | ||
Line 220: | Line 245: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Query</center> | ||
| | | | ||
Create query in design view | Create query in design view | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Field Alias,Table.Sort.Visible | Field Alias,Table.Sort.Visible | ||
Function button: Run query, Clear query, Switch design view on/off(switch with SQL editor to check before save, after save this button is disabled | Function button: Run query, Clear query, Switch design view on/off(switch with SQL editor to check before save, after save this button is disabled | ||
Line 234: | Line 260: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Use wizard to create query | Use wizard to create query | ||
Line 250: | Line 278: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Form</center> | ||
| | | | ||
Create Form in design view | Create Form in design view | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Need macro to activate event | Need macro to activate event | ||
|- | |- | ||
Line 262: | Line 291: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
User Wizard to create Form | User Wizard to create Form | ||
Line 277: | Line 308: | ||
| | | | ||
− | + | ||
| | | | ||
− | + | <center>Report</center> | |
− | + | | | |
+ | The report of fields | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
For table and query | For table and query | ||
Line 300: | Line 331: | ||
| | | | ||
− | Main Function/ | + | Main Function |
+ | | | ||
+ | <center>FileSave</center> | ||
| | | | ||
Save/Save As | Save/Save As | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
save file to different types. | save file to different types. | ||
Check the appearance and properties of saved files. | Check the appearance and properties of saved files. | ||
Line 312: | Line 344: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>FileSend</center> | ||
| | | | ||
− | + | Send | |
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Send with different style | Send with different style | ||
|- | |- | ||
Line 323: | Line 356: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>FileOpen</center> | ||
| | | | ||
− | + | Open | |
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Open/ save/ reopen different type of files, | Open/ save/ reopen different type of files, | ||
Check files can be opened correctly. | Check files can be opened correctly. | ||
Line 335: | Line 369: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>File Editing</center> | ||
| | | | ||
Editing | Editing | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Check the appearance of Editing operation ,such as undo/redo delete edit | Check the appearance of Editing operation ,such as undo/redo delete edit | ||
|- | |- | ||
Line 346: | Line 381: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>File UI</center> | ||
| | | | ||
Ui | Ui | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Do some operations to check the UI presents correctly. | Do some operations to check the UI presents correctly. | ||
|- | |- | ||
Line 357: | Line 393: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Copy/Paste/Paste Special</center> | ||
| | | | ||
Copy/Paste/Paste Special | Copy/Paste/Paste Special | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
1.Copy/paste/table | 1.Copy/paste/table | ||
2.Copy/paste special table | 2.Copy/paste special table | ||
Line 373: | Line 410: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Export and import data of base</center> | ||
| | | | ||
Export and import data of base | Export and import data of base | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | ===Export data from base=== | ||
+ | ===Import data to base=== | ||
+ | |- | ||
+ | | | ||
− | |||
− | |||
− | |||
− | |||
| | | | ||
| | | | ||
− | + | <center>Register database and integrate Usage</center> | |
| | | | ||
Register database and integrate Usage | Register database and integrate Usage | ||
Line 409: | Line 448: | ||
| | | | ||
− | + | ||
+ | | | ||
+ | <center>Tools</center> | ||
| | | | ||
Tools/SQL for testing sql command | Tools/SQL for testing sql command | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Tools->SQL for test sql command. | Tools->SQL for test sql command. | ||
Line 422: | Line 462: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Tools/Exension manager | Tools/Exension manager | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Add extension plugins. Common used extensions | Add extension plugins. Common used extensions | ||
|- | |- | ||
Line 433: | Line 474: | ||
| | | | ||
+ | | | ||
+ | <center></center> | ||
| | | | ||
Tools/Options<nowiki>/Openoffice.org</nowiki> Base connection pool | Tools/Options<nowiki>/Openoffice.org</nowiki> Base connection pool | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | |||
Connection pool for performance, but only some defined drivers, these drivers are not used frequently | Connection pool for performance, but only some defined drivers, these drivers are not used frequently | ||
|- | |- | ||
Line 444: | Line 486: | ||
| | | | ||
Accessibility | Accessibility | ||
+ | | | ||
+ | <center>Keyboard Navigator and accelerators</center> | ||
| | | | ||
Keyboard Navigator and accelerators | Keyboard Navigator and accelerators | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | Make sure you can perform | ||
+ | all test cases with just the keyboard" and refer the expected | ||
+ | result(navigation and accelerators) to AOO product Help | ||
+ | |- | ||
+ | | | ||
+ | |||
+ | | | ||
+ | |||
+ | | | ||
+ | <center></center> | ||
+ | | | ||
+ | |||
+ | | | ||
− | |||
− | |||
− | |||
|} | |} | ||
− | |||
− |
Revision as of 03:47, 20 May 2013
General Testing Test Cases
|
|
|
|
|
Base |
Database Wizard |
|
Create embedded database |
The testing cover:
|
|
Connect to an existing database via JDBC |
The testing cover:
| ||
|
Connect to an existing database via ODBC |
The testing cover:
| ||
|
Connect to an existing Speadsheet |
The testing cover:
| ||
|
Connect to an existing Text |
The testing cover: open text
open csv(address book file)
open custom type file
| ||
|
Connect to an existing Microsoft Access 2007 |
The testing cover:
| ||
|
Connect to address book (Microsoft Outlook) |
The testing cover: address book file also can be opened by open text open csv(address book file) open custom type file | ||
|
Register a databse and Use it |
The testing cover:
| ||
Database design entry |
|
Database objects |
The testing cover:
| |
|
Create table in design view |
The testing cover:
| ||
|
Use Wizard to create table |
The testing cover:
| ||
|
Create View |
The testing cover: Total same as Query Design Windows can edit and edit in SQL view. | ||
|
Table Data View |
The testing cover: Provide Data Filter and Data Statistics | ||
|
Relation View |
The testing cover: Tools->Relationships to pop up Relationship Design Window Drag and Drop or insert->New Relation | ||
|
Create query in design view |
The testing cover: Field Alias,Table.Sort.Visible Function button: Run query, Clear query, Switch design view on/off(switch with SQL editor to check before save, after save this button is disabled | ||
|
Use wizard to create query |
The testing cover:
| ||
|
Create Form in design view |
The testing cover: Need macro to activate event | ||
|
User Wizard to create Form |
The testing cover:
| ||
|
The report of fields |
The testing cover: For table and query Specifies the table or query for which you are creating the report Label the field to the report Group records in a report Select the fields by which to sort the report. Fields can be sorted by up to four levels, each either ascending or descending. Grouped fields can only be sorted within each group. Layout of data, layout of header and footer | ||
Main Function |
|
Save/Save As |
The testing cover: save file to different types. Check the appearance and properties of saved files. | |
|
Send |
The testing cover: Send with different style | ||
|
Open |
The testing cover: Open/ save/ reopen different type of files, Check files can be opened correctly. | ||
|
Editing |
The testing cover: Check the appearance of Editing operation ,such as undo/redo delete edit | ||
|
Ui |
The testing cover: Do some operations to check the UI presents correctly. | ||
|
Copy/Paste/Paste Special |
The testing cover: 1.Copy/paste/table 2.Copy/paste special table 3.Copy/paste query/form/report 4.Copy/ paste to Writer/Calc to Calc, will auto copy the data to writer, will design table colume | ||
|
Export and import data of base |
The testing cover: Export data from baseImport data to base | ||
|
Register database and integrate Usage |
The testing cover:
Operations in Scenario 3 Drag and Drop table or query in navigate tree to sheet, All definition and data will copy to Sheet/Writer page Data to text:Click Upper left corner to select all data in specified registered database, then click "Data to text" button. All definition and data will copy to Sheet Data to fields: Define fields with 2 ways, Add Insert->Fields->Other, define your fields in "Database" tab. Mouse select field name,drag and drop field name to writer document。 Then select specified record then click "Date to field", field data will copy to specified field. Mail Merge: Mail Merge Wizard entry, this function is commonly used | ||
|
Tools/SQL for testing sql command |
The testing cover: Tools->SQL for test sql command. | ||
|
Tools/Exension manager |
The testing cover: Add extension plugins. Common used extensions | ||
|
Tools/Options/Openoffice.org Base connection pool |
The testing cover: Connection pool for performance, but only some defined drivers, these drivers are not used frequently | ||
Accessibility |
|
Keyboard Navigator and accelerators |
The testing cover: Make sure you can perform all test cases with just the keyboard" and refer the expected result(navigation and accelerators) to AOO product Help | |
|