whlshy/usefulexpressapi

Trying to build a useful API on NodeJs Express.

usefulexpressapi's Issues

runSQL.js getMID passportCode

const getMID = async (req) => {
    const { passportCode } = req.session;
    let mid = -1;
    if (passportCode) {
        sqlcode = "select Account, MID from Member where MID = (select top 1 MID from MSession where PassportCode = @passportCode and ExpiredDT > (select convert(varchar, getdate(), 126)))"
        const pool = await readonlyPoolPromise;
        const request = pool.request();
        request.input('passportCode', sql.NVarChar, passportCode)  //變了 多單引號
        const result = await request.query(sqlcode);
        mid = result.recordset[0].MID
    }
    // 回傳使用者MID
    // return 1
    return mid
}

請記得更改

README is not current version

i can't understand README
pls update README

change to cookie-session

change to cookie-session