Files

157 lines
4.6 KiB
Go
Raw Permalink Normal View History

2024-07-23 14:48:37 +08:00
package migration
import (
"github.com/1Panel-dev/1Panel/agent/global"
"github.com/1Panel-dev/1Panel/agent/init/migration/migrations"
"github.com/go-gormigrate/gormigrate/v2"
"gorm.io/gorm"
2024-07-23 14:48:37 +08:00
)
func Init() {
InitAgentDB()
InitTaskDB()
InitAlertDB()
global.LOG.Info("Migration run successfully")
}
func InitAgentDB() {
m := gormigrate.New(global.DB, gormigrate.DefaultOptions, agentDBMigrations())
if err := m.Migrate(); err != nil {
global.LOG.Error(err)
panic(err)
}
}
func agentDBMigrations() []*gormigrate.Migration {
return []*gormigrate.Migration{
2024-07-23 14:48:37 +08:00
migrations.AddTable,
migrations.AddMonitorTable,
2024-07-23 14:48:37 +08:00
migrations.InitSetting,
migrations.InitImageRepo,
migrations.InitDefaultCA,
migrations.InitPHPExtensions,
migrations.InitBackup,
migrations.InitDefault,
migrations.UpdateWebsiteExpireDate,
2025-06-23 18:37:37 +08:00
migrations.UpdateRuntime,
migrations.AddSnapshotRule,
2025-06-27 16:56:13 +08:00
migrations.UpdatePHPRuntime,
migrations.AddSnapshotIgnore,
migrations.InitAppLauncher,
migrations.AddTableAlert,
migrations.InitAlertConfig,
migrations.AddMethodToAlertLog,
2025-07-23 16:58:24 +08:00
migrations.AddMethodToAlertTask,
migrations.UpdateMcpServer,
migrations.InitCronjobGroup,
migrations.AddColumnToAlert,
migrations.UpdateWebsiteSSL,
migrations.AddQuickJump,
2025-09-04 15:21:33 +08:00
migrations.UpdateMcpServerAddType,
migrations.UpdateMcpServerGatewayConfig,
migrations.InitLocalSSHConn,
migrations.InitLocalSSHShow,
migrations.InitRecordStatus,
migrations.AddShowNameForQuickJump,
migrations.AddAgentQuickJump,
migrations.AddTimeoutForClam,
migrations.UpdateCronjobSpec,
migrations.UpdateWebsiteSSLAddColumn,
migrations.UpdateMonitorInterval,
migrations.AddMonitorProcess,
migrations.UpdateCronJob,
migrations.AddCommonDescription,
migrations.UpdateDatabase,
migrations.AddGPUMonitor,
migrations.UpdateDatabaseMysql,
2026-04-14 18:40:44 +08:00
migrations.AddDatabaseMongodb,
migrations.InitIptablesStatus,
migrations.UpdateWebsite,
2025-12-23 13:35:38 +08:00
migrations.AddisIPtoWebsiteSSL,
migrations.InitPingStatus,
migrations.UpdateApp,
migrations.AddCronjobArgs,
migrations.AddWebsiteAcmeAccountColumn,
2026-02-05 16:54:55 +08:00
migrations.AddAgentTables,
migrations.AddAgentCustomModelFields,
migrations.AddAppInstallSortOrder,
migrations.AddAgentAccountRememberAPIKey,
migrations.AddEditionSetting,
migrations.AddAgentTypeForAgents,
migrations.NormalizeAgentAccountVerifiedStatus,
migrations.NormalizeOllamaAccountAPIType,
migrations.InitAgentAccountModelPool,
2026-06-05 14:48:53 +08:00
migrations.AddAgentAccountMasterID,
migrations.NormalizeAgentAccountModelIDs,
migrations.AddAgentAccountVerifyModel,
migrations.AddAgentAccountAuthMode,
2026-03-19 15:25:19 +08:00
migrations.AddHostTable,
migrations.AddAITerminalSettings,
2026-03-24 18:56:30 +08:00
migrations.UpdateAgentQuickJumpTitle,
migrations.FixOpenclaw20260323HTTPPort,
2026-03-30 14:53:05 +08:00
migrations.AddAgentRemarkColumn,
migrations.AddAgentWebsiteBinding,
migrations.AddFileManageAISettings,
migrations.AddFileShareTable,
migrations.AddFileHistoryTable,
migrations.MigrateLegoV5,
migrations.AddMcpServerGatewayArgs,
migrations.InitFirewallPortWhiteList,
2026-07-16 14:24:38 +08:00
migrations.AddDatabaseUserTable,
migrations.AddBackupRecordArgs,
migrations.AddFtpIdentity,
2026-07-31 10:01:20 +08:00
migrations.AddWebsiteTemplateTable,
2026-07-30 09:39:47 +08:00
migrations.AddComposePinned,
migrations.AddFirewallRuleTable,
migrations.InitDockerPortGuardStatus,
migrations.NormalizeFirewallBackendSelections,
migrations.MigrateFirewallDescriptions,
migrations.MigrateFirewallPortWhitelistSources,
migrations.AddAcceleratorMetrics,
2026-09-29 15:19:30 +08:00
migrations.AddMonitorSettings,
migrations.AddNativeAgentInstalls,
2026-10-21 16:21:07 +08:00
migrations.AddQuickDirectory,
migrations.AddLocalModelAccountLink,
migrations.AddOllamaModelAccountSync,
migrations.AddContainerImageCheckUpdates,
2026-11-09 23:54:25 +08:00
migrations.AddCronjobURLItems,
migrations.AddModelQuickJump,
migrations.MigrateVMDatabase,
migrations.UpdateModelServicesQuickJumpRouter,
migrations.AddAgentAccountVerificationResult,
migrations.AddAgentAccountType,
migrations.AddGPUGroup,
migrations.AddAgentAccountStatus,
2024-07-23 14:48:37 +08:00
}
}
func InitTaskDB() {
m := gormigrate.New(global.TaskDB, gormigrate.DefaultOptions, []*gormigrate.Migration{
migrations.AddTaskTable,
})
if err := m.Migrate(); err != nil {
global.LOG.Error(err)
panic(err)
}
2024-07-23 14:48:37 +08:00
}
func InitAlertDB() {
if err := migrateAlertDB(global.AlertDB); err != nil {
global.LOG.Error(err)
panic(err)
}
}
func migrateAlertDB(db *gorm.DB) error {
options := *gormigrate.DefaultOptions
options.UseTransaction = true
m := gormigrate.New(db, &options, []*gormigrate.Migration{
migrations.AddAlertConfigUIDAndSecret,
migrations.MigrateAlertMethodConfigIDs,
migrations.MigrateAlertLogTaskMethodConfigIDs,
migrations.AddAlertAuditUser,
migrations.AddAlertTaskDeliveryLogID,
})
return m.Migrate()
}