#!/bin/bash
set -euo pipefail

echo "=== Baseline schema definitions ==="
sed -n '48,56p' apps/api/src/migrations/1741087887225-migration.ts | nl -ba
sed -n '87,89p' apps/api/src/migrations/1741087887225-migration.ts | nl -ba

echo -e "\n=== Candidate app files that mention organizationId ==="
fd -t f 'webhook*' apps/api/src
fd -t f 'audit*' apps/api/src
fd -t f 'organization*.entity.ts' apps/api/src

while IFS= read -r f; do
  echo "--- $f ---"
  rg -n "organizationId|`@Column`|uuid|ManyToOne|JoinColumn" "$f" -C 2 || true
done < <(
  {
    fd -t f 'webhook*' apps/api/src
    fd -t f 'audit*' apps/api/src
    fd -t f 'organization*.entity.ts' apps/api/src
  } | sort -u
)

#!/bin/bash
set -euo pipefail

FILE="apps/api/src/migrations/1741087887225-migration.ts"

echo "=== Migration snippet around lines 40-110 (for context) ==="
sed -n '35,110p' "$FILE" | cat -n

echo -e "\n=== Find SQL table/column occurrences in the migration ==="
rg -n "webhook_initialization|audit_log|organizationId" "$FILE" || true

echo -e "\n=== Candidate entity/model files with organizationId references ==="
# Try common entity locations
fd -t f "organization*.entity.ts" apps/api/src -x echo {} >/dev/null || true
fd -t f "webhook*" apps/api/src | sort -u
fd -t f "audit*" apps/api/src | sort -u

# Search for type/relation hints
FILES=$(fd -t f '(' -name 'webhook*' -o -name 'audit*' -o -name 'organization*.entity.ts' ')' apps/api/src | sort -u || true)
if [ -z "${FILES:-}" ]; then
  echo "(No matching files found for webhook/audit/organization*.entity.ts)"
  exit 0
fi

echo -e "\n=== Ripgrep hits for organizationId / uuid / relations ==="
# Keep output small: only show matches with a little context
printf "%s\n" "$FILES" | while read -r f; do
  echo "--- $f ---"
  rg -n "organizationId|uuid|`@Column`|ManyToOne|JoinColumn" "$f" -C 1 || true
done

#!/bin/bash
set -euo pipefail

WEBHOOK_ENTITY="apps/api/src/webhook/entities/webhook-initialization.entity.ts"
AUDIT_ENTITY="apps/api/src/audit/entities/audit-log.entity.ts"

echo "=== webhook-initialization.entity.ts (organizationId) ==="
rg -n "organizationId|`@Column`|uuid" "$WEBHOOK_ENTITY" || true
sed -n '1,200p' "$WEBHOOK_ENTITY" | cat -n

echo -e "\n=== audit-log.entity.ts (organizationId) ==="
rg -n "organizationId|`@Column`|uuid" "$AUDIT_ENTITY" || true
sed -n '1,220p' "$AUDIT_ENTITY" | cat -n

echo -e "\n=== Other TS code touching webhook_initialization/audit_log organizationId ==="
rg -n "webhook_initialization|audit_log|organizationId" \
  apps/api/src/webhook apps/api/src/audit \
  -S | head -n 80

#!/bin/bash
set -euo pipefail

# Locate likely Organization entity
echo "=== Organization entity candidates ==="
fd -t f "*organization*.entity.ts" apps/api/src | head -n 50

ORG_FILE="$(fd -t f "organization*.entity.ts" apps/api/src | head -n 1 || true)"
if [ -z "${ORG_FILE:-}" ]; then
  ORG_FILE="$(fd -t f "*organization*.entity.ts" apps/api/src | head -n 1 || true)"
fi
echo -e "\nUsing ORG_FILE=$ORG_FILE"
if [ -n "${ORG_FILE:-}" ]; then
  sed -n '1,220p' "$ORG_FILE" | cat -n
  rg -n "class .*Organization|id:|`@PrimaryColumn`|`@PrimaryGeneratedColumn`|organizationId" "$ORG_FILE" || true
fi

# Check Box entity organizationId typing
echo -e "\n=== Box entity candidates ==="
fd -t f "*box*.entity.ts" apps/api/src | head -n 50
BOX_FILE="$(fd -t f "box*.entity.ts" apps/api/src | head -n 1 || true)"
if [ -z "${BOX_FILE:-}" ]; then
  BOX_FILE="$(fd -t f "*box*.entity.ts" apps/api/src | head -n 1 || true)"
