{"_id":"alinex-dbreport","_rev":"26-f9801231d981fe3314280f8ba78ade48","name":"alinex-dbreport","description":"Run database queries and send their results using email.","dist-tags":{"latest":"1.6.0"},"versions":{"0.0.1":{"name":"alinex-dbreport","version":"0.0.1","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"monitor":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-database":"^1.0.0","alinex-report":"^1.1.4","json2csv":"^3.1.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"8650493dc6da09e707323882d105a0d69255db07","_id":"alinex-dbreport@0.0.1","_shasum":"743e1c4862ff773b460a047a450c85ce2f7bffeb","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.6.0","_npmUser":{"name":"alinex","email":"info@alinex.de"},"dist":{"shasum":"743e1c4862ff773b460a047a450c85ce2f7bffeb","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-0.0.1.tgz","integrity":"sha512-yl1rX1iL88kfcko5k6/FawyfqYZhyB7pZUHhG/ThO6j9Ts9yS85DPmAqRyqB3T8StYT7NfLo2r4AfHCpYxP2Jw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIACVLsVaxMyHgkaiD9kYax5AG6tkovXZCTmUTNfwvPqBAiB043koVfczH10qOh0W4HmiK0YYr5+JkkPO68le4hzYXQ=="}]},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"_npmOperationalInternal":{"host":"packages-5-east.internal.npmjs.com","tmp":"tmp/alinex-dbreport-0.0.1.tgz_1455136997251_0.6496891679707915"}},"0.0.2":{"name":"alinex-dbreport","version":"0.0.2","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"e73b82a5575219581516bfcedf93dd26626e86a7","_id":"alinex-dbreport@0.0.2","_shasum":"26b043ca00f58fc9e27b92895a9aba86991271c7","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.6.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"26b043ca00f58fc9e27b92895a9aba86991271c7","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-0.0.2.tgz","integrity":"sha512-tYnq85vwcqKyHqo4kH4uQYjrl7/+ryn7NVID/HDw/qLohrwIDA82FuPlCi1ZJqlfZnSlTmecmlVSSJyeEvCObg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIAEL1aU+uBeGyHU4Ssrq3ACqPsOmMi2F9MoR0aHBxci9AiEA5oUqNdf0/ieu8DGHwttzVcwZB79ikLSuuw240Q6QF0I="}]},"_npmOperationalInternal":{"host":"packages-5-east.internal.npmjs.com","tmp":"tmp/alinex-dbreport-0.0.2.tgz_1455625349888_0.13312915456481278"}},"0.0.3":{"name":"alinex-dbreport","version":"0.0.3","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"cda7a96201ef6a20ea80517b66081bbc8295b031","_id":"alinex-dbreport@0.0.3","_shasum":"1944ecadbf46227c95d9e868a7505de91936e685","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.6.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"1944ecadbf46227c95d9e868a7505de91936e685","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-0.0.3.tgz","integrity":"sha512-gXDYQ4cGCDIxCKocx/mq+7aRglVfxN1syUs5lyH42EUdfaBcKh0sFdIZ2wToWu04F/1+DmZlz2D0sdF/flWGRA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBz9hmLH9Sx/uPfoQi6vR5lSx3O5GfHvSPtuXRtRu/2VAiB16H+NkALmImBln0NKZqzlRw9OWBvyJV/Z03QL353OKw=="}]},"_npmOperationalInternal":{"host":"packages-5-east.internal.npmjs.com","tmp":"tmp/alinex-dbreport-0.0.3.tgz_1455631803429_0.23337084869854152"}},"0.1.0":{"name":"alinex-dbreport","version":"0.1.0","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"242a5c9f27a0a9ef7681047d62dbe7e172cd34f1","_id":"alinex-dbreport@0.1.0","_shasum":"1238cf6ef06ba6dceb0f990d0a75c1daf983d86c","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.6.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"1238cf6ef06ba6dceb0f990d0a75c1daf983d86c","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-0.1.0.tgz","integrity":"sha512-E0jyjTZvos/O0SDAeyAAYmWjUEsukouZ13RRBV7krZyu23gOqMIcc3/STNOIlVOuJCqrAHVSpPiliKbvJD2LrQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIAHGqMCxOl7rKRB4zeqGQZFAu9yt1laf+l8b/maxdyguAiEA1cAzt5pgGhipUvtOQPg4neGwmY8JrbqF4IqM2AzrxF4="}]},"_npmOperationalInternal":{"host":"packages-9-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-0.1.0.tgz_1455632167674_0.7787197304423898"}},"1.0.0":{"name":"alinex-dbreport","version":"1.0.0","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"edb32767b947209e1b39e41ba491f2517f67f980","_id":"alinex-dbreport@1.0.0","_shasum":"0db1d808767178d448696b23d8535a79b30beac2","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.6.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"0db1d808767178d448696b23d8535a79b30beac2","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.0.0.tgz","integrity":"sha512-OhHa98CCI3YSZ3fdxeBetEv+DjcvDZ3XNCNfdh0yukxplfGdkUsz+YBU7XNLbloQGchnrmbhd3o3W5qAE9VtVg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDde+e3D0bslsiQpWcuJ3nBFJZsc6WVEScGIz9kASSJtAiEA7+yFNE0lG6sF1I/Mt74GvJR8pAhu3zOxC54Oo9lxlOQ="}]},"_npmOperationalInternal":{"host":"packages-9-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.0.0.tgz_1455706863746_0.6894819345325232"}},"1.0.1":{"name":"alinex-dbreport","version":"1.0.1","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"21085157e8169242c19a4eafe67d64c27e394f08","_id":"alinex-dbreport@1.0.1","_shasum":"a3521532fd4044669cf66ef420fbed023f61ac6b","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.6.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"a3521532fd4044669cf66ef420fbed023f61ac6b","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.0.1.tgz","integrity":"sha512-DZ5g0Nr95NXTnxPS86GORIB30ZvVLWDcYCSTgAAnGuLp14oWVZ6zyfRr24555twYzArmH/sBZxoEXmNohpUPAQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDLJPNq9fnPSYu0qzW94igzxLjK++3ZPiK3qXpbKlRqKQIhAM2ZgSyS3YV17Xyphw4GhfIzHNQU7v9tI4L77xa3I1aM"}]},"_npmOperationalInternal":{"host":"packages-6-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.0.1.tgz_1455707341359_0.9946341246832162"}},"1.0.2":{"name":"alinex-dbreport","version":"1.0.2","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"4af2dce158d421de039ef7c393d989dc756c7e84","_id":"alinex-dbreport@1.0.2","_shasum":"6b9c099f5957c750cc641240cd3ec002deb93fb2","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.6.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"6b9c099f5957c750cc641240cd3ec002deb93fb2","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.0.2.tgz","integrity":"sha512-dopxkzT5qFA+8RvMolqo8ONamh5TEmq7yyIIgHyZp2TPlcyL8rmv+BkqXa+pbv2yEVx0ssG4/6nn3pno4fY71w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIF/4eyeDq0pq1QWJECUIxwahaNyIjq+F1QWP1QRyNqtaAiEA0e+z/zL2RUa6SSSNWRSmZDykH/YAtveo+hx+6W6Ca/M="}]},"_npmOperationalInternal":{"host":"packages-5-east.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.0.2.tgz_1456127910539_0.8152684753295034"}},"1.0.3":{"name":"alinex-dbreport","version":"1.0.3","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"1665608324d28ddfcd6f6a3f5fbadd46cd623c07","_id":"alinex-dbreport@1.0.3","_shasum":"334da971e552bce859dedd60673203ccc1fab9a9","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.6.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"334da971e552bce859dedd60673203ccc1fab9a9","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.0.3.tgz","integrity":"sha512-AGaEkSYkuKRgZa1oTjT2QiApT7+Cp7Tksx4pd7wmLc8IDJoLmRw2THiITixgUijQDRb9IAv22g399GZALCuFaA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICzshE0C/jZwsZap1wIQHz2D4gsEZSOgaLkZOMxzAjCjAiBdKw8CrbswDydPq8AYBgfRWJy/KuwDEdCeHJ3uxIgU9A=="}]},"_npmOperationalInternal":{"host":"packages-6-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.0.3.tgz_1456129126144_0.6353743826039135"}},"1.1.0":{"name":"alinex-dbreport","version":"1.1.0","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"5e66d72718ef548ba91c103fec73eb8ae2914246","_id":"alinex-dbreport@1.1.0","_shasum":"17311ed8cd7627484e6a495290258d638e5788cf","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.7.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"17311ed8cd7627484e6a495290258d638e5788cf","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.1.0.tgz","integrity":"sha512-fXspeFBchw/sIhcrC5086o6fBtiKEVU9enmHo/I9P9q5l+8hQVniB0cdWSJ9lwe1HRMTim2NZUjIS5VCyZb4XQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDyyfUTP4l3f/ddlI8BSVFDVOmPcyxEKnsWtLyzvNaLDAiEAwu8m2HN3O3um2+gqkPGT+XNqPt4bsO5oR4wBGkf3B2c="}]},"_npmOperationalInternal":{"host":"packages-6-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.1.0.tgz_1456326484625_0.6586588774807751"}},"1.1.1":{"name":"alinex-dbreport","version":"1.1.1","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^0.3.15","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"d375c9450fa4eade673b8a46f91d7a6b0a2dd776","_id":"alinex-dbreport@1.1.1","_shasum":"db88970dcb4d55bb189fd0bdc8ef2317bb885f80","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.7.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"db88970dcb4d55bb189fd0bdc8ef2317bb885f80","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.1.1.tgz","integrity":"sha512-jRDtng8WN6btoKdbV+lwRv74kL+syZCknsJXiW0psksZum3gIc7f6tIbpvX791kCHtIWdrZ45QTUQcD9OkxggA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDO/z6KqA6W6dyRxMd44xn0YzV3iP9Ay4/7eKCRgYs9pwIgKMresy0Ub3ElVBihAQNwefiGaWBI2mpaK2/imvWCHIk="}]},"_npmOperationalInternal":{"host":"packages-9-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.1.1.tgz_1456393776921_0.10114702256396413"}},"1.1.2":{"name":"alinex-dbreport","version":"1.1.2","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^1.0.0","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.0","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"bb205073173ec0ed0c1222c5b96a06a70b488f05","_id":"alinex-dbreport@1.1.2","_shasum":"de2e75fff7e68b6e461ab29b23c20181ea79390f","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.7.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"de2e75fff7e68b6e461ab29b23c20181ea79390f","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.1.2.tgz","integrity":"sha512-dGTR5sOOVd76VMpG5q47V7c6dPmlXZzRFO+aU+x2hPcmHV5JdzlpNSgHGkbCIfr8keRn+jKtzTyy6EuqOrmn/w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGmE88hloUW0jEZNIUkf+W8SKo9e5lmNj7r4OBILrjALAiBVBCgIJ2pKidC5OfZN3AQcZvVE/AvsBmiSEUhxWFtjAw=="}]},"_npmOperationalInternal":{"host":"packages-9-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.1.2.tgz_1456492528723_0.6838252157904208"}},"1.1.3":{"name":"alinex-dbreport","version":"1.1.3","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^1.0.0","chalk":"^1.1.1","debug":"^2.2.0","json2csv":"^3.2.0","moment":"^2.11.2","nodemailer":"^2.1.0","nodemailer-plugin-inline-base64":"^1.0.1","yargs":"^4.1.0"},"devDependencies":{"alinex-builder":"^1.2.2","chai":"^3.5.0"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"499d58266b172d3224657849d1af4689ea0cb038","_id":"alinex-dbreport@1.1.3","_shasum":"8e6930223410a17c72ea76211ab6ae34bf8af365","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.7.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"8e6930223410a17c72ea76211ab6ae34bf8af365","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.1.3.tgz","integrity":"sha512-IByajasT7JjBxh5wPvWrFJFTpN510XFxWd849adUnvYtJTDKamem3hjpunjagIIfJ5FQJNxLfgJOuJyyPyiDJg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICfn1Hu5IgjCR1pbxQK3OQSYmfiFN6vCpB0uiVRhOGqoAiEAhYZQHKREUknzPEdHJcbyjeHoh+P7LaxgyNNd1Gyjaf0="}]},"_npmOperationalInternal":{"host":"packages-5-east.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.1.3.tgz_1456757482947_0.8350031482987106"}},"1.2.0":{"name":"alinex-dbreport","version":"1.2.0","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^1.0.0","chalk":"^1.1.1","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.1"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"95a35148ebf930448c47133871edcd6fb8ecc3df","_id":"alinex-dbreport@1.2.0","_shasum":"1f91127ca5ecb7ace8eb69edfab11a940b084eca","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.7.1","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"1f91127ca5ecb7ace8eb69edfab11a940b084eca","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.2.0.tgz","integrity":"sha512-/ARCGUW/0HWH5ZAGT3wGz52dKwkuwY9vB+nkluyIFeX1BwoTpO8GevybUgXX2cxpMek+pn0cpuCc9YJoNtdvvA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFeXPSpoxkbNqueSyNnh+ddtGXIyIYc3QeCJB3+9GXSCAiEAkTc0ZzM0rFn2k6y0CJick8je04f0UfqXAkizTznJ9pM="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.2.0.tgz_1458125971841_0.24962715804576874"}},"1.3.0":{"name":"alinex-dbreport","version":"1.3.0","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^1.1.0","alinex-validator":"^1.3.2","chalk":"^1.1.1","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.1"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"d1b37d3bc5e7c894164d438367476b261aa4028f","_id":"alinex-dbreport@1.3.0","_shasum":"6bbf664331bd0fff06792783a5179c3b63692662","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.7.1","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"6bbf664331bd0fff06792783a5179c3b63692662","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.3.0.tgz","integrity":"sha512-0bBj3208bvZc5bt071QA/liYGQyXpsy3awLPJ2jsZMcZKWg2FZnfXNmnugvO3P4bPk4Deus8zwdtJznTT4rkww==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDBF9E+CxI7HJfsMQeNSLIaN0coRFNVkXc5Ck+DwwtcGAiEAs+PzwuPDkaf28lUt5gvPoOrCHuvsWp9WIciKEfG1B+0="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.3.0.tgz_1458208174066_0.9893773763906211"}},"1.3.1":{"name":"alinex-dbreport","version":"1.3.1","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.0","alinex-report":"^1.3.0","alinex-util":"^1.1.0","alinex-validator":"^1.3.2","chalk":"^1.1.1","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.1"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"7e0a180537706e52e625fba27f4bb2b75ae0333e","_id":"alinex-dbreport@1.3.1","_shasum":"3e4b88693c09b63d158e70c932921d33617d99d1","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.7.1","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"3e4b88693c09b63d158e70c932921d33617d99d1","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.3.1.tgz","integrity":"sha512-uFRQTe0Oie7Mg7JKnpSRYP1ALGaGD54jchpve83Z197aPffhvwBnVtp5lHh0Az+YuNXV0Pz8oyNhHgkTe3Ejtg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBpgycUZqKBSQffNws43p6eye3rk0FiKdmv3ST7KblH4AiBQonWX5S7979j07iCDOXhJ0Y8gZfOz2IXECVh2HqMkWw=="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.3.1.tgz_1458220140659_0.5069719292223454"}},"1.3.2":{"name":"alinex-dbreport","version":"1.3.2","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.12","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.1","alinex-report":"^1.3.0","alinex-util":"^1.1.0","alinex-validator":"^1.3.2","chalk":"^1.1.1","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.1"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"413c93d73d59bea0b347538202bc0e5fba1383e0","_id":"alinex-dbreport@1.3.2","_shasum":"8f7afe84cb759f326c4749d51ac2cd4df6702b98","_from":".","_npmVersion":"3.6.0","_nodeVersion":"5.7.1","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"8f7afe84cb759f326c4749d51ac2cd4df6702b98","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.3.2.tgz","integrity":"sha512-K/mOMcMt0qQ1j1ku/rUuof5+CmheGIk1ZADMaR1zfpGORfn04kTzqBQjv22vbjusYmyUiAdPYxJOws/LBlOSEw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDQW8ZG0CGTvvzYtXJtvVaP3LIiTG/KT/spYRxLzosaJAIgX75RWB+8lzB056WNoxQsAaesXz84Mnac4FjTr6vFCDY="}]},"_npmOperationalInternal":{"host":"packages-13-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.3.2.tgz_1458226652880_0.3395195887424052"}},"1.3.3":{"name":"alinex-dbreport","version":"1.3.3","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.14","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.1","alinex-report":"^1.3.0","alinex-util":"^1.1.1","alinex-validator":"^1.4.2","chalk":"^1.1.1","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.2"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"3bcf4bda32f8d65b542d0fcdd42d1c83e8e4f3c5","_id":"alinex-dbreport@1.3.3","_shasum":"b3385ef536da24d8fcf2f38bd52372264d386b41","_from":".","_npmVersion":"3.7.3","_nodeVersion":"5.9.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"b3385ef536da24d8fcf2f38bd52372264d386b41","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.3.3.tgz","integrity":"sha512-2vcBIKsBJHheX93h+oNE4pJETBVHigk+/RZXTZRc5hMG/Ru+VfcJuXwS2olexpNTYnM9Hta0eDWxB5nj7tzQdg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQChWCNN8RUBZLRICOblAgj2OH9slsiEgBAwYsUibXbbBgIgW2rTeHXWISO9U83f4G+07mOsFbGKOw/DCvOaCLzKT0Y="}]},"_npmOperationalInternal":{"host":"packages-13-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.3.3.tgz_1458567093702_0.9551062788814306"}},"1.4.0":{"name":"alinex-dbreport","version":"1.4.0","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.14","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.1","alinex-report":"^1.3.0","alinex-util":"^1.1.2","alinex-validator":"^1.4.2","chalk":"^1.1.1","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.2"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"d7ae14ca7bbb7581db11610aa22439c1d0e6fd20","_id":"alinex-dbreport@1.4.0","_shasum":"ef9e4ea5ce236714e9333130d4c1ba23a872173a","_from":".","_npmVersion":"3.7.3","_nodeVersion":"5.9.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"ef9e4ea5ce236714e9333130d4c1ba23a872173a","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.4.0.tgz","integrity":"sha512-Lz3xmC7vd5tj1RI5ohfvJXGpKOgNXJkynyOCXe6oIUXlM95ntFFOvf4DoUhBGGBJPOAvhlG27H1RNJmKY8HdPg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICR39WcCr/2Kqwhw81h7XMXrN9kxkRzG4oCGyQL7kyHQAiEAiMwHfFEEMEp2iAYsFxWnX4YN+skHzHmTDGvyriBSxGc="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.4.0.tgz_1458720130443_0.8961526148486882"}},"1.4.1":{"name":"alinex-dbreport","version":"1.4.1","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.14","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.1","alinex-report":"^1.3.10","alinex-util":"^1.1.2","alinex-validator":"^1.4.2","chalk":"^1.1.3","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.2"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"95a6807c6653b9d62c00ca42042666425c002365","_id":"alinex-dbreport@1.4.1","_shasum":"1dae7d508a4503d1e6321d66952dd9022cad1219","_from":".","_npmVersion":"3.7.3","_nodeVersion":"5.9.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"1dae7d508a4503d1e6321d66952dd9022cad1219","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.4.1.tgz","integrity":"sha512-rSpNLjDuo4gPEdrlUCAjwhgxKc3ixY1HHkYjGzXIYnnShPJlTLIWRYh61O7Ym6O0R7CC0JDBkvpwZEIOnnCnwQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDfUy/JG3TL3rHZZRANOy6rCs3xSIq8DhUM/MlobYVuOQIhALHTvkO9r0o3CBZBflTEEyD8Kcn2qQYTPxjaVrq8KfMU"}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.4.1.tgz_1459345187682_0.983042263193056"}},"1.4.2":{"name":"alinex-dbreport","version":"1.4.2","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.14","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.1","alinex-report":"^1.3.10","alinex-util":"^1.1.2","alinex-validator":"^1.4.2","chalk":"^1.1.3","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.2"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"0afc33ecad48700df724b77b451fb604b653d867","_id":"alinex-dbreport@1.4.2","_shasum":"d700594b0d0f36545fcf390cf7f78fa27987581d","_from":".","_npmVersion":"3.7.3","_nodeVersion":"5.9.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"d700594b0d0f36545fcf390cf7f78fa27987581d","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.4.2.tgz","integrity":"sha512-V7ixa6wpv3e/Bth5HROhI6OcCLIR1KuMYV2jy6diwcWr9REDANx9FhD60ODdSLBW82wQ3TNeLWS1qhCo/+Hkag==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCVrisnfZtC/QkmkfQPeWTxMVy9KLBuJ1eefNsc2egkPAIgTi6nK8JHcuQcwZofsFyjmH6CyFhJCwwtDoX+Chq6knE="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.4.2.tgz_1459345983064_0.8740405752323568"}},"1.4.3":{"name":"alinex-dbreport","version":"1.4.3","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.14","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.1","alinex-report":"^1.3.10","alinex-util":"^1.1.2","alinex-validator":"^1.4.2","chalk":"^1.1.3","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.2"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"abf97d40af739adcff483547290ce3fe73a55857","_id":"alinex-dbreport@1.4.3","_shasum":"2476e7a6a164de342d994cd8dd7c59496b428e88","_from":".","_npmVersion":"3.7.3","_nodeVersion":"5.9.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"2476e7a6a164de342d994cd8dd7c59496b428e88","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.4.3.tgz","integrity":"sha512-DtVX/Nts3zYMhUtkjo/s2bM/GJiS8VYRfdb0DF4dhsBMGfACBaqTBWkvMwWnVBm8RZ6D257iWKGAZg7oCZAJ5w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBjudacpu4r1kMp22IkobeuzJ9gJwPJT2g/ZOgxN0SfCAiBusnrydoRLUgwC68bPAIWgeAnYTdLTU5VUymNC6mmixA=="}]},"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.4.3.tgz_1459401363088_0.9881880294997245"}},"1.4.4":{"name":"alinex-dbreport","version":"1.4.4","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.15","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.1","alinex-report":"^1.3.10","alinex-util":"^1.1.2","alinex-validator":"^1.4.2","chalk":"^1.1.3","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.3.2"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"9e956d27c035f32c0915e6a34ed341cf013d9daf","_id":"alinex-dbreport@1.4.4","_shasum":"8c13e5a113a7e6d4e4de78cb7256a056a7af6941","_from":".","_npmVersion":"3.7.3","_nodeVersion":"5.9.0","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"8c13e5a113a7e6d4e4de78cb7256a056a7af6941","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.4.4.tgz","integrity":"sha512-dKLVHXbjJS4PwYl//1R1AbLlaCqnSgK1Lkn+D1gGhQ/F77ih1QOYCH4ypypw81BkZ10mvC4f6/Kv946fXvav/Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCICOUgg+bY6BR1gSQMz79UpZpWEyjUX7xWe7ipAS2maUoAiEAhAi2wIJjqhStecLAe/yaXHmyuhAhF4pmX1FyA0d4fmE="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.4.4.tgz_1459410740024_0.7848997716791928"}},"1.5.0":{"name":"alinex-dbreport","version":"1.5.0","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.18","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.3","alinex-report":"^1.3.13","alinex-util":"^1.1.4","alinex-validator":"^1.4.6","chalk":"^1.1.3","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.6.0"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"55cd953f8f307e74c72f93ad13b1acf5fe79936c","_id":"alinex-dbreport@1.5.0","_shasum":"07d8a9997a6dc3c88e4975cb946aa3241f476079","_from":".","_npmVersion":"3.8.3","_nodeVersion":"5.10.1","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"07d8a9997a6dc3c88e4975cb946aa3241f476079","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.5.0.tgz","integrity":"sha512-Ff6m4A2GELZfPoCnv+hVDepB/+urEUzGrepBl+BSNfyO3PZs5y6+LIOqBEAOov1fVez+sl7cy0eBYSPlbxpxjw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGYFEvUh0LpAen4OU5QTgCZQH2IL5fnYFTrWL7lSO+YqAiEAmhstWlTH8uubvISrlLL/cPJDU3MKuy3rJL6J7WV1RIA="}]},"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.5.0.tgz_1460455884413_0.28985080728307366"}},"1.6.0":{"name":"alinex-dbreport","version":"1.6.0","description":"Run database queries and send their results using email.","copyright":"Alexander Schilling 2016","private":false,"keywords":["database","query","report","table"],"homepage":"http://alinex.github.io/node-dbreport/","repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"contributors":[],"license":"Apache-2.0","main":"./lib/index.js","bin":{"dbreport":"./bin/dbreport"},"man":["./man/dbreport.1"],"scripts":{"prepublish":"builder -c compile --uglify","test":"builder -c test","start":"bin/dbreport"},"preferGlobal":true,"directories":{"bin":"./bin","man":"./man","lib":"./lib"},"dependencies":{"alinex-async":"^1.0.0","alinex-config":"^1.0.19","alinex-core":"^0.1.4","alinex-database":"^1.0.0","alinex-mail":"^1.0.3","alinex-report":"^1.3.13","alinex-util":"^1.1.4","alinex-validator":"^1.5.0","chalk":"^1.1.3","debug":"^2.2.0","iconv-lite":"^0.4.13","json2csv":"^3.2.0","moment":"^2.12.0","yargs":"^4.6.0"},"devDependencies":{"alinex-builder":"^1.2.4"},"optionalDependencies":{},"engines":{"node":">=0.10"},"os":[],"gitHead":"aa5404fdae541119edbee7e67c7063a6061ca853","_id":"alinex-dbreport@1.6.0","_shasum":"c055990a074209a8ac5f16b6d8cf8707d53444de","_from":".","_npmVersion":"3.8.3","_nodeVersion":"5.10.1","_npmUser":{"name":"alinex","email":"alexander.schilling@4readers.org"},"maintainers":[{"name":"alinex","email":"info@alinex.de"}],"dist":{"shasum":"c055990a074209a8ac5f16b6d8cf8707d53444de","tarball":"https://registry.npmjs.org/alinex-dbreport/-/alinex-dbreport-1.6.0.tgz","integrity":"sha512-XPpqiA3z4aRnzaESCqOq1ftm5FDYgfqM74s+x9rQBRhFNjGs+LN5Y84ohfsEQnPdb3xhHse/JSsgciTLb17ywg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD4OUCcFZgIepXD+JjX4m1Ee5efHqyDN444a0EKqJjvlAIhAOUdkNQADmGV2jkZWBKH056osxRkvxq4K3nXEmV85gtu"}]},"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/alinex-dbreport-1.6.0.tgz_1460707674641_0.6459654176142067"}}},"readme":"Package: alinex-dbreport\n=================================================\n\n[![Build Status](https://travis-ci.org/alinex/node-dbreport.svg?branch=master)](https://travis-ci.org/alinex/node-dbreport)\n[![Coverage Status](https://coveralls.io/repos/alinex/node-dbreport/badge.png?branch=master)](https://coveralls.io/r/alinex/node-dbreport?branch=master)\n[![Dependency Status](https://gemnasium.com/alinex/node-dbreport.png)](https://gemnasium.com/alinex/node-dbreport)\n\nRun some database queries and send their results using email. The main features are:\n\n- work on any database\n- fully configurable\n- send results as csv\n- pretty email format\n- combine queries\n\nIt can be started from command line or triggered using cron.\n\n> It is one of the modules of the [Alinex Universe](http://alinex.github.io/code.html)\n> following the code standards defined in the [General Docs](http://alinex.github.io/develop).\n\n\nInstall\n-------------------------------------------------\n\n[![NPM](https://nodei.co/npm/alinex-dbreport.png?downloads=true&downloadRank=true&stars=true)\n ![Downloads](https://nodei.co/npm-dl/alinex-dbreport.png?months=9&height=3)\n](https://www.npmjs.com/package/alinex-dbreport)\n\nInstall the package globally using npm on a central server. From there all your\nmachines may be checked:\n\n``` sh\nsudo npm install -g alinex-dbreport --production\n```\n\nAfter global installation you may directly call `dbreport` from anywhere.\n\n``` sh\ndbreport --help\n```\n\nAlways have a look at the latest [changes](Changelog.md).\n\n### Bash Code completion\n\nIf you like, you can add code completion for bash by copying the output of:\n\n``` text\n> scripter bashrc-script\n\n###-begin-cli.coffee-completions-###\n#\n# yargs command completion script\n#\n# Installation: dbreport completion >> ~/.bashrc\n#    or dbreport completion >> ~/.bash_profile on OSX.\n#\n_yargs_completions()\n{\n    local cur_word args type_list\n\n    cur_word=\"${COMP_WORDS[COMP_CWORD]}\"\n    args=$(printf \"%s \" \"${COMP_WORDS[@]}\")\n\n    # ask yargs to generate completions.\n    type_list=`dbreport --get-yargs-completions $args`\n\n    COMPREPLY=( $(compgen -W \"${type_list}\" -- ${cur_word}) )\n\n    # if no match was found, fall back to filename completion\n    if [ ${#COMPREPLY[@]} -eq 0 ]; then\n      COMPREPLY=( $(compgen -f -- \"${cur_word}\" ) )\n    fi\n\n    return 0\n}\ncomplete -F _yargs_completions dbreport\n###-end-cli.coffee-completions-###\n```\n\n\nUsage\n-------------------------------------------------\n\nYou can simple call the `dbreport` command with at least one of the configured\nreports:\n\n    > dbreport <job>... [<options>]...\n\n    Initializing...\n    Run the jobs...\n    -> tables\n    Goodbye\n\nTo get some more information call it with debugging:\n\n    > DEBUG=dbreport dbreport <job>... [<options>]...\n\n    Initializing...\n    Run the jobs...\n    -> tables\n      dbreport start tables job +0ms\n      dbreport run query tables: SELECT table_schema, table_name FROM information_schema.tables ORDER BY table_schema, table_name +1ms\n      dbreport tables: 641 rows fetched +88ms\n      dbreport sending email to betriebsteam@mycompany.com.. +547ms\n      dbreport using SMTP +3ms\n      dbreport message send {accepted: [ 'betriebsteam@mycompany.com' ],\n      rejected: [],\n      response: '250 2.0.0 from MTA(smtp:[172.16.51.30]:10025): 250 2.0.0 Ok: queued as 7C61520AB5',\n      envelope:\n       { from: 'alexander.schilling@mycompany.com',\n         to: [ 'betriebsteam@mycompany.com' ] },\n      messageId: '1454671119582-6f16f637-c8a84be8-46bf2d0c@mycompany.com' } +2ms\n    Goodbye\n\nGlobal options:\n\n    -C, --nocolors  turn of color output\n    -v, --verbose   run in verbose mode\n    -h, --help      Show help\n\nUse other email address for test:\n\n    -m, --mail      give a specific mail address\n    -j, --json      give an optional object of variables to the job\n\n\nConfiguration\n-------------------------------------------------\nThe most parts are configurable without any code change.\n\n\n### jobs\n\nThe main part is the configuration of each single, possible job. At best this\nshould be done each in it's own file like `/dbreport/job/xxxx`:\n\n``` yaml\n# Test Job\n# =================================================\n\n# Job Meta\n# -------------------------------------------------\ntitle: Vorhandene Tabellen\ndescription: |+\n  Dieser Bericht zeigt alle Tabellen die zum Zeitpunkt der Ausführung in der manage\n  life Datenbank existieren. Die genaue Liste liegt als tables.csv dieser Email bei.\nvariables:\n  schema:\n    type: 'string'\n\n# Queries to Run\n# -------------------------------------------------\nquery:\n  tables:\n    title: List of Tables\n    description: a complete list of all relations in the database\n    database: test_postgresql\n    command: >\n      SELECT relname\n      FROM pg_class\n      WHERE relname !~ '^(pg_|sql_)' AND relkind = 'r'\n      AND relname not like '{{schema}}.%';\n  indexes:\n    title: List of Indexes\n    description: a complete list of all indexes in the database\n    database: test_postgresql\n    command: >\n      SELECT relname\n      FROM pg_class\n      WHERE relname !~ '^(pg_|sql_)' AND relkind = 'i';\n\n# Compose\n# -------------------------------------------------\ncompose:\n  all:\n    title: List of Objects\n    description: a complete list of all objects in the database\n    # combine methods\n    append:\n      - tables\n      - indexes\n    join:\n      tables: inner\n      indexes: inner\n    # select only some columns\n    fields: name, value\n    # sort the list\n    sort: relname\n    reverse: true    \n    unique: true\n    # change x and y axes\n    flip: true\n\n# Define contents\n# -------------------------------------------------\n# also go on for empty results - else skip\nsendEmpty: true\n# which csv files to send (list) or true for all\ncsv:\n  - all\n# add pdf reports\npdf:\n  example:\n    title: Example\n    format: A4\n    orientation: portrait\n    local: de\n    content: >\n      My handlebars template...\n\n# Where to Send them to\n# -------------------------------------------------\nemail:\n  base: default\n  to: betrieb@mycompany.com\n```\n\nAs you see above you have the four parts to fill up:\n\n- meta data to be used in the email like: '{{conf.title}}'\n- queries with a name, the db reference name and code to execute\n- compose options (optional)\n- email sending\n\n#### Meta Data\n\nHere only the `title` and `description` can be set tzo be used within the email\ntemplate. They are useable as  `{{conf.title}}` or `{{conf.description}}` in the\ntemplate.\n\nThe variables object define which variables are used within this job. You have to\ngive them from the command line by `--json ...`.\n\n#### Queries\n\nThis let you define multiple database queries to execute. They are given as an\nobject with an alias name as key. This name can be used later in composing\nmultiple queries together.\n\nIf no `compose` setting is given they will used directly as the attached csv files.\nTherefore the `title`, `description` and `sort` settings may be given. The resulting\nCSV file names will use the title or alias.\n\nThe `database` setting is a reference to the database connection to use. This is\ndefined separately (see below).\n\nThe `command` string is the SQL to be executed. This will be send as is to the\ndatabase server. So there are no variables possible.\n\n#### Compose\n\nIf you want to compose multiple query results together this section allows for.\nIt should contain an object of compositions to send as separate files. The\nkey of each entry is used as an alias.\n\nEach composition contains:\n\n- title <string> - to be used as filename and as template variable\n- description <string> - to be used as template variable\n- append 'true' or <list of query aliases>\n- join - specific join settings (see below)\n- sort [<field>]... - list of sort fields (prepend with '-' for decreasing order)\n- reverse <boolean> - will reverse the whole list if true\n- fields <list> - will remove all columns not listed here and sort columns after\n  the given list\n- unique <boolean> - set to true to remove completely duplicate rows\n- flip <boolean> - will change x- and y-axis within the table\n\nThe join can be set to:\n- 'true' - to left join all tables\n- list of alias names - to left join the given tables\n- object - with alias name and join type (left, right, inner, outer, append)\n  which will be done in the given order\n\n#### Email\n\nHere you have the option to prevent sending empty emails (without attached csv)\nby setting `sendEmpty` to `false`.\n\nThe email part is exactly like defined above in the base email settings. So you\nhave the possibility to overwrite each value written there with the ones here.\n\nWhile the email mostly uses a 'base' template and only defines the parts which\nare changed to the base template. So a proper use of the templates will help\nyou minimize the configuration for the jobs.\n\n### Email Templates\n\nThis templates are used for sending emails out. They will be defined under\n`/email`:\n\n``` yaml\n# Email Templates\n# =================================================\n\n\n# Default Email Templates\n# -------------------------------------------------\nThis will extend/overwrite the already existing setup within the code.\ndefault:\n  # specify how to connect to the server\n  transport: smtp://alexander.schilling%40mycompany.de:<PASSWORD>@mail.mycompany.de\n  # sender address\n  from: alexander.schilling@mycompany.de\n  replyTo: somebody@mycompany.de\n\n  # content\n  locale: en\n  subject: >\n    Database Report: {{name}}\n  body: |+\n    {{conf.title}}\n    ==========================================================================\n\n    {{conf.description}}\n\n    Started at {{dateFormat date \"LLL\"}}:\n\n    | Zeilen | Datei    | Beschreibung |\n    | ------:| -------- | ------------ |\n    {{#each result}}\n    | {{rows}} | {{file}} | {{description}} |\n    {{/each}}\n\n    Find the files attached to your mail if data available!\n```\n\nTo make it more modular you may also add a `base` setting to use the setting defined\nthere as a base and the options here may overwrite or enhance the base setup.\n\n#### Transport\n\nThe transport setting defines how to send the email. This should specify the\nconnection for the mail server to use for sending. It is possible to do this using\na connection url like above with the syntax:\n\n    <protocol>://<user>:<password>@<server>:<port>\n\nOr you may specify it as object like:\n\n``` yaml\ntransport:\n  pool: <boolean> # use pooled connections defaults to false\n  direct: <boolean> # set to true to try to connect directly to recipients MX\n  service: <string> # name of well-known service (will set host, port and secure options)\n  # services: 1und1, AOL, DebugMail.io, DynectEmail, FastMail, GandiMail, Gmail,\n  # Godaddy, GodaddyAsia, GodaddyEurope, hot.ee, Hotmail, iCloud, mail.ee, Mail.ru,\n  # Mailgun, Mailjet, Mandrill, Naver, Postmark, QQ, QQex, SendCloud, SendGrid,\n  # SES, Sparkpost, Yahoo, Yandex, Zoho\n  host: <string> # the hostname or IP address to connect to\n  port: <integer> # the port to connect to (defaults to 25 or 465)\n  secure: <boolean> # if true the connection will only use TLS else (the default)\n  # TLS may still be upgraded to if available via the STARTTLS command\n  ignoreTLS: <boolean> # if this is true and secure is false, TLS will not be used\n  requireTLS: <boolean> # if this is true and secure is false, it uses STARTTLS\n  # even if the server does not advertise support for it\n  tls: <object> # additional socket options like `{rejectUnauthorized: true}`\n  auth: # authentication objects\n    user: <string> # the username\n    pass: <string> # the password for the user\n  authMethod: <string> # preferred authentication method, eg. ‘PLAIN’\n  name: <string> # hostname of the client, used for identifying to the server\n  localAddress: <string> # the local interface to bind to for network connections\n  connectionTimeout: <integer> # milliseconds to wait for the connection to establish\n  greetingTimeout: <integer> # milliseconds to wait for the greeting after connection is established\n  socketTimeout: <integer> # milliseconds of inactivity to allow\n  debug: <boolean> # set to true to log the complete SMTP traffic\n  # if pool is set to true:\n  maxConnections: <integer> # the count of maximum simultaneous connections (defaults to 5)\n  maxMessages: <integer> # limits the message count to be sent using a single connection (defaults to 100)\n  rateLimit: <integer> # limits the message count to be sent in a second (defaults to false)    \n```\n\n#### Addressing\n\nFirst you can define the sender address using:\n\n``` yaml\nfrom: <string> # the address used as sender(often the same as used in transport)\nreplyTo: <string> # address which should be used for replys\n```\n\nAnd you give the addresses to send the mail to. In the following fields: `to`, `cc`\nand `bcc` you may give a single address or a list of addresses to use.\nAll e-mail addresses can be plain e-mail addresses\n\n    name@mymailserver.com\n\nor with formatted name (includes unicode support)\n\n    \"My Name\" <name@mymailserver.com>\n\n#### Content\n\nThe content of the mail consists of an subject line which should be not to long\nand the body. The body is given as [Markdown](http://alinex.github.io/develop/lang/markdown.html)\nsyntax and supports all possibilities from\n[report](http://alinex.github.io/node-report/README.md.html#markup%20syntax).\nThis will be converted to a plain text and html version for sending so that the\nmail client can choose the format to display.\n\nLike you see above, you can use handlebar syntax to use some variables from the\ncode. This is possible in subject and body. And you may specify a\nlocal to use for date formatting.\n\nYou can also define different templates which can be referenced from within the\njob.\n\nThe following context variables are possible:\n\n- name - the alias name for this job\n- conf... - configuration of job (object)\n- variables - list of variables\n- date - the date then the job was done (now)\n- result - data after Composing\n  - <job> - one entry for each job\n    - title - title of the job (from config)\n    - description - description of job (from config)\n    - data - raw data\n    - rows - number of rows in result (without heading)\n- attachments - list of attachments\n  - <entry>\n    - type - file type (extension)\n    - filename - file name\n    - description - description of file (from config)\n    - content - real data\n    - rows - number of rows contained (if applicable)\n\nFind more examples at [validator](http://alinex.github.io/node-validator/README.md.html#handlebars).\n\n### Database\n\nAlso you need the setup under `/database` like described in\n[Database](http://alinex.github.io/node-database).\nThis is used to make the specific database connections.\n\n\nCompose\n-------------------------------------------------\nLike seen above the compose section can be used to\n\n\nLicense\n-------------------------------------------------\n\nCopyright 2016 Alexander Schilling\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this file except in compliance with the License.\nYou may obtain a copy of the License at\n\n>  <http://www.apache.org/licenses/LICENSE-2.0>\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n","maintainers":[{"name":"alinex","email":"info@alinex.de"}],"time":{"modified":"2022-06-13T02:38:31.152Z","created":"2016-02-10T20:43:19.042Z","0.0.1":"2016-02-10T20:43:19.042Z","0.0.2":"2016-02-16T12:22:32.172Z","0.0.3":"2016-02-16T14:10:05.850Z","0.1.0":"2016-02-16T14:16:11.671Z","1.0.0":"2016-02-17T11:01:07.748Z","1.0.1":"2016-02-17T11:09:05.550Z","1.0.2":"2016-02-22T07:58:33.714Z","1.0.3":"2016-02-22T08:18:51.590Z","1.1.0":"2016-02-24T15:08:07.334Z","1.1.1":"2016-02-25T09:49:39.596Z","1.1.2":"2016-02-26T13:15:31.380Z","1.1.3":"2016-02-29T14:51:24.570Z","1.2.0":"2016-03-16T10:59:34.353Z","1.3.0":"2016-03-17T09:49:36.455Z","1.3.1":"2016-03-17T13:09:02.938Z","1.3.2":"2016-03-17T14:57:35.563Z","1.3.3":"2016-03-21T13:31:36.396Z","1.4.0":"2016-03-23T08:02:12.824Z","1.4.1":"2016-03-30T13:39:49.914Z","1.4.2":"2016-03-30T13:53:05.429Z","1.4.3":"2016-03-31T05:16:04.064Z","1.4.4":"2016-03-31T07:52:22.615Z","1.5.0":"2016-04-12T10:11:25.836Z","1.6.0":"2016-04-15T08:07:56.786Z"},"homepage":"http://alinex.github.io/node-dbreport/","keywords":["database","query","report","table"],"repository":{"type":"git","url":"git+https://github.com/alinex/node-dbreport.git"},"contributors":[],"author":{"name":"Alexander Schilling","email":"info@alinex.de","url":"http://alinex.de"},"bugs":{"url":"https://github.com/alinex/node-dbreport/issues"},"license":"Apache-2.0","readmeFilename":"README.md"}