function query()

in shortlink/db.js [48:70]

• 18 lines of code
• 4 McCabe index (conditional complexity)

function query(sqlString, values) {
  // Initialize the pool lazily, in case SQL access isn't needed for this
  // GCF instance. Doing so minimizes the number of active SQL connections,
  // which helps keep your GCF instances under SQL connection limits.
  if (!mysqlPool) {
    logger.debug('creating sql pool');
    mysqlPool = mysql.createPool(mysqlConfig);
  }
  
  if (!values) values = [];

  return new Promise((resolve, reject) => {
    logger.debug('sending sql query');
    mysqlPool.query(sqlString, values, (err, results) => {
      if (err) {
        reject(err);
        return;
      }
      logger.debug('query succeeded');
      resolve(results);
    });
  });
}