coder
diff --git a/‎coderd/database/databasefake/databasefake.go
Lines changed: 19 additions & 0 deletions b/‎coderd/database/databasefake/databasefake.go
Lines changed: 19 additions & 0 deletions
diff --git a/‎coderd/database/querier.go
Lines changed: 1 addition & 0 deletions b/‎coderd/database/querier.go
Lines changed: 1 addition & 0 deletions
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 28 additions & 0 deletions b/‎coderd/database/queries.sql.go
Lines changed: 28 additions & 0 deletions
diff --git a/‎coderd/database/queries/templateversions.sql
Lines changed: 10 additions & 0 deletions b/‎coderd/database/queries/templateversions.sql
Lines changed: 10 additions & 0 deletions
@@ -1717,6 +1717,25 @@ func (q *fakeQuerier) GetTemplateVersionByJobID(_ context.Context, jobID uuid.UU
 	return database.TemplateVersion{}, sql.ErrNoRows
 }
 
+func (q *fakeQuerier) GetPreviousTemplateVersionByID(_ context.Context, id uuid.UUID) (database.TemplateVersion, error) {
+	q.mutex.RLock()
+	defer q.mutex.RUnlock()
+
+	var previousIndex = -1
+	for index, templateVersion := range q.templateVersions {
+		if templateVersion.ID != id {
+			continue
+		}
+		previousIndex = index - 1
+	}
+
+	if previousIndex < 0 {
+		return database.TemplateVersion{}, sql.ErrNoRows
+	}
+
+	return q.templateVersions[previousIndex], nil
+}
+
 func (q *fakeQuerier) GetParameterSchemasByJobID(_ context.Context, jobID uuid.UUID) ([]database.ParameterSchema, error) {
 	q.mutex.RLock()
 	defer q.mutex.RUnlock()
 
@@ -110,3 +110,13 @@ SET
 	updated_at = $3
 WHERE
 	job_id = $1;
+
+-- name: GetPreviousTemplateVersionByID :one
+SELECT
+	*
+FROM
+	template_versions
+WHERE
+	created_at < (SELECT created_at FROM template_versions WHERE template_versions.id = @id)
+ORDER BY created_at DESC
+LIMIT 1;