Backend Local Setup

# Запустить PostgreSQL в Docker
docker run --name postgres-dev \
  -e POSTGRES_USER=dev \
  -e POSTGRES_PASSWORD=dev \
  -e POSTGRES_DB=app_dev \
  -p 5432:5432 \
  -d postgres:15

# macOS (Homebrew)
brew install postgresql@15
brew services start postgresql@15

# Создать базу
createdb app_dev

psql postgresql://dev:dev@localhost:5432/app_dev -c "SELECT 1;"

pnpm add prisma@latest
pnpm add -D @types/node

pnpm prisma init

// prisma/schema.prisma
generator client {
  provider = "prisma-client"
  output   = "../server/generated/prisma"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id        String   @id @default(cuid())
  email     String   @unique
  name      String?
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

# .env
DATABASE_URL="postgresql://dev:dev@localhost:5432/app_dev"

// server/utils/prisma.ts
import { PrismaClient } from '../generated/prisma'

const globalForPrisma = globalThis as unknown as {
  prisma: PrismaClient | undefined
}

export const prisma = globalForPrisma.prisma ?? new PrismaClient()

if (process.env.NODE_ENV !== 'production') {
  globalForPrisma.prisma = prisma
}

# Сгенерировать Prisma Client
pnpm prisma generate

# Создать миграцию
pnpm prisma migrate dev --name init

# Проверить соединение
pnpm prisma db pull

# Открыть Prisma Studio
pnpm prisma studio

// nuxt.config.ts
export default defineNuxtConfig({
  nitro: {
    experimental: {
      websocket: true
    }
  }
})

pnpm add socket.io socket.io-client

// server/plugins/socket.io.ts
import { Server } from 'socket.io'
import { Server as Engine } from 'engine.io'

export default defineNitroPlugin((nitroApp) => {
  const engine = new Engine()
  const io = new Server()
  io.bind(engine)

  io.on('connection', (socket) => {
    console.log('Client connected:', socket.id)

    socket.on('disconnect', () => {
      console.log('Client disconnected:', socket.id)
    })
  })

  nitroApp.router.use('/socket.io/', defineEventHandler({
    handler(event) {
      engine.handleRequest(event.node.req, event.node.res)
      event._handled = true
    },
    websocket: {
      open(peer) {
        engine.handleUpgrade(peer.request, peer.websocket.socket)
      }
    }
  }))
})

# Запустить dev сервер
pnpm dev

# В другом терминале - тест подключения
node -e "
const { io } = require('socket.io-client');
const socket = io('http://localhost:3000');
socket.on('connect', () => {
  console.log('Connected:', socket.id);
  socket.disconnect();
  process.exit(0);
});
socket.on('connect_error', (err) => {
  console.error('Error:', err.message);
  process.exit(1);
});
"

# REST Client для VS Code
code --install-extension humao.rest-client

# Или httpie для терминала
brew install httpie

// server/api/health.get.ts
export default defineEventHandler(async (event) => {
  return {
    status: 'ok',
    timestamp: new Date().toISOString()
  }
})

# api.http
### Health Check
GET http://localhost:3000/api/health

### Create User (пример)
POST http://localhost:3000/api/users
Content-Type: application/json

{
  "email": "test@example.com",
  "name": "Test User"
}

# GET запрос
http GET localhost:3000/api/health

# POST запрос
http POST localhost:3000/api/users email=test@example.com name="Test User"

# Health check
curl -s http://localhost:3000/api/health | jq

# POST запрос
curl -X POST http://localhost:3000/api/users \
  -H "Content-Type: application/json" \
  -d '{"email":"test@example.com","name":"Test User"}' | jq

// prisma/seed.ts
import { PrismaClient } from '../server/generated/prisma'

const prisma = new PrismaClient()

async function main() {
  // Очистка
  await prisma.user.deleteMany()

  // Создание тестовых данных
  await prisma.user.createMany({
    data: [
      { email: 'admin@example.com', name: 'Admin' },
      { email: 'user@example.com', name: 'User' },
    ],
  })

  console.log('Seed completed')
}

main()
  .catch(console.error)
  .finally(() => prisma.$disconnect())

{
  "prisma": {
    "seed": "tsx prisma/seed.ts"
  }
}

# Установить tsx если нет
pnpm add -D tsx

# Запустить seed
pnpm prisma db seed

// Неправильно (старый способ)
import { PrismaClient } from '@prisma/client'

// Правильно (Prisma 7)
import { PrismaClient } from '../generated/prisma'

# Проверить статус PostgreSQL
docker ps | grep postgres

# Если не запущен
docker start postgres-dev

# Или проверить локальный сервис
brew services list | grep postgresql

# Пересоздать базу
dropdb app_dev
createdb app_dev

# Применить миграции заново
pnpm prisma migrate dev