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

# /data jest montowane przez HF; jeśli nie mamy uprawnień, pomiń
if [ ! -d /data ]; then
  echo "Info: /data not available (will be mounted by Spaces)."
fi

: "${DATABASE_URL:?ERROR: DATABASE_URL is not set}"

python - <<'PY'
import os
from sqlalchemy import create_engine, text
engine = create_engine(os.environ["DATABASE_URL"], pool_pre_ping=True)
with engine.begin() as conn:
    conn.execute(text("""
        CREATE TABLE IF NOT EXISTS notes (
            id SERIAL PRIMARY KEY,
            body TEXT NOT NULL,
            created_at TIMESTAMPTZ DEFAULT now()
        )
    """))
PY

# Start aplikacji – dopasuj do swojej
exec python server.py
# (albo: exec python server.py)