#!/bin/bash

# Load the .env file
export $(grep -v '^#' .env | xargs)

# Check if DB_USERNAME and DB_PASSWORD are available
#if [[ -z "$DB_USER" || -z "$DB_PASSWORD" ]]; then
# echo "DB_USERNAME and DB_PASSWORD must be set"
# exit 1
#fi

# Replace values in settings.php
#
sed -i "s|'database' => .*|'database' => '${DB_NAME}',|" /opt/drupal/web/sites/default/settings.php
sed -i "s|'username' => .*|'username' => '${DB_USER}',|" /opt/drupal/web/sites/default/settings.php
sed -i "s|'password' => .*|'password' => '${DB_PASSWORD}',|" /opt/drupal/web/sites/default/settings.php
sed -i "s|'host' => .*|'host' => '${DB_HOST}',|" /opt/drupal/web/sites/default/settings.php
sed -i "s|'port' => .*|'port' => '3306',|" /opt/drupal/web/sites/default/settings.php
sed -i "s|PDO::MYSQL_ATTR_SSL_CA => .*|PDO::MYSQL_ATTR_SSL_CA => '/opt/drupal/web/DigiCertGlobalRootCA.crt.pem',|" /opt/drupal/web/sites/default/settings.php