26 lines
658 B
SQL
26 lines
658 B
SQL
-- name: CreateAttendee :one
|
|
INSERT INTO event_attendees (id, event_id, user_id, email, status)
|
|
VALUES ($1, $2, $3, $4, 'pending')
|
|
RETURNING id, event_id, user_id, email, status;
|
|
|
|
-- name: ListAttendeesByEvent :many
|
|
SELECT id, event_id, user_id, email, status
|
|
FROM event_attendees
|
|
WHERE event_id = $1
|
|
ORDER BY id ASC;
|
|
|
|
-- name: UpdateAttendeeStatus :one
|
|
UPDATE event_attendees
|
|
SET status = $2
|
|
WHERE id = $1
|
|
RETURNING id, event_id, user_id, email, status;
|
|
|
|
-- name: DeleteAttendee :exec
|
|
DELETE FROM event_attendees
|
|
WHERE id = $1 AND event_id = $2;
|
|
|
|
-- name: GetAttendeeByID :one
|
|
SELECT id, event_id, user_id, email, status
|
|
FROM event_attendees
|
|
WHERE id = $1;
|