Advertisement
Guest User

Untitled

a guest
Jul 6th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. var db_config = {
  2. host: 'localhost',
  3. user: 'root',
  4. password: '',
  5. database: 'db',
  6. };
  7.  
  8. var connection;
  9.  
  10. function update_query(param1) {
  11. return new Promise(function (resolve, reject) {
  12. try {
  13. connection = mysql.createConnection(db_config);
  14. connection.connect(function(err) {
  15. if(err) {
  16. console.log('error when connecting to db:', err);
  17. }
  18. });
  19.  
  20.  
  21. var query_str =
  22. //SQL statement. Blah blah
  23. "UPDATE XXX " +
  24. "SET YYY=?"
  25. ;
  26. var query_var=param1;
  27. connection.query(query_str, query_var, function (err, rows, fields) {
  28. if (err) {
  29. console.log(err);
  30. logger.info(err);
  31. return reject(err);
  32. }
  33. else {
  34. resolve(rows);
  35. }
  36. });
  37. } catch (err) {
  38. reject(err);
  39. }
  40. });
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement