sqlog

type SQLWriter ¶

type SQLWriter struct {
	log.BatchSupport
	log.FilterSupport

	Driver    string
	Dsn       string
	Statement string

	ConnMaxIdleTime time.Duration
	ConnMaxLifeTime time.Duration
	// contains filtered or unexported fields
}

SQLWriter implements log Writer Interface and batch send log messages to database. Prepare:

CREATE TABLE logs (
	id serial NOT NULL,
	time timestamp with time zone NOT NULL,
	level char(1) NOT NULL,
	msg text NOT NULL,
	file text NOT NULL,
	line integer NOT NULL,
	func text NOT NULL,
	trace text NOT NULL);

Driver: postgres Dsn: host=127.0.0.1 user=pango password=pango dbname=pango port=5432 sslmode=disable Statement: "INSERT INTO sqlogs (time, level, msg, file, line, func, trace) VALUES" Parameter: "%t %p %m %S %L %F %T"

func (sw *SQLWriter) Close()

func (sw *SQLWriter) Flush()

func (sw *SQLWriter) SetConnMaxIdleTime(duration string) error

func (sw *SQLWriter) SetConnMaxLifeTime(duration string) error

func (sw *SQLWriter) SetParameter(format string)

func (sw *SQLWriter) Write(le *log.Event)