75105b8b46
- OpenAPI: add missing endpoints (add-from-url, subscriptions, public availability) - OpenAPI: CalendarSubscription schema, Subscriptions tag - Frontend app - Migrations: count_for_availability, subscriptions_sync, user_preferences, calendar_settings - Config, rate limit, auth, calendar, booking, ICS, availability, user service updates Made-with: Cursor
41 lines
2.3 KiB
SQL
41 lines
2.3 KiB
SQL
-- name: CreateUser :one
|
|
INSERT INTO users (id, email, password_hash, timezone)
|
|
VALUES ($1, $2, $3, $4)
|
|
RETURNING id, email, password_hash, timezone, is_active, created_at, updated_at;
|
|
|
|
-- name: GetUserByID :one
|
|
SELECT id, email, password_hash, timezone, is_active, week_start_day, date_format, time_format,
|
|
default_event_duration_minutes, default_reminder_minutes, show_weekends,
|
|
working_hours_start, working_hours_end, notifications_email, created_at, updated_at
|
|
FROM users
|
|
WHERE id = $1 AND deleted_at IS NULL;
|
|
|
|
-- name: GetUserByEmail :one
|
|
SELECT id, email, password_hash, timezone, is_active, week_start_day, date_format, time_format,
|
|
default_event_duration_minutes, default_reminder_minutes, show_weekends,
|
|
working_hours_start, working_hours_end, notifications_email, created_at, updated_at
|
|
FROM users
|
|
WHERE email = $1 AND deleted_at IS NULL;
|
|
|
|
-- name: UpdateUser :one
|
|
UPDATE users
|
|
SET timezone = COALESCE(sqlc.narg('timezone')::TEXT, timezone),
|
|
week_start_day = COALESCE(sqlc.narg('week_start_day')::SMALLINT, week_start_day),
|
|
date_format = COALESCE(sqlc.narg('date_format')::TEXT, date_format),
|
|
time_format = COALESCE(sqlc.narg('time_format')::TEXT, time_format),
|
|
default_event_duration_minutes = COALESCE(sqlc.narg('default_event_duration_minutes')::INTEGER, default_event_duration_minutes),
|
|
default_reminder_minutes = COALESCE(sqlc.narg('default_reminder_minutes')::INTEGER, default_reminder_minutes),
|
|
show_weekends = COALESCE(sqlc.narg('show_weekends')::BOOLEAN, show_weekends),
|
|
working_hours_start = COALESCE(sqlc.narg('working_hours_start')::TEXT, working_hours_start),
|
|
working_hours_end = COALESCE(sqlc.narg('working_hours_end')::TEXT, working_hours_end),
|
|
notifications_email = COALESCE(sqlc.narg('notifications_email')::BOOLEAN, notifications_email),
|
|
updated_at = now()
|
|
WHERE id = @id AND deleted_at IS NULL
|
|
RETURNING id, email, password_hash, timezone, is_active, week_start_day, date_format, time_format,
|
|
default_event_duration_minutes, default_reminder_minutes, show_weekends,
|
|
working_hours_start, working_hours_end, notifications_email, created_at, updated_at;
|
|
|
|
-- name: SoftDeleteUser :exec
|
|
UPDATE users SET deleted_at = now(), is_active = false, updated_at = now()
|
|
WHERE id = $1 AND deleted_at IS NULL;
|