User: clu Date: 06/05/10 08:59:11 Added: /dba/www/QA/ Extraordinary_Testcases.html
Log: add page File Changes: Directory: /dba/www/QA/ ======================= File [added]: Extraordinary_Testcases.html Url: http://dba.openoffice.org/source/browse/dba/www/QA/Extraordinary_Testcases.html?rev=1.1&content-type=text/vnd.viewcvs-markup Added lines: 203 ---------------- <!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: extraordinary 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">Connection Test</td> </tr> </table> </div> The collected results of this test can be found under <a href="Connection_Result.html">Connection Result Table</a>. The used placeholder in words:<br> (+) = works fine/ok ; (-) = is not supported ; (?) = works partly/with workaround.<br> <dd>0. open or create according database for testing</dd> <p>- create tables -</p> <dd>1. create a new table (by clicking on the 'table container' and choosing: 'create table in design view...')</dd> <dd>-> table design window appear</dd> <dd>2. insert any field name and save table (with 'save' icon in toolbar or file/save menue)</dd> <dd>-> save dialog appear</dd> <dd>3. insert any table name and push the 'ok' button</dd> <dd>-> proposual dialog for primary key appears (if database support primary key)</dd> <dd>4. push the 'no' button and close the window</dd> <dd>=> check: 'create tables' on your checklist (if works fine/ok (+) or not supported (-) or works partly/with workaround (?)) </dd> <p>- primary key -</p> <dd>5. repeat step 1. to 3. but choose 'yes' for primary key in step 4.</dd> <dd>=> check: 'primary key' on your checklist (ok(+) - not supported(-) - works partly(?))</dd> <p>- delete tables -</p> <dd>6. delete both tables (by context on tablename or 'del' key on keyboard)</dd> <dd>=> check: 'delete tables' (+-?)</dd> <p>- insert table fields -</p> <dd>7. create a table with several fields (with different field types of your choice)</dd> <dd>8. save and close table (with primary key if supported)</dd> <dd>9. open table in design view (by context on table and 'edit' or in edit/edit menue)</dd> <dd>10. add a field and save table</dd> <dd>=> check: 'insert table fields'</dd> <p>- modify table fields -</p> <dd>11. change any field name and any field type and save the table</dd> <dd>-> if warning dialog appear click 'yes' (warning dialog propose appending as new table)</dd> <dd>=> check: 'modify table fields'</dd> <p>- modify table fields -</p> <dd>12. delete any field and save the table</dd> <dd>=> check: 'delete table fields'</dd> <p>- insert table data -</p> <p>- insert table rows -</p> <dd>13. close the table</dd> <dd>14. open the table in design view again, control and close (check if the 'insert/modified/deleted' changes are still present)</dd> <dd>15. open the table in normal view (doubleclick on table or context/open)</dd> <dd>16. insert some rows with any data and save (or leave current row - should save data, too)</dd> <dd>=> check: 'insert table data'</dd> <dd>=> check: 'insert table rows'</dd> <p>- modify table data -</p> <dd>17. change any content and save</dd> <dd>=> check: 'modify table data'</dd> <p>- delete table data -</p> <p>- delete table rows -</p> <dd>18. delete any content and any table row (by context or by marking whole row and pushing 'del' key on keyboard)</dd> <dd>=> check: 'delete table data'</dd> <dd>=> check: 'delete table rows'</dd> <p>- create query -</p> <dd>19. close table and push the 'query container'</dd> <dd>20. create a new query (in design view)</dd> <dd>-> 'add tables' dialog appear</dd> <dd>21. add the created test table (or any else containing different field types and any data)</dd> <dd>-> 'table' container appear</dd> <dd>22. choose some fields from 'table container' (by doubleclicking on tablename or field listbox in lower grid)</dd> <dd>23. run and save the query (by corresponding icon or menue: edit/run query)</dd> <dd>-> upper 'result' window should appear (and show the result of the query)</dd> <dd>24. close and reopen the query in design view (context:'edit')</dd> <dd>=> check: 'create query'</dd> <p>- modify query -</p> <dd>25. insert any further field, or delete one (delete field by marking 'field header' in lower grid and context or 'del' key)</dd> <dd>26. save and close query design</dd> <dd>27. reopen and verify the change you have made</dd> <dd>=> check: 'modify query'</dd> <p>- delete query -</p> <dd>28. close query and delete it</dd> <dd>=> check: 'delete query'</dd> <p>- views -</p> <dd>29. create a new 'view' (table container/create view - if supported)</dd> <dd>30. save, close and delete it</dd> <dd>=> check: 'views'</dd> <p>- indexes -</p> <dd>31. open or create any table in design view</dd> <dd>32. open the 'index' design dialog (in menue: tools/index design or with according icon)</dd> <dd>-> index dialog appear</dd> <dd>33. create a new index, save it and close dialog and table (with the according icons)</dd> <dd>34. reopen test table</dd> <dd>35. reopen index dialog and recheck if index still present</dd> <dd>=> check: 'indexes'</dd> <p>- joins -</p> <dd>36. close dialog and table design</dd> <dd>37. create any other table (for further test we need min. two tables)</dd> <dd>38. open a new query in design view</dd> <dd>39. add two tables</dd> <dd>-> two table container should appear</dd> <dd>40. create a join between them (by drag&drop any field name from one table container to the other)</dd> <dd>-> a 'connector' between the two table container appear</dd> <dd>41. doubleclick on the connector</dd> <dd>-> the 'join property' dialog appear</dd> <dd>42. choose from 'type listbox' any item f.e. 'inner join' (if supported)</dd> <dd>43. push the 'ok' button</dd> <dd>-> dialog disappear</dd> <dd>44. insert any table field for query (by doubleclicking on any field in table container or with 'listbox'..)</dd> <dd>45. run and save the query (for a senseful result you need sensfull data)</dd> <dd>46. open the query in design view and doubleclick on the 'connector'</dd> <dd>-> the 'join property' dialog appear</dd> <dd>47. (optional) check the other proposed join 'types' if supported (43. to 46.)</dd> <dd>=> check: 'join'</dd> <p>- relations -</p> <dd>48. close dialog and query design</dd> <dd>49. open the 'relation design' (menue: tools/relationships)</dd> <dd>-> dialog appear</dd> <dd>50. add two tables</dd> <dd>-> table container appear</dd> <dd>51. drag and drop a field from one table container to the other (does not work with every field - try the two primary key fields)</dd> <dd>-> 'connector ' between the two table container appear (with doubleclick on it, dialog available)</dd> <dd>52. save, refresh, reopen and recheck if everything is still fine</dd> <dd>=> check: 'relations'</dd> <p> <div align="center">- finish test -</div><br><br> please send the filled checklist with 'connection test' in title to <a href="mailto:[EMAIL PROTECTED] test">[EMAIL PROTECTED]</a>.<br><br> (please fill in like example:<br> create tables: +<br> indexes: -<br> ...<br> and notice, that the order differ a bit)<br><br> Database:<br> Driver (vers. number):<br> OS (Operating System f.e. WinXP or LinuxSuse10.1):<br> oo Version:<br> known bugs (optional):<br><br> Checklist: -Connection Test-<br> primary key:<br> create tables:<br> delete tables:<br> insert table fields:<br> modify table fields:<br> delete table fields:<br> insert table data:<br> modify table data:<br> delete table data:<br> insert table rows:<br> delete table rows:<br> create query:<br> modify query:<br> delete query:<br> views:<br> indexes:<br> joins:<br> relations:<br> </p> </body> </html> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
