JSPM

winston-sqlserver

0.1.1
  • ESM via JSPM
  • ES Module Entrypoint
  • Export Map
  • Keywords
  • License
  • Repository URL
  • TypeScript Types
  • README
  • Created
  • Published
  • Downloads 4
  • Score
    100M100P100Q33779F

A SQL Server transport for winston

Package Exports

  • winston-sqlserver

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (winston-sqlserver) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

winston-sqlserver

This module allows you to log your winston messages to any SQL Server database supported by node-sqlserver.

Installation

  1. Follow the steps in How to Access Windows Azure SQL Database from Node.js to get the node-sqlserver package installed.
  2. Run npm install winston-sqlserver.
  3. In the database you will use for logging, execute CreateLogTable.sql to create a table of the form necessary for this package.

Usage

var winston = require('winston');
require('winston-sqlserver');
winston.add(winston.transports.SQLServer, options);

Options

This transport takes the following options:

  • connectionString: Connection string that this transport should use (default 'Driver={SQL Server Native Client 11.0};Server=(local);Trusted_Connection=Yes;Database=winston').
  • table: Table name to log to (default 'dbo.NodeLogs').

Testing

Unit tests can be found in the test directory and executed with npm test. They are driven by mocha and should. The default settings assume SQL Express has been installed and CreateLogTable.sql has been run in a database called winston (connection string: 'Driver={SQL Server Native Client 11.0};Server=.\SQLEXPRESS;Database=winston;Trusted_Connection=Yes;'). You can change this by editing the variables in test/test-config.js.