| |
3.1 Initial Application Workflow
- Read in the APIS translation defintions file in to a hash of arrays of hashes e.g. definitionHash{"table name"}->Arr[i]->{{"column"}, {"tag"}, {"multiple"}, {"secondary"}, {"pk"}, {"fk"}, {"value"}}
- sort the arrays contained in the difinitionsHash
- when creating the queries, sort hash by pk then column
- store the tags and their values in a tag hash, tagHash
- loop through the definitionsHash, for each entry generate a query, loop through the query, set all relevant values, continue on with the definitionsHash values
- When a a foreign key is found in the definitions file, store the forign key column and its value in a hash and run a query for that table using the fk value as the search criteria.
- after the query, in a loop through the array in definitionHash{"table name"}, select the columns of the query from the array and set the value into an @outputArray
- Write the output array into a loader file
- continue with the next record
- write the status report and exit
3.2 Application Design
3.3 Enhancements and Code Updates
|
|
