// Code generated by sqlc. DO NOT EDIT. // versions: // sqlc v1.31.1 // source: messages_attachments.sql package sqlc import ( "context" "github.com/jackc/pgx/v5/pgtype" ) const createMessagesAttachments = `-- 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 ` type CreateMessagesAttachmentsParams struct { MessageID pgtype.UUID AttachmentID pgtype.UUID ChatID pgtype.UUID Position int16 } func (q *Queries) CreateMessagesAttachments(ctx context.Context, arg CreateMessagesAttachmentsParams) (int64, error) { result, err := q.db.Exec(ctx, createMessagesAttachments, arg.MessageID, arg.AttachmentID, arg.ChatID, arg.Position, ) if err != nil { return 0, err } return result.RowsAffected(), nil } const getMessagesAttachments = `-- name: GetMessagesAttachments :many SELECT attachment_id, position FROM messages_attachments WHERE message_id = $1 ORDER BY position ASC ` type GetMessagesAttachmentsRow struct { AttachmentID pgtype.UUID Position int16 } func (q *Queries) GetMessagesAttachments(ctx context.Context, messageID pgtype.UUID) ([]GetMessagesAttachmentsRow, error) { rows, err := q.db.Query(ctx, getMessagesAttachments, messageID) if err != nil { return nil, err } defer rows.Close() var items []GetMessagesAttachmentsRow for rows.Next() { var i GetMessagesAttachmentsRow if err := rows.Scan(&i.AttachmentID, &i.Position); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil } const lockAttachmentsForMessage = `-- name: LockAttachmentsForMessage :many SELECT id, status FROM attachments WHERE chat_id = $1 AND id = ANY($2::uuid[]) ORDER BY id FOR SHARE ` type LockAttachmentsForMessageParams struct { ChatID pgtype.UUID AttachmentIds []pgtype.UUID } type LockAttachmentsForMessageRow struct { ID pgtype.UUID Status string } func (q *Queries) LockAttachmentsForMessage(ctx context.Context, arg LockAttachmentsForMessageParams) ([]LockAttachmentsForMessageRow, error) { rows, err := q.db.Query(ctx, lockAttachmentsForMessage, arg.ChatID, arg.AttachmentIds) if err != nil { return nil, err } defer rows.Close() var items []LockAttachmentsForMessageRow for rows.Next() { var i LockAttachmentsForMessageRow if err := rows.Scan(&i.ID, &i.Status); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil }