jojo/models/forgejo_migrations/v14a_add-foreign-keys-pull_request-1.go

// Copyright 2025 The Forgejo Authors. All rights reserved.
// SPDX-License-Identifier: GPL-3.0-or-later

package forgejo_migrations

import (
	"xorm.io/builder"
	"xorm.io/xorm"
)

func init() {
	registerMigration(&Migration{
		Description: "add foreign keys to pull_request, base_repo_id & issue_id",
		Upgrade:     addForeignKeysPullRequest1,
	})
}

func addForeignKeysPullRequest1(x *xorm.Engine) error {
	type PullRequest struct {
		IssueID    int64 `xorm:"INDEX REFERENCES(issue, id)"`
		BaseRepoID int64 `xorm:"INDEX REFERENCES(repository, id)"`
	}
	return syncForeignKeyWithDelete(x,
		new(PullRequest),
		builder.Or(
			builder.Expr("NOT EXISTS (SELECT id FROM issue WHERE issue.id = pull_request.issue_id)"),
			builder.Expr("NOT EXISTS (SELECT id FROM repository WHERE repository.id = pull_request.base_repo_id)"),
		),
	)
}