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>
50 lines
1.0 KiB
Go
50 lines
1.0 KiB
Go
// Copyright 2023 The Gitea Authors. All rights reserved.
|
|
// SPDX-License-Identifier: MIT
|
|
|
|
package v1_20
|
|
|
|
import (
|
|
"gitea.dev/modelmigration/base"
|
|
"gitea.dev/modules/log"
|
|
)
|
|
|
|
// FixIncorrectProjectType: set individual project's type from 3(TypeOrganization) to 1(TypeIndividual)
|
|
func FixIncorrectProjectType(x base.EngineMigration) error {
|
|
type User struct {
|
|
ID int64 `xorm:"pk autoincr"`
|
|
Type int
|
|
}
|
|
|
|
const (
|
|
UserTypeIndividual int = 0
|
|
|
|
TypeIndividual uint8 = 1
|
|
TypeOrganization uint8 = 3
|
|
)
|
|
|
|
type Project struct {
|
|
OwnerID int64 `xorm:"INDEX"`
|
|
Type uint8
|
|
Owner *User `xorm:"extends"`
|
|
}
|
|
|
|
sess := x.NewSession()
|
|
defer sess.Close()
|
|
|
|
if err := sess.Begin(); err != nil {
|
|
return err
|
|
}
|
|
|
|
count, err := sess.Table("project").
|
|
Where("type = ? AND owner_id IN (SELECT id FROM `user` WHERE type = ?)", TypeOrganization, UserTypeIndividual).
|
|
Update(&Project{
|
|
Type: TypeIndividual,
|
|
})
|
|
if err != nil {
|
|
return err
|
|
}
|
|
log.Debug("Updated %d projects to belong to a user instead of an organization", count)
|
|
|
|
return sess.Commit()
|
|
}
|