sqlquest-reporting
This is a simple sqlquest plugin for doing simple reporting from sqlquest jobs.
Usage
$ npm install --save sqlquest-reporting
Then in your quest you can do stuff like this:
Quest = require 'sqlquest' module.exports = plugins: 'sqlquest-reporting' : -> @report "ses" from: "person@people.org" to: @opts_ subject: "Omg it works" : builderheader "Hi kids" builderheader "Do you like violence?"'small' builderparagraph "Wanna copy me and do exactly like I did?" italic: true bold: true link = builderlink "http://genius.com/Eminem-my-name-is-lyrics" "Try <bleep> and get <bleep> worse than my life is?" builderparagraph link buildertable @sql"SELECT * FROM stv_recents limit 10;" wrap: 'query'
Right now the only reporter we have is an SES implementation using AWS, but we'd love to have more options!
To use the ses
reporter, make sure you set the normal AWS credentials env
vars:
AWS_ACCESS_KEY_ID=things AWS_SECRET_ACCESS_KEY=stuff ./sqlquest ..