Guest User

Untitled

a guest
Oct 24th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. var mysql = require('mysql');
  2. var mclient = mysql.createConnection({
  3. host: settings.MYSQL.HOST,
  4. user: settings.MYSQL.USER,
  5. password: settings.MYSQL.PASSWORD,
  6. database: settings.MYSQL.DB,
  7. });
  8.  
  9. var mysql = require("mysql");
  10. var pool = mysql.createPool(/* credentials go here */);
  11.  
  12. exports.getConnection = function(callback) {
  13. pool.getConnection(function(err, conn) {
  14. if(err) {
  15. return callback(err);
  16. }
  17. callback(err, conn);
  18. });
  19. };
  20.  
  21. var mysqlLib = require("mysqlLib");
  22.  
  23. mysqlLib.getConnection(function(err, mclient) {
  24. //do queries that you need
  25. });
  26.  
  27. var mysqlLib = require("mysqlLib");
  28.  
  29. mysqlLib.getConnection(function(err, mclient) {
  30. //do queries that you need
  31. var sql = '//Your SQL here';
  32. var inserts = [your inserts here];
  33. sql = mysql.format(sql, inserts);
  34. mclient.query(sql, function (err, rows) {
  35.  
  36. if (err) {
  37. //handle error here
  38. }
  39.  
  40. })
  41. });
Add Comment
Please, Sign In to add comment