База данных и общий compose

# фиксируем мажорную версию Prisma 6 — на v7 поведение генератора и output ломает текущую инструкцию
npm i prisma@^6.19 @prisma/client@^6.19
npx prisma init --datasource-provider postgresql

{
  ...
  "scripts": {
    "dev": "tsx src/server.ts",
    "build": "tsc",
    "start": "node dist/server.js",
    "db:generate": "prisma generate",
    "db:deploy": "prisma migrate deploy"
  }
  ...
}

import fp from 'fastify-plugin'
import { PrismaClient } from '../generated/prisma/client.js'

// Расширяем типизацию Fastify: после регистрации плагина у экземпляра появится свойство prisma.
declare module 'fastify' {
  interface FastifyInstance {
    prisma: PrismaClient
  }
}

// Fastify-плагин, который создаёт один экземпляр PrismaClient и подключает его ко всему приложению.
export default fp(async (app) => {
  const prisma = new PrismaClient()
  // decorate делает prisma доступным как app.prisma во всех маршрутах и хуках.
  app.decorate('prisma', prisma)

  // Хук onClose вызывает $disconnect, когда сервер останавливается, чтобы закрыть соединение с БД.
  app.addHook('onClose', async (inst) => {
    await inst.prisma.$disconnect()
  })
})

import prismaPlugin from './plugins/prisma.js'

// внутри buildApp(), после await app.register(swagger, ...):
await app.register(prismaPlugin)

const users: User[] = [
  { id: 'u-1', email: 'alice@example.com' },
  { id: 'u-2', email: 'bob@example.com' },
]

app.get('/api/users', { schema: /* как было в лабе 06 */ },
  async () => app.prisma.user.findMany({ select: { id: true, email: true } })
)

app.get(
  '/api/health',
  {
    schema: {
      operationId: 'health',
      tags: ['System'],
      summary: 'Health/Readiness',
      description: 'Проверяет, что процесс жив и база данных отвечает.',
      response: {
        200: { description: 'Ready', content: { 'application/json': { schema: Health } } },
        503: { description: 'Temporarily unavailable', content: { 'application/problem+json': { schema: ProblemDetails } } },
      },
    },
  },
  async (_req, reply) => {
    try {
      // Если SELECT 1 прошёл — сервис готов.
      await app.prisma.$queryRaw`SELECT 1`
      return { ok: true } as Health
    } catch {
      // Возвращаем 503, чтобы балансировщик мог вывести инстанс из ротации.
      reply.code(503).type('application/problem+json').send({
        type: 'https://example.com/problems/dependency-unavailable',
        title: 'Service Unavailable',
        status: 503,
        detail: 'Database ping failed',
        instance: '/api/health',
      } satisfies ProblemDetails)
    }
  }
)

FROM node:24-alpine AS deps
WORKDIR /app
COPY package*.json ./
RUN --mount=type=cache,target=/root/.npm \
    npm i --no-audit --no-fund

FROM node:24-alpine AS build
WORKDIR /app
ENV NODE_ENV=development
COPY --from=deps /app/node_modules ./node_modules
COPY . .
RUN npx prisma generate --schema=prisma/schema.prisma
RUN npm run build
# Оставляем только runtime-зависимости
RUN npm prune --omit=dev

FROM node:24-alpine AS dev
WORKDIR /app
ENV NODE_ENV=development
COPY --from=deps /app/node_modules ./node_modules
COPY . .
CMD ["sh","-lc","npx prisma generate --schema=prisma/schema.prisma && npx prisma migrate deploy || true; npx tsx src/server.ts"]

FROM node:24-alpine AS prod
WORKDIR /app
ENV NODE_ENV=production
COPY --from=build /app/node_modules ./node_modules
COPY --from=build /app/dist         ./dist
COPY --from=build /app/prisma       ./prisma
COPY --from=build /app/src/generated/prisma ./dist/generated/prisma

USER node
EXPOSE 3000
CMD ["node","dist/server.js"]

# БАЗОВЫЕ ЯКОРЯ
x-env-file: &env_file [.env]

x-db-env: &db_env
  POSTGRES_DB: ${POSTGRES_DB}
  POSTGRES_USER: ${POSTGRES_USER}
  POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}

