mirror of
https://github.com/go-gitea/gitea.git
synced 2026-07-22 20:53:20 +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>
37 lines
912 B
Go
37 lines
912 B
Go
// Copyright 2023 The Gitea Authors. All rights reserved.
|
|
// SPDX-License-Identifier: MIT
|
|
|
|
package v1_21
|
|
|
|
import (
|
|
"time"
|
|
|
|
"gitea.dev/modelmigration/base"
|
|
"gitea.dev/modules/timeutil"
|
|
)
|
|
|
|
func AddExpiredUnixColumnInActionArtifactTable(x base.EngineMigration) error {
|
|
type ActionArtifact struct {
|
|
ExpiredUnix timeutil.TimeStamp `xorm:"index"` // time when the artifact will be expired
|
|
}
|
|
if err := x.Sync(new(ActionArtifact)); err != nil {
|
|
return err
|
|
}
|
|
return updateArtifactsExpiredUnixTo90Days(x)
|
|
}
|
|
|
|
func updateArtifactsExpiredUnixTo90Days(x base.EngineMigration) error {
|
|
sess := x.NewSession()
|
|
defer sess.Close()
|
|
|
|
if err := sess.Begin(); err != nil {
|
|
return err
|
|
}
|
|
expiredTime := time.Now().AddDate(0, 0, 90).Unix()
|
|
if _, err := sess.Exec(`UPDATE action_artifact SET expired_unix=? WHERE status='2' AND expired_unix is NULL`, expiredTime); err != nil {
|
|
return err
|
|
}
|
|
|
|
return sess.Commit()
|
|
}
|