diff options
Diffstat (limited to 'profile')
| -rw-r--r-- | profile/index.js | 56 |
1 files changed, 36 insertions, 20 deletions
diff --git a/profile/index.js b/profile/index.js index 1a46fc1..fcdf877 100644 --- a/profile/index.js +++ b/profile/index.js @@ -43,11 +43,15 @@ app.post("/api/add", async (req, res) => { for (let qid in req.body) { if (!req.body.hasOwnProperty(qid) || req.body[qid] === "dbg-image") continue; let answer = req.body[qid].replace(/</g, "<").replace(/>/g, ">"); - await db.query("INSERT INTO profile_answers (question_id, user_id, answer) VALUES (?, ?, ?)", [ - qid, - req.session.uid, - answer.replace(/</g, "<").replace(/>/g, ">"), - ]); + try { + await db.query("INSERT INTO profile_answers (question_id, user_id, answer) VALUES (?, ?, ?)", [ + qid, + req.session.uid, + answer.replace(/</g, "<").replace(/>/g, ">"), + ]); + } catch (e) { + console.error(e); + } } for (let fid in req.files) { if (!req.files.hasOwnProperty(fid)) return; @@ -58,11 +62,15 @@ app.post("/api/add", async (req, res) => { imageType = image.name.split(".").reverse()[0]; imageName = `${req.session.uid}_${new Date().getTime()}.${imageType}`; image.mv(__dirname + "/public/uploads/" + imageName); - await db.query("INSERT INTO profile_answers (question_id, user_id, answer) VALUES (?, ?, ?)", [ - fid, - req.session.uid, - imageName, - ]); + try { + await db.query("INSERT INTO profile_answers (question_id, user_id, answer) VALUES (?, ?, ?)", [ + fid, + req.session.uid, + imageName, + ]); + } catch (e) { + console.error(e); + } } res.send("ok"); } catch (e) { @@ -76,11 +84,15 @@ app.put("/api/update", async (req, res) => { for (let qid in req.body) { if (!req.body.hasOwnProperty(qid) || req.body[qid] === "dbg-image") continue; let answer = req.body[qid].replace(/</g, "<").replace(/>/g, ">"); - await db.query("UPDATE profile_answers SET answer = ? WHERE question_id = ? AND user_id = ?", [ - answer, - qid, - req.session.uid, - ]); + try { + await db.query("UPDATE profile_answers SET answer = ? WHERE question_id = ? AND user_id = ?", [ + answer, + qid, + req.session.uid, + ]); + } catch (e) { + console.error(e); + } } for (let fid in req.files) { if (!req.files.hasOwnProperty(fid)) return; @@ -91,11 +103,15 @@ app.put("/api/update", async (req, res) => { imageType = image.name.split(".").reverse()[0]; imageName = `${req.session.uid}_${new Date().getTime()}.${imageType}`; image.mv(__dirname + "/public/uploads/" + imageName); - await db.query("UPDATE profile_answers SET answer = ? WHERE question_id = ? AND user_id = ?", [ - imageName, - fid, - req.session.uid, - ]); + try { + await db.query("UPDATE profile_answers SET answer = ? WHERE question_id = ? AND user_id = ?", [ + imageName, + fid, + req.session.uid, + ]); + } catch (e) { + console.error(e); + } } res.send("ok"); } catch (e) { |