mirror of
https://github.com/go-gitea/gitea.git
synced 2026-07-23 05:17:29 +02:00
Migrations should never use model structs directly, because the model structs can be different in different releases. e.g. if one migration uses "User" model, it works in the early releases, then one day, when the User model changes, the migration breaks because it will use the new (incorrect) User model, it should only use the old User model. The same to "modules/structs". --------- Signed-off-by: wxiaoguang <wxiaoguang@gmail.com> Co-authored-by: delvh <dev.lh@web.de>
30 lines
797 B
Go
30 lines
797 B
Go
// Copyright 2025 The Gitea Authors. All rights reserved.
|
|
// SPDX-License-Identifier: MIT
|
|
|
|
package v1_24
|
|
|
|
import (
|
|
"gitea.dev/modelmigration/base"
|
|
)
|
|
|
|
func MovePinOrderToTableIssuePin(x base.EngineMigration) error {
|
|
type IssuePin struct {
|
|
ID int64 `xorm:"pk autoincr"`
|
|
RepoID int64 `xorm:"UNIQUE(s) NOT NULL"`
|
|
IssueID int64 `xorm:"UNIQUE(s) NOT NULL"`
|
|
IsPull bool `xorm:"NOT NULL"`
|
|
PinOrder int `xorm:"DEFAULT 0"`
|
|
}
|
|
|
|
if err := x.Sync(new(IssuePin)); err != nil {
|
|
return err
|
|
}
|
|
|
|
if _, err := x.Exec("INSERT INTO issue_pin (repo_id, issue_id, is_pull, pin_order) SELECT repo_id, id, is_pull, pin_order FROM issue WHERE pin_order > 0"); err != nil {
|
|
return err
|
|
}
|
|
sess := x.NewSession()
|
|
defer sess.Close()
|
|
return base.DropTableColumns(sess, "issue", "pin_order")
|
|
}
|