mirror of
https://github.com/go-gitea/gitea.git
synced 2026-07-23 17:44:38 +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>
63 lines
1.5 KiB
Go
63 lines
1.5 KiB
Go
// Copyright 2020 The Gitea Authors. All rights reserved.
|
|
// SPDX-License-Identifier: MIT
|
|
|
|
package v1_14
|
|
|
|
import (
|
|
"gitea.dev/modelmigration/base"
|
|
|
|
"xorm.io/xorm/schemas"
|
|
)
|
|
|
|
func ConvertHookTaskTypeToVarcharAndTrim(x base.EngineMigration) error {
|
|
dbType := x.Dialect().URI().DBType
|
|
if dbType == schemas.SQLITE { // For SQLITE, varchar or char will always be represented as TEXT
|
|
return nil
|
|
}
|
|
|
|
// HookTask: Typ string `xorm:"VARCHAR(16) index"`
|
|
if err := base.ModifyColumn(x, "hook_task", &schemas.Column{
|
|
Name: "typ",
|
|
SQLType: schemas.SQLType{
|
|
Name: "VARCHAR",
|
|
},
|
|
Length: 16,
|
|
Nullable: true, // To keep compatible as nullable
|
|
DefaultIsEmpty: true,
|
|
}); err != nil {
|
|
return err
|
|
}
|
|
|
|
var hookTaskTrimSQL string
|
|
if dbType == schemas.MSSQL {
|
|
hookTaskTrimSQL = "UPDATE hook_task SET typ = RTRIM(LTRIM(typ))"
|
|
} else {
|
|
hookTaskTrimSQL = "UPDATE hook_task SET typ = TRIM(typ)"
|
|
}
|
|
if _, err := x.Exec(hookTaskTrimSQL); err != nil {
|
|
return err
|
|
}
|
|
|
|
// Webhook: Type string `xorm:"VARCHAR(16) index"`
|
|
if err := base.ModifyColumn(x, "webhook", &schemas.Column{
|
|
Name: "type",
|
|
SQLType: schemas.SQLType{
|
|
Name: "VARCHAR",
|
|
},
|
|
Length: 16,
|
|
Nullable: true, // To keep compatible as nullable
|
|
DefaultIsEmpty: true,
|
|
}); err != nil {
|
|
return err
|
|
}
|
|
|
|
var webhookTrimSQL string
|
|
if dbType == schemas.MSSQL {
|
|
webhookTrimSQL = "UPDATE webhook SET type = RTRIM(LTRIM(type))"
|
|
} else {
|
|
webhookTrimSQL = "UPDATE webhook SET type = TRIM(type)"
|
|
}
|
|
_, err := x.Exec(webhookTrimSQL)
|
|
return err
|
|
}
|