View source | View content page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

Projects:Configurable Update Analytics Fact Tables Process/QA

Manual Tests

Different manual tests have been done along this project, testing different combinations for the process configuration.

It has been put special attention on boundaries, i.e., the behavior on those fact records related to the dates defined as the limits of the process execution.

This is the summary of individual executions of the Forward and Backward processes for every possible configuration:


Forward Start Date Forward Batch Size Backward Start Date Backward Batch Size Forward Process Backward Process Test Result
Not defined Not defined Not defined Not defined Calculated all fact records Nothing calculated. Detected an invalid configuration. OK
09-06-2015 Not defined Not defined Not defined Calculated all fact records from 09-06-2015 until now.
Records for 09-06-2015 are created.
Calculated all fact records from the beginning until 09-06-2015.
Records for 09-06-2015 are not created.
OK
Not defined 100 Not defined Not defined Calculated the first 100 fact records. Nothing calculated. Detected an invalid configuration. OK
09-06-2015 100 Not defined Not defined Calculated the first 100 fact records starting from 09-06-2015.
Records for 09-06-2015 are created.
Calculated all fact records from the beginning until 09-06-2015.
Records for 09-06-2015 are not created.
OK
09-06-2015 100 05-05-2015 Not defined Calculated the first 100 fact records starting from 09-06-2015.
Records for 09-06-2015 are created.
Calculated all fact records between 05-05-2015 and 09-06-2015.
Records for 05-05-2015 are created. Records for 09-06-2015 are not created.
OK
09-06-2015 100 Not defined 100 Calculated the first 100 fact records starting from 09-06-2015.
Records for 09-06-2015 are created.
Calculated the last 100 records previous to 09-06-2015.
Records for 09-06-2015 are not created.
OK
09-06-2015 100 05-05-2015 100 Calculated the first 100 fact records starting from 09-06-2015.
Records for 09-06-2015 are created.
Calculated the last 100 records between 05-05-2015 and 09-06-2015.
Records for 05-05-2015 are created if reached with batch size. Records for 09-06-2015 are not created.
OK


Together with this, it has also been tested the following:

  1. If there not exists any configuration, all the fact records are created when launching the Forward process.
  2. If there not exists any configuration, the Backward process detects it and it does not create anything.
  3. It is not possible to create a configuration having a backward start date greater or equal than the forward start date.
  4. If the batch size is 0, no records are created.

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Configurable_Update_Analytics_Fact_Tables_Process/QA"

This page has been accessed 583 times. This page was last modified on 13 February 2017, at 14:12. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.