Files
mtusi2026lab5/db/queries/attachment_variants.sql

12 lines
368 B
SQL

-- name: CreateAttachmentVariant :exec
INSERT INTO attachment_variants (
attachment_id, pipeline_version, name, object_key, content_type, size_bytes, width, height, sha256
) VALUES (
$1, $2, $3, $4, $5, $6, $7, $8, $9
);
-- name: ListAttachmentVariants :many
SELECT * FROM attachment_variants
WHERE attachment_id = $1 AND pipeline_version = $2
ORDER BY name;