Files
XRayPDF/client/prisma/schema.prisma
Aryan SinghandClaude Opus 5 7e7e4d9b1c Make the container actually deployable, publish to GHCR
The Docker setup built but never came up. Three separate blockers, each
found by running the full compose stack against a real Postgres:

- The runner stage hand-copied prisma/@prisma/dotenv, which misses the
  CLI's transitive deps (valibot) and crash-looped the entrypoint. A
  dedicated migrator stage now installs the CLI at the exact lockfile
  version with its real dependency tree.
- Docker sets HOSTNAME to the container id and Next's standalone server
  binds to it verbatim, so the app was unreachable on localhost inside
  the container and the healthcheck could never pass. Pinned to 0.0.0.0.
- openssl was missing from the build stages but present at runtime, so
  Prisma detected a different platform and tried to download a matching
  query engine at boot, as an unprivileged user, into a root-owned
  directory. Aligned openssl across every stage that touches Prisma.

Verified from a clean volume: migrations apply, both containers report
healthy, /api/health returns 200, and the app serves from the image.

Also:
- Publish multi-arch images to GHCR on push to main and on v* tags, with
  an SBOM and a signed provenance attestation.
- Default compose to the published image; add a build override for
  working on the app itself. Host port and image are configurable.
- Drop two unused dependencies: canvas (19MB of native node-canvas; the
  pipeline uses @napi-rs/canvas) and multer (routes use formData()).
- Add a root .gitignore. There wasn't one, so a real .env was one
  `git add .` away from being committed. Untrack .DS_Store.
- Rewrite the README around what the tool does and how to run it.

Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
2026-09-01 23:54:57 -05:00

55 lines
1.5 KiB
Plaintext

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema
// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init
generator client {
provider = "prisma-client"
output = "../src/generated/prisma"
}
datasource db {
provider = "postgresql"
}
model user {
id String @id @default(uuid())
email String @unique
name String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
documents pdfDocument[]
}
model pdfDocument {
id String @id @default(uuid())
userId String
user user @relation(fields: [userId], references: [id], onDelete: Cascade)
originalName String
filePath String
pixelResultDir String?
ocrResultDir String?
ocrRan Boolean @default(false)
fileSize Int
pageCount Int @default(1)
pixelPageCount Int @default(0)
ocrPageCount Int @default(0)
createdAt DateTime @default(now())
pages pdfPage[]
@@index([userId])
}
model pdfPage {
id String @id @default(uuid())
documentId String
document pdfDocument @relation(fields: [documentId], references: [id], onDelete: Cascade)
pageNumber Int
confidence Float
wordsJson Json
createdAt DateTime @default(now())
@@unique([documentId, pageNumber])
@@index([documentId])
}