30 lines
1005 B
JavaScript
30 lines
1005 B
JavaScript
const express = require('express');
|
|
const router = express.Router();
|
|
const db = require('../db');
|
|
|
|
router.get('/', (req, res) => {
|
|
const folders = db.prepare('SELECT * FROM folders ORDER BY sort_order, name').all();
|
|
res.json(folders);
|
|
});
|
|
|
|
router.post('/', (req, res) => {
|
|
const { name } = req.body;
|
|
if (!name || !name.trim()) return res.status(400).json({ error: 'Name is required' });
|
|
const info = db.prepare('INSERT INTO folders (name) VALUES (?)').run(name.trim());
|
|
const folder = db.prepare('SELECT * FROM folders WHERE id = ?').get(info.lastInsertRowid);
|
|
res.status(201).json(folder);
|
|
});
|
|
|
|
router.put('/:id', (req, res) => {
|
|
const { name } = req.body;
|
|
db.prepare('UPDATE folders SET name = ? WHERE id = ?').run(name, req.params.id);
|
|
res.json(db.prepare('SELECT * FROM folders WHERE id = ?').get(req.params.id));
|
|
});
|
|
|
|
router.delete('/:id', (req, res) => {
|
|
db.prepare('DELETE FROM folders WHERE id = ?').run(req.params.id);
|
|
res.status(204).end();
|
|
});
|
|
|
|
module.exports = router;
|