Before you first run this code, please install composer and run:

# composer install

Once this is done, you can then run the required queries.

 USAGE:
   EstimateOne.php <OPTIONS> <COMMAND> ...

   EstimateOne Data Processor


OPTIONS:
   -v, --version                                                         Print Version

   -h, --help                                                            Display this help screen and exit immediately.

   --no-colors                                                           Do not use any colors in output. Useful when piping output to other tools or files.

   --loglevel <level>                                                    Minimum level of messages to display. Default is info. Valid levels are: debug, info, notice, success, warning, error, critical, alert, emergency.


COMMANDS:
   This tool accepts a command as first parameter as outlined below:


   new

     Fetch Tenders and Builders for the past 3 days and insert or update the database,  This includes updating existing tenders which have had status and data changes in that 3 day period.


   update

     Update Tenders and Builders data across the whole database, initially this will be only on records which do not had a "lastDbUpdate" set for the tender.  After that, we'll settle on a time period if data isn't routinely kept up to date.

USAGE EXAMPLES:

    php ./bin/EstimateOne.php new
