This module allows you to log your winston messages to any SQL Server database supported by node-sqlserver.
- Follow the steps in How to Access Windows Azure SQL Database from Node.js to get the node-sqlserver package installed.
- Run
npm install winston-sqlserver
. - In the database you will use for logging, execute
CreateLogTable.sql
to create a table of the form necessary for this package.
var winston = require('winston');
require('winston-sqlserver');
winston.add(winston.transports.SQLServer, 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').
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
.