1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556 |
- // Copyright 2019 The Gitea Authors. All rights reserved.
- // SPDX-License-Identifier: MIT
-
- package cmd
-
- import (
- "fmt"
-
- "code.gitea.io/gitea/models/db"
- "code.gitea.io/gitea/modules/log"
- "code.gitea.io/gitea/modules/setting"
-
- "github.com/urfave/cli/v2"
- )
-
- // cmdDoctorConvert represents the available convert sub-command.
- var cmdDoctorConvert = &cli.Command{
- Name: "convert",
- Usage: "Convert the database",
- Description: "A command to convert an existing MySQL database from utf8 to utf8mb4 or MSSQL database from varchar to nvarchar",
- Action: runDoctorConvert,
- }
-
- func runDoctorConvert(ctx *cli.Context) error {
- stdCtx, cancel := installSignals()
- defer cancel()
-
- if err := initDB(stdCtx); err != nil {
- return err
- }
-
- log.Info("AppPath: %s", setting.AppPath)
- log.Info("AppWorkPath: %s", setting.AppWorkPath)
- log.Info("Custom path: %s", setting.CustomPath)
- log.Info("Log path: %s", setting.Log.RootPath)
- log.Info("Configuration file: %s", setting.CustomConf)
-
- switch {
- case setting.Database.Type.IsMySQL():
- if err := db.ConvertUtf8ToUtf8mb4(); err != nil {
- log.Fatal("Failed to convert database from utf8 to utf8mb4: %v", err)
- return err
- }
- fmt.Println("Converted successfully, please confirm your database's character set is now utf8mb4")
- case setting.Database.Type.IsMSSQL():
- if err := db.ConvertVarcharToNVarchar(); err != nil {
- log.Fatal("Failed to convert database from varchar to nvarchar: %v", err)
- return err
- }
- fmt.Println("Converted successfully, please confirm your database's all columns character is NVARCHAR now")
- default:
- fmt.Println("This command can only be used with a MySQL or MSSQL database")
- }
-
- return nil
- }
|