appsunit-develop Mailing List for Apps Unit
Status: Beta
Brought to you by:
jancumps
You can subscribe to this list here.
2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(40) |
Oct
(34) |
Nov
(20) |
Dec
|
---|
From: Jan C. <jan...@us...> - 2006-11-30 21:38:55
|
Update of /cvsroot/appsunit/project/src/net/sourceforge/appsunit/environment In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv30688/environment Modified Files: DbSession.java AppsSession.java Log Message: Checkstyle cleanup. Index: AppsSession.java =================================================================== RCS file: /cvsroot/appsunit/project/src/net/sourceforge/appsunit/environment/AppsSession.java,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** AppsSession.java 30 Nov 2006 21:06:11 -0000 1.5 --- AppsSession.java 30 Nov 2006 21:38:54 -0000 1.6 *************** *** 37,40 **** --- 37,41 ---- * @TODO replace literal value insertion by parameter binding. */ + @SuppressWarnings("net.sourceforge.pmd.rules.UnusedLocalVariableRule") public static void logon(final Connection connection, final String user, final String responsibility, final String application) *************** *** 89,92 **** --- 90,97 ---- // call the fnd_global api to log on to the apps + int userColumn = 1; + int respColumn = userColumn + 1; + int appColumn = respColumn + 1; + CallableStatement cstmt = null; cstmt = connection.prepareCall( *************** *** 96,103 **** + ", resp_appl_id => ?" + ", security_group_id => null)}"); ! cstmt.setInt(1, usr); ! cstmt.setInt(2, rsp); ! cstmt.setInt(3, appl); ! try { // the first call somethimes fails. --- 101,108 ---- + ", resp_appl_id => ?" + ", security_group_id => null)}"); ! cstmt.setInt(userColumn, usr); ! cstmt.setInt(respColumn, rsp); ! cstmt.setInt(appColumn, appl); ! try { // the first call somethimes fails. Index: DbSession.java =================================================================== RCS file: /cvsroot/appsunit/project/src/net/sourceforge/appsunit/environment/DbSession.java,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** DbSession.java 30 Oct 2006 11:07:59 -0000 1.5 --- DbSession.java 30 Nov 2006 21:38:54 -0000 1.6 *************** *** 49,53 **** * @throws java.lang.Exception Exceptions are not caught. * They will be passed to the caller. ! * @TODO: parameterize nls settings */ @SuppressWarnings("net.sourceforge.pmd.rules.CloseResource") --- 49,53 ---- * @throws java.lang.Exception Exceptions are not caught. * They will be passed to the caller. ! * TODO: parameterize nls settings */ @SuppressWarnings("net.sourceforge.pmd.rules.CloseResource") *************** *** 92,97 **** throw e; } ! ! if (connection == null ) { throw new NullPointerException("Database connection is null."); } --- 92,97 ---- throw e; } ! ! if (connection == null) { throw new NullPointerException("Database connection is null."); } |
From: Jan C. <jan...@us...> - 2006-11-30 21:38:55
|
Update of /cvsroot/appsunit/project/src/net/sourceforge/appsunit/backend In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv30688/backend Modified Files: ViewValidator.java Log Message: Checkstyle cleanup. Index: ViewValidator.java =================================================================== RCS file: /cvsroot/appsunit/project/src/net/sourceforge/appsunit/backend/ViewValidator.java,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** ViewValidator.java 30 Oct 2006 11:07:57 -0000 1.3 --- ViewValidator.java 30 Nov 2006 21:38:54 -0000 1.4 *************** *** 32,36 **** /** ! * Compares if a test query against your view returns the same number of rows than * a test query against the driving table. * @param expectationQuery Row count query against driving table. --- 32,37 ---- /** ! * Compares if a test query against your view returns ! * the same number of rows than * a test query against the driving table. * @param expectationQuery Row count query against driving table. |
From: Jan C. <jan...@us...> - 2006-11-30 21:06:16
|
Update of /cvsroot/appsunit/project/src/net/sourceforge/appsunit/environment In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv18040 Modified Files: AppsSession.java Log Message: Binding parameters. Index: AppsSession.java =================================================================== RCS file: /cvsroot/appsunit/project/src/net/sourceforge/appsunit/environment/AppsSession.java,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** AppsSession.java 23 Sep 2006 22:12:25 -0000 1.4 --- AppsSession.java 30 Nov 2006 21:06:11 -0000 1.5 *************** *** 43,91 **** PreparedStatement stmt = null; ! String usr = null; stmt = connection.prepareStatement( "select user_id " + "from fnd_user " ! + "where user_name = '" ! + user ! + "'"); rs = stmt.executeQuery(); // execute if (rs.next()) { ! usr = rs.getString(1); // retrieve map_id } rs.close(); ! if (usr == null) { throw new Exception("User " + user + " not found."); } ! String rsp = null; stmt = connection.prepareStatement( "select responsibility_id " + "from fnd_responsibility " ! + "where responsibility_key = '" ! + responsibility ! + "'"); rs = stmt.executeQuery(); // execute if (rs.next()) { ! rsp = rs.getString(1); // retrieve responsibility_id } rs.close(); ! if (rsp == null) { throw new Exception("Responsibility " + responsibility + " not found."); } ! String appl = null; stmt = connection.prepareStatement( "select application_id from fnd_application where " ! + "application_short_name = '" ! + application ! + "'"); rs = stmt.executeQuery(); // execute if (rs.next()) { ! appl = rs.getString(1); // retrieve application_id } rs.close(); ! if (appl == null) { throw new Exception("Application " + application + " not found."); } --- 43,88 ---- PreparedStatement stmt = null; ! int usr = 0; stmt = connection.prepareStatement( "select user_id " + "from fnd_user " ! + "where user_name = ?"); ! stmt.setString(1, user); rs = stmt.executeQuery(); // execute if (rs.next()) { ! usr = rs.getInt(1); // retrieve user_id } rs.close(); ! if (usr == 0) { throw new Exception("User " + user + " not found."); } ! int rsp = 0; stmt = connection.prepareStatement( "select responsibility_id " + "from fnd_responsibility " ! + "where responsibility_key = ?"); ! stmt.setString(1, responsibility); rs = stmt.executeQuery(); // execute if (rs.next()) { ! rsp = rs.getInt(1); // retrieve responsibility_id } rs.close(); ! if (rsp == 0) { throw new Exception("Responsibility " + responsibility + " not found."); } ! int appl = 0; stmt = connection.prepareStatement( "select application_id from fnd_application where " ! + "application_short_name = ?"); ! stmt.setString(1, application); rs = stmt.executeQuery(); // execute if (rs.next()) { ! appl = rs.getInt(1); // retrieve application_id } rs.close(); ! if (appl == 0) { throw new Exception("Application " + application + " not found."); } *************** *** 95,105 **** cstmt = connection.prepareCall( "{ call apps.fnd_global.apps_initialize(" ! + "user_id => " ! + usr ! + ", resp_id => " ! + rsp ! + ", resp_appl_id => " ! + appl + ", security_group_id => null)}"); try { // the first call somethimes fails. --- 92,103 ---- cstmt = connection.prepareCall( "{ call apps.fnd_global.apps_initialize(" ! + "user_id => ?" ! + ", resp_id => ?" ! + ", resp_appl_id => ?" + ", security_group_id => null)}"); + cstmt.setInt(1, usr); + cstmt.setInt(2, rsp); + cstmt.setInt(3, appl); + try { // the first call somethimes fails. |
From: Jan C. <jan...@us...> - 2006-11-30 19:25:22
|
Update of /cvsroot/appsunit/web/htdocs In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv14351 Modified Files: index.html Log Message: Added reference to ARCHETYPE instructions. Index: index.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/index.html,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** index.html 12 Nov 2006 22:32:27 -0000 1.11 --- index.html 30 Nov 2006 19:25:19 -0000 1.12 *************** *** 104,109 **** The example project tests some core apps views, an creates a </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> ! <br> </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> </td> --- 104,110 ---- The example project tests some core apps views, an creates a </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> + The instructions are included in the <a href="http://appsunit.cvs.sourceforge.net/appsunit/project/resources/archetype/README?view=markup">readme</a>. ! <br><br> </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> </td> |
From: Jan C. <jan...@us...> - 2006-11-13 18:58:07
|
Update of /cvsroot/appsunit/web/htdocs/testguide In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv5911 Modified Files: AppsUnit Test Guide.html Log Message: Fix table width. Index: AppsUnit Test Guide.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/testguide/AppsUnit Test Guide.html,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** AppsUnit Test Guide.html 12 Nov 2006 22:32:27 -0000 1.11 --- AppsUnit Test Guide.html 12 Nov 2006 22:45:53 -0000 1.12 *************** *** 113,117 **** <p class="normal"></p> ! <table style="background-color: rgb(255, 255, 204); width: 706px; height: 125px;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> <col width="256*"> <thead> <tr> --- 113,117 ---- <p class="normal"></p> ! <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> <col width="256*"> <thead> <tr> |
From: Jan C. <jan...@us...> - 2006-11-13 18:56:34
|
Update of /cvsroot/appsunit/web/htdocs/testguide In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv320/testguide Modified Files: AppsUnit Test Guide.html Log Message: namedrop e-lusion.com (used their grayscale web icons). Index: AppsUnit Test Guide.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/testguide/AppsUnit Test Guide.html,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** AppsUnit Test Guide.html 12 Nov 2006 22:22:16 -0000 1.10 --- AppsUnit Test Guide.html 12 Nov 2006 22:32:27 -0000 1.11 *************** *** 409,413 **** <div style="font-family: Helvetica,Arial,sans-serif;" class="normal"><font size="-2">thank you <a ! href="http://e-lusion.com/design/greyscale/">http://e-lusion.com/design/greyscale/</a></font></div> </body> </html> --- 409,413 ---- <div style="font-family: Helvetica,Arial,sans-serif;" class="normal"><font size="-2">thank you <a ! href="http://e-lusion.com/design/greyscale/" target="_blank">http://e-lusion.com/design/greyscale/</a></font></div> </body> </html> |
From: Jan C. <jan...@us...> - 2006-11-13 18:38:01
|
Update of /cvsroot/appsunit/web/htdocs/testguide In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv19057 Modified Files: AppsUnit Test Guide.html Log Message: Restyle to reflect (some kind of) house style. Index: AppsUnit Test Guide.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/testguide/AppsUnit Test Guide.html,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** AppsUnit Test Guide.html 22 Sep 2006 16:21:47 -0000 1.4 --- AppsUnit Test Guide.html 12 Nov 2006 19:20:30 -0000 1.5 *************** *** 3,159 **** <head> - - - - <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> - - - - <title>AppsUnit Test Guide</title> - </head> ! <body> ! ! ! ! <h1 class="western">AppsUnit</h1> ! <table class="" style="text-align: left; width: 712px; height: 132px;" border="1" cellpadding="2" cellspacing="2"> <tbody> - - <tr> ! ! <td> ! ! ! <div>This project is just starting (08-SEP-2006).</div> ! ! ! ! ! ! <div>The aim is to create a toolkit that will support unit ! testing Oracle ! Apps bespoke code.</div> ! ! ! ! ! ! <div>There's no need to install anything on the Apps ! instances.</div> ! ! ! ! ! ! <div><br> ! ! ! ! Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.</div> ! ! </td> - - </tr> - - - - </tbody> </table> ! <p style="margin-bottom: 0cm;">Oracle ® e-business suite bespoke test toolkit</p> ! ! ! ! <h1 class="western">Test Guide</h1> ! ! ! ! <h2 class="western">Foreword</h2> ! ! ! ! <p>Although automation of functional test for ERP software is ! becoming common practice, unit testing and test driven development ! is less popular.<br> ! ! ! ! This project wants to promote unit testing, and ! test driven development, in the ERP community. We will do this by</p> ! ! ! ! <ul> ! ! ! ! <li> ! ! ! <p>showing that it can be done,</p> ! ! ! ! </li> ! ! ! ! <li> ! ! ! <p>providing usefull tools to facilitate testing.</p> ! ! ! ! </li> ! ! ! ! </ul> ! ! <p>This document describes how you can test your code.</p> ! <p>This is an open source project, independent from Oracle Corporation.</p> ! <p>"Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates."</p> ! <h2 class="western">Testing views</h2> ! <p>When creating database views, the most common failures are missing or duplicate records, and wrong data values.</p> ! ! ! <p>A wrong record count is mostly caused by incorrect joins. If you forget to define an outer join, your view will miss records. If you --- 3,72 ---- <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title>AppsUnit Test Guide</title> ! <link rel="stylesheet" href="../stylesheet.css" type="text/css"> + </head> ! <body style="background-color: rgb(204, 204, 204);"> + <br> + <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr> + <td style="text-align: center;"> + <p class="H0">AppsUnit</p> ! <p><span class="H1">Oracle ® ! e-business suite bespoke test toolkit</span> </p> </td> </tr> </tbody> </table> + <br> + <table style="background-color: rgb(255, 255, 255); width: 100%; text-align: center; margin-left: 0px; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> ! <tbody> + <tr> ! <td> ! <p class="H1">Test Guide</p> ! </td> ! </tr> + </tbody> + </table> + <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="0" cellspacing="1"> + <tbody> + <tr> ! <td><span class="H1">Testing views</span> ! <p class="normal">When creating database views, the ! most common failures are missing or duplicate records, and wrong data values.</p> ! <p class="normal">A wrong record count is mostly ! caused by incorrect joins. If you forget to define an outer join, your view will miss records. If you *************** *** 162,172 **** you'll get a lot of wrong records.</p> ! ! ! <p>You can avoid these mismatches by asserting that your view contains the correct number of records.<br> - - Most of the time there is one table in the view that is the driving table. It's the core table --- 75,82 ---- you'll get a lot of wrong records.</p> ! <p class="normal">You can avoid these mismatches by ! asserting that your view contains the correct number of records.<br> Most of the time there is one table in the view that is the driving table. It's the core table *************** *** 174,180 **** count of your view.</p> ! ! ! <p>When creating a view for order lines with additional item and customer info, the driver could be oe_order_lines_all. It's the number of order lines in the system that should decide how many rows --- 84,89 ---- count of your view.</p> ! <p class="normal">When creating a view for order ! lines with additional item and customer info, the driver could be oe_order_lines_all. It's the number of order lines in the system that should decide how many rows *************** *** 183,563 **** oe_order_headers_all.</p> ! <table border="1" bordercolor="#000000" cellpadding="4" cellspacing="0" width="100%"> ! ! ! ! <col width="256*"> <thead> <tr> ! ! ! <td valign="top" width="100%"> ! ! ! <p><u>How to test for missing or extra records in a view?</u></p> ! ! ! ! ! <p>Find the table that is the core of your view (the driving table).<br> - - Assert that the record count of the driving table matches the record count of your view.</p> ! ! ! ! ! <p><font face="Courier New, monospace">simpleCompare( “select count(*) from oe_order_lines_all”,<br> - - “select count(*) from xx_order_lines_view”);</font></p> ! </td> ! ! ! ! </tr> ! ! ! ! </thead> ! </table> ! ! ! ! <p><br> ! ! ! ! <br> ! ! ! ! </p> ! ! ! <p>You can create this test at the very begin of your view design phase. Then start by creating your basic view:</p> ! ! ! <p><font face="Courier New, monospace">create view xx_order_lines_view as <br> - - select<br> - - line_id <br> - - from<br> - - oe_order_lines_all<br> - - with read only;</font></p> ! ! ! <p>The tests will pass. You can now safely add extra fields and tables to the view. Run the tests again. If you forget an outer join, or create a cardinal join, your tests will fail.</p> ! ! ! <p>Validating the correctness of a field value in your view is straightforward. You write a quey that asserts wether your view returns the value you expect.</p> ! ! ! <p>If you want to validate the value for the customer, you could locate an example order line in your application and write down the customer name (the expectation). Then write a query to verify that your view returns this customer.</p> ! ! ! <p><font face="Courier New, monospace">select count(*) from xx_order_lines_view where<br> - - line_id = 25845<br> - - and customer_name = 'SOURCEFORGE';</font></p> ! <table border="1" bordercolor="#000000" cellpadding="4" cellspacing="0" width="100%"> ! ! ! ! <col width="256*"> <thead> <tr> ! ! ! ! <td valign="top" width="100%"> ! ! ! <p><u>How to test for correct field values in a view?</u></p> ! ! ! ! ! ! <p>Locate an example that has a known value for the field.<br> Assert that the view returns this expected value.</p> ! ! ! ! ! <p><font face="Courier New, monospace">simpleCompare( “select 1 from dual”,<br> - - “select count(*) from xx_order_lines_view where line_id = 23548<br> - - and item_description = 'Feature Request'”);</font></p> ! </td> ! ! ! ! </tr> ! ! ! ! </thead> ! </table> ! ! ! ! <p><br> ! ! ! ! <br> ! ! ! ! </p> ! ! ! <p>Add regression tests during the lifecycle of your view. Whenever you find a wrong value in your view, or when someone raises a bug against your view, create a test that fails for the given error.</p> ! ! ! <p style="font-style: normal;">If the error report says that your view reports that the order line was not closed, but the application shows that it's closed, you can create a regression test:</p> ! ! ! <p style="font-style: normal;"><font face="Courier New, monospace">select count(*) from xx_order_lines_view where<br> - - line_id = 12487 <br> - - and closed_status = 'Y';</font></p> ! ! ! <p>The test will pass when your bug is resolved. And because you add this test to the test suite, this bug will never have a chance of showing up again.</p> ! <table border="1" bordercolor="#000000" cellpadding="4" cellspacing="0" width="100%"> ! ! ! ! <col width="256*"> <thead> <tr> ! ! ! ! <td valign="top" width="100%"> ! ! ! <p><u>How to avoid regression?</u></p> ! ! ! ! <p>Create a regression test for each bug or error reported for your view.<br> - - Add the test to your test suite.</p> ! ! ! ! ! <p><font face="Courier New, monospace">simpleCompare( “select 0 from dual”,<br> - - “select count(*) from xx_order_lines_view where line_id = 48574<br> - - and payment_date < order_date”);</font></p> ! </td> ! </tr> ! </thead> ! </table> ! <p><br> ! <br> ! </p> ! <h2 class="western">Testing functions</h2> ! <p>The smartest way to test a database function is to write a query ! that validates if the function returns expected results.</p> ! <p>If you have a function that converts amounts from one currency to ! another, you can assert this as follows:</p> ! <p style="font-style: normal;"><font face="Courier New, monospace">select ! count(*) from dual where<br> ! xx_currency_spot_convert(<br> ! ! 1200, 'USD', 'EUR', '01-JAN-2001') = 1193;</font></p> ! <p>The test will pass when the function returns the correct value ! for these parameters,</p> ! <table border="1" bordercolor="#000000" cellpadding="4" cellspacing="0" width="100%"> ! <col width="256*"> ! <thead> ! <tr> ! <td valign="top" width="100%"> ! ! <p><u>How to test a stored function?</u></p> ! ! <p>Locate an example that has a known return value for a given ! set of parameters.<br> ! Assert that the function returns this ! expected value.</p> ! ! <p><font face="Courier New, monospace">simpleCompare( “select 1 ! from dual”,<br> ! “select count(*) from dual where <br> ! ! <span style="font-style: normal;">xx_currency_spot_convert(<br> ! ! 821.256, 'USD', 'USD', '19-JAN-2003') = 821.256</span>”)</font></p> ! </td> ! </tr> ! </thead> </table> - <p><br> <br> ! </p> ! <h2 class="western">Testing concurrent requests</h2> ! <p>To be written</p> <br> ! Sister project: <a href="http://junitpdfreport.sourceforge.net" target="_blank">JUnit PDF Report</a> ! <br> ! <br> ! <br> - <a href="http://sourceforge.net"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a> </body> </html> --- 92,389 ---- oe_order_headers_all.</p> + <p class="normal"></p> + <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! <col width="256*"> <thead> <tr> ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to test for ! missing or extra records in a view?</u></p> ! <p class="normal">Find the table that is the ! core of your view (the driving table).<br> Assert that the record count of the driving table matches the record count of your view.</p> ! <p><font face="Courier New, monospace">simpleCompare( “select count(*) from oe_order_lines_all”,<br> “select count(*) from xx_order_lines_view”);</font></p> + </td> + </tr> ! </thead> ! </table> ! <p class="normal">You can create this test at the ! very begin of your view design phase. Then start by creating your basic view:</p> ! <p><font face="Courier New, monospace">create ! view xx_order_lines_view as <br> select<br> line_id <br> from<br> oe_order_lines_all<br> with read only;</font></p> ! <p class="normal">The tests will pass. You can now ! safely add extra fields and tables to the view. Run the tests again. If you forget an outer join, or create a cardinal join, your tests will fail.</p> ! <p class="normal">Validating the correctness of a ! field value in your view is straightforward. You write a quey that asserts wether your view returns the value you expect.</p> ! <p class="normal">If you want to validate the value ! for the customer, you could locate an example order line in your application and write down the customer name (the expectation). Then write a query to verify that your view returns this customer.</p> ! <p><font face="Courier New, monospace">select count(*) from xx_order_lines_view where<br> line_id = 25845<br> and customer_name = 'SOURCEFORGE';</font></p> + <p></p> + <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! <col width="256*"> <thead> <tr> + <td style="width: 100%; vertical-align: top;"> + <p class="normal"><u>How to test for + correct field values in a view?</u></p> + <p class="normal">Locate an example that has a + known value for the field.<br> Assert that the view returns this expected value.</p> ! <p><font face="Courier New, monospace">simpleCompare( “select 1 from dual”,<br> “select count(*) from xx_order_lines_view where line_id = 23548<br> and item_description = 'Feature Request'”);</font></p> + </td> + </tr> ! </thead> ! </table> ! <p class="normal">Add regression tests during the ! lifecycle of your view. Whenever you find a wrong value in your view, or when someone raises a bug against your view, create a test that fails for the given error.</p> ! <p class="normal" style="font-style: normal;">If ! the error report says that your view reports that the order line was not closed, but the application shows that it's closed, you can create a regression test:</p> ! <p style="font-style: normal;"><font face="Courier New, monospace">select count(*) from xx_order_lines_view where<br> line_id = 12487 <br> and closed_status = 'Y';</font></p> ! <p class="normal">The test will pass when your bug ! is resolved. And because you add this test to the test suite, this bug will never have a chance of showing up again.</p> + <p></p> + <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! <col width="256*"> <thead> <tr> + <td style="width: 100%; vertical-align: top;"> + <p class="normal"><u>How to avoid + regression?</u></p> ! <p class="normal">Create a regression test for ! each bug or error reported for your view.<br> Add the test to your test suite.</p> ! <p><font face="Courier New, monospace">simpleCompare( “select 0 from dual”,<br> “select count(*) from xx_order_lines_view where line_id = 48574<br> and payment_date < order_date”);</font></p> + </td> + </tr> ! </thead> ! </table> + <br> + </td> ! </tr> + </tbody> + </table> + <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> + <tbody> + <tr> ! <td> ! <p class="H2">Testing functions</p> + <p class="normal">The smartest way to test a + database function is to write a + query + that validates if the function returns expected results.</p> + <p class="normal">If you have a function that + converts amounts from one currency + to + another, you can assert this as follows:</p> ! <p style="font-style: normal;"><font face="Courier New, monospace">select ! count(*) from dual where<br> + xx_currency_spot_convert(<br> + 1200, 'USD', 'EUR', '01-JAN-2001') = 1193;</font></p> ! <p class="normal">The test will pass when the ! function returns the correct value ! for these parameters.</p> + <p></p> + <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! <col width="256*"> <thead> <tr> ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to test a stored ! function?</u></p> ! <p class="normal">Locate an example that has a ! known return value for a ! given set of parameters.<br> ! Assert that the function returns this expected value.</p> ! <p><font face="Courier New, monospace">simpleCompare( ! “select 1 from dual”,<br> ! “select count(*) from dual where <br> ! <span style="font-style: normal;">xx_currency_spot_convert(<br> ! 821.256, 'USD', 'USD', '19-JAN-2003') = 821.256</span>”)</font></p> ! </td> ! </tr> ! </thead> ! </table> ! </td> ! </tr> ! ! </tbody> </table> <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> + <tbody> + <tr> ! <td><span class="H1">Testing concurrent ! requests</span> ! <p class="normal">To be written</p> + </td> + + </tr> + </tbody> + </table> <br> + <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> + <tbody> ! <tr> + <td style="background-color: rgb(255, 255, 255);"> + <div> + <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> + <tbody> ! <tr> + <td class="normal">Sister project: <a href="http://junitpdfreport.sourceforge.net/" target="_blank">JUnit + PDF Report</a></td> + <td style="text-align: right;"><a href="http://sourceforge.net/"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a></td> ! </tr> ! ! </tbody> ! </table> + </div> + </td> + + </tr> + + </tbody> + </table> </body> </html> |
From: Jan C. <jan...@us...> - 2006-11-13 18:37:57
|
Update of /cvsroot/appsunit/web/htdocs In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv14245 Modified Files: stylesheet.css index.html Log Message: Restyle to reflect (some kind of) house style. Index: index.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/index.html,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** index.html 3 Nov 2006 23:48:29 -0000 1.8 --- index.html 12 Nov 2006 20:32:22 -0000 1.9 *************** *** 1,183 **** ! <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ! <html> ! <head> ! ! <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> ! <title>Apps Unit</title> ! ! ! <link rel="stylesheet" href="stylesheet.css" type="text/css"> ! ! </head> ! ! ! <body style="background-color: rgb(204, 204, 204);"> ! ! <br> ! ! <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td style="text-align: center;"> ! <p class="H0">AppsUnit</p> ! ! <p><span class="H1">Oracle ® ! e-business suite bespoke test toolkit</span> </p> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255);" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td> <span class="H1">Foreword</span> <br> ! ! <span class="normal"><br> ! ! Although automation of ! functional test for ERP software ! is ! becoming common practice, unit testing and test driven development ! is less popular.</span><br> ! ! <span class="normal">This project wants to promote ! unit testing, and ! test driven development, in the ERP community. We will do this by</span> ! <ul class="normal"> ! ! <li> showing that it can be done, </li> ! ! <li> providing usefull tools to facilitate testing. </li> ! ! </ul> ! ! <span class="normal">There's no need to install ! anything on the Apps instances.<br> ! ! </span> ! <p><span class="normal">The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> ! helps you validating your code.<br> ! ! Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.</span></p> ! ! <span class="normal">This is an open source project, ! independent from Oracle Corporation.</span><br class="normal"> ! ! <span class="normal">"Oracle, JD Edwards, ! PeopleSoft, and Siebel are registered trademarks ! of Oracle Corporation and/or its affiliates."</span></td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td><span class="H2">Fast Start</span><br> ! ! <br> ! ! <span class="normal">You can start running your own ! testsuite by </span><a class="normal" href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> ! downloading the example project</a><span class="normal">, ! named </span><i class="normal">Archetype</i><span class="normal">.<br> ! ! The example project tests some core apps views, an creates a </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> ! ! <br> ! ! </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td> ! <div class="H1">Specification. </div> ! ! <p class="H2">Requirements </p> ! ! <span class="normal">The toolkit will provide ! the means to ! test Oracle e-business suite development. We will focuss on backend ! objects: views, packages and concurrent requests. </span><br class="normal"> ! ! <span class="normal">Utility objects will help ! to connect to ! the backend and create an environment as if your code was running ! from within the ERP.</span> ! <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td style="background-color: rgb(255, 255, 255);"> ! <div> ! <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td class="normal">Sister project: <a href="http://junitpdfreport.sourceforge.net/" target="_blank">JUnit ! PDF Report</a></td> ! ! <td style="text-align: right;"><a href="http://sourceforge.net/"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a></td> ! ! </tr> ! ! </tbody> ! </table> ! ! </div> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! </body> ! </html> --- 1,183 ---- ! <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ! <html> ! <head> ! ! <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> ! <title>Apps Unit</title> ! ! ! <link rel="stylesheet" href="stylesheet.css" type="text/css"> ! ! </head> ! ! ! <body> ! ! <br> ! ! <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td style="text-align: center;"> ! <p class="H0">AppsUnit</p> ! ! <p><span class="H1">Oracle ® ! e-business suite bespoke test toolkit</span> </p> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255);" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td> <span class="H1">Foreword</span> <br> ! ! <span class="normal"><br> ! ! Although automation of ! functional test for ERP software ! is ! becoming common practice, unit testing and test driven development ! is less popular.</span><br> ! ! <span class="normal">This project wants to promote ! unit testing, and ! test driven development, in the ERP community. We will do this by</span> ! <ul class="normal"> ! ! <li> showing that it can be done, </li> ! ! <li> providing usefull tools to facilitate testing. </li> ! ! </ul> ! ! <span class="normal">There's no need to install ! anything on the Apps instances.<br> ! ! </span> ! <p><span class="normal">The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> ! helps you validating your code.<br> ! ! Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.</span></p> ! ! <span class="normal">This is an open source project, ! independent from Oracle Corporation.</span><br class="normal"> ! ! <span class="normal">"Oracle, JD Edwards, ! PeopleSoft, and Siebel are registered trademarks ! of Oracle Corporation and/or its affiliates."</span></td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td><span class="H2">Fast Start</span><br> ! ! <br> ! ! <span class="normal">You can start running your own ! testsuite by </span><a class="normal" href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> ! downloading the example project</a><span class="normal">, ! named </span><i class="normal">Archetype</i><span class="normal">.<br> ! ! The example project tests some core apps views, an creates a </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> ! ! <br> ! ! </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td> ! <div class="H1">Specification. </div> ! ! <p class="H2">Requirements </p> ! ! <span class="normal">The toolkit will provide ! the means to ! test Oracle e-business suite development. We will focuss on backend ! objects: views, packages and concurrent requests. </span><br class="normal"> ! ! <span class="normal">Utility objects will help ! to connect to ! the backend and create an environment as if your code was running ! from within the ERP.</span> ! <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td style="background-color: rgb(255, 255, 255);"> ! <div> ! <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td class="normal">Sister project: <a href="http://junitpdfreport.sourceforge.net/" target="_blank">JUnit ! PDF Report</a></td> ! ! <td style="text-align: right;"><a href="http://sourceforge.net/"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a></td> ! ! </tr> ! ! </tbody> ! </table> ! ! </div> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! </body> ! </html> Index: stylesheet.css =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/stylesheet.css,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** stylesheet.css 12 Nov 2006 20:05:29 -0000 1.2 --- stylesheet.css 12 Nov 2006 20:32:22 -0000 1.3 *************** *** 1,5 **** /* Generated by CaScadeS, a stylesheet editor for Mozilla Composer */ ! .H1 { font-family: Arial,Helvetica,sans-serif; font-size: larger; font-weight: bold; --- 1,13 ---- /* Generated by CaScadeS, a stylesheet editor for Mozilla Composer */ ! body ! { ! background-color: #CCCCCC; ! font-family: Arial,Helvetica,sans-serif; ! font-size: 100%; ! } ! ! ! .H1 { font-family: Arial,Helvetica,sans-serif; font-size: larger; font-weight: bold; *************** *** 8,12 **** .normal { font-family: Arial,Helvetica,sans-serif; - font-size: small; font-weight: inherit; } --- 16,19 ---- |
From: Jan C. <jan...@us...> - 2006-11-13 18:05:46
|
Update of /cvsroot/appsunit/web/htdocs/testguide In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv28442/testguide Modified Files: AppsUnit Test Guide.html Log Message: Restyle to reflect (some kind of) house style. Index: AppsUnit Test Guide.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/testguide/AppsUnit Test Guide.html,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** AppsUnit Test Guide.html 12 Nov 2006 20:32:21 -0000 1.7 --- AppsUnit Test Guide.html 12 Nov 2006 21:07:43 -0000 1.8 *************** *** 44,48 **** <td> ! <p class="H1">Test Guide</p> </td> --- 44,66 ---- <td> ! ! <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td class="H1"> ! <p align="center">Test Guide</p> ! ! </td> ! ! <td align="right" valign="undefined"><a href="/index.html"><img style="border: 0px solid ; width: 30px; height: 30px;" alt="home" title="home" src="../images/greyscale_17.gif"></a></td> ! ! </tr> ! ! </tbody> ! </table> ! </td> |
From: Jan C. <jan...@us...> - 2006-11-13 18:05:17
|
Update of /cvsroot/appsunit/web/htdocs/images In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv28442/images Added Files: greyscale_17.gif Log Message: Restyle to reflect (some kind of) house style. --- NEW FILE: greyscale_17.gif --- (This appears to be a binary file; contents omitted.) |
From: Jan C. <jan...@us...> - 2006-11-13 18:05:09
|
Update of /cvsroot/appsunit/web/htdocs/testguide In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv14245/testguide Modified Files: AppsUnit Test Guide.html Log Message: Restyle to reflect (some kind of) house style. Index: AppsUnit Test Guide.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/testguide/AppsUnit Test Guide.html,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** AppsUnit Test Guide.html 12 Nov 2006 20:05:29 -0000 1.6 --- AppsUnit Test Guide.html 12 Nov 2006 20:32:21 -0000 1.7 *************** *** 12,20 **** ! <body style="background-color: rgb(204, 204, 204);"> <br> ! <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 12,20 ---- ! <body> <br> ! <table style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> *************** *** 61,65 **** <tr> ! <td class="normal normal"><span class="H1">Testing views</span> <p class="normal">When creating database views, the most common failures are --- 61,66 ---- <tr> ! <td class="normal normal"><span class="H1">Testing ! views</span> <p class="normal">When creating database views, the most common failures are *************** *** 355,359 **** <br> ! <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 356,360 ---- <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> <tbody> |
From: Jan C. <jan...@us...> - 2006-11-13 18:05:08
|
Update of /cvsroot/appsunit/web/htdocs In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv3761 Modified Files: stylesheet.css Log Message: Restyle to reflect (some kind of) house style. Index: stylesheet.css =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/stylesheet.css,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** stylesheet.css 3 Nov 2006 23:37:16 -0000 1.1 --- stylesheet.css 12 Nov 2006 20:05:29 -0000 1.2 *************** *** 17,23 **** } ! .H0 { font-family: Arial,Helvetica,sans-serif; ! color: rgb(51, 102, 102); font-size: x-large; } --- 17,27 ---- } ! .H0 { color: rgb(51, 102, 102); font-size: x-large; + font-family: Arial,Helvetica,sans-serif; + } + + .code { font-family: Courier New,Courier,monospace; + color: rgb(0, 0, 153); } |
From: Jan C. <jan...@us...> - 2006-11-13 18:05:03
|
Update of /cvsroot/appsunit/web/htdocs/testguide In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv3761/testguide Modified Files: AppsUnit Test Guide.html Log Message: Restyle to reflect (some kind of) house style. Index: AppsUnit Test Guide.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/testguide/AppsUnit Test Guide.html,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** AppsUnit Test Guide.html 12 Nov 2006 19:20:30 -0000 1.5 --- AppsUnit Test Guide.html 12 Nov 2006 20:05:29 -0000 1.6 *************** *** 61,65 **** <tr> ! <td><span class="H1">Testing views</span> <p class="normal">When creating database views, the most common failures are --- 61,65 ---- <tr> ! <td class="normal normal"><span class="H1">Testing views</span> <p class="normal">When creating database views, the most common failures are *************** *** 94,98 **** <p class="normal"></p> ! <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> <col width="256*"> <thead> <tr> --- 94,98 ---- <p class="normal"></p> ! <table style="background-color: rgb(255, 255, 204); width: 706px; height: 125px;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> <col width="256*"> <thead> <tr> *************** *** 110,114 **** count of your view.</p> ! <p><font face="Courier New, monospace">simpleCompare( “select count(*) from oe_order_lines_all”,<br> --- 110,114 ---- count of your view.</p> ! <p class="code"><font face="Courier New, monospace">simpleCompare( “select count(*) from oe_order_lines_all”,<br> *************** *** 126,130 **** phase. Then start by creating your basic view:</p> ! <p><font face="Courier New, monospace">create view xx_order_lines_view as <br> --- 126,130 ---- phase. Then start by creating your basic view:</p> ! <p class="code"><font face="Courier New, monospace">create view xx_order_lines_view as <br> *************** *** 156,160 **** your view returns this customer.</p> ! <p><font face="Courier New, monospace">select count(*) from xx_order_lines_view where<br> --- 156,160 ---- your view returns this customer.</p> ! <p class="code"><font face="Courier New, monospace">select count(*) from xx_order_lines_view where<br> *************** *** 180,184 **** Assert that the view returns this expected value.</p> ! <p><font face="Courier New, monospace">simpleCompare( “select 1 from dual”,<br> --- 180,184 ---- Assert that the view returns this expected value.</p> ! <p class="code"><font face="Courier New, monospace">simpleCompare( “select 1 from dual”,<br> *************** *** 207,211 **** that it's closed, you can create a regression test:</p> ! <p style="font-style: normal;"><font face="Courier New, monospace">select count(*) from xx_order_lines_view where<br> --- 207,211 ---- that it's closed, you can create a regression test:</p> ! <p class="code" style="font-style: normal;"><font face="Courier New, monospace">select count(*) from xx_order_lines_view where<br> *************** *** 237,241 **** Add the test to your test suite.</p> ! <p><font face="Courier New, monospace">simpleCompare( “select 0 from dual”,<br> --- 237,241 ---- Add the test to your test suite.</p> ! <p class="code"><font face="Courier New, monospace">simpleCompare( “select 0 from dual”,<br> *************** *** 269,273 **** <tr> ! <td> <p class="H2">Testing functions</p> --- 269,273 ---- <tr> ! <td class="normal"> <p class="H2">Testing functions</p> *************** *** 282,286 **** another, you can assert this as follows:</p> ! <p style="font-style: normal;"><font face="Courier New, monospace">select count(*) from dual where<br> --- 282,286 ---- another, you can assert this as follows:</p> ! <p class="code" style="font-style: normal;"><font face="Courier New, monospace">select count(*) from dual where<br> *************** *** 309,313 **** Assert that the function returns this expected value.</p> ! <p><font face="Courier New, monospace">simpleCompare( “select 1 from dual”,<br> --- 309,313 ---- Assert that the function returns this expected value.</p> ! <p class="code"><font face="Courier New, monospace">simpleCompare( “select 1 from dual”,<br> *************** *** 325,328 **** --- 325,330 ---- </table> + <br> + </td> |
From: Jan C. <jan...@us...> - 2006-11-13 18:04:46
|
Update of /cvsroot/appsunit/web/htdocs In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv320 Modified Files: index.html Log Message: namedrop e-lusion.com (used their grayscale web icons). Index: index.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/index.html,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** index.html 12 Nov 2006 22:00:33 -0000 1.10 --- index.html 12 Nov 2006 22:32:27 -0000 1.11 *************** *** 182,186 **** <div style="font-family: Helvetica,Arial,sans-serif;" class="normal"><font size="-2">thank you <a ! href="http://e-lusion.com/design/greyscale/">http://e-lusion.com/design/greyscale/</a></font></div> </body> </html> --- 182,186 ---- <div style="font-family: Helvetica,Arial,sans-serif;" class="normal"><font size="-2">thank you <a ! href="http://e-lusion.com/design/greyscale/" target="_blank">http://e-lusion.com/design/greyscale/</a></font></div> </body> </html> |
From: Jan C. <jan...@us...> - 2006-11-13 17:54:10
|
Update of /cvsroot/appsunit/web/htdocs/testguide In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv28120 Modified Files: AppsUnit Test Guide.html Log Message: namedrop e-lusion.com (used their grayscale web icons). Index: AppsUnit Test Guide.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/testguide/AppsUnit Test Guide.html,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** AppsUnit Test Guide.html 12 Nov 2006 22:00:32 -0000 1.9 --- AppsUnit Test Guide.html 12 Nov 2006 22:22:16 -0000 1.10 *************** *** 4,11 **** <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> ! <title>Apps Unit</title> ! <link rel="stylesheet" href="stylesheet.css" type="text/css"> </head> --- 4,11 ---- <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> ! <title>AppsUnit Test Guide</title> ! <link rel="stylesheet" href="../stylesheet.css" type="text/css"> </head> *************** *** 16,20 **** <br> ! <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 16,20 ---- <br> ! <table style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> *************** *** 37,41 **** <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255);" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 37,41 ---- <br> ! <table style="background-color: rgb(255, 255, 255); width: 100%; text-align: center; margin-left: 0px; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> *************** *** 43,83 **** <tr> ! <td> <span class="H1">Foreword</span> <br> ! ! <span class="normal"><br> ! Although automation of ! functional test for ERP software ! is ! becoming common practice, unit testing and test driven development ! is less popular.</span><br> ! <span class="normal">This project wants to promote ! unit testing, and ! test driven development, in the ERP community. We will do this by</span> ! <ul class="normal"> ! <li> showing that it can be done, </li> ! <li> providing usefull tools to facilitate testing. </li> ! </ul> ! <span class="normal">There's no need to install ! anything on the Apps instances.<br> ! </span> ! <p><span class="normal">The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> ! helps you validating your code.<br> ! Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.</span></p> - <span class="normal">This is an open source project, - independent from Oracle Corporation.</span><br class="normal"> ! <span class="normal">"Oracle, JD Edwards, ! PeopleSoft, and Siebel are registered trademarks ! of Oracle Corporation and/or its affiliates."</span></td> </tr> --- 43,68 ---- <tr> ! <td> ! <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> ! <tbody> ! <tr> ! <td class="H1"> ! <p align="center">Test Guide</p> ! </td> ! <td align="right" valign="undefined"><a href="/index.html"><img style="border: 0px solid ; width: 30px; height: 30px;" alt="home" title="home" src="../images/greyscale_17.gif"></a></td> ! </tr> ! </tbody> ! </table> ! </td> </tr> *************** *** 88,92 **** <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 73,77 ---- <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="0" cellspacing="1"> <tbody> *************** *** 94,111 **** <tr> ! <td><span class="H2">Fast Start</span><br> ! <br> ! <span class="normal">You can start running your own ! testsuite by </span><a class="normal" href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> ! downloading the example project</a><span class="normal">, ! named </span><i class="normal">Archetype</i><span class="normal">.<br> ! The example project tests some core apps views, an creates a </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> <br> ! </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> </td> </tr> --- 79,277 ---- <tr> ! <td class="normal normal"><span class="H1">Testing ! views</span> ! <p class="normal">When creating database views, the ! most common failures are ! missing ! or duplicate records, and wrong data values.</p> ! <p class="normal">A wrong record count is mostly ! caused by incorrect joins. If ! you ! forget to define an outer join, your view will miss records. If you ! don't use the propper join conditions, you might get duplicate ! records. If you forget the join conditions for one of the tables, ! you'll get a lot of wrong records.</p> ! <p class="normal">You can avoid these mismatches by ! asserting that your view ! contains the correct number of records.<br> ! Most of the time there is ! one table in the view that is the driving table. It's the core table ! of the view. Compare the record count of that table with the record ! count of your view.</p> ! ! <p class="normal">When creating a view for order ! lines with additional item and ! customer info, the driver could be oe_order_lines_all. It's the ! number of order lines in the system that should decide how many rows ! your view returns, not the number of items or customers you have. ! Your view should return exactly the same record count as table ! oe_order_headers_all.</p> ! ! <p class="normal"></p> ! ! <table style="background-color: rgb(255, 255, 204); width: 706px; height: 125px;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! ! <col width="256*"> <thead> <tr> ! ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to test for ! missing or extra records in a ! view?</u></p> ! ! <p class="normal">Find the table that is the ! core of your view (the driving ! table).<br> ! ! Assert that the record count of the driving table matches the record ! count of your view.</p> ! ! <p class="code"><font face="Courier New, monospace">simpleCompare( ! “select count(*) from oe_order_lines_all”,<br> ! ! “select count(*) from xx_order_lines_view”);</font></p> ! ! </td> ! ! </tr> ! ! </thead> ! </table> ! ! <p class="normal">You can create this test at the ! very begin of your view design ! phase. Then start by creating your basic view:</p> ! ! <p class="code"><font face="Courier New, monospace">create ! view ! xx_order_lines_view as <br> ! ! select<br> ! ! line_id <br> ! ! from<br> ! ! oe_order_lines_all<br> ! ! with read only;</font></p> ! ! <p class="normal">The tests will pass. You can now ! safely add extra fields and ! tables to the view. Run the tests again. If you forget an outer join, ! or create a cardinal join, your tests will fail.</p> ! ! <p class="normal">Validating the correctness of a ! field value in your view is ! straightforward. You write a quey that asserts wether your view ! returns the value you expect.</p> ! ! <p class="normal">If you want to validate the value ! for the customer, you could ! locate an example order line in your application and write down the ! customer name (the expectation). Then write a query to verify that ! your view returns this customer.</p> ! ! <p class="code"><font face="Courier New, monospace">select ! count(*) from ! xx_order_lines_view where<br> ! ! line_id = 25845<br> ! ! and customer_name ! = 'SOURCEFORGE';</font></p> ! ! <p></p> ! ! <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! ! <col width="256*"> <thead> <tr> ! ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to test for ! correct field values in a view?</u></p> ! ! <p class="normal">Locate an example that has a ! known value for the field.<br> ! ! Assert that the view returns this expected value.</p> ! ! <p class="code"><font face="Courier New, monospace">simpleCompare( ! “select 1 from dual”,<br> ! ! “select count(*) from xx_order_lines_view where line_id = ! 23548<br> ! ! and item_description = 'Feature Request'”);</font></p> ! ! </td> ! ! </tr> ! ! </thead> ! </table> ! ! <p class="normal">Add regression tests during the ! lifecycle of your view. ! Whenever ! you find a wrong value in your view, or when someone raises a bug ! against your view, create a test that fails for the given error.</p> ! ! <p class="normal" style="font-style: normal;">If ! the error report says ! that your view ! reports that the order line was not closed, but the application shows ! that it's closed, you can create a regression test:</p> ! ! <p class="code" style="font-style: normal;"><font face="Courier New, monospace">select ! count(*) from xx_order_lines_view where<br> ! ! line_id = 12487 <br> ! ! and ! closed_status = 'Y';</font></p> ! ! <p class="normal">The test will pass when your bug ! is resolved. And because you ! add ! this test to the test suite, this bug will never have a chance of ! showing up again.</p> ! ! <p></p> ! ! <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! ! <col width="256*"> <thead> <tr> ! ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to avoid ! regression?</u></p> ! ! <p class="normal">Create a regression test for ! each bug or error reported ! for your view.<br> ! ! Add the test to your test suite.</p> ! ! <p class="code"><font face="Courier New, monospace">simpleCompare( ! “select 0 from dual”,<br> ! ! “select count(*) from xx_order_lines_view where line_id = ! 48574<br> ! ! and payment_date < order_date”);</font></p> ! ! </td> ! ! </tr> ! ! </thead> ! </table> <br> ! </td> </tr> *************** *** 122,140 **** <tr> ! <td> ! <div class="H1">Specification. </div> ! <p class="H2">Requirements </p> ! <span class="normal">The toolkit will provide ! the means to ! test Oracle e-business suite development. We will focuss on backend ! objects: views, packages and concurrent requests. </span><br class="normal"> ! <span class="normal">Utility objects will help ! to connect to ! the backend and create an environment as if your code was running ! from within the ERP.</span> ! <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> </td> --- 288,348 ---- <tr> ! <td class="normal"> ! <p class="H2">Testing functions</p> ! <p class="normal">The smartest way to test a ! database function is to write a ! query ! that validates if the function returns expected results.</p> ! <p class="normal">If you have a function that ! converts amounts from one currency ! to ! another, you can assert this as follows:</p> ! <p class="code" style="font-style: normal;"><font face="Courier New, monospace">select ! count(*) from dual where<br> ! ! xx_currency_spot_convert(<br> ! ! 1200, 'USD', 'EUR', '01-JAN-2001') = 1193;</font></p> ! ! <p class="normal">The test will pass when the ! function returns the correct value ! for these parameters.</p> ! ! <p></p> ! ! <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! ! <col width="256*"> <thead> <tr> ! ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to test a stored ! function?</u></p> ! ! <p class="normal">Locate an example that has a ! known return value for a ! given set of parameters.<br> ! ! Assert that the function returns this expected value.</p> ! ! <p class="code"><font face="Courier New, monospace">simpleCompare( ! “select 1 from dual”,<br> ! ! “select count(*) from dual where <br> ! ! <span style="font-style: normal;">xx_currency_spot_convert(<br> ! ! 821.256, 'USD', 'USD', '19-JAN-2003') = 821.256</span>”)</font></p> ! ! </td> ! ! </tr> ! ! </thead> ! </table> ! ! <br> </td> *************** *** 147,151 **** <br> ! <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 355,378 ---- <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td><span class="H1">Testing concurrent ! requests</span> ! <p class="normal">To be written</p> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> <tbody> *************** *** 179,187 **** </tbody> </table> - <br> ! ! <div style="font-family: Helvetica,Arial,sans-serif;" class="normal"><font size="-2">thank you <a href="http://e-lusion.com/design/greyscale/">http://e-lusion.com/design/greyscale/</a></font></div> ! </body> </html> --- 406,413 ---- </tbody> </table> <br> ! <div style="font-family: Helvetica,Arial,sans-serif;" ! class="normal"><font size="-2">thank you <a ! href="http://e-lusion.com/design/greyscale/">http://e-lusion.com/design/greyscale/</a></font></div> </body> </html> |
From: Jan C. <jan...@us...> - 2006-11-13 17:54:07
|
Update of /cvsroot/appsunit/web/htdocs In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv18325 Modified Files: stylesheet.css index.html Log Message: Restyle to reflect (some kind of) house style. Index: index.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/index.html,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** index.html 12 Nov 2006 20:32:22 -0000 1.9 --- index.html 12 Nov 2006 22:00:33 -0000 1.10 *************** *** 179,183 **** </tbody> </table> ! </body> </html> --- 179,186 ---- </tbody> </table> ! <br> ! <div style="font-family: Helvetica,Arial,sans-serif;" ! class="normal"><font size="-2">thank you <a ! href="http://e-lusion.com/design/greyscale/">http://e-lusion.com/design/greyscale/</a></font></div> </body> </html> Index: stylesheet.css =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/stylesheet.css,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** stylesheet.css 12 Nov 2006 20:32:22 -0000 1.3 --- stylesheet.css 12 Nov 2006 22:00:33 -0000 1.4 *************** *** 9,13 **** ! .H1 { font-family: Arial,Helvetica,sans-serif; font-size: larger; font-weight: bold; --- 9,13 ---- ! .H1 { font-family: Arial,Helvetica,sans-serif; font-size: larger; font-weight: bold; |
From: Jan C. <jan...@us...> - 2006-11-13 17:45:29
|
Update of /cvsroot/appsunit/web/htdocs/testguide In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv18325/testguide Modified Files: AppsUnit Test Guide.html Log Message: Restyle to reflect (some kind of) house style. Index: AppsUnit Test Guide.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/testguide/AppsUnit Test Guide.html,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** AppsUnit Test Guide.html 12 Nov 2006 21:07:43 -0000 1.8 --- AppsUnit Test Guide.html 12 Nov 2006 22:00:32 -0000 1.9 *************** *** 4,11 **** <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> ! <title>AppsUnit Test Guide</title> ! <link rel="stylesheet" href="../stylesheet.css" type="text/css"> </head> --- 4,11 ---- <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> ! <title>Apps Unit</title> ! <link rel="stylesheet" href="stylesheet.css" type="text/css"> </head> *************** *** 16,20 **** <br> ! <table style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 16,20 ---- <br> ! <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> *************** *** 37,41 **** <br> ! <table style="background-color: rgb(255, 255, 255); width: 100%; text-align: center; margin-left: 0px; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 37,41 ---- <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255);" border="1" cellpadding="2" cellspacing="0"> <tbody> *************** *** 43,68 **** <tr> ! <td> ! <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> ! <tbody> ! <tr> ! <td class="H1"> ! <p align="center">Test Guide</p> ! </td> ! <td align="right" valign="undefined"><a href="/index.html"><img style="border: 0px solid ; width: 30px; height: 30px;" alt="home" title="home" src="../images/greyscale_17.gif"></a></td> ! </tr> ! </tbody> ! </table> ! </td> </tr> --- 43,83 ---- <tr> ! <td> <span class="H1">Foreword</span> <br> ! <span class="normal"><br> ! Although automation of ! functional test for ERP software ! is ! becoming common practice, unit testing and test driven development ! is less popular.</span><br> ! <span class="normal">This project wants to promote ! unit testing, and ! test driven development, in the ERP community. We will do this by</span> ! <ul class="normal"> ! <li> showing that it can be done, </li> ! <li> providing usefull tools to facilitate testing. </li> ! </ul> ! <span class="normal">There's no need to install ! anything on the Apps instances.<br> ! </span> ! <p><span class="normal">The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> ! helps you validating your code.<br> + Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home + on SourceForge.net</a> for more info.</span></p> ! <span class="normal">This is an open source project, ! independent from Oracle Corporation.</span><br class="normal"> ! ! <span class="normal">"Oracle, JD Edwards, ! PeopleSoft, and Siebel are registered trademarks ! of Oracle Corporation and/or its affiliates."</span></td> </tr> *************** *** 73,77 **** <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="0" cellspacing="1"> <tbody> --- 88,92 ---- <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> <tbody> *************** *** 79,277 **** <tr> ! <td class="normal normal"><span class="H1">Testing ! views</span> ! <p class="normal">When creating database views, the ! most common failures are ! missing ! or duplicate records, and wrong data values.</p> ! ! <p class="normal">A wrong record count is mostly ! caused by incorrect joins. If ! you ! forget to define an outer join, your view will miss records. If you ! don't use the propper join conditions, you might get duplicate ! records. If you forget the join conditions for one of the tables, ! you'll get a lot of wrong records.</p> ! ! <p class="normal">You can avoid these mismatches by ! asserting that your view ! contains the correct number of records.<br> ! ! Most of the time there is ! one table in the view that is the driving table. It's the core table ! of the view. Compare the record count of that table with the record ! count of your view.</p> ! ! <p class="normal">When creating a view for order ! lines with additional item and ! customer info, the driver could be oe_order_lines_all. It's the ! number of order lines in the system that should decide how many rows ! your view returns, not the number of items or customers you have. ! Your view should return exactly the same record count as table ! oe_order_headers_all.</p> ! ! <p class="normal"></p> ! ! <table style="background-color: rgb(255, 255, 204); width: 706px; height: 125px;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! ! <col width="256*"> <thead> <tr> ! ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to test for ! missing or extra records in a ! view?</u></p> ! ! <p class="normal">Find the table that is the ! core of your view (the driving ! table).<br> ! ! Assert that the record count of the driving table matches the record ! count of your view.</p> ! ! <p class="code"><font face="Courier New, monospace">simpleCompare( ! “select count(*) from oe_order_lines_all”,<br> ! ! “select count(*) from xx_order_lines_view”);</font></p> ! ! </td> ! ! </tr> ! ! </thead> ! </table> ! ! <p class="normal">You can create this test at the ! very begin of your view design ! phase. Then start by creating your basic view:</p> ! ! <p class="code"><font face="Courier New, monospace">create ! view ! xx_order_lines_view as <br> ! ! select<br> ! ! line_id <br> ! ! from<br> ! ! oe_order_lines_all<br> ! ! with read only;</font></p> ! ! <p class="normal">The tests will pass. You can now ! safely add extra fields and ! tables to the view. Run the tests again. If you forget an outer join, ! or create a cardinal join, your tests will fail.</p> ! ! <p class="normal">Validating the correctness of a ! field value in your view is ! straightforward. You write a quey that asserts wether your view ! returns the value you expect.</p> ! ! <p class="normal">If you want to validate the value ! for the customer, you could ! locate an example order line in your application and write down the ! customer name (the expectation). Then write a query to verify that ! your view returns this customer.</p> ! ! <p class="code"><font face="Courier New, monospace">select ! count(*) from ! xx_order_lines_view where<br> ! ! line_id = 25845<br> ! ! and customer_name ! = 'SOURCEFORGE';</font></p> ! ! <p></p> ! ! <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! ! <col width="256*"> <thead> <tr> ! ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to test for ! correct field values in a view?</u></p> ! ! <p class="normal">Locate an example that has a ! known value for the field.<br> ! ! Assert that the view returns this expected value.</p> ! ! <p class="code"><font face="Courier New, monospace">simpleCompare( ! “select 1 from dual”,<br> ! ! “select count(*) from xx_order_lines_view where line_id = ! 23548<br> ! ! and item_description = 'Feature Request'”);</font></p> ! ! </td> ! ! </tr> ! ! </thead> ! </table> ! ! <p class="normal">Add regression tests during the ! lifecycle of your view. ! Whenever ! you find a wrong value in your view, or when someone raises a bug ! against your view, create a test that fails for the given error.</p> ! ! <p class="normal" style="font-style: normal;">If ! the error report says ! that your view ! reports that the order line was not closed, but the application shows ! that it's closed, you can create a regression test:</p> ! ! <p class="code" style="font-style: normal;"><font face="Courier New, monospace">select ! count(*) from xx_order_lines_view where<br> ! ! line_id = 12487 <br> ! ! and ! closed_status = 'Y';</font></p> ! ! <p class="normal">The test will pass when your bug ! is resolved. And because you ! add ! this test to the test suite, this bug will never have a chance of ! showing up again.</p> ! ! <p></p> ! ! <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! ! <col width="256*"> <thead> <tr> ! ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to avoid ! regression?</u></p> ! ! <p class="normal">Create a regression test for ! each bug or error reported ! for your view.<br> ! ! Add the test to your test suite.</p> ! ! <p class="code"><font face="Courier New, monospace">simpleCompare( ! “select 0 from dual”,<br> ! ! “select count(*) from xx_order_lines_view where line_id = ! 48574<br> ! ! and payment_date < order_date”);</font></p> ! </td> ! </tr> ! </thead> ! </table> <br> ! </td> </tr> --- 94,111 ---- <tr> ! <td><span class="H2">Fast Start</span><br> ! <br> ! <span class="normal">You can start running your own ! testsuite by </span><a class="normal" href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> ! downloading the example project</a><span class="normal">, ! named </span><i class="normal">Archetype</i><span class="normal">.<br> ! The example project tests some core apps views, an creates a </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> <br> ! </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> </td> </tr> *************** *** 288,367 **** <tr> ! <td class="normal"> ! <p class="H2">Testing functions</p> ! ! <p class="normal">The smartest way to test a ! database function is to write a ! query ! that validates if the function returns expected results.</p> ! ! <p class="normal">If you have a function that ! converts amounts from one currency ! to ! another, you can assert this as follows:</p> ! ! <p class="code" style="font-style: normal;"><font face="Courier New, monospace">select ! count(*) from dual where<br> ! ! xx_currency_spot_convert(<br> ! ! 1200, 'USD', 'EUR', '01-JAN-2001') = 1193;</font></p> ! ! <p class="normal">The test will pass when the ! function returns the correct value ! for these parameters.</p> ! ! <p></p> ! ! <table style="background-color: rgb(255, 255, 204); width: 100%;" border="1" bordercolor="#000000" cellpadding="4" cellspacing="0"> ! ! <col width="256*"> <thead> <tr> ! ! <td style="width: 100%; vertical-align: top;"> ! <p class="normal"><u>How to test a stored ! function?</u></p> ! ! <p class="normal">Locate an example that has a ! known return value for a ! given set of parameters.<br> ! ! Assert that the function returns this expected value.</p> ! ! <p class="code"><font face="Courier New, monospace">simpleCompare( ! “select 1 from dual”,<br> ! ! “select count(*) from dual where <br> ! ! <span style="font-style: normal;">xx_currency_spot_convert(<br> ! ! 821.256, 'USD', 'USD', '19-JAN-2003') = 821.256</span>”)</font></p> ! ! </td> ! ! </tr> ! ! </thead> ! </table> ! ! <br> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! <tbody> ! <tr> ! <td><span class="H1">Testing concurrent ! requests</span> ! <p class="normal">To be written</p> </td> --- 122,140 ---- <tr> ! <td> ! <div class="H1">Specification. </div> ! <p class="H2">Requirements </p> ! <span class="normal">The toolkit will provide ! the means to ! test Oracle e-business suite development. We will focuss on backend ! objects: views, packages and concurrent requests. </span><br class="normal"> ! <span class="normal">Utility objects will help ! to connect to ! the backend and create an environment as if your code was running ! from within the ERP.</span> ! <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> </td> *************** *** 374,378 **** <br> ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> <tbody> --- 147,151 ---- <br> ! <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> <tbody> *************** *** 407,410 **** --- 180,187 ---- </table> + <br> + + <div style="font-family: Helvetica,Arial,sans-serif;" class="normal"><font size="-2">thank you <a href="http://e-lusion.com/design/greyscale/">http://e-lusion.com/design/greyscale/</a></font></div> + </body> </html> |
From: Jan C. <jan...@us...> - 2006-11-03 23:48:32
|
Update of /cvsroot/appsunit/web/htdocs In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv15913 Modified Files: index.html Log Message: Index: index.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/index.html,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** index.html 3 Nov 2006 23:37:16 -0000 1.7 --- index.html 3 Nov 2006 23:48:29 -0000 1.8 *************** *** 1,167 **** ! <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ! <html> ! <head> ! ! <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> ! <title>Apps Unit</title> ! ! ! <link rel="stylesheet" href="stylesheet.css" type="text/css"> ! ! </head> ! ! ! <body style="background-color: rgb(204, 204, 204);"> ! ! <br> ! <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td style="text-align: center;"> ! <p class="H0">AppsUnit</p> ! ! <p><span class="H1">Oracle ® ! e-business suite bespoke test toolkit</span> ! </p> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255);" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td> <span class="H1">Foreword</span> <br> ! ! <span class="normal"><br> ! ! Although automation of ! functional test for ERP software ! is ! becoming common practice, unit testing and test driven development ! is less popular.</span><br> ! ! <span class="normal">This project wants to promote ! unit testing, and ! test driven development, in the ERP community. We will do this by</span> ! <ul class="normal"> ! ! <li> showing that it can be done, </li> ! ! <li> providing usefull tools to facilitate testing. </li> ! ! </ul> ! ! <span class="normal">There's no need to install ! anything on the Apps instances.<br> ! ! </span> ! <p><span class="normal">The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> ! helps you validating your code.<br> ! ! Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.</span></p> ! ! <span class="normal">This is an open source project, ! independent from Oracle Corporation.</span><br class="normal"> ! ! <span class="normal">"Oracle, JD Edwards, ! PeopleSoft, and Siebel are registered trademarks ! of Oracle Corporation and/or its affiliates."</span></td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td><span class="H2"> ! Fast Start</span><br> ! <br> ! <span class="normal">You can start running your own testsuite by ! </span><a class="normal" href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> ! downloading the example project</a><span class="normal">, named </span><i class="normal">Archetype</i><span class="normal">.<br> ! The example project tests some core apps views, an creates a ! </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> ! <br> ! </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td> ! <div class="H1">Specification. ! </div> ! ! <p class="H2">Requirements ! </p> ! ! <span class="normal">The toolkit will provide ! the means to ! test Oracle e-business suite development. We will focuss on backend ! objects: views, packages and concurrent requests. ! </span><br class="normal"> ! ! <span class="normal">Utility objects will help ! to connect to ! the backend and create an environment as if your code was running ! from within the ERP.</span> ! <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> ! ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! <tbody> ! <tr> ! <td style="background-color: rgb(255, 255, 255);"> ! <div><a href="http://junitpdfreport.sourceforge.net/" target="_blank"></a> ! <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> ! <tbody> ! <tr> ! <td class="normal"> ! Sister project: <a href="http://junitpdfreport.sourceforge.net/" target="_blank">JUnit PDF Report</a></td> ! <td style="text-align: right;"><a href="http://sourceforge.net/"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a></td> ! </tr> ! </tbody> ! </table> ! </div> ! </td> ! </tr> ! </tbody> ! </table> ! </body> ! </html> --- 1,183 ---- ! <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ! <html> ! <head> ! ! <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> ! <title>Apps Unit</title> ! ! ! <link rel="stylesheet" href="stylesheet.css" type="text/css"> ! ! </head> ! ! ! <body style="background-color: rgb(204, 204, 204);"> ! ! <br> ! ! <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td style="text-align: center;"> ! <p class="H0">AppsUnit</p> ! ! <p><span class="H1">Oracle ® ! e-business suite bespoke test toolkit</span> </p> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255);" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td> <span class="H1">Foreword</span> <br> ! ! <span class="normal"><br> ! ! Although automation of ! functional test for ERP software ! is ! becoming common practice, unit testing and test driven development ! is less popular.</span><br> ! ! <span class="normal">This project wants to promote ! unit testing, and ! test driven development, in the ERP community. We will do this by</span> ! <ul class="normal"> ! ! <li> showing that it can be done, </li> ! ! <li> providing usefull tools to facilitate testing. </li> ! ! </ul> ! ! <span class="normal">There's no need to install ! anything on the Apps instances.<br> ! ! </span> ! <p><span class="normal">The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> ! helps you validating your code.<br> ! ! Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.</span></p> ! ! <span class="normal">This is an open source project, ! independent from Oracle Corporation.</span><br class="normal"> ! ! <span class="normal">"Oracle, JD Edwards, ! PeopleSoft, and Siebel are registered trademarks ! of Oracle Corporation and/or its affiliates."</span></td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td><span class="H2">Fast Start</span><br> ! ! <br> ! ! <span class="normal">You can start running your own ! testsuite by </span><a class="normal" href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> ! downloading the example project</a><span class="normal">, ! named </span><i class="normal">Archetype</i><span class="normal">.<br> ! ! The example project tests some core apps views, an creates a </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> ! ! <br> ! ! </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td> ! <div class="H1">Specification. </div> ! ! <p class="H2">Requirements </p> ! ! <span class="normal">The toolkit will provide ! the means to ! test Oracle e-business suite development. We will focuss on backend ! objects: views, packages and concurrent requests. </span><br class="normal"> ! ! <span class="normal">Utility objects will help ! to connect to ! the backend and create an environment as if your code was running ! from within the ERP.</span> ! <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! <br> ! ! <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td style="background-color: rgb(255, 255, 255);"> ! <div> ! <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> ! ! <tbody> ! ! <tr> ! ! <td class="normal">Sister project: <a href="http://junitpdfreport.sourceforge.net/" target="_blank">JUnit ! PDF Report</a></td> ! ! <td style="text-align: right;"><a href="http://sourceforge.net/"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a></td> ! ! </tr> ! ! </tbody> ! </table> ! ! </div> ! ! </td> ! ! </tr> ! ! </tbody> ! </table> ! ! </body> ! </html> |
From: Jan C. <jan...@us...> - 2006-11-03 23:37:22
|
Update of /cvsroot/appsunit/web/htdocs/images In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv11984/images Modified Files: junit.jpg Log Message: Restyling home page. Index: junit.jpg =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/images/junit.jpg,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 Binary files /tmp/cvscw9Akn and /tmp/cvstY7rz0 differ |
From: Jan C. <jan...@us...> - 2006-11-03 23:37:21
|
Update of /cvsroot/appsunit/web/htdocs In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv11984 Modified Files: index.html Added Files: stylesheet.css Log Message: Restyling home page. Index: index.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/index.html,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** index.html 30 Oct 2006 22:19:47 -0000 1.6 --- index.html 3 Nov 2006 23:37:16 -0000 1.7 *************** *** 3,208 **** <head> - - - - <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> - - - - <title>Apps Unit</title> - </head> - - - <body> ! <h1 class="western">AppsUnit</h1> ! ! - <table class="" style="text-align: left; width: 712px; height: 132px;" border="1" cellpadding="2" cellspacing="2"> <tbody> - - <tr> ! ! <td> ! ! ! <div> ! This project is just starting (08-SEP-2006).</div> ! ! ! ! ! <div> ! The aim is to create a toolkit that will support unit testing Oracle ! Apps bespoke code.</div> ! ! ! ! ! <div> ! There's no need to install anything on the Apps instances.</div> ! ! ! ! ! ! <div><br> ! ! The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> helps you validating your code.<br> ! ! ! ! Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.</div> ! </td> - - </tr> - - - - </tbody> </table> ! <br> ! Oracle ® e-business suite bespoke test toolkit ! <h2 class="western">Foreword</h2> ! <p>Although automation of functional test for ERP software is becoming common practice, unit testing and test driven development ! is less popular.<br> ! ! ! ! This project wants to promote unit testing, and ! test driven development, in the ERP community. We will do this by</p> ! ! ! ! <ul> ! <li> ! ! ! <p>showing that it can be done,</p> ! </li> ! <li> ! ! ! <p>providing usefull tools to facilitate testing.</p> ! </li> - </ul> - This document describes the specification for the toolkit.<br> <br> - This is an open source project, independent from Oracle Corporation.<br> - "Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates." ! <h2 class="western">Fast Start</h2> ! <p>You can start running your own testsuite by ! <a href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> ! downloading the example project</a>, named <i>Archetype</i>. </p> ! <p>The example project tests some core apps views, an creates a ! <a href="example/junit.pdf">pdf report</a> from the results.</p> ! <p><img border="0" src="images/junit.jpg" width="268" height="377"></p> ! <h2 class="western">Specification.</h2> ! <h3 class="western">Requirements</h3> ! <p style="margin-bottom: 0cm;">The toolkit will provide the means to test Oracle e-business suite development. We will focuss on backend ! objects: views, packages and concurrent requests.</p> ! ! ! <p style="margin-bottom: 0cm;">Utility objects will help to connect to the backend and create an environment as if your code was running ! from within the ERP.</p> ! ! ! <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> ! ! ! <p style="margin-bottom: 0cm;"></p> ! ! ! ! <p style="margin-bottom: 0cm;"><br> ! ! ! ! </p> ! ! ! ! <br> ! ! ! ! <br> ! ! ! ! <br> ! ! ! ! Sister project: <a href="http://junitpdfreport.sourceforge.net" target="_blank">JUnit PDF Report</a> ! <br> ! ! <br> <br> ! ! ! ! <a href="http://sourceforge.net"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a> </body> </html> --- 3,167 ---- <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title>Apps Unit</title> + <link rel="stylesheet" href="stylesheet.css" type="text/css"> ! </head> + <body style="background-color: rgb(204, 204, 204);"> + <br> + <table class="normal" style="background-color: rgb(255, 255, 255); width: 100%; text-align: left; margin-left: auto; margin-right: auto;" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr> + <td style="text-align: center;"> + <p class="H0">AppsUnit</p> ! <p><span class="H1">Oracle ® ! e-business suite bespoke test toolkit</span> ! </p> </td> </tr> </tbody> </table> + <table style="text-align: left; background-color: rgb(255, 255, 255);" border="1" cellpadding="2" cellspacing="0"> + <tbody> ! <tr> + <td> <span class="H1">Foreword</span> <br> + <span class="normal"><br> ! Although automation of ! functional test for ERP software ! is becoming common practice, unit testing and test driven development ! is less popular.</span><br> + <span class="normal">This project wants to promote + unit testing, and + test driven development, in the ERP community. We will do this by</span> + <ul class="normal"> + <li> showing that it can be done, </li> ! <li> providing usefull tools to facilitate testing. </li> + </ul> + <span class="normal">There's no need to install + anything on the Apps instances.<br> ! </span> ! <p><span class="normal">The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> ! helps you validating your code.<br> + Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home + on SourceForge.net</a> for more info.</span></p> + <span class="normal">This is an open source project, + independent from Oracle Corporation.</span><br class="normal"> ! <span class="normal">"Oracle, JD Edwards, ! PeopleSoft, and Siebel are registered trademarks ! of Oracle Corporation and/or its affiliates."</span></td> + </tr> + </tbody> + </table> <br> + <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! <tbody> + <tr> + <td><span class="H2"> + Fast Start</span><br> + <br> + <span class="normal">You can start running your own testsuite by + </span><a class="normal" href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> + downloading the example project</a><span class="normal">, named </span><i class="normal">Archetype</i><span class="normal">.<br> + The example project tests some core apps views, an creates a + </span><a class="normal" href="example/junit.pdf">pdf report</a><span class="normal"> from the results.<br> + <br> + </span><img style="border: 0px solid ; width: 725px; height: 398px;" alt="Example PDF Report" class="normal" src="images/junit.jpg"> + </td> ! </tr> + </tbody> + </table> ! <br> + <table style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> + <tbody> ! <tr> + <td> + <div class="H1">Specification. + </div> + <p class="H2">Requirements + </p> ! <span class="normal">The toolkit will provide the means to test Oracle e-business suite development. We will focuss on backend ! objects: views, packages and concurrent requests. ! </span><br class="normal"> ! <span class="normal">Utility objects will help to connect to the backend and create an environment as if your code was running ! from within the ERP.</span> ! <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> ! </td> + </tr> + </tbody> + </table> <br> ! <table class="normal" style="text-align: left; background-color: rgb(255, 255, 255); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! <tbody> ! <tr> ! <td style="background-color: rgb(255, 255, 255);"> ! <div><a href="http://junitpdfreport.sourceforge.net/" target="_blank"></a> ! <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> ! <tbody> ! <tr> ! <td class="normal"> ! Sister project: <a href="http://junitpdfreport.sourceforge.net/" target="_blank">JUnit PDF Report</a></td> ! <td style="text-align: right;"><a href="http://sourceforge.net/"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a></td> ! </tr> ! </tbody> ! </table> ! </div> ! </td> ! </tr> ! </tbody> ! </table> </body> </html> --- NEW FILE: stylesheet.css --- /* Generated by CaScadeS, a stylesheet editor for Mozilla Composer */ .H1 { font-family: Arial,Helvetica,sans-serif; font-size: larger; font-weight: bold; color: rgb(51, 102, 102); } .normal { font-family: Arial,Helvetica,sans-serif; font-size: small; font-weight: inherit; } .H2 { font-family: Arial,Helvetica,sans-serif; color: rgb(51, 102, 102); font-weight: bold; } .H0 { font-family: Arial,Helvetica,sans-serif; color: rgb(51, 102, 102); font-size: x-large; } |
From: Jan C. <jan...@us...> - 2006-10-30 22:19:48
|
Update of /cvsroot/appsunit/web/htdocs In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv32366 Modified Files: index.html Log Message: Archetype docs. Index: index.html =================================================================== RCS file: /cvsroot/appsunit/web/htdocs/index.html,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** index.html 28 Oct 2006 23:04:11 -0000 1.5 --- index.html 30 Oct 2006 22:19:47 -0000 1.6 *************** *** 5,10 **** - - --- 5,8 ---- *************** *** 12,17 **** - - --- 10,13 ---- *************** *** 24,35 **** - <h1 class="western">AppsUnit</h1> ! ! <table style="text-align: left; width: 712px; height: 132px;" class="" border="1" cellpadding="2" cellspacing="2"> ! --- 20,28 ---- <h1 class="western">AppsUnit</h1> ! <table class="" style="text-align: left; width: 712px; height: 132px;" border="1" cellpadding="2" cellspacing="2"> *************** *** 39,58 **** - <tr> - <td> - <div> This project is just starting (08-SEP-2006).</div> - - --- 32,46 ---- *************** *** 62,67 **** - - --- 50,53 ---- *************** *** 71,100 **** - - <div><br> - The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> helps you validating your code.<br> - Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.<br> ! <br> ! <table style="text-align: left; background-color: rgb(204, 204, 204); width: 100%;" border="1" cellpadding="2" cellspacing="0"> ! <tbody> ! <tr> ! <td>Look out for the release of an example test suite soon.<br> ! The suite will use some of the apps fnd views as an example.<br> ! These views will be unit tested, and the results will be available as html and pdf reports.</td> ! </tr> ! </tbody> ! </table> ! </div> ! --- 57,70 ---- <div><br> The <a href="testguide/AppsUnit%20Test%20Guide.html">Test Guide</a> helps you validating your code.<br> Please refer to the <a href="http://sourceforge.net/projects/appsunit">project home ! on SourceForge.net</a> for more info.</div> *************** *** 103,113 **** - </tr> - - --- 73,80 ---- *************** *** 117,123 **** - <br> - Oracle ® e-business suite bespoke test toolkit <h2 class="western">Foreword</h2> --- 84,88 ---- *************** *** 125,129 **** - <p>Although automation of functional test for ERP software is becoming common practice, unit testing and test driven development --- 90,93 ---- *************** *** 132,136 **** - This project wants to promote unit testing, and test driven development, in the ERP community. We will do this by</p> --- 96,99 ---- *************** *** 138,191 **** - <ul> - <li> - <p>showing that it can be done,</p> - </li> - <li> - <p>providing usefull tools to facilitate testing.</p> - </li> - </ul> - This document describes the specification for the toolkit.<br> - <br> - This is an open source project, independent from Oracle Corporation.<br> - "Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates." ! <h2 class="western">Specification.</h2> - <h3 class="western">Requirements</h3> --- 101,152 ---- <ul> <li> <p>showing that it can be done,</p> </li> <li> <p>providing usefull tools to facilitate testing.</p> </li> </ul> This document describes the specification for the toolkit.<br> <br> This is an open source project, independent from Oracle Corporation.<br> "Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates." ! <h2 class="western">Fast Start</h2> + <p>You can start running your own testsuite by + <a href="http://sourceforge.net/project/showfiles.php?group_id=176804&package_id=203456&release_id=449807"> + downloading the example project</a>, named <i>Archetype</i>. </p> + <p>The example project tests some core apps views, an creates a + <a href="example/junit.pdf">pdf report</a> from the results.</p> + <p><img border="0" src="images/junit.jpg" width="268" height="377"></p> + + + <h2 class="western">Specification.</h2> + <h3 class="western">Requirements</h3> + *************** *** 197,201 **** - <p style="margin-bottom: 0cm;">Utility objects will help to connect to --- 158,161 ---- *************** *** 204,242 **** - <p style="margin-bottom: 0cm;"><img style="width: 281px; height: 361px;" alt="Analysis Model" src="images/AnalysisModel.jpg"></p> - <p style="margin-bottom: 0cm;"></p> - <p style="margin-bottom: 0cm;"><br> - </p> - <br> - <br> - <br> - Sister project: <a href="http://junitpdfreport.sourceforge.net" target="_blank">JUnit PDF Report</a> <br> --- 164,194 ---- *************** *** 244,258 **** - <br> - <br> - <a href="http://sourceforge.net"><img src="http://sflogo.sourceforge.net/sflogo.php?group_id=176804&type=1" alt="SourceForge.net Logo" border="0" height="31" width="88"></a> </body> --- 196,207 ---- |
From: Jan C. <jan...@us...> - 2006-10-30 22:19:30
|
Update of /cvsroot/appsunit/web/htdocs/images In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv32343/images Added Files: junit.jpg Log Message: Archetype docs. --- NEW FILE: junit.jpg --- (This appears to be a binary file; contents omitted.) |
From: Jan C. <jan...@us...> - 2006-10-30 22:19:30
|
Update of /cvsroot/appsunit/web/htdocs/example In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv32343/example Added Files: junit.pdf Log Message: Archetype docs. --- NEW FILE: junit.pdf --- (This appears to be a binary file; contents omitted.) |
From: Jan C. <jan...@us...> - 2006-10-30 22:17:13
|
Update of /cvsroot/appsunit/web/htdocs/example In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv31494/example Log Message: Directory /cvsroot/appsunit/web/htdocs/example added to the repository |
From: Jan C. <jan...@us...> - 2006-10-30 21:41:07
|
Update of /cvsroot/appsunit/project/resources/archetype In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv11640/resources/archetype Modified Files: build.xml Added Files: README Log Message: Added junitpdfreport, added insructions. --- NEW FILE: README --- http://sourceforge.net/projects/appsunit/ Getting started: ----------------- 1. Required software -------------------- You need the Oracle jdbc driver library (ojdbc14.jar) on your computer. As the library is not open source, it's not distributed with this package. The library can be downloaded from: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html You need java jdk 1.5 or higher, available from http://java.sun.com You need Ant 1.7 or higher, available from http://ant.apache.org 2. configuration ---------------- Rename build.properties.sample to build.properties. Edit build.properties with a text editor: db.jar has to point to your ojdbc14.jar file example: db.jar=c:/library_home/oracle/ojdbc14.jar db.uri has to point to your Oracle Apps test instance's database. example: db.uri=jdbc:oracle:thin:apps/3q4Q8@myserver:1521:ORAC More info on the connect string is available on Oracle's web: http://download-uk.oracle.com/docs/cd/B19306_01/java.102/b14355/basic.htm#i1006650 3. run the test --------------- >From the project's root directory, run: ant build test Look for the pdf report in the build/test/testreport/pdf subdirectory. Look for the html report in the build/test/testreport/html-noframes subdirectoy Index: build.xml =================================================================== RCS file: /cvsroot/appsunit/project/resources/archetype/build.xml,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** build.xml 30 Oct 2006 11:07:59 -0000 1.3 --- build.xml 30 Oct 2006 21:40:58 -0000 1.4 *************** *** 1,4 **** --- 1,7 ---- <?xml version="1.0" encoding="UTF-8"?> <project name="Apps Unit Tests" default="all" basedir="."> + + <import file="junitpdfreport/build-junitpdfreport.xml"/> + <property file="build.properties"/> *************** *** 31,35 **** <target name="test" description="Run the test scenarios" depends="build"> <mkdir dir="${test.result.dir}"/> - <echo message="${db.uri}"/> <junit printsummary="yes" fork="yes" forkmode="once" haltonfailure="no"> <sysproperty key="db.driver" value ="${db.driver}"/> --- 34,37 ---- *************** *** 44,51 **** <classpath refid="classpath"/> </junit> </target> ! ! ! <target name="all" depends="init,build,test" description="Run all targets"> --- 46,67 ---- <classpath refid="classpath"/> </junit> + <replace dir="${test.result.dir}" token="${db.uri}" value="hidden"> + <include name="**/TEST-*.xml"/> + </replace> + <mkdir dir="${test.report.dir}/html-noframes"/> + <junitreport todir="${test.report.dir}"> + <fileset dir="${test.result.dir}"> + <include name="TEST-*.xml"/> + </fileset> + <report format="noframes" todir="${test.report.dir}/html-noframes"/> + </junitreport> + <mkdir dir="${test.report.dir}/pdf"/> + <junitpdfreport todir="${test.report.dir}/pdf" styledir="default"> + <fileset dir="${test.result.dir}"> + <include name="TEST-*.xml"/> + </fileset> + </junitpdfreport> </target> ! <target name="all" depends="init,build,test" description="Run all targets"> |