1) MongoDB Atlas

Alustame pilveandmebaasi loomisest teenuses MongoDB Atlas.

2) Paigaldamine

Projektis paigaldame vajalikud paketid ja seadistame keskkonnamuutujad.

Kopeerinpm install express swagger-ui-express mongoose dotenv

.env fail projekti juurkaustas:

KopeeriMONGODB_URI=mongodb+srv://<USER>:<PASS>@<CLUSTER>.mongodb.net/?retryWrites=true&w=majority&appName=Cluster0

3) Mongoose: mudel Game

Luuakse lihtne skeem, kus id on unikaalne, lisaks nimi ja hind.

Kopeeri// models/game.js
const mongoose = require('mongoose');

const gameSchema = new mongoose.Schema({
  id:   { type: Number, required: true, unique: true, index: true },
  name: { type: String, required: true },
  price:{ type: Number, required: true }
}, { timestamps: true });

module.exports = mongoose.model('Game', gameSchema);

4) Express API rajad

All on näidised GET, POST, PUT, DELETE jaoks. Kui kasutad praegu mälus hoitavat massiivi, jätka nii; kui kolid MongoDB-le, asenda loogika Mongoose päringutega.

Kopeeri// index.js (põhiosa)
require('dotenv').config();
const express = require('express');
const swaggerUi = require('swagger-ui-express');
const swaggerDocument = require('./docs/swagger.json');
const mongoose = require('mongoose');
const Game = require('./models/game');

const app = express();
const port = process.env.PORT || 8080;

mongoose.connect(process.env.MONGODB_URI)
  .then(() => console.log('Connected to MongoDB Atlas'))
  .catch((err) => console.error('MongoDB connection error:', err));

app.use(express.json());

// DEMO: mälupõhine andmestik (vajadusel)
const games = [
  { id: 1, name: 'Witcher 3', price: 29.99 },
  { id: 2, name: 'Cyberpunk 2077', price: 59.99 },
  { id: 3, name: 'Minecraft',   price: 26.99 }
];

// POST /games — loo uus
app.post('/games', (req, res) => {
  const { name, price } = req.body;
  if (name == null || price == null) {
    return res.status(400).json({ error: 'One or all params are missing' });
  }
  const game = { id: games.length + 1, name, price };
  games.push(game);
  res.status(201)
     .location(`${getBaseUrl(req)}/games/${game.id}`)
     .json(game);
});

// GET /games — nimed (otsing + sorteerimine)
app.get('/games', (req, res) => {
  const { q, order = 'asc' } = req.query;
  if (!['asc', 'desc'].includes(order)) {
    return res.status(400).json({ error: 'Invalid order. Use asc or desc.' });
  }
  let list = games.map(g => g.name);
  if (q?.trim()) {
    const s = q.toLowerCase();
    list = list.filter(n => n.toLowerCase().includes(s));
  }
  list.sort((a, b) => a.localeCompare(b));
  if (order === 'desc') list.reverse();
  res.json(list);
});

// GET /games/:id — detailid
app.get('/games/:id', (req, res) => {
  const id = Number(req.params.id);
  if (!Number.isInteger(id) || id <= 0) {
    return res.status(400).json({ error: 'Invalid id. Must be a positive integer.' });
  }
  const game = games.find(g => g.id === id);
  if (!game) return res.status(404).json({ error: `Game with id=${id} not found` });
  res.json(game);
});

// DELETE /games/:id — kustuta
app.delete('/games/:id', (req, res) => {
  const id = Number(req.params.id);
  if (!Number.isInteger(id) || id <= 0) {
    return res.status(400).json({ error: 'Invalid id. Must be a positive integer.' });
  }
  const idx = games.findIndex(g => g.id === id);
  if (idx === -1) return res.status(404).json({ error: 'Game not found' });
  games.splice(idx, 1);
  res.status(204).end();
});

// Swagger UI
app.use('/docs', swaggerUi.serve, swaggerUi.setup(swaggerDocument));
app.get('/', (req, res) => res.redirect('/docs'));

app.listen(port, () => console.log(`API up at: http://localhost:${port}`));

function getBaseUrl(req) {
  const protocol = (req.connection && req.connection.encrypted) ? 'https' : 'http';
  return `${protocol}://${req.headers.host}`;
}

5) Testimine

Käivita server ja testi Swagger UI kaudu.