将gorm日志存储在文件中

package main

import (
    "fmt"
    "os"
    "path/filepath"

    "gorm.io/driver/mysql"
    "gorm.io/gorm"
    "gorm.io/gorm/logger"
)

func main() {
    // 创建日志文件
    logFile, err := os.Create("log.txt")
    if err != nil {
        fmt.Println("Failed to create log file:", err)
        return
    }
    defer logFile.Close()

    // 设置gorm日志输出为文件
    gormConfig := &gorm.Config{
        Logger: logger.New(
            logFile,
            logger.Config{
                SlowThreshold:             200, // 慢查询阈值，单位毫秒
                LogLevel:                  logger.Info,
                IgnoreRecordNotFoundError: true,
                Colorful:                  false,
            },
        ),
    }

    // 连接数据库
    dsn := "user:password@tcp(127.0.0.1:3306)/database?charset=utf8mb4&parseTime=True&loc=Local"
    db, err := gorm.Open(mysql.Open(dsn), gormConfig)
    if err != nil {
        fmt.Println("Failed to connect to database:", err)
        return
    }
    defer db.Close()

    // 其他数据库操作...
}