fi
echo -e "\nUsing BOX_FILE=$BOX_FILE"
if [ -n "${BOX_FILE:-}" ]; then
  sed -n '1,240p' "$BOX_FILE" | cat -n
  rg -n "organizationId|`@Column`" "$BOX_FILE" || true
fi

#!/bin/bash
set -euo pipefail

echo "=== Organization entity files (glob match) ==="
ORG_FILES=$(fd -t f -g '*organization*.entity.ts' apps/api/src | sort -u)
echo "$ORG_FILES" | head -n 50
ORG_FILE=$(echo "$ORG_FILES" | head -n 1 || true)

if [ -n "${ORG_FILE:-}" ]; then
  echo -e "\n=== Inspect $ORG_FILE ==="
  sed -n '1,220p' "$ORG_FILE" | cat -n
  rg -n "class .*Organization|`@PrimaryColumn`|`@PrimaryGeneratedColumn`|organizationId|id:" "$ORG_FILE" || true
else
  echo "No organization entity file found with *organization*.entity.ts"
fi

echo -e "\n=== Box entity files (glob match) ==="
BOX_FILES=$(fd -t f -g '*box*.entity.ts' apps/api/src | sort -u)
echo "$BOX_FILES" | head -n 50
BOX_FILE=$(echo "$BOX_FILES" | head -n 1 || true)

if [ -n "${BOX_FILE:-}" ]; then
  echo -e "\n=== Inspect $BOX_FILE ==="
  sed -n '1,260p' "$BOX_FILE" | cat -n
  rg -n "organizationId|`@Column`" "$BOX_FILE" || true
else
  echo "No box entity file found with *box*.entity.ts"
fi

echo -e "\n=== Volume entity files (glob match) ==="
VOL_FILES=$(fd -t f -g '*volume*.entity.ts' apps/api/src | sort -u)
echo "$VOL_FILES" | head -n 50
VOL_FILE=$(echo "$VOL_FILES" | head -n 1 || true)

if [ -n "${VOL_FILE:-}" ]; then
  echo -e "\n=== Inspect $VOL_FILE ==="
  sed -n '1,220p' "$VOL_FILE" | cat -n
  rg -n "organizationId|`@Column`" "$VOL_FILE" || true
else
  echo "No volume entity file found with *volume*.entity.ts"
fi

#!/bin/bash
set -euo pipefail

ORG_ENTITY="apps/api/src/organization/entities/organization.entity.ts"
BOX_ENTITY="apps/api/src/box/entities/box.entity.ts"

echo "=== organization.entity.ts ==="
sed -n '1,220p' "$ORG_ENTITY" | cat -n
rg -n "id:|`@PrimaryGeneratedColumn`|`@PrimaryColumn`|`@Column`\\(\\{[^}]*type:'uuid'|`@Column`\\(\\{[^}]*type: 'uuid'|uuid" "$ORG_ENTITY" || true

echo -e "\n=== box.entity.ts (organizationId) ==="
sed -n '1,260p' "$BOX_ENTITY" | cat -n
rg -n "organizationId|`@Column`" "$BOX_ENTITY" || true

echo -e "\n=== any explicit uuid validation for organizationId in webhook/audit paths ==="
rg -n "organizationId|uuid|isUUID|validate.*organizationId|ParseUUID" apps/api/src/webhook apps/api/src/audit || true

#!/bin/bash
set -euo pipefail

FILES=$(fd -t f -g '*organization-user*.entity.ts' apps/api/src/organization || true)
echo "$FILES"

if [ -n "$FILES" ]; then
  f=$(echo "$FILES" | head -n 1)
  echo -e "\n=== Inspect $f ==="
  sed -n '1,220p' "$f" | cat -n
  rg -n "organizationId|`@Column`\\(\\{|`@JoinColumn`|`@ManyToOne`|uuid" "$f" || true
fi

# Also inspect any user/request typing for organizationId usage patterns
echo -e "\n=== Search for request.user.organizationId type hints ==="
rg -n "request\\.user\\.organizationId|organizationId:.*uuid|organizationId\\?:.*uuid" apps/api/src -S | head -n 80