Difference between revisions of "QA/Tescase"
Liupingtan (talk | contribs) |
(+cat) |
||
(7 intermediate revisions by 2 users not shown) | |||
Line 6: | Line 6: | ||
|- | |- | ||
| | | | ||
− | <center> | + | <center>'''Component'''</center> |
| | | | ||
<center>'''Function Category(top suite)'''</center> | <center>'''Function Category(top suite)'''</center> | ||
Line 42: | Line 42: | ||
<center>Connect to External business database</center> | <center>Connect to External business database</center> | ||
| | | | ||
− | Connect to an existing database | + | Connect to an existing database via JDBC |
| | | | ||
The testing cover: | The testing cover: | ||
Line 62: | Line 62: | ||
<center></center> | <center></center> | ||
| | | | ||
− | Connect to an existing database | + | Connect to an existing database via ODBC |
| | | | ||
The testing cover: | The testing cover: | ||
Line 129: | Line 129: | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
address book file also can be opened by | address book file also can be opened by | ||
open text | open text | ||
Line 139: | Line 140: | ||
| | | | ||
− | <center>Register | + | <center>Register databse</center> |
| | | | ||
Register a databse and Use it | Register a databse and Use it | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
# Register database automatically | # Register database automatically | ||
# Register database manually | # Register database manually | ||
Line 212: | Line 214: | ||
| | | | ||
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 226: | Line 229: | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Provide Data Filter and Data Statistics | Provide Data Filter and Data Statistics | ||
Line 239: | Line 243: | ||
| | | | ||
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 252: | Line 257: | ||
| | | | ||
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 285: | Line 291: | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Need macro to activate event | Need macro to activate event | ||
|- | |- | ||
Line 299: | Line 306: | ||
# Field selection | # Field selection | ||
# For table and query | # For table and query | ||
− | # Specify | + | # Specify a subform |
# Layout of created form. Arrange of main form, Arrange or sub form. | # Layout of created form. Arrange of main form, Arrange or sub form. | ||
# Specifies the data handling mode for the new form. | # Specifies the data handling mode for the new form. | ||
Line 315: | Line 322: | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
For table and query | For table and query | ||
Line 338: | Line 346: | ||
| | | | ||
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 351: | Line 360: | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Send with different style | Send with different style | ||
|- | |- | ||
Line 363: | Line 373: | ||
| | | | ||
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 376: | Line 387: | ||
| | | | ||
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 388: | Line 400: | ||
| | | | ||
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 417: | Line 430: | ||
| | | | ||
The testing cover: | The testing cover: | ||
− | + | ||
− | + | Export data from base | |
+ | |||
+ | |||
+ | Import data to base | ||
|- | |- | ||
| | | | ||
Line 455: | Line 471: | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Tools->SQL for test sql command. | Tools->SQL for test sql command. | ||
Line 468: | Line 485: | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Add extension plugins. Common used extensions | Add extension plugins. Common used extensions | ||
|- | |- | ||
Line 480: | Line 498: | ||
| | | | ||
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 492: | Line 511: | ||
| | | | ||
The testing cover: | The testing cover: | ||
+ | |||
Make sure you can perform | Make sure you can perform | ||
− | + | all test cases with just the keyboard" and refer the expected | |
− | + | result(navigation and accelerators) to AOO product Help | |
|- | |- | ||
| | | | ||
Line 507: | Line 527: | ||
|} | |} | ||
+ | |||
+ | [[Category:Quality Assurance]] |
Latest revision as of 15:33, 23 September 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 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 | |
|