mirror of
https://github.com/J3vb/OwnCord.git
synced 2026-09-03 03:50:00 +03:00
J3vb
2a46b95111
- Add sqlc.yaml config (SQLite engine, db/queries/sqlite/, db/dbgen/ output) - Pin sqlc v1.30.0 in sqlc.version - Add Makefile with sqlc-install, sqlc-generate, sqlc-verify targets - Write 14 SQL query files covering all DB domains (users, sessions, invites, channels, messages, reactions, voice, roles, attachments, admin, dm, blocks, lockouts, profile) - Commit generated db/dbgen/ package (querier interface + typed fns) - FTS5 search queries remain hand-written in message_queries.go; transactional multi-step operations unchanged in Go
20 lines
726 B
SQL
20 lines
726 B
SQL
-- name: CreateInvite :exec
|
|
INSERT INTO invites (code, created_by, max_uses, expires_at) VALUES (?, ?, ?, ?);
|
|
|
|
-- name: GetInvite :one
|
|
SELECT id, code, created_by, max_uses, use_count, expires_at, revoked, created_at
|
|
FROM invites WHERE code = ?;
|
|
|
|
-- name: UseInviteAtomic :execresult
|
|
UPDATE invites SET use_count = use_count + 1
|
|
WHERE code = ? AND revoked = 0
|
|
AND (max_uses IS NULL OR use_count < max_uses)
|
|
AND (expires_at IS NULL OR strftime('%s', expires_at) > strftime('%s', 'now'));
|
|
|
|
-- name: RevokeInvite :exec
|
|
UPDATE invites SET revoked = 1 WHERE code = ?;
|
|
|
|
-- name: ListInvites :many
|
|
SELECT id, code, created_by, max_uses, use_count, expires_at, revoked, created_at
|
|
FROM invites ORDER BY created_at DESC LIMIT 200;
|