MySQL transport plugin for winston logger
This MySQL transport module is a plugin for winston logger running in node.js.
var options_default = {
host : 'localhost',
user : 'logtest',
password : 'log*test*pass',
database : 'logtest',
table : 'sys_logs_default'
};
var logger = new (winston.Logger)({
transports: [
new winston_mysql(options_default)
]
});
var msg = 'test message');
logger.info('first log', {message: msg});
You should create a table in the database first.
Demos:
CREATE TABLE `logtest`.`sys_logs_default` (
`id` INT NOT NULL AUTO_INCREMENT,
`level` VARCHAR(16) NOT NULL,
`message` VARCHAR(512) NOT NULL,
`meta` VARCHAR(1024) NOT NULL,
`timestamp` DATETIME NOT NULL,
PRIMARY KEY (`id`));
If you already have the log table, you can set custom fields for this module.
//custom log table fields
var options_custom = {
host : 'localhost',
user : 'logtest',
password : 'log*test*pass',
database : 'logtest',
table : 'sys_logs_custom',
fields : { level: 'mylevel', meta: 'metadata', message: 'source', timestamp: 'addDate'}
};Install via npm:
$ npm install winston-mysqlHead over to https://github.com/charles-zh/winston-mysql
$ node mysql_transport_test.jscharles-zh
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent