/
dfr8938
/
store
Обзор
Документация
Войти
/
dfr8938
/
store
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
controllers/user.controller.js
36 строк
1 KB
dfr8938
first_commit
22 ноя 2025, 22:40
22 ноя 2025, 22:40
68c763a
Код
Авторство
О чём код?
const db = require("../db.js"); class UserController { async create(req, res) { const { name, surname } = req.body; const user = await db .query(`INSERT INTO person (name, surname) VALUES ($1, $2) RETURNING *`, [name, surname]); res.json(user.rows[0]); }; async getAll(req, res) { const users = await db.query(`SELECT * FROM person`); res.json(users.rows); }; async getOne(req, res) { const id = req.params.id; const user = await db.query(`SELECT * FROM person WHERE id = $1`, [id]); res.json(user.rows[0]); }; async update(req, res) { const { id, name, surname } = req.body; const user = await db.query(`UPDATE person SET name = $1, surname = $2 WHERE id = $3 RETURNING *`, [name, surname, id]); res.json(user.rows[0]); }; async delete(req, res) { const { id } = req.params; const user = await db.query(`DELETE FROM person WHERE id = $1`, [id]); res.json(user.rows); }; } module.exports = new UserController();