workbc-survey

A repository to hold templates and code for the WorkBC Surveys.

Docker Installation and Setup

Step 1: Install Docker

Make sure you have Docker installed on your machine. You can download and install Docker from the Docker official website.

Step 2: Verify Docker installation

After installing Docker, open a terminal and run the following command to verify that Docker is installed correctly:

docker --version

Setup the Postgres Database

Run the following command to start a new PostgreSQL database:

docker run --name postgres -e POSTGRES_PASSWORD=mysecretpassword -e POSTGRES_USER=myuser -p 5432:5432 -d postgres

Run the ./SQL/create_table.sql SQL on the database after connection. This will create the tables surveys and recipients.

Node-Cron Application Installation and Setup

Step 1: Install Node.js and npm

Make sure you have Node.js and npm (Node Package Manager) installed on your machine. You can download and install them from Node.js official website.

Step 2: cd into cron and install all packages

Run the following commands

cd cron
npm install

Step 3: fill out the .env with the required environment variables

Check .env.example to fill out all environment variables, this can also be taken from the production application.

Step 4: Run the following command to start the CRON job:

npx nodemon app.ts