mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
26 lines
584 B
SQL
26 lines
584 B
SQL
-- name: GetTemplateVersionTerraformValues :one
|
|
SELECT
|
|
template_version_terraform_values.*
|
|
FROM
|
|
template_version_terraform_values
|
|
WHERE
|
|
template_version_terraform_values.template_version_id = @template_version_id;
|
|
|
|
-- name: InsertTemplateVersionTerraformValuesByJobID :exec
|
|
INSERT INTO
|
|
template_version_terraform_values (
|
|
template_version_id,
|
|
cached_plan,
|
|
cached_module_files,
|
|
updated_at,
|
|
provisionerd_version
|
|
)
|
|
VALUES
|
|
(
|
|
(select id from template_versions where job_id = @job_id),
|
|
@cached_plan,
|
|
@cached_module_files,
|
|
@updated_at,
|
|
@provisionerd_version
|
|
);
|