0.0.16 • Published 4 years ago
kmk-mssqlclient v0.0.16
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);
}
})()