#!/bin/bash
# init-db.sh

# Arrête le script si une commande échoue
set -e

echo "Enabling postgis_raster"
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    -- Activation de l'extension pour le raster
    CREATE EXTENSION IF NOT EXISTS postgis_raster;
EOSQL

echo "Init database data with RGF93"
raster2pgsql -s EPSG:2154 -I -C -M /opt/RAF20_lambert93.tiff -F -t 100x100 public.raf20lambert93 | psql -U ${POSTGRES_USER} -d ${POSTGRES_DB}
exit $?

echo "Create postgrest roles"

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    CREATE ROLE webanon nologin;
    GRANT USAGE ON SCHEMA raf20lamber93 TO webanon;
    GRANT SELECT ON SCHEMA raf20lamber93 TO webanon;
    GRANT web_anon to ${POSTGRES_USER}
EOSQL