#!/usr/bin/env bash
set -e

# Charge les variables du fichier .env si present.
if [ -f .env ]; then
  set -a
  . ./.env
  set +a
fi

: "${PGHOST:?PGHOST manquant}"
: "${PGPORT:=5432}"
: "${PGDATABASE:?PGDATABASE manquant}"
: "${PGUSER:?PGUSER manquant}"

psql "host=$PGHOST port=$PGPORT dbname=$PGDATABASE user=$PGUSER sslmode=${PGSSLMODE:-disable}" -f sql/01_views_capteurs.sql
psql "host=$PGHOST port=$PGPORT dbname=$PGDATABASE user=$PGUSER sslmode=${PGSSLMODE:-disable}" -f sql/02_indexes_recommandes.sql