notify_with_mail.js

var PGPubsub = require('pg-pubsub');
var nodemailer = require('nodemailer');

var pubsubInstance = new PGPubsub('postgres://password:user@host:port/database'); // don't hard code this in real life. get it from a config or environment variable

var transporter = nodemailer.createTransport({
  service: 'gmail',
  auth: {
    user: "[email protected]", // don't hard code this in real life. get it from a config or environment variable
    pass: "complex_gmail_password" // don't hard code this in real life. get it from a config or environment variable
  }
});
 
pubsubInstance.addChannel('jhucounty', function (channelPayload) {
  var msg = channelPayload.properties.label + ": " + channelPayload.properties.confirmed;
  var mailOptions = {
    from: "[email protected]", // don't hard code this in real life. get it from a config or environment variable
    to: '[email protected]', // don't hard code this in real life. get it from a config or environment variable
    subject: 'COVID-19 update for ' + channelPayload.properties.label,
    text: msg
  };
  transporter.sendMail(mailOptions, function(error, info){
    if (error) {
        console.log(error);
    } else {
        console.log('Email sent: ' + info.response);
    }
  });
});