function saveMetrics(microservice, responseTime) { var query = "INSERT INTO response_time (microservice, response_time, dt_transaction) VALUES ('" query += microservice; query += "',"; query += responseTime; query += ", NOW())"; connection.query(query, function(err, result){ console.log(err, result) }).on('error', function(err) { console.log("[mysql error]",err); }); }
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); var query = pool.query('SELECT 1'); query.on('error', function (err) { assert.ok(err, 'got error'); assert.equal(err.code, 'ER_HOST_NOT_PRIVILEGED'); assert.equal(err.fatal, true); server.destroy(); }); });
connection.query(`INSERT INTO ${table} set ?`, data, function(err, res){ if (err) { callback(err, null); } else { callback(null, {insertId: res.insertId, ...data}); } });
passport.use('local.signin', new Strategy({ usernameField: 'username', passwordField: 'password', passReqToCallback: true }, async (req, username, password, done) => { const rows = await pool.query('SELECT * FROM users WHERE username = ?', [username]); if (rows.length > 0) { const user = rows[0]; const validPassword = await bcrypt.comparePasswords(password, user.password); if (validPassword) done(null, user); else done(null, false, req.flash('message', 'Incorrect Password')); } else done(null, false, req.flash('message', 'Incorrect Username')); }));
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); pool.getConnection(function (err, conn) { assert.ifError(err); var query = conn.query('SELECT INVALID'); query.on('end', function () { conn.release(); pool.end(function (err) { assert.ifError(err); server.destroy(); }); }); }); });
connection.query(stmt_multiple_insert, [values], function (err, result) { if (err) { console.log(err); } else { console.log(str_query.sql); } })
connection.query(`SELECT * FROM ${table}`, function(err, res){ });
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(); }); }); });
function saveMetrics(microservice, responseTime) { var query = "INSERT INTO response_time (microservice, response_time, dt_transaction) VALUES ('" query += microservice; query += "',"; query += responseTime; query += ", NOW())"; connection.query(query, function(err, result){ console.log(err, result) }).on('error', function(err) { console.log("[mysql error]",err); }); }
function saveMetrics(microservice, responseTime) { var query = "INSERT INTO response_time (microservice, response_time, dt_transaction) VALUES ('" query += microservice; query += "',"; query += responseTime; query += ", NOW())"; connection.query(query, function(err, result){ console.log(err, result) }).on('error', function(err) { console.log("[mysql error]",err); }); }
function saveMetrics(microservice, responseTime) { var query = "INSERT INTO response_time (microservice, response_time, dt_transaction) VALUES ('" query += microservice; query += "',"; query += responseTime; query += ", NOW())"; connection.query(query, function(err, result){ console.log(err, result) }).on('error', function(err) { console.log("[mysql error]",err); }); }
function saveMetrics(microservice, responseTime) { var query = "INSERT INTO response_time (microservice, response_time, dt_transaction) VALUES ('" query += microservice; query += "',"; query += responseTime; query += ", NOW())"; connection.query(query, function(err, result){ console.log(err, result) }).on('error', function(err) { console.log("[mysql error]",err); }); }
function saveMetrics(microservice, responseTime) { var query = "INSERT INTO response_time (microservice, response_time, dt_transaction) VALUES ('" query += microservice; query += "',"; query += responseTime; query += ", NOW())"; connection.query(query, function(err, result){ console.log(err, result) }).on('error', function(err) { console.log("[mysql error]",err); }); }
function saveMetrics(microservice, responseTime) { var query = "INSERT INTO response_time (microservice, response_time, dt_transaction) VALUES ('" query += microservice; query += "',"; query += responseTime; query += ", NOW())"; connection.query(query, function(err, result){ console.log(err, result) }).on('error', function(err) { console.log("[mysql error]",err); }); }
function saveMetrics(microservice, responseTime) { var query = "INSERT INTO response_time (microservice, response_time, dt_transaction) VALUES ('" query += microservice; query += "',"; query += responseTime; query += ", NOW())"; connection.query(query, function(err, result){ console.log(err, result) }).on('error', function(err) { console.log("[mysql error]",err); }); }