Skip to content

Add max_workspaces and max_workspaces_per_user fields

What does this MR do and why?

Add max_workspaces and max_workspaces_per_user field to remote_development_agent_configs

Related to DB: Add workspaces_quota and workspaces_per_use... (#426511 - closed)

Migration output

$ bin/rails db:migrate:up:main VERSION=20231114062200 RAILS_ENV=development
main: == [advisory_lock_connection] object_id: 184200, pg_backend_pid: 481889
main: == 20231114062200 AddMaxWorkspacesToRemoteDevelopmentAgentConfigs: migrating ==
main: -- add_column(:remote_development_agent_configs, :max_workspaces, :bigint, {:default=>-1, :null=>false})
main:    -> 0.0026s
main: == 20231114062200 AddMaxWorkspacesToRemoteDevelopmentAgentConfigs: migrated (0.0058s) 
main: == [advisory_lock_connection] object_id: 184200, pg_backend_pid: 481889

$ bin/rails db:migrate:down:main VERSION=20231114062200 RAILS_ENV=development
main: == [advisory_lock_connection] object_id: 184060, pg_backend_pid: 482233
main: == 20231114062200 AddMaxWorkspacesToRemoteDevelopmentAgentConfigs: reverting ==
main: -- remove_column(:remote_development_agent_configs, :max_workspaces, :bigint, {:default=>-1, :null=>false})
main:    -> 0.0011s
main: == 20231114062200 AddMaxWorkspacesToRemoteDevelopmentAgentConfigs: reverted (0.0042s) 
main: == [advisory_lock_connection] object_id: 184060, pg_backend_pid: 482233


$ bin/rails db:migrate:up:main VERSION=20231114062215 RAILS_ENV=development
main: == [advisory_lock_connection] object_id: 184180, pg_backend_pid: 482701
main: == 20231114062215 AddMaxWorkspacesPerUserToRemoteDevelopmentAgentConfigs: migrating 
main: -- add_column(:remote_development_agent_configs, :max_workspaces_per_user, :bigint, {:default=>-1, :null=>false})
main:    -> 0.0020s
main: == 20231114062215 AddMaxWorkspacesPerUserToRemoteDevelopmentAgentConfigs: migrated (0.0061s) 
main: == [advisory_lock_connection] object_id: 184180, pg_backend_pid: 482701

$ bin/rails db:migrate:down:main VERSION=20231114062215 RAILS_ENV=development
main: == [advisory_lock_connection] object_id: 184180, pg_backend_pid: 483230
main: == 20231114062215 AddMaxWorkspacesPerUserToRemoteDevelopmentAgentConfigs: reverting 
main: -- remove_column(:remote_development_agent_configs, :max_workspaces_per_user, :bigint, {:default=>-1, :null=>false})
main:    -> 0.0011s
main: == 20231114062215 AddMaxWorkspacesPerUserToRemoteDevelopmentAgentConfigs: reverted (0.0045s) 
main: == [advisory_lock_connection] object_id: 184180, pg_backend_pid: 483230

How to set up and validate locally

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Alper Akgun

Merge request reports