FitNesse Book and Improvement

[red1]

You can read an online book still in progress here http://red1.org/iDempiereFitNesse.pdf
The improvement to roll back or commit option is made as a plugin and described here http://wiki.idempiere.org/en/Plugin:_FitNesse_RollBack. It includes https://idempiere.atlassian.net/browse/IDEMPIERE-2859 patch.
To use it, just install the linked fixture plugin, and start it, without starting the other fixture plugin.
You may submit any comments, suggestions for improvements or contribution to improve in this forum.
This work is under the auspices of SYSNOVA, Bangladesh who sponsors most of my contributions and testing effort.

[red1]

More goodies. I made a new Fixture to handle 'Create Record Auto' which will try to create your table record without entering any data setting! This assume that you want to test if your table can be populated as full as possible at will, saving you the tedious task of putting in every column data. This is even more useful when you just created a new table and want to quickly test it.

However I made a cooler thing that you can add more specific rows setting as usual under that within the same CreateAutoRecord template in order to control any field value!

Just check the new CreateRecordAuto.java in the patch at http://sourceforge.net/projects/red1/files/Testing/. Use the jar plugin to replace the one already in iDempiere to get these cool features.
Note below how the CreateAutoRecord only needs an empty line to make it work. So you can go lazy or half lazy with this. Then after that, other templates are usable as seen below.

CreateRecordAuto.png (47.92 KiB) Viewed 8252 times

When tested, everything goes well.

AutoFixtureResults.png (85.13 KiB) Viewed 8252 times

Below we see a pristine example where i am able to test a new Forecast master-detail set with blank row line in each table, and just pass the parent ID over. The processing of it also returned 1 extra making it 51 new PO forecastlines as compared to 50 proven elsewhere.

ForecastMasterDetail.png (73.89 KiB) Viewed 8243 times

[red1]

[red1]

[red1]

Now I add another follow through test to Generate POs from the PO FOrecasts and here are the results:

GenerateForecastPOs.png (48.05 KiB) Viewed 8214 times

Note that the POs are consolidated to respective vendors and returned message of success.

I also renamed all packages to be unique to individual plugin project on advice from Hiep LQ to avoid name clash in future from other future new plugins. I have reissued fresh 2Packs and pushed all code changes to respective bitbucket repos.

[red1]

Another big improvement to the testing arsenal that now includes Info Window!

Screen Shot 2015-09-29 at 1.41.00 AM.png (46.76 KiB) Viewed 8207 times

Now any InfoWindow can be tested! Just specify the Info Window name in the first box and then specify its associated InfoProcess using the same Run Process box and it will pick up the first record derived from the InfoWindow. This can effectively test generically that Info Window itself, the defined SQL and WHERE clauses execution is working with its passing via PInstance into T_Selection table to successfully pick up the trail and when processed, returns the result output to the test.

[red1]

New test script underway specifically for Libero Manufacturing based on test plan contributed by SYSNOVA, Bangladesh uploaded here .
Results of first set of test:

Screen Shot 2015-10-20 at 11.18.59 AM.png (72.3 KiB) Viewed 8056 times

READ TO CONFIRM DATA IS PRESENT BEFORE FURTHER TESTS

!include -c AaAdminLogin

!|Read Record|
|*Table* |PP_Product_BOM |
|PP_Product_BOM_ID |@Ref=PP_Product_BOM[Value='Fertilizer'].PP_Product_BOM_ID|
|*Read* | |
|Name||

UPDATE CURRENTCOSTPRICE FOR LABOR OF FERTILIZER
!|Update Record|
|*Table*|M_Cost|
|*WHERE*|M_CostElement_ID=105 AND M_Product_ID = 50025|
|*Update*||
|CurrentCostPrice|15|

UPDATE CURRENTCOSTPRICE FOR OVERHEAD OF FERTILIZER
!|Update Record|
|*Table*|M_Cost|
|*WHERE*|M_CostElement_ID=50001 AND M_Product_ID = 50025|
|*Update*||
|CurrentCostPrice|15|

UPDATE BOMTYPE OF FERTILIZER TO 'MAKE-TO-ORDER'
!|Update Record|
|*Table*|PP_Product_BOM|
|*WHERE*|PP_Product_BOM_ID=50006|
|*Update*||
|BOMType|O|

!|Read Record|
|*Table* |C_bpartner |
|c_bpartner_id |@Ref=c_bpartner[Value='SeedFarm'].c_bpartner_id|
|*Read* | |
|actuallifetimevalue| |
|so_creditused | |
|totalopenbalance | |

Create sales order

!|Create Record|
|*Table* |C_Order |
|ad_org_id |50001 |
|c_doctypetarget_id |@Ref=c_doctype[Name='Standard Order'].c_doctype_id|
|salesrep_id |101 |
|dateordered |2009-03-25 00:00:00.0 |
|c_bpartner_id |@c_bpartner.c_bpartner_id@ |
|c_bpartner_location_id|114 |
|paymentrule |B |
|m_warehouse_id |50002 |
|m_pricelist_id |101 |
|ad_user_id |105 |
|*Save* | |

!|Create Record|
|*Table* |C_OrderLine |
|c_order_id |@C_order.c_Order_id@ |
|ad_org_id |@C_Order.AD_Org_ID@ |
|m_product_id|@Ref=M_Product[Value='Fertilizer'].M_Product_ID|
|qtyentered |2 |
|qtyordered |2 |
|*Save* | |

Complete the sales order
!|Run Process|
|*ProcessValue*|C_Order Process |
|*RecordID* |@C_Order.C_Order_ID@|
|*DocAction* |CO |
|*Run* | |

CALCULATE MATERIAL PLAN
!|Run Process|
|*ProcessValue*|PP_Calculate Material Plan |
|AD_Org_ID |@Ref=AD_Org[Value='Fertilizer'].AD_Org_ID|
|S_Resource_ID|@Ref=S_Resource[Value='Fertilizer Plant'].S_Resource_ID|
|M_Warehouse_ID|@Ref=M_Warehouse[Value='Fertilizer'].M_Warehouse_ID|
|*Run* | |

!|RollBack|
|*RollBack*|TRUE|

[red1]