'Reject if rowcount == 0 in a post request using tedious
Hello im having trouble rejecting my promise if my request has rowcount == 0, how can i reject if my sql statement returns no rows? Even if it returns 0 rows it resolves.
This is my code
function login(body) {
return new Promise((resolve, reject) => {
var connection = new Connection(config)
connection.on('connect', function(err){
if (err){
reject(err)
console.log(err);
}
else {
const request = new Request(`SELECT * FROM dba.[user] WHERE username = '${body.username}' and password = '${body.password}'`, function(err, rowCount){
if (err){
reject("Sorry not possible")
}
else if (rowCount == 0) {
console.log(rowCount+'rows')
reject("No rows returned")
}
})
var counter = 1
response = {}
connection.execSql(request)
request.on('row', function(columns){
response[counter] = {}
columns.forEach(function(column){
response[counter][column.metadata.colName] = column.value
});
counter += 1
});
request.on('doneInProc', function () {
resolve(response)
})
}
})
connection.connect()
})
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
