node.js async/await using with MySQL

by

if you happen to be in Node 8+, you can leverage the native util.promisify() with the node mysql.

Do not forget to call it with bind() so the this will not mess up:

const mysql = require('mysql'); // or use import if you use TS
const util = require('util');
const conn = mysql.createConnection({yourHOST/USER/PW/DB});

// node native promisify
const query = util.promisify(conn.query).bind(conn);

(async () => {
  try {
    const rows = await query('select count(*) as count from file_managed');
    console.log(rows);
  } finally {
    conn.end();
  }
})()

More Related Contents:

  1. Is it an anti-pattern to use async/await inside of a new Promise() constructor?
  2. Understanding the Event Loop
  3. Callback after all asynchronous forEach callbacks are completed
  4. Preventing SQL injection in Node.js
  5. Are all javascript callbacks asynchronous? If not, how do I know which are?
  6. Asynchronous exception handling with bluebird promises
  7. How to return values from async functions using async-await from function? [duplicate]
  8. JavaScript, Node.js: is Array.forEach asynchronous?
  9. nodeJs callbacks simple example
  10. Best way to call an asynchronous function within map?
  11. How to avoid long nesting of asynchronous functions in Node.js
  12. Node JS Promise.all and forEach
  13. How to write asynchronous functions for Node.js
  14. Understanding Asynchronous Code in Layman’s terms
  15. How to wrap async function calls into a sync function in Node.js or Javascript?
  16. Are all Node.js callback functions asynchronous?
  17. Understanding async/await on NodeJS
  18. using async await and .then together
  19. Node js socket explanation
  20. When to close MongoDB database connection in Nodejs
  21. Asynchronous constructor
  22. javascript – Why is there a spec for sync and async modules?
  23. How do you create custom asynchronous functions in node.js?
  24. Why is node.js asynchronous?
  25. ER_NOT_SUPPORTED_AUTH_MODE – MySQL server
  26. Javascript Asynchronous Exception Handling with node.js
  27. How to use the ‘main’ parameter in package.json?
  28. Does an async function always need to be called with await?
  29. Properly batch nested promises in Node
  30. JavaScript asynchronous programming: promises vs generators

Leave a Comment