[TOC] ## xorm > 1.0 1.0 可輸出完整的sql 字符串 ``` package db import ( "github.com/sirupsen/logrus" "xorm.io/xorm/log" ) type dbLog struct { logger *logrus.Logger showSQL bool } func NewDbLog(showSQL bool) *dbLog { return &dbLog{ showSQL: showSQL, logger:logrus.StandardLogger(), } } func (d *dbLog) BeforeSQL(context log.LogContext) { d.logger.Infof("BeforeSQL : %+v\n", context.SQL) } func (d *dbLog) AfterSQL(context log.LogContext) { d.logger.Infof("AfterSQL : %+v\n", context.SQL) } func (d *dbLog) Debugf(format string, v ...interface{}) { d.logger.Debugf(format, v) } func (d *dbLog) Errorf(format string, v ...interface{}) { d.logger.Errorf(format, v) } func (d *dbLog) Infof(format string, v ...interface{}) { d.logger.Infof(format, v) } func (d *dbLog) Warnf(format string, v ...interface{}) { d.logger.Warnf(format, v) } func (d *dbLog) Level() log.LogLevel { return log.LogLevel(d.logger.Level) } func (d *dbLog) SetLevel(l log.LogLevel) { d.logger.SetLevel(logrus.Level(l)) } func (d *dbLog) ShowSQL(show ...bool) { if len(show) == 0 { d.showSQL = true return } d.showSQL = show[0] } func (d *dbLog) IsShowSQL() bool { return d.showSQL } ``` 使用 ``` engine, _:= xorm.NewEngine(dbtype, dsn) ... newDbLog := NewDbLog(conf.DB.ShowSql) engine.SetLogger(newDbLog) ```