coder · mtojek · Feb 7, 2023 · Feb 6, 2023 · Feb 6, 2023 · Feb 6, 2023
diff --git a/cli/cliui/parameter.go b/cli/cliui/parameter.go
@@ -114,5 +114,5 @@ func validateRichPrompt(value string, p codersdk.TemplateVersionParameter) error
 	return codersdk.ValidateWorkspaceBuildParameter(p, codersdk.WorkspaceBuildParameter{
 		Name:  p.Name,
 		Value: value,
-	})
+	}, nil)
 }
diff --git a/coderd/apidoc/docs.go b/coderd/apidoc/docs.go
diff --git a/coderd/apidoc/swagger.json b/coderd/apidoc/swagger.json
diff --git a/coderd/database/dbfake/databasefake.go b/coderd/database/dbfake/databasefake.go
@@ -2573,18 +2573,19 @@ func (q *fakeQuerier) InsertTemplateVersionParameter(_ context.Context, arg data
 
 	//nolint:gosimple
 	param := database.TemplateVersionParameter{
-		TemplateVersionID: arg.TemplateVersionID,
-		Name:              arg.Name,
-		Description:       arg.Description,
-		Type:              arg.Type,
-		Mutable:           arg.Mutable,
-		DefaultValue:      arg.DefaultValue,
-		Icon:              arg.Icon,
-		Options:           arg.Options,
-		ValidationError:   arg.ValidationError,
-		ValidationRegex:   arg.ValidationRegex,
-		ValidationMin:     arg.ValidationMin,
-		ValidationMax:     arg.ValidationMax,
+		TemplateVersionID:   arg.TemplateVersionID,
+		Name:                arg.Name,
+		Description:         arg.Description,
+		Type:                arg.Type,
+		Mutable:             arg.Mutable,
+		DefaultValue:        arg.DefaultValue,
+		Icon:                arg.Icon,
+		Options:             arg.Options,
+		ValidationError:     arg.ValidationError,
+		ValidationRegex:     arg.ValidationRegex,
+		ValidationMin:       arg.ValidationMin,
+		ValidationMax:       arg.ValidationMax,
+		ValidationMonotonic: arg.ValidationMonotonic,
 	}
 	q.templateVersionParameters = append(q.templateVersionParameters, param)
 	return param, nil

diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000094_rich_parameters_validation_monotonic.down.sql b/coderd/database/migrations/000094_rich_parameters_validation_monotonic.down.sql
@@ -0,0 +1,3 @@
+ALTER TABLE template_version_parameters DROP CONSTRAINT validation_monotonic_order;
+
+ALTER TABLE template_version_parameters DROP COLUMN validation_monotonic;
diff --git a/coderd/database/migrations/000094_rich_parameters_validation_monotonic.up.sql b/coderd/database/migrations/000094_rich_parameters_validation_monotonic.up.sql
@@ -0,0 +1,6 @@
+ALTER TABLE template_version_parameters ADD COLUMN validation_monotonic text NOT NULL DEFAULT '';
+
+ALTER TABLE template_version_parameters ADD CONSTRAINT validation_monotonic_order CHECK (validation_monotonic IN ('increasing', 'decreasing', ''));
+
+COMMENT ON COLUMN template_version_parameters.validation_monotonic
+IS 'Validation: consecutive values preserve the monotonic order';
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/templateversionparameters.sql b/coderd/database/queries/templateversionparameters.sql
@@ -12,7 +12,8 @@ INSERT INTO
         validation_regex,
         validation_min,
         validation_max,
-        validation_error
+        validation_error,
+        validation_monotonic
     )
 VALUES
     (
@@ -27,7 +28,8 @@ VALUES
         $9,
         $10,
         $11,
-        $12
+        $12,
+        $13
     ) RETURNING *;
 
 -- name: GetTemplateVersionParameters :many
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,3 @@
		ALTER TABLE template_version_parameters DROP CONSTRAINT validation_monotonic_order;

		ALTER TABLE template_version_parameters DROP COLUMN validation_monotonic;