Difference between revisions of "QA/Tescase"

Base

Database Wizard

Create embedded database

The testing cover:

1. Create a new database
2. create table in design view,
3. Name, type, Primary Key, format example
4. double click created table to input data
5. Check data from design view
6. Create queries in SQL view(Grammar check when saving，Logical check on execution)
7. create form from wizard(organize data with controller)
8. create report to writer

Connect to an existing database via JDBC

The testing cover:

1. install driver(ensure step 4 can pass)
2. Connection URL:
3. Driver Class: com.mysql.jdbc.Driver
4. click Test Class button, check driver can load correctly.
5. Input User name, then Test Connection
6. check load database, table ...from mysql db.
7. Edit exist table: add column, delete column, but can't edit data record.
8. Create new table on exist mysql database(load all database from connected db), field and data record all can be edited.
9. Create query, form, report base on exist table and new created table

Connect to an existing database via ODBC

The testing cover:

1. install odbc driver connect to db info(ensuse name in step 2 can be browsed)
2. connect to exist database via ODBC select name of odbc data source on system
3. Edit exist table: add column, delete column, but can't edit data record.
4. Create new table on exist mysql database(load all database from connected db), field and data record all can be edited.
5. Create query, form, report base on exist table and new created table

Connect to an existing Speadsheet

The testing cover:

1. open spreadsheet with read-only mode, (one sheet one table)
2. Add table, edit table, include field definition and data record.
3. create query use Wizard(not easy to write sql to query Spreadsheet)
4. create form and report base on sheet

Connect to an existing Text

The testing cover: open text

1. create a text like table, with field separator
2. one text one table, can't edit table.

open csv(address book file)

1. use spreadsheet to save as to a text csv file.
2. Select folder where csv in. (one csv one table, if more csv in this folder, then will get all csv more tables)
3. can add table, edit table.

open custom type file

1. create a custom type file with definition separator(Field separator), filed separator have tab space

Connect to an existing Microsoft Access 2007

The testing cover:

1. browse Access accdb file
2. operation like other db

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:

1. Register database automatically
2. Register database manually
3. check registered database
4. new Calc or Writer document
5. View-Data Sources or F4 to pop up registered data source.
6. Select all data then click “data to text ” button, or drag&drop table to sheet. Data from database will copy to sheet or writer.

Database design entry

Database objects

The testing cover:

1. Database objects: Table, Query, Form, Report
2. Report:
3. Tasks zone
4. Description
5. Object Zone
6. Preview
7. Status bar: include info about DataBase type, database name/database file path, user, IP.

Create table in design view

The testing cover:

1. Field Properties: Entry Required, Auto Value, Auto-increment state, Length, Format example
2. Must have Primary Key
3. Provide shortcut of Field Type via keyboard
4. Provide Index design in Tools->Index Design

Use Wizard to create table

The testing cover:

1. Select Fields:
2. Select category: Business or Personal.
3. Set types and format
4. Set types and format for selected fields.
5. Auto value is yes will pop up Auto-increment statement (auto value field must key) such as MySQL need input AUTO_INCREMENT to this statement box.
6. Set primary key
7. Create table

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:

1. Field selection.
2. Sorting Order
3. Search condition(can't save search condition, maybe defect)
4. Detail or summary
5. Grouping
6. Grouping conditions
7. Aliases
8. Assign Aliases of field if desired.

Create Form in design view

The testing cover:

Need macro to activate event

User Wizard to create Form

The testing cover:

1. Field selection
2. For table and query
3. Specify a subform
4. Layout of created form. Arrange of main form, Arrange or sub form.
5. Specifies the data handling mode for the new form.
6. Specifies the page style for the form
7. Specifies the name of the form and how to proceed.

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

Import data to base

Register database and integrate Usage

The testing cover:

1. Register database automatically
2. Register database manually
3. Usage registered database in Calc and Writer

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 accelerato​rs

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