Apr 23, 2025 · Apr 23, 2025 · Apr 23, 2025
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000318_template_module_data.down.sql b/coderd/database/migrations/000318_template_module_data.down.sql
 ALTER TABLE template_version_terraform_values
 DROP COLUMN IF EXISTS modules;
diff --git a/coderd/database/migrations/000318_template_module_data.up.sql b/coderd/database/migrations/000318_template_module_data.up.sql
 ALTER TABLE template_version_terraform_values
 ADD COLUMN IF NOT EXISTS tfstate bytea DEFAULT null;

 COMMENT ON COLUMN template_version_terraform_values.tfstate IS 'Tarball of the relevant tfstate directory files for dynamic parameters. Not all files are included.'
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/templateversionterraformvalues.sql b/coderd/database/queries/templateversionterraformvalues.sql
 template_version_terraform_values (
 template_version_id,
 cached_plan,
    tfstate,
 updated_at
 )
 VALUES
 (
 (select id from template_versions where job_id = @job_id),
 @cached_plan,
 @tfstate,
 @updated_at
 );
diff --git a/coderd/provisionerdserver/provisionerdserver.go b/coderd/provisionerdserver/provisionerdserver.go
 err := s.Database.InsertTemplateVersionTerraformValuesByJobID(ctx, database.InsertTemplateVersionTerraformValuesByJobIDParams{
 JobID:      jobID,
 CachedPlan: jobType.TemplateImport.Plan,
 Tfstate:    nil,
 UpdatedAt:  now,
 })
 if err != nil {
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		ALTER TABLE template_version_terraform_values
		DROP COLUMN IF EXISTS modules;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,4 @@
		ALTER TABLE template_version_terraform_values
		ADD COLUMN IF NOT EXISTS tfstate bytea DEFAULT null;

		COMMENT ON COLUMN template_version_terraform_values.tfstate IS 'Tarball of the relevant tfstate directory files for dynamic parameters. Not all files are included.'
Original file line number	Diff line number	Diff line change
Expand Up		@@ -11,11 +11,13 @@ INSERT INTO
		template_version_terraform_values (
		template_version_id,
		cached_plan,
		tfstate,
		updated_at
		)
		VALUES
		(
		(select id from template_versions where job_id = @job_id),
		@cached_plan,
		@tfstate,
		@updated_at
		);
Original file line number	Diff line number	Diff line change
Expand Up		@@ -1428,6 +1428,7 @@ func (s server) CompleteJob(ctx context.Context, completed proto.CompletedJob)
		err := s.Database.InsertTemplateVersionTerraformValuesByJobID(ctx, database.InsertTemplateVersionTerraformValuesByJobIDParams{
		JobID: jobID,
		CachedPlan: jobType.TemplateImport.Plan,
		Tfstate: nil,
		UpdatedAt: now,
		})
		if err != nil {
Expand Down