kmk-mssqlclient

kmk-mssqlclient

Installation

npm install kmk-mssqlclient

Usage

Initialization

const SqlClient = require('kmk-mssqlclient');
const cn = new SqlClient();
cn.setConfig({
	user: 'username',
	password: 'password',
	server: 'server',
	database: 'database',
	options: {
		encrypt: false
	}
});

Connecting

cn.connect()
.catch(e => {
	console.log(e);
})
.then(() => {
	console.log('connected');
})

/* OR */

SqlClient.open({
	user: 'username',
	password: 'password',
	server: 'server',
	database: 'database',
	options: {
		encrypt: false
	}
}, (err, client) => {
	if(err) console.log(err);
	else console.log(client);
})

Connecting using async/await mode

(async () => {
	try{
		await cn.connect();
		console.log('connected');
	}
	catch(e){
		console.log(e);
	}
})()

Querying data

cn.query('select * from table')
.catch(e => {
	console.log(e);
})
.then(result => {
	console.log(result);
})

Querying data using async/await mode

(async () => {
	try{
		let result = await cn.query('select * from table');
		console.log(result);
	}
	catch(e){
		console.log(e);
	}
})()

Methods