# Stage 1: Builder
FROM node:22-alpine AS builder
WORKDIR /app

# Install dependencies
COPY package*.json ./
RUN npm install -g pnpm
RUN pnpm install

# Copy project files
COPY . .

# Generate Prisma client
RUN pnpx prisma generate

# Build Svelte app
RUN pnpm run build

# Prune dev dependencies to reduce final image size
RUN pnpm prune --prod

# Stage 2: Production
FROM node:22-alpine
WORKDIR /app

# Copy necessary files and folders from the builder
COPY --from=builder /app/build build/
COPY --from=builder /app/node_modules node_modules/
COPY --from=builder /app/prisma prisma/
COPY package.json .

# Generate Prisma client in production environment
RUN pnpx prisma generate

# Set environment variables and expose port
EXPOSE 3000
ENV NODE_ENV=production

# Run the application
CMD ["node", "build"]

# Stage 1: Builder
FROM node:22-alpine AS builder
WORKDIR /app

# Install dependencies
COPY package*.json ./
RUN npm install -g pnpm
RUN pnpm install

# Copy project files
COPY . .

# Generate Prisma client
RUN pnpx prisma generate

# Build Svelte app
RUN pnpm run build

# Prune dev dependencies to reduce final image size
RUN pnpm prune --prod

# Stage 2: Production
FROM node:22-alpine
WORKDIR /app

# Copy necessary files and folders from the builder
COPY --from=builder /app/build build/
COPY --from=builder /app/node_modules node_modules/
COPY --from=builder /app/prisma prisma/
COPY package.json .

# Generate Prisma client in production environment
RUN pnpx prisma generate

# Set environment variables and expose port
EXPOSE 3000
ENV NODE_ENV=production

# Run the application
CMD ["node", "build"]

DEBUG="prisma:migrate*" npx prisma migrate dev --skip-generate

DEBUG="prisma:migrate*" npx prisma migrate dev --skip-generate

model Test {
  id                    String                  @id @default(uuid())
  name                  String
  description           String
  price                 Float
  current_price         Float
  created_at            DateTime
  updated_at            DateTime
  order_id              String?
  TestsOfMembersInOrder TestsOfMembersInOrder[]
  ParametersToTests     ParametersToTests[]

  @@map("tests")
  @@schema("public")
}

model Parameter {
  id                 String              @id @default(uuid())
  name               String
  Parameter_category Parameter_category? @relation(fields: [categoryId], references: [id])
  categoryId         String
  ParametersToTests  ParametersToTests[]

  @@map("parameters")
  @@schema("public")
}

model ParametersToTests {
  test_id      String
  Test         Test      @relation(fields: [test_id], references: [id])
  parameter_id String
  Parameter    Parameter @relation(fields: [parameter_id], references: [id])

  @@id([test_id, parameter_id])
  @@map("parameter_test")
  @@schema("public")
}

model Test {
  id                    String                  @id @default(uuid())
  name                  String
  description           String
  price                 Float
  current_price         Float
  created_at            DateTime
  updated_at            DateTime
  order_id              String?
  TestsOfMembersInOrder TestsOfMembersInOrder[]
  ParametersToTests     ParametersToTests[]

  @@map("tests")
  @@schema("public")
}

model Parameter {
  id                 String              @id @default(uuid())
  name               String
  Parameter_category Parameter_category? @relation(fields: [categoryId], references: [id])
  categoryId         String
  ParametersToTests  ParametersToTests[]

  @@map("parameters")
  @@schema("public")
}

model ParametersToTests {
  test_id      String
  Test         Test      @relation(fields: [test_id], references: [id])
  parameter_id String
  Parameter    Parameter @relation(fields: [parameter_id], references: [id])

  @@id([test_id, parameter_id])
  @@map("parameter_test")
  @@schema("public")
}