Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
SQL Server transport for Winston Logger. http://github.com/gonerandom/winston-sqlserver
JavaScript
Branch: master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
lib
test
.gitignore
CreateLogTable.sql
LICENSE
README.md
package.json

README.md

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.

Something went wrong with that request. Please try again.