coder · Emyrk · 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
@@ -0,0 +1,2 @@
+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
@@ -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.'
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
@@ -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
 	);
diff --git a/coderd/provisionerdserver/provisionerdserver.go b/coderd/provisionerdserver/provisionerdserver.go
@@ -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 {
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;