Develop - #45

#!/bin/bash
set -euo pipefail

printf '--- package.json relevant scripts ---\n'
python3 - <<'PY'
import json
from pathlib import Path
pkg = json.loads(Path('package.json').read_text())
for name in [
  'db:reset','seed','seed:event','seed:chapters','seed:story',
  'seed:challenges','seed:users','seed:admin'
]:
    print(f'{name}: {pkg.get("scripts",{}).get(name)}')
PY

printf '\n--- seed-related imports ---\n'
rg -n '"dotenv/config"|from ["'+"'"]dotenv/config" scripts package.json || true

printf '\n--- installed tsx/node availability ---\n'
(command -v node && node --version) || true
(command -v tsx && tsx --version) || true

printf '\n--- local flag behavior probe (using installed tsx if present) ---\n'
if command -v tsx >/dev/null 2>&1; then
  tmpdir="$(mktemp -d)"
  cat > "$tmpdir/probe.ts" <<'TS'
console.log('node-options-value:', process.env.SECRET_VAR)
TS
  export SECRET_VAR=fromEnv
  printf 'tsx --env-file=.env --env-file-if-exists=.env: '
  tsx --env-file=.env --env-file-if-exists=.env "$tmpdir/probe.ts" 2>&1 || true
  rm -rf "$tmpdir"
fi

#!/bin/bash
set -euo pipefail

printf '%s\n' '--- package.json relevant scripts ---'
python3 - <<'PY'
import json
from pathlib import Path
pkg = json.loads(Path("package.json").read_text())
for name in [
  "db:reset","seed","seed:event","seed:chapters","seed:story",
  "seed:challenges","seed:users","seed:admin"
]:
    print(f"{name}: {pkg.get('scripts',{}).get(name)}")
PY

printf '%s\n' ''
printf '%s\n' '--- seed-related imports ---'
rg -n '"dotenv/config"|from ["'"'']dotenv/config' scripts package.json || printf '%s\n' 'no matches'

printf '%s\n' ''
printf '%s\n' '--- installed tsx/node availability ---'
(command -v node && node --version) || printf '%s\n' 'node unavailable'
(command -v tsx && tsx --version) || printf '%s\n' 'tsx unavailable'

printf '%s\n' ''
printf '%s\n' '--- local flag behavior probe (using installed tsx if present) ---'
if command -v tsx >/dev/null 2>&1; then
  tmpdir="$(mktemp -d)"
  cat > "$tmpdir/probe.ts" <<'TS'
console.log("node-options-value:", process.env.SECRET_VAR)
TS
  export SECRET_VAR=fromEnv
  printf '%s ' 'tsx --env-file=.env --env-file-if-exists=.env: '
  tsx --env-file=.env --env-file-if-exists=.env "$tmpdir/probe.ts" 2>&1 || printf '%s\n' '(exited non-zero)'
  rm -rf "$tmpdir"
fi

#!/bin/bash
set -euo pipefail

# Expect: all write paths reject negative XP values, or the schema adds checks.
rg -n -C 4 '\bxpCost\b|\bxpSpent\b' --glob '*.{ts,tsx,js,jsx,sql,prisma}'

#!/bin/bash
set -euo pipefail

echo "tracked files around prisma:"
git ls-files | sed -n '/prisma/p' | head -200

echo
echo "migration file:"
if [ -f prisma/migrations/20260804192440_add_hint/migration.sql ]; then
  cat -n prisma/migrations/20260804192440_add_hint/migration.sql
fi

echo
echo "schema files:"
fd -a 'schema\.prisma$|.*\.prisma$' prisma . 2>/dev/null | sed 's#^\./##' | head -100

echo
echo "search xpCost/xpSpent broader:"
rg -n -C 4 '\bxpCost\b|\bxpSpent\b' . || true

#!/bin/bash
set -euo pipefail

echo "hint service outline:"
ast-grep outline modules/hint -f '.*service.*|.*guard.*|.*resolver.*' || true

echo
echo "search xpCost/xpSpent in module code with context:"
rg -n -C 8 '\bxpCost\b|\bxpSpent\b' modules prisma || true

echo
echo "database CHECK constraints in migrations:"
rg -n 'CHECK\s*\(|Check\s*\(|constraint|`@unique`|`@id`' --glob '*.sql' prisma/migrations || true

#!/bin/bash
set -euo pipefail

echo "files likely containing Hint/PlayerHint services or seeds:"
git ls-files | rg '(^modules/hint/seed|hint\.service|hint\.db|hint\.repository|seed-hints|hint.constants)' || true

