Callback passed to destroy(sid, fn) is overwritten by the sid. about node-connect-pg-simple

[makuga01]

@saraginov I actually found the solution lol
I dug into source of req.session.destroy -> found out that it takes only the fn argument and later passes it to req.sessionStore.destroy(this.id, fn)

The solution in your case would be just to do

exports.logOut = async function(req, res)
{
const {session, sessionID} = req;

const cb = (err) => {
console.log({err});
}

console.log({sessionID});
console.log(cb);

const deletedSession = req.sessionStore.destroy(sessionID, cb);

res.header('Content-Type', 'application/json;charset=UTF-8');
res.header('Access-Control-Allow-Credentials', true);
res.header(
'Access-Control-Allow-Headers',
'Origin, X-Requested-With, Content-Type, Accept'
);

delete req.session
res.end('Logged Out');
}

Or a little better without using the session.destroy

req.session.destroy(function (err: Error) {
    if (err) {
      res.status(400)
    } else {
      res.clearCookie('connect.sid')
      res.header('Content-Type', 'application/json;charset=UTF-8');
      res.header('Access-Control-Allow-Credentials', true);
      res.header(
      'Access-Control-Allow-Headers',
      'Origin, X-Requested-With, Content-Type, Accept'
      );
      res.status(200)
    }
  })

Bonus

The connect-pg-simple module just runs a simple SQL query when sessionStore.destroy(x, y) is called.

this.query(
        'DELETE FROM ' + this.quotedTable() + ' WHERE sid = $1',
        [sid],
        err => { fn && fn(err); }
      );

My usecase of this was to log user off on every device using a knex/sql query like this

knex('session').select('sid').whereRaw("sess->'passport'->>'user' = ?", [userId]).delete()

select sess->'passport'->>'user' as userid from session where sess->'passport'->>'user' = 'ID here'

[makuga01]

Glad to help

[makuga01]

Hey @saraginov! How did you manage to solve this?

[saraginov]

@makuga01 I didn't, I closed this because I am overwhelmed with other work and don't have time to address it. Feel free to re-open it if you would like.

[saraginov]

Thank you I appreciate it, I will try it out at some point soon and get back to you.