Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/AI_Brain / scripts/db_check.sh |
| Date | Not specified in source |
| Repository | Janady13/AI_Brain |
| Revision | d6c309d3fa439714ca46b9d3bb94caf478ea5376 |
| Branch | main |
| Path or archive member | scripts/db_check.sh |
| Original SHA-256 | 37bee9f4c8176f829ad31704f885a7ae9a69ab6d046fae64de195506b288734d |
| Git blob SHA | 5544b54cb4f7f52ca6969d63f98cb44c4117f49c |
| Reading-copy SHA-256 | 37bee9f4c8176f829ad31704f885a7ae9a69ab6d046fae64de195506b288734d |
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_check.sh | main | d6c309d3fa439714ca46b9d3bb94caf478ea5376 | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-hr4y0z | 366ab848896ae49159cfb3f6c201b8c5a731e9c8 | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-irqa7y | 11aa50ef5d7692e8abd1b8d74ae31c5c29201b14 | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-i3cigl | 3a6e002311c48c27ffd41ef4a2a31c63947128cd | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | copilot/convert-python-files-to-csharp | 6d0767aad08781eb5c4e1eb14a42ec92c437be78 | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | claude/binary-helix-fibonacci-hive-011CUj7dx1WWJLVYcWCjBbYv | 527d4882c71eb041393f9d8945996177c5ac9e86 | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-7v4kug | 5cd0bbf744b0aee9445913337e852889d9a8098e | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-nbgsix | 840945d70b88674d8f40d330001cc63d871dc8e2 | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | copilot/vscode1760283895982 | 9e1c1a5b171addb5bb4a83b2ea7dede50c1cc81e | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-7nmb21 | d0f50071c85cddaaebbf9c4dd1313bd7676986da | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | feature/seeder-engine-tests | cdb497ece2d1a770ca8c83eb1de8923cfaa9eceb | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani | 49db80a641b10ab62d16cc7643bd0b367f93951c | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-jf5olo | c6653627c453ab428d665226167fa5f4aa05e9a5 | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-0etkns | e250b19d446bdffd542c9eea31cead12e30800d6 | Open original |
| Janady13/AI_Brain / scripts/db_check.sh | codex/build-online-github-ani-hrtsoc | 50285aff347685f043e7a72e4d72891eebaa6cd6 | Open original |
Recovered source transcript
Download complete source text ↓36 lines · 0.9 KB
#!/usr/bin/env bash
set -Eeuo pipefail
IFS=$'\n\t'
log() { printf '%s\n' "$*"; }
log_err() { printf 'ERR: %s\n' "$*" >&2; }
usage() {
cat <<'USG'
Usage: db_check.sh
Env:
DATABASE_URL or PGHOST/PGPORT/PGDATABASE/PGUSER/PGPASSWORD
USG
}
command -v psql >/dev/null 2>&1 || { log_err "psql not found"; exit 127; }
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
SQL=$(cat <<'SQL'
\timing on
SELECT 'atomic_facts_total' AS metric, count(*) AS value FROM atomic_facts
UNION ALL
SELECT 'by_category:' || category, count(*) FROM atomic_facts GROUP BY category ORDER BY 1;
SQL
)
psql "${PSQL_ARGS[@]}" -At -c "$SQL" | awk -F'|' '{ printf("%s: %s\n", $1, $2) }'