echo
echo "hints service outline:"
fd -a 'hint\.service\.(tsx?|ts)' . --owner --no-ignore 2>/dev/null | while read -r f; do
  echo "--- $f"
  wc -l "$f"
done

echo
echo "seed/constants relevant sections:"
for f in modules/hint/constants/hint.constants.ts modules/hint/seed-hints.ts; do
  if [ -f "$f" ]; then
    echo "--- $f lines 80-110"
    sed -n '80,110p' "$f" | cat -n -v
  fi
done

echo
echo "write/repo references to hints model fields:"
python3 - <<'PY'
from pathlib import Path
import re
terms = ['xpCost', 'xpSpent', 'PlayerHint', 'hint.xpCost', 'hintSpent', 'HINT_XP_COST_CHANGED']
for p in Path('.').rglob('*'):
    if not p.is_file(): continue
    if p.parts and p.parts[0] in {'.git','node_modules','dist','build','coverage'}: continue
    try:
        txt = p.read_text(errors='ignore')
    except Exception:
        continue
    if any(t in txt for t in terms) or 'hints.update' in txt or 'createPlayerHint' in txt:
        print(f"--- {p}")
        for i,line in enumerate(txt.splitlines(),1):
            if any(t in line for t in terms) or 'hints.update' in line or 'createPlayerHint' in line:
                print(f"{i}:{line[:220]}")
PY

#!/bin/bash
set -euo pipefail

# Expect: deletion behavior explicitly treats player hint records as disposable or historical.
rg -n -C 5 '\b(playerHints|PlayerHint|xpSpent|unlockedAt)\b|\.delete(Many)?\(' \
  --glob '*.{ts,tsx,js,jsx,sql,prisma}'

#!/bin/bash
set -euo pipefail

echo "Tracked files sample:"
git ls-files | sed -n '1,120p'

echo
echo "Migration file:"
cat -n prisma/migrations/20260804192440_add_hint/migration.sql | sed -n '1,120p'

echo
echo "Search for hints/player hints/xp/unlocked wording:"
rg -n -C 3 'hints|player_hints|playerHints|PlayerHint|xpSpent|XP|XP spent|XP spent|unlockedAt|unlocked|xpSpent|xp_spent' -S . || true

echo
echo "Prisma schema:"
fd -a 'schema.prisma|*.prisma' . -d 3 -x sh -c 'echo "--- {}"; cat -n "{}" | sed -n "1,220p"'

#!/bin/bash
set -euo pipefail

echo "Schema file locations:"
fd -a 'schema\.prisma|\.prisma$' . -d 4

echo
echo "Prisma schema:"
SCHEMA="$(fd 'schema\.prisma|.*\.prisma' prisma -d 4 | head -n1)"
[ -n "${SCHEMA:-}" ] && cat -n "${SCHEMA}" | sed -n '1,260p' || true

echo
echo "Hint module services/repositories repository/files:"
fd -a '\.(ts|tsx)$' modules/lib/prisma prisma -d 4 | sort | sed -n '1,220p'

echo
echo "Hint service outline:"
ast-grep outline modules/hint/services/hint.service.ts --view expanded || true

echo
echo "Hint service relevant sections:"
cat -n modules/hint/services/hint.service.ts | sed -n '1,260p'

echo
echo "Hint repository relevant sections:"
cat -n modules/hint/repositories/hint.repository.ts | sed -n '1,220p' || true

echo
echo "Hint DTO mapper relevant sections:"
cat -n modules/hint/mapper/hint.mapper.ts | sed -n '1,180p' || true

echo
echo "Focused searches for hint deletion/update/admin usage:"
rg -n -C 4 '\b(hint|Hint|Hints)\b|\.(delete|destroy|remove|updateMany|updateOne|create|unlock|xpSpent|unlockedAt)\b|deleteMany\(|deleteOne\(' modules/hint scripts package.json prisma -g '*.ts' -g '*.tsx' -g '*.sql' -g '*.prisma' -g 'package.json' || true

#!/bin/bash
set -euo pipefail

echo "Prisma schema Hint/PlayerHint models:"
cat -n prisma/schema.prisma | sed -n '260,420p'

echo
echo "Hint module files:"
find modules/hint -maxdepth 3 -type f \( -name '*.ts' -o - name '*.tsx' \) | sort

