var Connection = require("tedious").Connection;
var Request = require("tedious").Request;

// Create connection to database
/*var config =
{
    userName: 'najimoha', // update me
    password: 'Spectrum2019', // update me
    server: 'najisample.database.windows.net', // update me
    options:
    {
        database: 'mySampleDatabase', //update me
        encrypt: true
    }
}*/

var config =
{
    server: "najisample.database.windows.net",
    // If you're on Windows Azure, you will need this:
    options:
	{
		database: "mySampleDatabase",
		encrypt: true
	}.
    authentication:
	{
		type: "default",
		options:
		{
			userName: "najimoha",
			password: "Spectrum2019",

	}
};

var connection = new Connection(config);

// Attempt to connect and execute queries if connection goes through
connection.on('connect', function(err)
    {
        if (err)
        {
            console.log(err)
        }
        else
        {
            queryDatabase()
        }
    }
);

function queryDatabase()
{
    console.log('Reading rows from the Table...');

    // Read all rows from table
    var request = new Request(
        "SELECT * FROM Condition$",
        function(err, rowCount, rows)
        {
            console.log(rowCount + ' row(s) returned');
            process.exit();
        }
    );

    request.on('row', function(columns) {
        columns.forEach(function(column) {
            console.log("%s\t%s", column.metadata.colName, column.value);
        });
    });
    connection.execSql(request);
}