var Connection = require('tedious').Connection;

var config = {
    server: 'DESKTOP-GJR5JP2', //update me
    authentication: {
        type: 'default',
        options: {
            userName: 'skezze', //update me
            password: '' //update me
        }
    },
    options: {
        database: 'VTlabs' //update me
    }
};
console.log("start");
var connection = new Connection(config);
connection.on('connect', function(err) {
    // If no error, then good to proceed.
    console.log("Connected");
    executeStatement();
});

connection.connect();

var Request = require('tedious').Request;
var TYPES = require('tedious').TYPES;

function executeStatement() {
    request = new Request("use VTlabs;select * from lab6;", function(err) {
        if (err) {
            console.log(err);
        }
    });
    var result = "";
    request.on('row', function(columns) {
        columns.forEach(function(column) {
            if (column.value === null) {
                console.log('NULL');
            } else {
                result += column.value + " ";
            }
        });
        console.log(result);
        result = "";
    });

    request.on('done', function(rowCount, more) {
        console.log(rowCount + ' rows returned');
    });
    connection.execSql(request);
}