forked from mtusi2026/mtusi2026lab5
17 lines
536 B
SQL
17 lines
536 B
SQL
-- name: CreateMessagesAttachments :execrows
|
|
INSERT INTO messages_attachments (message_id, attachment_id, chat_id, position)
|
|
SELECT $1, $2, $3, $4
|
|
FROM attachments
|
|
WHERE id = $2 AND chat_id = $3;
|
|
|
|
-- name: GetMessagesAttachments :many
|
|
SELECT attachment_id, position
|
|
FROM messages_attachments
|
|
WHERE message_id = sqlc.arg(message_id)
|
|
ORDER BY position ASC;
|
|
|
|
-- name: LockAttachmentsForMessage :many
|
|
SELECT id, status FROM attachments
|
|
WHERE chat_id = sqlc.arg(chat_id) AND id = ANY(sqlc.arg(attachment_ids)::uuid[])
|
|
ORDER BY id FOR SHARE;
|