#!/usr/bin/env bash
set -euo pipefail

app_dir="/opt/thaifortravel-miniapp"

set -a
# shellcheck disable=SC1091
. "${app_dir}/.env.production"
set +a

printf '%s\n' \
  "SELECT \"telegramUserId\", COALESCE(username, '') AS username, COALESCE(\"firstName\", '') AS first_name, \"lastAuthAt\" FROM \"TelegramUser\" WHERE lower(COALESCE(username, '')) = lower('max958166') ORDER BY \"lastAuthAt\" DESC LIMIT 3;" \
  | docker compose --env-file "${app_dir}/.env.production" \
      -f "${app_dir}/docker-compose.production.yml" \
      exec -T postgres \
      psql -v ON_ERROR_STOP=1 -P pager=off -U "${POSTGRES_USER}" -d "${POSTGRES_DB}"

unset TELEGRAM_BOT_TOKEN TELEGRAM_WEBHOOK_SECRET DATABASE_URL POSTGRES_PASSWORD