mirror of
https://github.com/go-gitea/gitea.git
synced 2026-07-23 07:22:36 +02:00
fff32e9469
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>
70 lines
1.6 KiB
Go
70 lines
1.6 KiB
Go
// Copyright 2021 The Gitea Authors. All rights reserved.
|
|
// SPDX-License-Identifier: MIT
|
|
|
|
package v1_15
|
|
|
|
import (
|
|
"context"
|
|
"fmt"
|
|
|
|
"gitea.dev/modelmigration/base"
|
|
"gitea.dev/modules/setting"
|
|
)
|
|
|
|
func RenameTaskErrorsToMessage(x base.EngineMigration) error {
|
|
type Task struct {
|
|
Errors string `xorm:"TEXT"` // if task failed, saved the error reason
|
|
Type int
|
|
Status int `xorm:"index"`
|
|
}
|
|
|
|
// This migration maybe rerun so that we should check if it has been run
|
|
messageExist, err := x.Dialect().IsColumnExist(x.DB(), context.Background(), "task", "message")
|
|
if err != nil {
|
|
return err
|
|
}
|
|
|
|
if messageExist {
|
|
errorsExist, err := x.Dialect().IsColumnExist(x.DB(), context.Background(), "task", "errors")
|
|
if err != nil {
|
|
return err
|
|
}
|
|
if !errorsExist {
|
|
return nil
|
|
}
|
|
}
|
|
|
|
sess := x.NewSession()
|
|
defer sess.Close()
|
|
if err := sess.Begin(); err != nil {
|
|
return err
|
|
}
|
|
|
|
if err := sess.Sync(new(Task)); err != nil {
|
|
return fmt.Errorf("error on Sync: %w", err)
|
|
}
|
|
|
|
if messageExist {
|
|
// if both errors and message exist, drop message at first
|
|
if err := base.DropTableColumns(sess, "task", "message"); err != nil {
|
|
return err
|
|
}
|
|
}
|
|
|
|
switch {
|
|
case setting.Database.Type.IsMySQL():
|
|
if _, err := sess.Exec("ALTER TABLE `task` CHANGE errors message text"); err != nil {
|
|
return err
|
|
}
|
|
case setting.Database.Type.IsMSSQL():
|
|
if _, err := sess.Exec("sp_rename 'task.errors', 'message', 'COLUMN'"); err != nil {
|
|
return err
|
|
}
|
|
default:
|
|
if _, err := sess.Exec("ALTER TABLE `task` RENAME COLUMN errors TO message"); err != nil {
|
|
return err
|
|
}
|
|
}
|
|
return sess.Commit()
|
|
}
|