From 07ad8de77e16c00831db3687c1a8e67bbd062972 Mon Sep 17 00:00:00 2001
From: Evgeny Zinoviev <me@ch1p.io>
Date: Sat, 27 Mar 2021 00:12:29 +0300
Subject: fix mysql bug

---
 src/lib/worker.js | 11 +++++++----
 1 file changed, 7 insertions(+), 4 deletions(-)

diff --git a/src/lib/worker.js b/src/lib/worker.js
index 0be6a19..cd1f0cd 100644
--- a/src/lib/worker.js
+++ b/src/lib/worker.js
@@ -547,14 +547,17 @@ class Worker extends EventEmitter {
             update.stdout = data.stdout
 
         let list = []
+        let argv = []
+
         for (let field in update) {
             let val = update[field]
-            if (val !== null)
-                val = db.escape(val)
-            list.push(`${field}=${val}`)
+            list.push(`${field}=?`)
+            argv.push(val)
         }
 
-        await db.query(`UPDATE ${config.get('mysql_table')} SET ${list.join(', ')} WHERE id=?`, [id])
+        argv.push(id)
+
+        await db.query(`UPDATE ${config.get('mysql_table')} SET ${list.join(', ')} WHERE id=?`, argv)
     }
 
     /**
-- 
cgit v1.2.3