echo
echo "Hint module relevant files:"
for f in modules/hint/constants/hint.constants.ts modules/hint/constants/hint.events.ts modules/hint/repositories/hint.repository.ts modules/hint/services/hint.service.ts modules/hint/mapper/hint.mapper.ts modules/hint/types/hint.types.ts; do
  if [ -f "$f" ]; then
    echo "--- $f"
    cat -n "$f" | sed -n '1,260p'
  fi
done

echo
echo "Focused references to hint unlock/history/XP:"
rg -n -C 4 'hint|Hint|PlayerHint|xpSpent|xpCost|unlockedAt|unlock' modules/hint modules -g '*.ts' -g '*.tsx' -g '*.sql' -g '*.prisma' || true

#!/bin/bash
set -euo pipefail

echo "Hint/PlayerHint model definitions:"
python3 - <<'PY'
from pathlib import Path
p=Path('prisma/schema.prisma')
text=p.read_text()
for i,line in enumerate(text.splitlines(),1):
    if 'model Hint' in line or 'model PlayerHint' in line:
        start=max(1,i-5)
        print(f'--- lines {start}-{i+25} ---')
        lines=text.splitlines()
        for n in range(start, min(len(lines), i+25)+1):
            print(f'{n:4d}: {lines[n-1]}')
PY

echo
echo "Hint module files:"
find modules/hint -maxdepth 3 -type f | sort

echo
echo "Hint module service/repo/mapper if present:"
for f in modules/hint/services/hint.service.ts modules/hint/repositories/hint.repository.ts modules/hint/mapper/hint.mapper.ts; do
  if [ -f "$f" ]; then
    echo "--- $f"
    cat -n "$f" | sed -n '1,260p'
  fi
done

echo
echo "Focused references to PlayerHint/unlock/XP/status change:"
rg -n -C 4 'PlayerHint|PlayerHint|playerHints|xpSpent|xpcost|xpcost|xpcost|unlock|hintId|hintId|status|DRAFT|ARCHIVED|onDelete|`@Relation`|hints' modules/hint modules prisma -g '*.ts' -g '*.tsx' -g '*.sql' -g '*.prisma' -g '!prisma/migrations/**/migration.sql' | sed -n '1,260p' ... || true

#!/bin/bash
# Description: Check whether CI invokes db:reset and how DATABASE_URL is supplied.
fd -H -e yml -e yaml . .github --exec rg -n 'db:reset|DATABASE_URL|prisma migrate' {} \; 2>/dev/null || echo "no workflow references found"
rg -n 'DATABASE_URL' --hidden -g '!node_modules' -g '!*.lock'

#!/bin/bash
set -u

printf 'Tracked files matching reset/db/seed/env docs: '
git ls-files | rg '(^scripts/reset-db\.ts$|(^|/)(package\.json|pnpm-lock\.yaml|yarn.lock|package-lock\.json|Makefile|.*\.env.*|.*\.test\.ts|.*\.spec\.ts).*|(^|/)\.github/workflows/)'

printf '\nscripts/reset-db.ts excerpt:\n'
sed -n '1,140p' scripts/reset-db.ts

printf '\npackage scripts and Prisma version:\n'
if [ -f package.json ]; then jq '.scripts, .devDependencies, .dependencies' package.json; fi

printf '\nRead-only structural/static verifier for reset-db confirmation bypass and database target:\n'
python3 - <<'PY'
from pathlib import Path
p = Path('scripts/reset-db.ts')
s = p.read_text()
checks = {
    "has_confirm": "async function confirm()" in s,
    "ci_bypass": 'process.env.CI === "true"' in s,
    "yes_bypass": 'process.argv.includes("--yes")' in s,
    "bypass_returns_true": 'process.env.CI === "true" || process.argv.includes("--yes")' in s and "return true;" in s[s.index('process.argv.includes("--yes")'):s.index('process.argv.includes("--yes")')+500],
    "migrate_reset_force": 'execSync("npx prisma migrate reset --force --skip-seed"' in s,
    "uses_DATABASE_URL_via_prisma": 'DATABASE_URL' in s or 'prismaClient' in s or '.dotenv/config' in s,
}
for k, v in checks.items():
    print(f"{k}={v}")
print("function reset starts after confirm", s.find('async function resetDatabase') > s.find('async function confirm'))
PY

printf '\nAny explicit guard against CI/production target in reset-db:\n'
rg -n 'CI|NPM|NODE_ENV|DATABASE_URL|production|refus|env=' scripts/reset-db.ts package.json .github 2>/dev/null || true