server/routes/resources.js

Repository

wynajem_motorowek

Original path

server/routes/resources.js

Role

SOURCE

Size

592 bytes

Lines

29

SHA-256

6bc652fdc6fdc64337713c5b47fd53c10ee825a1fd0317e012680611cfe50701

Displayed range

1–29

const express = require("express");

module.exports = function resourcesRoute({ db }) {
	const router = express.Router();

	router.get("/", async (_req, res, next) => {
		try {
			const { rows } = await db.query(
				`SELECT name, capacity
				 FROM resources
					 WHERE active = 1
				 ORDER BY name ASC`
			);
			res.json({
				ok: true,
				resources: rows.map((item) => item.name),
				items: rows.map((item) => ({
					name: item.name,
					capacity: Number(item.capacity || 6),
				})),
			});
		} catch (err) {
			next(err);
		}
	});

	return router;
};