NotificationsYou must be signed in to change notification settings
Fork913
Star10k

feat: add ai tasks migrations#18359

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

Jump to bottom

Merged

hugodutka merged 3 commits intomainfromhugodutka/ai-tasks-migrations

Jun 13, 2025

Merged

feat: add ai tasks migrations#18359

hugodutka merged 3 commits intomainfromhugodutka/ai-tasks-migrations

Jun 13, 2025

Conversation

Copy link

Contributor

hugodutka commentedJun 13, 2025•
edited
Loading

Adds database migrations required for the Tasks feature.

There's a slight difference between the migrations in this PR and the RFC: this PR addsNOT NULL constraints to thehas_ai_task columns. It was an oversight on my part when I wrote the RFC - I assumed theDEFAULT FALSE value would make the columns implicitly NOT NULL, but that's not the case with Postgres. We have no use for the NULL value.

TheDEFAULT FALSE statement ensures that the migration will pass even when there are existing rows in the template version and workspace builds tables, so there's no danger in adding theNOT NULL constraints.

github-actionsbot assignedhugodutka

Jun 13, 2025

hugodutka force-pushed thehugodutka/ai-tasks-migrations branch from101e894 to2b15938Compare

June 13, 2025 12:57

hugodutka marked this pull request as ready for review

June 13, 2025 13:16

hugodutka requested a review fromdannykopping

June 13, 2025 13:16

dannykopping reviewed

Jun 13, 2025

View reviewed changes

coderd/database/migrations/000335_ai_tasks.up.sqlShow resolvedHide resolved

coderd/database/models.go Outdated

		@@ -3355,6 +3355,7 @@ type TemplateVersion struct {
		Message string `db:"message" json:"message"`
		Archived bool `db:"archived" json:"archived"`
		SourceExampleID sql.NullString `db:"source_example_id" json:"source_example_id"`
		HasAiTask bool `db:"has_ai_task" json:"has_ai_task"`