/
Arsinenko
/
CompClubAPI_Go
Обзор
Документация
Войти
/
Arsinenko
/
CompClubAPI_Go
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
main
sqlc/queries/bookings.sql
32 строки
879 B
Arsinenko
booking sqlc, club_service refactoring, tariff handlers
07 окт 2025, 18:01
07 окт 2025, 18:01
05974d9
Код
Авторство
О чём код?
-- name: StartBooking :one INSERT INTO bookings("user", working_space, start_time) VALUES ($1, $2, $3) RETURNING *; -- name: EndBooking :exec WITH updated_booking AS ( UPDATE bookings SET end_time = $1 WHERE bookings.id = $2 RETURNING "user", working_space ), booking_price AS ( SELECT ub."user", t.price FROM updated_booking ub JOIN working_spaces ws ON ws.id = ub.working_space JOIN tariffs t ON t.name = ws.tariff ) UPDATE users SET balance = users.balance - bp.price FROM booking_price bp WHERE users.login = bp."user"; -- name: GetUserBookings :many SELECT * FROM bookings WHERE "user" = $1; -- name: GetAllBookings :many SELECT * FROM bookings; -- name: GetBookingById :one SELECT * FROM bookings WHERE id = $1; -- name: DeleteBooking :exec DELETE FROM bookings WHERE id = $1;