6-bo'lim mashqlari — Node.js + MySQL + Redis

CREATE TABLE kitoblar (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    nom        VARCHAR(200) NOT NULL,
    muallif    VARCHAR(100) NOT NULL,
    yil        SMALLINT UNSIGNED NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) DEFAULT CHARSET = utf8mb4;

INSERT INTO kitoblar (nom, muallif, yil) VALUES
    ('O''tkan kunlar', 'Abdulla Qodiriy', 1926),
    ('Kecha va kunduz', 'Cho''lpon', 1936),
    ('Sariq devni minib', 'Xudoyberdi To''xtaboyev', 1968);

import express from 'express';
import mysql from 'mysql2/promise';
import { createClient } from 'redis';

const app = express();
app.use(express.json());

const pool = mysql.createPool({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASSWORD,
  database: process.env.DB_NAME,
  connectionLimit: 10,
});

const redis = createClient({ url: process.env.REDIS_URL });
redis.on('error', (e) => console.error('Redis:', e.message));
await redis.connect();

const KESH_KALIT = 'kitoblar:hammasi';

app.get('/health', async (_req, res) => {
  try {
    await pool.query('SELECT 1');
    await redis.ping();
    res.json({ holat: 'ok' });
  } catch {
    res.status(503).json({ holat: 'xato' });
  }
});

app.get('/kitoblar', async (_req, res) => {
  const kesh = await redis.get(KESH_KALIT);
  if (kesh) return res.set('X-Kesh', 'HIT').json(JSON.parse(kesh));

  const [rows] = await pool.query('SELECT id, nom, muallif, yil FROM kitoblar ORDER BY id');
  await redis.set(KESH_KALIT, JSON.stringify(rows), { EX: 30 });
  res.set('X-Kesh', 'MISS').json(rows);
});

app.post('/kitoblar', async (req, res) => {
  const { nom, muallif, yil } = req.body ?? {};
  if (!nom || !muallif) return res.status(422).json({ xato: 'nom va muallif kerak' });

  const [r] = await pool.execute(
    'INSERT INTO kitoblar (nom, muallif, yil) VALUES (?, ?, ?)',
    [nom, muallif, yil ?? null]
  );
  await redis.del(KESH_KALIT);
  res.status(201).json({ id: (r as mysql.ResultSetHeader).insertId });
});

const PORT = Number(process.env.PORT ?? 3000);
const server = app.listen(PORT, '0.0.0.0', () => console.log(`API ${PORT}-portda`));

process.on('SIGTERM', async () => {
  server.close();
  await pool.end();
  await redis.quit();
  process.exit(0);
});

package.json da "type": "module" va tsconfig.json da "module": "nodenext" (top-level await uchun), skriptlar: "dev": "tsx watch src/index.ts", "build": "tsc", "start": "node dist/index.js".

# syntax=docker/dockerfile:1
FROM node:22-alpine AS base
WORKDIR /app
COPY package.json package-lock.json ./

FROM base AS dev
RUN npm ci
COPY . .
CMD ["npm", "run", "dev"]

FROM base AS build
RUN npm ci
COPY . .
RUN npm run build

FROM base AS production
ENV NODE_ENV=production
RUN npm ci --omit=dev && npm cache clean --force
COPY --from=build /app/dist ./dist
USER node
EXPOSE 3000
HEALTHCHECK --interval=15s --timeout=3s --start-period=10s \
  CMD wget -qO- http://localhost:3000/health || exit 1
CMD ["node", "dist/index.js"]

name: kitoblar

services:
  api:
    build:
      context: .
      target: production
    restart: unless-stopped
    environment:
      DB_HOST: baza
      DB_NAME: kitoblar
      DB_USER: app
      DB_PASSWORD: ${DB_PASSWORD:?DB_PASSWORD kerak}
      REDIS_URL: redis://kesh:6379
    depends_on:
      baza:
        condition: service_healthy
      kesh:
        condition: service_healthy

  baza:
    image: mysql:8.4
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: ${DB_ROOT_PASSWORD:?DB_ROOT_PASSWORD kerak}
      MYSQL_DATABASE: kitoblar
      MYSQL_USER: app
      MYSQL_PASSWORD: ${DB_PASSWORD}
      TZ: Asia/Tashkent
    volumes:
      - baza-data:/var/lib/mysql
      - ./db/init:/docker-entrypoint-initdb.d:ro
    healthcheck:
      test: ["CMD", "mysqladmin", "ping", "-h", "localhost", "--silent"]
      interval: 5s
      timeout: 5s
      retries: 20
      start_period: 30s

  kesh:
    image: redis:7-alpine
    restart: unless-stopped
    command: redis-server --appendonly yes
    volumes:
      - redis-data:/data
    healthcheck:
      test: ["CMD", "redis-cli", "ping"]
      interval: 5s
      retries: 10

  adminer:
    image: adminer
    ports:
      - "127.0.0.1:8080:8080"
    profiles: [tools]

volumes:
  baza-data:
  redis-data:

services:
  api:
    build:
      target: dev
    ports:
      - "3000:3000"
    environment:
      NODE_ENV: development
    develop:
      watch:
        - action: sync
          path: ./src
          target: /app/src
        - action: rebuild
          path: package.json

  baza:
    ports:
      - "127.0.0.1:3306:3306"

# compose.prod.yaml
services:
  api:
    ports:
      - "127.0.0.1:3000:3000"
    deploy:
      resources:
        limits:
          memory: 512M
    logging:
      driver: json-file
      options: { max-size: "10m", max-file: "3" }

# .env.example
DB_ROOT_PASSWORD=
DB_PASSWORD=