addShopPromise.js

connection.query(checkLocation, [location]).then(function (rows) {
  // Location exists
  return connection.query(addShop, [shopParams])
}).then(function (rows) {
  // Shop added
  return connection.query(linkState, [shopParams])
}).then(function (rows) {
  // Categorize with state
  callback(1);
}).catch(function(err) {
  console.log(err);
  callback(0);
})