var express = require('express');
var app = express();
const port = process.env.PORT || 8080;
app.get('/', function (req, res) {
var sql = require("mssql");
var config = {
user: 'ViewMelk',
password: 'ViewMelk!@#',
server: '89.32.248.175',
database: 'viewmelk_db',
"port": '1433',
"dialect": "mssql",
"dialectOptions": {
"instanceName": "SQLEXPRESS"
}
};
sql.connect(config, function (err) {
if (err) console.log(err);
var request = new sql.Request();
request.query('SELECT Id,Address,CreateShamsiDate FROM dbo.Melk WHERE Address IS NOT NULL', function (err, recordset) {
if (err) console.log(err)
if (err) console.log(err)
else {
res.send(recordset);
}
sql.close();
});
});
});
var server = app.listen(port, function () {
console.log('Server is running..');
});