mirror of
https://github.com/hanzoai/forge.git
synced 2026-10-30 15:00:39 +00:00
zeekayandHanzo Dev
aa87442fdd
Source files keep their SPDX-License-Identifier and Hanzo copyright line; the Gitea, Gogs and LFS Test Server copyrights they used to repeat now live once in NOTICE, alongside LICENSE. The header lint accepts any copyright line above the SPDX line, so it no longer demands an upstream one. Co-authored-by: Hanzo Dev <[email protected]>
87 lines
2.2 KiB
Go
87 lines
2.2 KiB
Go
// Copyright 2026 Hanzo AI, Inc. All rights reserved.
|
|
// SPDX-License-Identifier: MIT
|
|
|
|
package db
|
|
|
|
import (
|
|
"fmt"
|
|
|
|
"github.com/hanzoai/git/modules/setting"
|
|
|
|
"github.com/hanzoai/orm/relational"
|
|
"github.com/hanzoai/xorm/convert"
|
|
"github.com/hanzoai/xorm/schemas"
|
|
)
|
|
|
|
// ConvertDatabaseTable converts database and tables from utf8 to utf8mb4 if it's mysql and set ROW_FORMAT=dynamic
|
|
func ConvertDatabaseTable() error {
|
|
if xormEngine.Dialect().URI().DBType != schemas.MYSQL {
|
|
return nil
|
|
}
|
|
|
|
r, err := CheckCollations(xormEngine)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
|
|
_, err = xormEngine.Exec(fmt.Sprintf("ALTER DATABASE `%s` CHARACTER SET utf8mb4 COLLATE %s", setting.Database.Name, r.ExpectedCollation))
|
|
if err != nil {
|
|
return err
|
|
}
|
|
|
|
tables, err := xormEngine.DBMetas()
|
|
if err != nil {
|
|
return err
|
|
}
|
|
for _, table := range tables {
|
|
if _, err := xormEngine.Exec(fmt.Sprintf("ALTER TABLE `%s` ROW_FORMAT=dynamic", table.Name)); err != nil {
|
|
return err
|
|
}
|
|
|
|
if _, err := xormEngine.Exec(fmt.Sprintf("ALTER TABLE `%s` CONVERT TO CHARACTER SET utf8mb4 COLLATE %s", table.Name, r.ExpectedCollation)); err != nil {
|
|
return err
|
|
}
|
|
}
|
|
|
|
return nil
|
|
}
|
|
|
|
// ConvertVarcharToNVarchar converts database and tables from varchar to nvarchar if it's mssql
|
|
func ConvertVarcharToNVarchar() error {
|
|
if xormEngine.Dialect().URI().DBType != schemas.MSSQL {
|
|
return nil
|
|
}
|
|
|
|
sess := xormEngine.NewSession()
|
|
defer sess.Close()
|
|
res, err := sess.QuerySliceString(`SELECT 'ALTER TABLE ' + OBJECT_NAME(SC.object_id) + ' MODIFY SC.name NVARCHAR(' + CONVERT(VARCHAR(5),SC.max_length) + ')'
|
|
FROM SYS.columns SC
|
|
JOIN SYS.types ST
|
|
ON SC.system_type_id = ST.system_type_id
|
|
AND SC.user_type_id = ST.user_type_id
|
|
WHERE ST.name ='varchar'`)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
for _, row := range res {
|
|
if len(row) == 1 {
|
|
if _, err = sess.Exec(row[0]); err != nil {
|
|
return err
|
|
}
|
|
}
|
|
}
|
|
return err
|
|
}
|
|
|
|
// CellToInt converts a relational.Cell field value to an int value
|
|
func CellToInt[T ~int | int64](cell relational.Cell, def T) (ret T, has bool, err error) {
|
|
if *cell == nil {
|
|
return def, false, nil
|
|
}
|
|
val, err := convert.AsInt64(*cell)
|
|
if err != nil {
|
|
return def, false, err
|
|
}
|
|
return T(val), true, err
|
|
}
|