// Code generated by sqlc. DO NOT EDIT. // versions: // sqlc v1.31.1 // source: attachment_variants.sql package sqlc import ( "context" "github.com/jackc/pgx/v5/pgtype" ) const createAttachmentVariant = `-- 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 ) ` type CreateAttachmentVariantParams struct { AttachmentID pgtype.UUID PipelineVersion int32 Name string ObjectKey string ContentType string SizeBytes int64 Width int32 Height int32 Sha256 string } func (q *Queries) CreateAttachmentVariant(ctx context.Context, arg CreateAttachmentVariantParams) error { _, err := q.db.Exec(ctx, createAttachmentVariant, arg.AttachmentID, arg.PipelineVersion, arg.Name, arg.ObjectKey, arg.ContentType, arg.SizeBytes, arg.Width, arg.Height, arg.Sha256, ) return err } const listAttachmentVariants = `-- name: ListAttachmentVariants :many SELECT attachment_id, pipeline_version, name, object_key, content_type, size_bytes, width, height, sha256 FROM attachment_variants WHERE attachment_id = $1 AND pipeline_version = $2 ORDER BY name ` type ListAttachmentVariantsParams struct { AttachmentID pgtype.UUID PipelineVersion int32 } func (q *Queries) ListAttachmentVariants(ctx context.Context, arg ListAttachmentVariantsParams) ([]AttachmentVariant, error) { rows, err := q.db.Query(ctx, listAttachmentVariants, arg.AttachmentID, arg.PipelineVersion) if err != nil { return nil, err } defer rows.Close() var items []AttachmentVariant for rows.Next() { var i AttachmentVariant if err := rows.Scan( &i.AttachmentID, &i.PipelineVersion, &i.Name, &i.ObjectKey, &i.ContentType, &i.SizeBytes, &i.Width, &i.Height, &i.Sha256, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil }