charles-zh / winston-mysql Goto Github PK

 CREATE TABLE IF NOT EXISTS sys_logs_default (
 id INT NOT NULL AUTO_INCREMENT,
 env VARCHAR(100) default 0,
 level VARCHAR(16) NOT NULL,
 message VARCHAR(2048) NOT NULL,
 meta VARCHAR(2048) NOT NULL,
 timestamp DATETIME NOT NULL,
 PRIMARY KEY (id));

var ip = require("ip");
....
  const myFormatter = format((info) => {
    info.env = ip.address()
    return info;
  })();

...
  const SqlLogger = createLogger({
...
  format: combine(timestamp(), errors({ stack: true }), myFormatter, json()),
...
    new winstonMysql({
      host: process.env.DB_HOST,
      user: process.env.DB_USER,
      password: process.env.DB_PASSWORD,
      database: 'logging_nodejs',
      table: 'sys_logs_default',
      charset: 'utf8_general_ci',
      fields: { env: 'env', level: 'level', meta: 'meta', message: 'message', timestamp: 'timestamp' }
    })
...

  if (!options.fields) {
      this.options.fields = {};
      //use default names
      this.fields = {
        level: 'level',
        meta: 'meta',
        message: 'message',
        timestamp: 'timestamp'
      }
    } else {
      //use custom table field names
      const { level, meta, message, timestamp } = this.options.fields;
      this.fields = {
        // for custome fields
        ...this.options.fields,
        level,
        meta,
        message,
        timestamp
      }
    }

 const log = {};
        log[this.fields.meta] = JSON.stringify(winstonMeta);
        log[this.fields.level] = level;
        log[this.fields.message] = message;
        log[this.fields.timestamp] = new Date();

        for (const key in info) {
          if (!['meta', 'level', 'message', 'timestamp'].includes(key) && this.fields.hasOwnProperty(key)) {
            log[key] = info[key]
          }
        }

logger.debug(msg, {message: msg, type: 'demo'});
logger.error(msg, {message: msg, type: 'demo'});
logger.info(msg, {message: msg, type: 'demo'});
logger.warn(msg, {message: msg, type: 'demo'});