Janady13/AI_Brain / scripts/db_apply.sh

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/AI_Brain / scripts/db_apply.sh
Date	Not specified in source
Repository	Janady13/AI_Brain
Revision	d6c309d3fa439714ca46b9d3bb94caf478ea5376
Branch	main
Path or archive member	scripts/db_apply.sh
Original SHA-256	3e285f5adced5f37ffcdd0ca722abf586b8d0b26f6a9aeb150c369e68af25087
Git blob SHA	88500e2ac18b81058ee3d69e20d6f2d76c976f82
Reading-copy SHA-256	3e285f5adced5f37ffcdd0ca722abf586b8d0b26f6a9aeb150c369e68af25087

Original source ↗

Every recorded occurrence

These 15 records contain identical original source bytes. Their paths and revisions remain part of the archive.

Original record	Branch or archive	Revision / identifier	Original location
Janady13/AI_Brain / scripts/db_apply.sh	main	d6c309d3fa439714ca46b9d3bb94caf478ea5376	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-hr4y0z	366ab848896ae49159cfb3f6c201b8c5a731e9c8	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-irqa7y	11aa50ef5d7692e8abd1b8d74ae31c5c29201b14	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-i3cigl	3a6e002311c48c27ffd41ef4a2a31c63947128cd	Open original
Janady13/AI_Brain / scripts/db_apply.sh	copilot/convert-python-files-to-csharp	6d0767aad08781eb5c4e1eb14a42ec92c437be78	Open original
Janady13/AI_Brain / scripts/db_apply.sh	claude/binary-helix-fibonacci-hive-011CUj7dx1WWJLVYcWCjBbYv	527d4882c71eb041393f9d8945996177c5ac9e86	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-7v4kug	5cd0bbf744b0aee9445913337e852889d9a8098e	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-nbgsix	840945d70b88674d8f40d330001cc63d871dc8e2	Open original
Janady13/AI_Brain / scripts/db_apply.sh	copilot/vscode1760283895982	9e1c1a5b171addb5bb4a83b2ea7dede50c1cc81e	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-7nmb21	d0f50071c85cddaaebbf9c4dd1313bd7676986da	Open original
Janady13/AI_Brain / scripts/db_apply.sh	feature/seeder-engine-tests	cdb497ece2d1a770ca8c83eb1de8923cfaa9eceb	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani	49db80a641b10ab62d16cc7643bd0b367f93951c	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-jf5olo	c6653627c453ab428d665226167fa5f4aa05e9a5	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-0etkns	e250b19d446bdffd542c9eea31cead12e30800d6	Open original
Janady13/AI_Brain / scripts/db_apply.sh	codex/build-online-github-ani-hrtsoc	50285aff347685f043e7a72e4d72891eebaa6cd6	Open original

Recovered source transcript

Download complete source text ↓50 lines · 1.2 KB

#!/usr/bin/env bash
set -Eeuo pipefail
IFS=$'\n\t'

# Apply infra/schema.sql to the configured Postgres

log()      { printf '%s\n' "$*"; }
log_err()  { printf 'ERR: %s\n' "$*" >&2; }

usage() {
  cat <<'USG'
Usage: db_apply.sh [--dry-run] [--schema PATH]
Env:
  DATABASE_URL or PGHOST/PGPORT/PGDATABASE/PGUSER/PGPASSWORD
USG
}

DRY=0
SCHEMA="$(CDPATH= cd -- "$(dirname -- "$0")/.." && pwd -P)/infra/schema.sql"
while [[ $# -gt 0 ]]; do
  case "$1" in
    --dry-run) DRY=1; shift ;;
    --schema)  SCHEMA="${2:-}"; shift 2 ;;
    -h|--help) usage; exit 0 ;;
    *) log_err "Unknown arg: $1"; usage; exit 2 ;;
  esac
done

[[ -f "$SCHEMA" ]] || { log_err "Schema not found: $SCHEMA"; exit 1; }

command -v psql >/dev/null 2>&1 || { log_err "psql not found in PATH"; exit 127; }

if [[ ${DRY} -eq 1 ]]; then
  log "[DRY] Would apply schema: $SCHEMA"
  exit 0
fi

if [[ -n "${DATABASE_URL:-}" ]]; then
  PSQL_ARGS=("$DATABASE_URL")
else
  : "${PGHOST:?PGHOST required or set DATABASE_URL}"
  : "${PGDATABASE:?PGDATABASE required or set DATABASE_URL}"
  PSQL_ARGS=("host=$PGHOST" "port=${PGPORT:-5432}" "dbname=$PGDATABASE" "user=${PGUSER:-postgres}")
fi

log "Applying schema to database..."
psql "${PSQL_ARGS[@]}" -f "$SCHEMA"
log "Schema applied."