golang訪問(wèn)數(shù)據(jù)庫(kù)記錄SQL語(yǔ)句：
使用的包為：
1：github.com/arthurkiller/rollingwriter //寫(xiě)入日志包
2： github.com/go-xorm/xorm //xorm包
具體實(shí)現(xiàn)為：
package main
import (
"time"
"github.com/arthurkiller/rollingwriter"
_ "github.com/go-sql-driver/mysql"
"github.com/go-xorm/xorm"
)
func main() {
var conn string = "root:123456@tcp(127.0.0.1)/logsdemo?charset=utf-8"
Engine, err := xorm.NewEngine("mysql", conn)
if err != nil {
panic("mysql connect fail")
}
config := rollingwriter.Config{
LogPath: "./logs", //日志路徑
TimeTagFormat: "060102150405", //時(shí)間格式串
FileName: "mysql_exec", //日志文件名
MaxRemain: 3, //配置日志最大存留數(shù)
RollingPolicy: rollingwriter.VolumeRolling, //配置滾動(dòng)策略 norolling t
imerolling volumerolling
RollingTimePattern: "* * * * * *", //配置時(shí)間滾動(dòng)策略
RollingVolumeSize: "1M", //配置截?cái)辔募孪薮笮?
WriterMode: "none",
BufferWriterThershould: 256,
// Compress will compress log file with gzip
Compress: true,
}
writer, err := rollingwriter.NewWriterFromConfig(config)
if err != nil {
panic(err)
}
var logger *xorm.SimpleLogger = xorm.NewSimpleLogger(writer)
Engine.SetLogger(logger)
Engine.ShowSQL(true)
logger.Info("ts info code")
Engine.Exec("select * from cp_order where id = ? ", 3)
time.Sleep(1 * time.Second)
}
rollingwriter 實(shí)現(xiàn)一個(gè) io.Writer傳入到xorm.NewSimpleLogger 中 在xorm中實(shí)現(xiàn)日志的寫(xiě)入，在rollingwriter中保存日志到文件中
依賴包：https://github.com/robfig/cron
補(bǔ)充： golang xorm Model 模型文件模板
* Record.go
package models
import (
"fmt"
"github.com/go-xorm/xorm"
"time"
)
// 用戶首次登錄
type FirstLoginRecord struct {
Id int64 `xorm:"not null pk autoincr INT(11)"`
UserID int64 `json:"userid" xorm:"int(11) not null 'userid'"`
IP string `json:"logonip" xorm:"varchar(45) not null 'logonip'"`
CreatedAt time.Time `json:"logontime" xorm:"timestamp not null 'logontime'"`
UpdatedAt time.Time `json:"logofftime" xorm:"timestamp not null 'logofftime'"`
Source int `json:"source" xorm:"tinyint(3) not null"`
IsCharged int `json:"ischargeaccount" xorm:"tinyint(3) unsigned not null 'ischargeaccount'"`
}
func (*FirstLoginRecord) TableName() string {
return "W_UserFirstLogonRec"
}
func (*FirstLoginRecord) DB() *xorm.Engine {
return DbDefault()
}
func (t *FirstLoginRecord) Save() error {
var err error
var engine = t.DB()
if t.Id == 0 {
t.Id, err = engine.Insert(t)
return err
}
var rowsAffected int64
rowsAffected, err = engine.Id(t.Id).Update(t)
fmt.Printf("@table: %s: %d rows affected", t.TableName(), rowsAffected)
return err
}
// 用戶id唯一約束
func (this *FirstLoginRecord) AddDistinct() error {
var err error
var engine = this.DB()
var has bool
var ent = FirstLoginRecord{UserID: this.UserID }
has, err = engine.Get(ent)
if has {
return nil
}
this.Id, err = engine.Insert(this)
return err
}
http://www.xorm.io/docs/
以上為個(gè)人經(jīng)驗(yàn)，希望能給大家一個(gè)參考，也希望大家多多支持腳本之家。如有錯(cuò)誤或未考慮完全的地方，望不吝賜教。
標(biāo)簽：電子產(chǎn)品 儋州 海南 物業(yè)服務(wù) 青海 遼寧 西雙版納 安康
巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《golang xorm日志寫(xiě)入文件中的操作》，本文關(guān)鍵詞 golang,xorm,日志,寫(xiě)入,文件,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。
