mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
8e684c8195
Updates coder/customers#365 This PR updates our migration framework to run all migrations in a single transaction. This is the same behavior we had in v1 and ensures that failed migrations don't bring the whole deployment down. If a migration fails now, it will automatically be rolled back to the previous version, allowing the deployment to continue functioning.
18 lines
799 B
SQL
18 lines
799 B
SQL
-- Add "exectrace" to workspace_agent_subsystem type.
|
|
ALTER TYPE workspace_agent_subsystem ADD VALUE 'exectrace';
|
|
|
|
-- Create column subsystems in workspace_agents table, with default value being
|
|
-- an empty array.
|
|
ALTER TABLE workspace_agents ADD COLUMN subsystems workspace_agent_subsystem[] DEFAULT '{}';
|
|
|
|
-- Add a constraint that the subsystems cannot contain the deprecated value
|
|
-- 'none'.
|
|
ALTER TABLE workspace_agents ADD CONSTRAINT subsystems_not_none CHECK (NOT ('none' = ANY (subsystems)));
|
|
|
|
-- Update all existing workspace_agents to have subsystems = [subsystem] unless
|
|
-- the subsystem is 'none'.
|
|
UPDATE workspace_agents SET subsystems = ARRAY[subsystem] WHERE subsystem != 'none';
|
|
|
|
-- Drop the subsystem column from workspace_agents.
|
|
ALTER TABLE workspace_agents DROP COLUMN subsystem;
|