diff options
| author | Leo Goetz <dev@leogtz.de> | 2026-01-22 09:10:15 +0100 |
|---|---|---|
| committer | Leo Goetz <dev@leogtz.de> | 2026-01-22 09:10:15 +0100 |
| commit | 01c0f792484f8f52606eae0e58abe528acef3086 (patch) | |
| tree | e30894caf65b39aab1e050035f63450b5032123c /backend/src/routes/events.js | |
| parent | b6d422d33c3b647ab249a8cf3520bc986fa2c549 (diff) | |
Diffstat (limited to 'backend/src/routes/events.js')
| -rw-r--r-- | backend/src/routes/events.js | 97 |
1 files changed, 0 insertions, 97 deletions
diff --git a/backend/src/routes/events.js b/backend/src/routes/events.js deleted file mode 100644 index b95c747..0000000 --- a/backend/src/routes/events.js +++ /dev/null @@ -1,97 +0,0 @@ -import db from '../db.js'; -import { Router } from 'express'; -import { getUser } from './users.js'; - -const router = Router(); - -const joinHost = (event) => { - const host = getUser(event.host_id); - return { ...event, host }; -} - -const joinRSVPs = (event) => { - const { id } = event; - const getRSVPs = db.prepare('SELECT * FROM rsvps WHERE event_id = @id'); - const rsvps = getRSVPs.all({ id }); - return { ...event, rsvps }; -} - -const getEvent = (eventId) => { - const byId = db.prepare('SELECT * FROM events WHERE id = @eventId'); - const event = byId.get({ eventId }); - return joinHost(event); -} - -router.get('/', (_req, res) => { - const listEvents = db.prepare(`SELECT * FROM events`); - const events = listEvents.all(); - res.json(events.map(joinHost).map(joinRSVPs)); -}); - -const insertEvent = db.prepare(`INSERT INTO events VALUES (@id, @title, @description, @image_url, @date, @host_id)`); - -router.post('/new', (req, res) => { - const data = req.body; - const { lastInsertRowid: id } = insertEvent.run(data); - const event = getEvent(id); - res.status(201).json(event); -}); - -router.get('/:id', (req, res) => { - const id = parseInt(req.params.id); - const event = getEvent(id); - if (!event) { - return res.status(404).json({ error: 'Event not found' }); - } - res.json(event); -}); - -router.patch('/:id', (req, res) => { - const eventId = parseInt(req.params.id); - const patch = req.body; - - const updateCol = db.prepare(` - UPDATE events SET @col = @val WHERE id = @eventId - `); - const updateEvent = db.transaction((patch) => { - for (const [col, val] of Object.entries(patch)) { - updateCol.run({ col, val, eventId }); - } - }); - - updateEvent(Object.entries(patch)); - const updated = getEvent(eventId); - res.json(updated); -}); - -router.delete('/:id', (req, res) => { - const deleteEvent = db.prepare(`DELETE FROM events WHERE id = @eventId`); - const eventId = parseInt(req.params.id); - const event = getEvent(eventId); - if (!event) { - return res.status(404).json({ error: 'Event not found' }); - } - deleteEvent.run({ eventId }); - res.json(event); -}); - -router.post('/:id/rsvp', (req, res) => { - const eventId = parseInt(req.params.id); - const { name, email } = req.body; - - const getRSVP = db.prepare(`SELECT * FROM rsvps WHERE (event_id = ${eventId} AND email = '${email}')`); - const insertRSVP = db.prepare(`INSERT INTO rsvps VALUES (@eventId, @name, @email)`); - - let [rsvp] = getRSVP.all({ eventId, email }); - if (rsvp) { - // This email has already RSVPed - res.status(200).json({ rsvp }); - } else { - // New RSVP - insertRSVP.run({ name, email, eventId }); - rsvp = getRSVP.run({ eventId, email }); - res.status(201).json({ rsvp }); - } -}); - -export default router; |