x-fastify-env: &fastify_env
  DATABASE_URL: postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@db:5432/${POSTGRES_DB}?schema=public
  PORT: "3000"

x-db-healthy: &db_healthy
  depends_on:
    db:
      condition: service_healthy

services:
  db:
    image: postgres:17-alpine
    env_file: *env_file
    environment: *db_env
    volumes: [ "db_data:/var/lib/postgresql/data" ]
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U ${POSTGRES_USER} -d ${POSTGRES_DB}"]
      interval: 5s
      timeout: 3s
      retries: 10

  backend:
    <<: *db_healthy
    env_file: *env_file
    build:
      context: ./backend
      dockerfile: Dockerfile
      # target задаётся в override-файлах (dev/prod)
    environment: *fastify_env
    expose: ["3000"]

  scalar:
    # для учебного стенда оставляем :latest — на проде лучше пинить конкретный SHA-дайджест
    image: scalarapi/api-reference:latest
    environment:
      # URL относительный, редирект идёт через тот же NGINX
      API_REFERENCE_CONFIG: >
        {"layout":"modern","theme":"purple",
         "sources":[{"name":"API","url":"/openapi.json"}]}
    <<: *db_healthy
    expose: ["8080"]

volumes:
  db_data:

POSTGRES_DB=example
POSTGRES_USER=exampleuser
POSTGRES_PASSWORD=examplepassword

services:
  frontend:
    build:
      context: ./frontend
      dockerfile: Dockerfile
      target: dev
    expose: ["5173"]
    volumes:
      - ./frontend:/app
      - /app/node_modules
    environment:
      - CHOKIDAR_USEPOLLING=true

  nginx:
    image: nginx:1.29-alpine
    depends_on:
      - frontend
      - backend
      - scalar
    ports: ["80:80"]
    volumes:
      - ./nginx/nginx.conf:/etc/nginx/conf.d/default.conf:ro

  backend:
    build:
      context: ./backend
      dockerfile: Dockerfile
      target: dev
    volumes:
      - ./backend/prisma:/app/prisma
      - /app/node_modules

# --- Auto-Upgrade для WebSocket
map $http_upgrade $connection_upgrade {
  default upgrade;
  ''      close;
}

# --- Upstreams
upstream backend_upstream { server backend:3000; keepalive 32; }
upstream vite_upstream    { server frontend:5173; keepalive 32; }
upstream scalar_upstream  { server scalar:8080;  keepalive 8;  }

server {
  listen 80;
  server_name _;

  # --- gzip: сжатие файлов при передаче
  gzip on;
  gzip_min_length 256;
  gzip_types text/plain text/css text/javascript application/javascript application/json application/xml application/xml+rss image/svg+xml;
  gzip_vary on;

  proxy_intercept_errors off;

  # ===== API -> backend =====
  location ^~ /api/ {
    proxy_pass         http://backend_upstream;
    proxy_http_version 1.1;
    proxy_set_header   Host              $host;
    proxy_set_header   X-Real-IP         $remote_addr;
    proxy_set_header   X-Forwarded-For   $proxy_add_x_forwarded_for;
    proxy_set_header   X-Forwarded-Proto $scheme;
    proxy_read_timeout 300s;
    proxy_buffering    off;
  }

  # openapi
  location = /openapi.json { proxy_pass http://backend_upstream/openapi.json; }

  # ===== Scalar UI (документация) =====
  location ^~ /docs/ {
    proxy_pass         http://scalar_upstream/;
    proxy_http_version 1.1;
    proxy_set_header   Host $host;
    proxy_read_timeout 120s;
  }

  # ===== Vite dev + HMR =====
  location / {
    proxy_pass         http://vite_upstream;
    proxy_http_version 1.1;
    proxy_set_header   Host $host;
    proxy_set_header   X-Real-IP         $remote_addr;
    proxy_set_header   X-Forwarded-For   $proxy_add_x_forwarded_for;
    proxy_set_header   X-Forwarded-Proto $scheme;

    # WebSocket для HMR
    proxy_set_header   Upgrade           $http_upgrade;
    proxy_set_header   Connection        $connection_upgrade;

    proxy_read_timeout 300s; # длинные WS-сессии
    proxy_buffering    off;  # не буферим dev-потоки
  }
}

docker compose -f compose.base.yaml -f compose.prod.yaml --env-file .env up -d --build