mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
b5f5e909bd
* return parameters from Terraform provisioner in sorted order * persist parameter indices in database and return them in correct order from API * don't re-sort parameters by name when creating templates
16 lines
461 B
SQL
16 lines
461 B
SQL
-- temporarily create index column as nullable
|
|
ALTER TABLE parameter_schemas ADD COLUMN index integer;
|
|
|
|
-- initialize ordering for existing parameters
|
|
WITH tmp AS (
|
|
SELECT id, row_number() OVER (PARTITION BY job_id ORDER BY name) AS index
|
|
FROM parameter_schemas
|
|
)
|
|
UPDATE parameter_schemas
|
|
SET index = tmp.index
|
|
FROM tmp
|
|
WHERE parameter_schemas.id = tmp.id;
|
|
|
|
-- all rows should now be initialized
|
|
ALTER TABLE parameter_schemas ALTER COLUMN index SET NOT NULL;
|