function Read()

in sqllinuxbook/ch4/customerappinssel.js [46:78]

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

function Read(callback) {
  console.log('Reading Customer Contacts...');

  // Read all rows from table
  request = new Request(
  'SELECT c.[CustomerName], c.[WebsiteURL], p.[FullName] AS PrimaryContact FROM [Sales].[Customers] AS c JOIN [Application].[People] AS p  ON p.[PersonID] = c.[PrimaryContactPersonID];',
  function(err, rowCount, rows) {
  if (err) {
      console.log(err);
      callback(err);
  } else {
      console.log(rowCount + ' row(s) returned');
      callback(null);
  }
  });

  // Print the rows read
  var result = "";
  request.on('row', function(columns) {
      columns.forEach(function(column) {
          if (column.value === null) {
              console.log('NULL');
          } else {
              result += column.value + " ";
          }
      });
      console.log(result);
      result = "";
  });

  // Execute SQL statement
  connection.execSql(request);
}