#!/bin/bash
# sql - run SQL queries against the connected database
# usage: sql "SELECT * FROM users LIMIT 10"

set -e

if [ -z "$1" ]; then
  echo "Usage: sql \"SELECT * FROM table\"" >&2
  exit 1
fi

# Get connection string
if [ -f /workspace/.connection.json ]; then
  CONN=$(cat /workspace/.connection.json | jq -r .connectionString)
else
  echo "Error: No database connection. /workspace/.connection.json not found." >&2
  exit 1
fi

if [ -z "$CONN" ] || [ "$CONN" = "null" ]; then
  echo "Error: No connection string in /workspace/.connection.json" >&2
  exit 1
fi

# Run query
psql "$CONN" -c "$1"
