First sprint of this dev branch.
Fixes bugs that were inserted when changing the database schema. The new database schema makes possible to store the faulty systems history.
Hopefully, the definitive SQLite database schema.
Implemented connect_and_prepare() subroutine. A new subroutine responsible of connecting to the SQLite table (just once) and prepare the tables.
Change how faulty systems are retrieved. Merged everything into one complex subroutine, get_faulty_systems(), that handles all the internals of querying ESL and Reporter. Returns the result set ready to be inserted into the DHCR database.
Fixes a little where only systems with an ESL record were being inserted into the SQLite database.
Changed name convention of tables to CamelCase. Enforced lowercase in ESL Oracle columns.
Implemented calc_additions() and calc_deletions() subroutines.
Added comments to calc_additions() and calc_deletions() subroutines.
Re-engineered how faulty systems are gathered and how ESL and Reporter databases are queried and how DHCR is populated. One subroutine, initialize(), and three separate DB connection subroutines.
Database subroutines were practically rewritten. Changed config parameters ESLEnable and SMTPEnable valid values to 1 and 0, instead of 'on' and 'off'.
The hosts and bulk_discovery.txt files, and HostsFile and BulkDiscovery tables, are parsed and populated respectively at the same time.
Moved imports (use statements) to the head of the file.
Tons of refactoring. The coda suffered significant changes. This is what will be merged with master, plus some slight modification maybe. The application is fully functional.
Fixed a couple of non-docuemented bugs with the hosts and bulk_discovery.txt files tests. Doing QA of report.
Passed QA after checking some systems. Now merging with master branch.