ETL FFLCH

Deployment instructions

1. First, have all the project's dependencies installed:

composer install

2. Make a copy of .env.example and configure your .env:

cp .env.example .env

3. After your database is set up, you may create (or recreate) the tables with

php builder.php

To bypass the confirmation prompt and force rebuild, you can simply pass the -y parameter.

4. Once you have created them, data can be inserted (or updated) whenever needed by:

php main.php

To force build/rebuild while running main.php, you can pass the -f parameter.

5. To check the last time the ETL scripts were executed, use the check.php script:

php check.php

6. Finally, if you'd like to drop all tables, you may run:

php drop.php