SQL2Slack
a cron deamon that executes the specified sql query and forward its result to slack ()
Features
- Tiny & Portable.
- Works with multiple sql engine.
- Customize the slack message using javascript as well underscore.js .
- Cron like syntax for scheduling sql jobs.
- Uses hcl language for structured configurations.
- Ability to define a job per single file for future maintainability of large jobs.
Quick Overview
job tst {
// slack-channel webhook url
channel = "https://hooks.slack.com/services/xxxxxxxxxxxxxxxxxxxxx"
// which sql driver do you use?
driver = "mysql"
// data source name (connection string)
dsn = "root:root@tcp(127.0.0.1:3306)/dbname"
// the query this is a multiline example, you can just write the following
// query = "select * from users"
query = <<SQL
SELECT users.* FROM users;
SQL
// cron like syntax
schedule = "* * * * *"
// here you need to build the text message that will be sent
// to the slack channel.
// -------
// say(....): a function that will append the specified arguments into the main slack text message.
// log(....): a logger function, for debugging purposes.
// $rows: a variable that holds the output of the query execution.
message = <<JS
if ( $rows.length < 1 ) {
return
}
say("there are (", $rows.length, ") new users!")
say("users list is:")
_.chain($rows).pluck('name').each(function(name){
say("- ", name, " .")
})
JS
}
Integrating Slack
- Go there .
-
Click on
Create New App. -
Choose
Incoming Webhooksand activate it. -
Scroll down to
Add New Webhook to Workspaceand follow the instructions. - Scroll down to the webhooks table, and copy the generated webhook url.
Available SQL Drivers
| Driver | DSN |
|---|---|
mysql
|
usrname:password@tcp(server:port)/dbname?option1=value1&...
|
postgres
|
postgresql://username:password@server:port/dbname?option1=value1
|
sqlserver
|
sqlserver://username:password@host/instance?param1=value¶m2=value
|
sqlserver://username:password@host:port?param1=value¶m2=value
|
|
sqlserver://sa@localhost/SQLExpress?database=master&connection+timeout=30
|
|
mssql
|
server=localhost\\SQLExpress;user id=sa;database=master;app name=MyAppName
|
server=localhost;user id=sa;database=master;app name=MyAppName
|
|
odbc:server=localhost\\SQLExpress;user id=sa;database=master;app name=MyAppName
|
|
odbc:server=localhost;user id=sa;database=master;app name=MyAppName
|
|
clickhouse
|
tcp://host1:9000?username=user&password=qwerty&database=clicks&read_timeout=10&write_timeout=20&alt_hosts=host2:9000,host3:9000
|
Installation
Notes
-
by default
sql2slackuses the current working directory as jobs files source, you can override that using--jobs-dirflag. -
each job file must
have the
.s2s.hclsuffix.
以上所述就是小编给大家介绍的《sql2slack - send sql results periodically to slack》,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对 码农网 的支持!
猜你喜欢:本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们。
Java RESTful Web Service实战
韩陆 / 机械工业出版社 / 2014-10-1 / 69.00
国内首本完整、深度地讲解如何基于Java标准规范实现REST风格的Web服务的专著,阿里巴巴Java技术专家12年开发经验结晶,3位业内著名技术专家联袂推荐!不仅深刻解读了最新的JAX-RS标准和其API设计,以及Jersey的使用要点和实现原理,而且系统讲解了REST的基本理论,更重要的是从实践角度深度讲解了如何基于Jersey实现完整的、安全的、高性能的REST式的Web服务。 《Jav......一起来看看 《Java RESTful Web Service实战》 这本书的介绍吧!