#!/usr/bin/env bash
set -euo pipefail
set -a
source /srv/sub2api-80/shared/env/sub2api-80.env
set +a
export PGPASSWORD="$DATABASE_PASSWORD"
psql -h "$DATABASE_HOST" -p "$DATABASE_PORT" -U "$DATABASE_USER" -d "$DATABASE_DBNAME" -At <<'SQL'
select id,name,platform,allow_messages_dispatch,status,updated_at
from groups
where platform = anthropic
order by id;

select created_at,user_id,api_key_id,group_id,request_path,status_code,left(error_message,120)
from ops_error_logs
where created_at > now() - interval 3 days
  and group_id = 25
  and request_path = /v1/messages
order by created_at desc
limit 20;
SQL