// Drizzle schema — 52 tables in tt_fresh_db alone
import { pgTable, uuid, text, timestamp, jsonb } from 'drizzle-orm/pg-core'

export const bookings = pgTable('bookings', {
  id:         uuid('id').defaultRandom().primaryKey(),
  contactId:  uuid('contact_id').references(() => contacts.id),
  status:     bookingStatusEnum('status').notNull().default('pending'),
  vendor:     text('vendor').notNull(),
  metadata:   jsonb('metadata').$type<BookingMeta>(),
  createdAt:  timestamp('created_at').defaultNow(),
})

// Fire-and-forget sync with 3-retry exponential backoff
export async function syncToNexus(deal: Deal) {
  const delays = [0, 1000, 3000, 8000]
  for (const [i, wait] of delays.entries()) {
    if (wait) await sleep(wait)
    try {
      const r = await fetch(`${NEXUS}/deals`, {
        method: 'POST',
        headers: { 'X-Api-Key': env.NEXUS_KEY },
        body: JSON.stringify(deal)
      })
      if (r.ok) return r.json()
    } catch (e) {
      sentry.captureException(e, { extra: { attempt: i } })
    }
  }
}

#!/bin/bash
# Deploy to VPS. 5 parallel health checks. Auto-rollback.
set -euo pipefail

PREV=$(docker ps --format '{{.Image}}' | grep tt-api)
docker build -t tt-api:$GIT_SHA .
docker tag tt-api:$GIT_SHA tt-api:latest
docker compose up -d --no-deps tt-api

# 5 parallel checks, 90s timeout
for check in http db redis queue sentry; do
  ./bin/check-$check.sh &
done
wait || { docker tag $PREV tt-api:latest; docker compose up -d tt-api; exit 1; }

echo "✓ deploy ok: $GIT_SHA"