constructor() { super(); mysqlPool.query('SELECT 1 + 1 AS two', (error) => { if (error) { console.log(chalk.bgYellow.bold('Warning:') + ' Cannot connect to the MySQL server. Error Code: ' + error.code); return; } this.init(); }); }
function saveToMysql(results) { results.forEach(function (result) { pool.query('insert into booklist set ?', result, function (err, result1) { if (err) throw err console.log(`insert ${result.id} success`) }) }) }
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); pool.query('SELECT 1', function (err) { assert.ok(err, 'got error'); assert.equal(err.code, 'ER_HOST_NOT_PRIVILEGED'); assert.equal(err.fatal, true); server.destroy(); }); });
// Get one user router.get('/api/users/:username', async (req, res) => { const { username } = req.params; const user = await pool.query('SELECT * FROM users WHERE username = ?', [username]) res.json(user); });
router.post('/contacts/add', async (req, res) => { const contact = req.body; contact.user = req.user.username; await pool.query('INSERT INTO contacts SET ?', [contact]); req.flash('success', 'Contact Added Successfully'); res.redirect('/contacts'); });
connection.query(cmd, [pconfig.pub, pconfig.ttl, pconfig.level, pconfig.porder, new Date().getTime(), pid], function(err, result) { var cmd = 'DELETE FROM problem_dependency WHERE pid = ?'; connection.query(cmd, [pid], function(err, result) { var cmd = 'INSERT INTO problem_dependency SET pid = ?, depend_pid = ?'; for (var i in pconfig.dependency) { connection.query(cmd, [pid, pconfig.dependency[i]], function(err, result) { }); } }); });
connection.query(cmd, [offset, count], function(err, result) { if (err) { callback(null); return 0; } callback(result); });
// Create contact router.post('/api/contacts', async (req, res) => { try { await pool.query('INSERT INTO contacts SET ?', [req.body]); res.json({status: 'created'}); } catch(err) { console.log(err); res.json({status: 'error'}); } });
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); var query = pool.query('SELECT INVALID'); query.on('end', function () { pool.end(function (err) { assert.ifError(err); server.destroy(); }); }); });
connection.query(cmd, [uid], function(err, result) { if (err || result.length == 0) { console.log(err); return callback(false); } return callback(result[0]["class"] == null); });
// Get all contacts router.get('/api/contacts', async (req, res) => { const contacts = await pool.query('SELECT * FROM contacts'); res.json(contacts); });
connection.query(cmd, [username], function(err, result) { if (err || !result || result.length == 0) return callback(); var uid = result[0].uid; var cmd = 'INSERT INTO chats (uid, msg, status, ts) VALUES (?, ?, ?, ?)'; connection.query(cmd, [uid, message, status, date], function(err, result) { if (err) console.log(err); return callback(); }); });
connection.query(cmd, [cid, pid], function(err, result) { if (!err) table_config.grade = result || []; else console.log(err); callback(table_config); });
var sql_depend = function(ret, did, lid, uid, callback) { var cmd = 'SELECT LPD.pid AS pid, COUNT(*) AS depend_count FROM (SELECT LP.pid, PD.depend_pid FROM (SELECT pid FROM problems AS P JOIN level_domain AS L ON P.level = L.level AND L.did = ? AND P.pub != 0 AND L.level = ?) AS LP JOIN problem_dependency AS PD ON LP.pid = PD.pid) AS LPD JOIN (SELECT pid FROM users NATURAL JOIN submissions WHERE uid = ? AND res = 7 GROUP BY uid, pid ORDER BY pid) AS AC ON LPD.depend_pid = AC.pid GROUP BY pid'; connection.query(cmd, [did, lid, uid], function(err, result) { ret.solve_dep = result; var cmd = 'SELECT LP.pid AS pid, COUNT(*) AS depend_count FROM (SELECT pid FROM problems AS P JOIN level_domain AS L ON P.level = L.level AND L.did = ? AND P.pub != 0 AND L.level = ?) AS LP JOIN problem_dependency AS PD ON LP.pid = PD.pid GROUP BY pid'; connection.query(cmd, [did, lid], function(err, result) { ret.prob_dep = result; callback(ret); }); }); }
connection.query(cmd, [ip, time, uid], function(err, result) { if (err) { callback(null) } callback(); });