User: clu Date: 06/05/10 08:47:53 Added: /dba/www/QA/ Special_Testcases.html
Log: add testcase File Changes: Directory: /dba/www/QA/ ======================= File [added]: Special_Testcases.html Url: http://dba.openoffice.org/source/browse/dba/www/QA/Special_Testcases.html?rev=1.1&content-type=text/vnd.viewcvs-markup Added lines: 156 ---------------- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>OpenOffice.org Database QA</title> <meta http-equiv="content-type"content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Style-Type" content="text/css"> <style type="text/css"> @import "/css/dba.css"; .available_in_1x_not_used { background-color:#CCFFCC; } .available_in_20_not_used { background-color:#CCFFFF; } .available_in_680_not_used { background-color:#FFFFCC; } </style> </head> <body> <b>Project Sections</b>: <a href="/index.html">Home</a> | <a href="/howto/index.html">HowTo's</a> | <a href="/specifications/index.html"><b>Specifications</b></a> | <a href="/FAQ/index.html">Tips 'n' Tricks</a> | <a href="/downloads/index.html">Downloads</a> | <a href="/miscellaneous/index.html">Miscellaneous</a> | <a href="/drivers/index.html">Drivers</a><br/> <hr/> <div class="dba"> <h1>Database Access - QA: special Testcases</h1> </div> If you have any questions, anything to add etc. please contact: <a href="mailto:[EMAIL PROTECTED] test">[EMAIL PROTECTED]</a>.<br> If you want to support oo by testing or adding your testresults, please join the <a href="http://qa.openoffice.org";>OpenOffice.org QA project</a> and add your values in <a href="http://www.sunvirtuallab.com/tcm2/tcm_login.cgi";>TCM tool</a> or execute one of the following testcases and send the result to the respective QA member.<br><br> <div class="dba_light"> <table cellpadding="0" cellspacing="0" width="100%"> <tr class="MainTableHeader"> <td colspan="2">available Testcases: (with short content description)</td> </tr> </table> </div> <p> <a href="#db-join">Joins</a> - (inner Join, left Join, right Join, full Join)<br> <a href="#further-testcase">further testcase</a> - (in progress) </p> <div class="dba_light"> <table cellpadding="0" cellspacing="0" width="100%"> <tr class="MainTableHeader"> <a name=db-join> <td colspan="2">Testcase: Joins</td> </tr> </table> </div> <p> Attention: database formats like text, spreadsheet, dBase, adressbook and several other databases do not support joins<br> <br> Join Test Tables (numeric fields)<br> <img src="pics/JoinTables.jpg" alt="JoinTables.jpg"> <br> Create the Join Test Tables (step by step)<br> <br> 0. open the database document of your choice (or create a new one)<br> 1. choose the 'table container' (by clicking on it)<br> 2. take 'create table in design view'<br> -> table design window appear<br> 3. insert a field from fieldtype 'numeric' (named f.e. 'LeftTableField')<br> 4. save table (as LeftTable)<br> -> primary key dialog appear: push 'yes'<br> 5. close 'table design window'<br> 6. create the same way (2. to 5.) the second table (as 'RightTable' containing numeric field 'RightTableField' and primary key)<br> 7. open the 'LeftTable' (by doubleclick on it or from it's context)<br> -> table data window appear<br> 8. insert three new rows (by filling the 'ID' field with 1,2,3)<br> 9. fill the 'LeftTableField' also with three values (1,2,3)<br> 10. save and close the the 'table data window'<br> 11. fill the same way the 'RightTableField' table (7. to 10.), but insert 3,4,5 as values in 'RightTableField'<br> finish<br> <br> Join test<br> <br> 0. open the database document of your choice (containing the 'join test tables' or similar)<br> 1. click on the 'query container'<br> 2. take 'create query in design view'<br> -> query design window appear (with add tables dialog)<br> 3. insert the two test tables (by doubleclick on the tablenames or marking them and pushing add button)<br> -> two table container appear<br> 4. close the 'add tables' dialog<br> 5. choose the 'Left- and the RightTableField' for viewing results (by doubleclicking on each or choosing them from corresponding listbox in lower table grid)<br> -> fieldnames appear in lower table grid<br> 6. create a join between the two test tables (by drag and dropping 'RightTableField' from Right Table container on 'LeftTableField')<br> -> connector between the two table container appear<br> 7. open the join properties dialog (by doublecklicking on the connector or taking 'new relation' from 'insert' menue)<br> 8. try the single join types like described in next part (not all databases support all join types!)<br> <br> - inner Join -<br> <br> x. choose type 'inner join' (if supported) and push 'ok'<br> y. run the query (by pushing the 'run query button' or from 'edit' menue)<br> <br> => the result should be the row with the content '3'<br> (result table should contain the record(s) with same content in both tables)<br> <br> - left (outer) Join -<br> <br> x. choose type 'left join' (if supported) and push 'ok'<br> y. run the query (by pushing the 'run query button' or from 'edit' menue)<br> <br> => the result should be the three rows from 'LeftTableField' and the '3' row from 'RightTableField'<br> (result table should contain all record(s) from the left table and the record(s) from the right table wich content is equal to the left table)<br> <br> - right (outer) Join -<br> <br> x. choose type 'right join' (if supported) and push 'ok'<br> y. run the query (by pushing the 'run query button' or from 'edit' menue)<br> <br> => the result should be the three rows from 'RightTableField' and the '3' row from 'LeftTableField'<br> (result table should contain all record(s) from the right table and the record(s) from the left table wich content is equal to the right table)<br> <br> - full (outer) Join -<br> <br> x. choose type 'full join' (if supported) and push 'ok'<br> y. run the query (by pushing the 'run query button' or from 'edit' menue)<br> <br> => the result should be all rows from both testtables<br> <br> 9. save and close the query design window<br> 10. reopen it in design view (context of query name and choose 'edit' or from menue edit/edit)<br> 11. check if the two last choosen tablecontainer are still present with connector<br> 12. run the query and check if the result is still correct and close the query design window<br> 13. reopen the test query in data view (doubleclick on the query or take 'open' from query context)<br> 14. check if the last query result is still shown<br> <br> - finish - </p> <p> written by <a href="mailto:[EMAIL PROTECTED] testcase: joins">clu</a> </p> <div class="dba_light"> <table cellpadding="0" cellspacing="0" width="100%"> <tr class="MainTableHeader"> <a name=further-testcase> <td colspan="2">Testcase: further testcase</td> </tr> </table> </div> <p> text for further testcase </p> </body> </html> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
