logging not working

[sysmat]

• mod
  go 1.20

require (
	github.com/coreos/go-systemd/v22 v22.5.0
	github.com/gin-gonic/gin v1.9.1
	github.com/sirupsen/logrus v1.9.3
	github.com/thomas-tacquet/gormv2-logrus v1.2.2
	gopkg.in/natefinch/lumberjack.v2 v2.2.1
	gorm.io/driver/mysql v1.5.1
	gorm.io/gorm v1.25.1
)

• code

gormLogger := gormv2logrus.NewGormlog(
		gormv2logrus.WithLogrus(l),
		gormv2logrus.WithGormOptions(
			gormv2logrus.GormOptions{
				SlowThreshold: slowThresholdDuration,
				LogLevel:      logger.Info,
				LogLatency:    true,
			},
		),
	)

gormr, err := gorm.Open(mysql.New(mysql.Config{
		Conn: db,
	}), &gorm.Config{
		Logger:         gormLogger,
		TranslateError: true,
		NamingStrategy: schema.NamingStrategy{
			SingularTable: true, // Use singular table names
		},
	})

• in my log file I don't see gorm logging, I try gorm.Debug() no logging
• when I use gorm logger logger.Default.LogMode(logger.Silent) it works fine, but output is console

[sysmat]

• I see in log sql error, so it works
• Can I configure gormLogger to log gorm Debug()?

[thomas-tacquet]

Hello 👋 thank you for raising an issue and sorry for the response time 🤦

Gorm does not offers a "Debug" log level, to start the Debug mode on gorm you need to use the Debug function. I did a full example here to test if it works:

package main

import (
	"fmt"
	"os"

	log "github.com/sirupsen/logrus"
	gormv2logrus "github.com/thomas-tacquet/gormv2-logrus"
	"gorm.io/driver/sqlite"
	"gorm.io/gorm"
	"gorm.io/gorm/logger"
)

func main() {
	lrus := log.New()
	lrus.SetFormatter(&log.JSONFormatter{})
	lrus.SetOutput(os.Stdout)
	lrus.SetLevel(log.TraceLevel)

	gormLog := gormv2logrus.NewGormlog(
		gormv2logrus.WithLogrus(lrus),
		gormv2logrus.WithGormOptions(
			gormv2logrus.GormOptions{
				LogLevel:   logger.Info,
				LogLatency: true,
			},
		),
	)

	const sqliteConnString = "file:%s?mode=memory&cache=shared"

	db, err := gorm.Open(sqlite.Open(
		fmt.Sprintf(sqliteConnString, "testing")),
		&gorm.Config{Logger: gormLog},
	)
	if err != nil {
		panic(err)
	}

	_ = db.Debug().Exec(`SELECT printf('This is an information message.');`)
	if err != nil {
		log.Fatal(err)
	}
}

``