- Notifications
You must be signed in to change notification settings - Fork1.1k
fix(coderd): remove deprecated AITaskSidebarApp column#20680
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.
Already on GitHub?Sign in to your account
base:main
Are you sure you want to change the base?
Uh oh!
There was an error while loading.Please reload this page.
Changes fromall commits
File filter
Filter by extension
Conversations
Uh oh!
There was an error while loading.Please reload this page.
Jump to
Uh oh!
There was an error while loading.Please reload this page.
Diff view
Diff view
There are no files selected for viewing
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
| Original file line number | Diff line number | Diff line change |
|---|---|---|
| @@ -0,0 +1,45 @@ | ||
| ALTER TABLE workspace_builds ADD COLUMN ai_task_sidebar_app_id UUID; | ||
| ALTER TABLE workspace_builds ADD CONSTRAINT workspace_builds_ai_task_sidebar_app_id_fkey FOREIGN KEY (ai_task_sidebar_app_id) REFERENCES workspace_apps(id); | ||
| DROP VIEW workspace_build_with_user; | ||
| -- Restore view. | ||
| CREATE VIEW workspace_build_with_user AS | ||
| SELECT | ||
| workspace_builds.id, | ||
| workspace_builds.created_at, | ||
| workspace_builds.updated_at, | ||
| workspace_builds.workspace_id, | ||
| workspace_builds.template_version_id, | ||
| workspace_builds.build_number, | ||
| workspace_builds.transition, | ||
| workspace_builds.initiator_id, | ||
| workspace_builds.provisioner_state, | ||
| workspace_builds.job_id, | ||
| workspace_builds.deadline, | ||
| workspace_builds.reason, | ||
| workspace_builds.daily_cost, | ||
| workspace_builds.max_deadline, | ||
| workspace_builds.template_version_preset_id, | ||
| workspace_builds.has_ai_task, | ||
| workspace_builds.ai_task_sidebar_app_id, | ||
| workspace_builds.has_external_agent, | ||
| COALESCE( | ||
| visible_users.avatar_url, | ||
| '' :: text | ||
| ) AS initiator_by_avatar_url, | ||
| COALESCE( | ||
| visible_users.username, | ||
| '' :: text | ||
| ) AS initiator_by_username, | ||
| COALESCE(visible_users.name, '' :: text) AS initiator_by_name | ||
| FROM | ||
| ( | ||
| workspace_builds | ||
| LEFT JOIN visible_users ON ( | ||
| ( | ||
| workspace_builds.initiator_id = visible_users.id | ||
| ) | ||
| ) | ||
| ); | ||
| COMMENT ON VIEW workspace_build_with_user IS 'Joins in the username + avatar url of the initiated by user.'; |
| Original file line number | Diff line number | Diff line change |
|---|---|---|
| @@ -0,0 +1,43 @@ | ||
| -- We're dropping the ai_task_sidebar_app_id column. | ||
| DROP VIEW workspace_build_with_user; | ||
| CREATE VIEW workspace_build_with_user AS | ||
| SELECT | ||
| workspace_builds.id, | ||
| workspace_builds.created_at, | ||
| workspace_builds.updated_at, | ||
| workspace_builds.workspace_id, | ||
| workspace_builds.template_version_id, | ||
| workspace_builds.build_number, | ||
| workspace_builds.transition, | ||
| workspace_builds.initiator_id, | ||
| workspace_builds.provisioner_state, | ||
| workspace_builds.job_id, | ||
| workspace_builds.deadline, | ||
| workspace_builds.reason, | ||
| workspace_builds.daily_cost, | ||
| workspace_builds.max_deadline, | ||
| workspace_builds.template_version_preset_id, | ||
| workspace_builds.has_ai_task, | ||
| workspace_builds.has_external_agent, | ||
| COALESCE( | ||
| visible_users.avatar_url, | ||
| '' :: text | ||
| ) AS initiator_by_avatar_url, | ||
| COALESCE( | ||
| visible_users.username, | ||
| '' :: text | ||
| ) AS initiator_by_username, | ||
| COALESCE(visible_users.name, '' :: text) AS initiator_by_name | ||
| FROM | ||
| ( | ||
| workspace_builds | ||
| LEFT JOIN visible_users ON ( | ||
| ( | ||
| workspace_builds.initiator_id = visible_users.id | ||
| ) | ||
| ) | ||
| ); | ||
| COMMENT ON VIEW workspace_build_with_user IS 'Joins in the username + avatar url of the initiated by user.'; | ||
| ALTER TABLE workspace_builds DROP COLUMN ai_task_sidebar_app_id; | ||
johnstcn marked this conversation as resolved. Show resolvedHide resolvedUh oh!There was an error while loading.Please reload this page. | ||
Some generated files are not rendered by default. Learn more abouthow customized files appear on GitHub.
Uh oh!
There was an error while loading.Please reload this page.
Uh oh!
There was an error while loading.Please reload this page.
Uh oh!
There was an error while loading.Please reload this page.