Returning response from async call in function

Question

I know this has been answered here already (How do I return the response from an asynchronous call?), but I couldn't find anything that would work with what I need.

I have a basic function reading data from a databse, that's then supposed to return a value depending on the data. This is what it looks like:

function checkcooldown(name, user){
    //gets the row from the sqlite database (returns a promise)
    sql.get(`SELECT * FROM usercooldowns WHERE user = "${user}" AND name = "${name}"`).then((row) => {
        if(!row || row == undefined){return 0} //if the user doesn't have a cooldown, return 0
        else if(row.time <= getcurdate()){//if the cooldown is already over, return 0
            return 0
        }
        else{//if a cooldown exists, return the number of seconds it lasts (currently dummy number)
            return 123
        }
    })
}

I want to call this function in an if statement similar to this

if(await checkcooldown(name, user) > 0){//do something}
else{//add a new cooldown}

This of course doesn't work, since the function returns undefined.

However, none of the solutions I found in the thread above helped me with this, they all ended up using multi-line functions or resolving promises. Is there ANY way to make it compact enough to fit in a simple if statement like I described above?

Thanks for the help ^^

`return sql.get(....` then the function returns a Promise you can await ... to await a promise one must return a promise — Jaromanda X, Apr 30 '20 at 11:26
That would just return the entire data from the row I'm getting the data from, not any of the values I would want to have returned, right? — Aci, Apr 30 '20 at 11:27
no, it would return what you return in the last .then - that's how chaining promises works — Jaromanda X, Apr 30 '20 at 11:28

score 0 · Accepted Answer · answered Apr 30 '20 at 11:35

0

Why not just use async await syntax if you want to be concise ?

    async function checkcooldown(name, user) {
         try {

         const row = await sql.get(`SELECT * FROM usercooldowns WHERE user = "${user}" AND name = "${name}"`)

         } catch(err) {
          console.log(err)
         }
        if(row.time <= getcurdate()) {
          return 0
         } else {
          return 123
         }
     }

answered Apr 30 '20 at 11:35

C.Gochev

1,837
11
21

If I define row inside the try{} part, I can't access it outside of it. – Aci Apr 30 '20 at 11:49
I managed to access the variable, this did the trick. Thank you! – Aci Apr 30 '20 at 11:54

Returning response from async call in function

1 Answers1