diff options
Diffstat (limited to 'tests/clickhouse-basic.sh')
| -rwxr-xr-x | tests/clickhouse-basic.sh | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/tests/clickhouse-basic.sh b/tests/clickhouse-basic.sh new file mode 100755 index 0000000..0c3306d --- /dev/null +++ b/tests/clickhouse-basic.sh @@ -0,0 +1,30 @@ +#!/bin/bash +# add 2018-12-07 by Pascal Withopf, released under ASL 2.0 +. ${srcdir:=.}/diag.sh init +export NUMMESSAGES=1 +generate_conf +add_conf ' +module(load="../plugins/omclickhouse/.libs/omclickhouse") + +template(name="outfmt" option.stdsql="on" type="string" string="INSERT INTO rsyslog.basic (id, severity, facility, timestamp, ipaddress, tag, message) VALUES (%msg:F,58:2%, %syslogseverity%, %syslogfacility%, ' +add_conf "'%timereported:::date-unixtimestamp%', '%fromhost-ip%', '%syslogtag%', '%msg%')" +add_conf '") + + +:syslogtag, contains, "tag" action(type="omclickhouse" server="localhost" port="8443" bulkmode="off" + user="default" pwd="" template="outfmt") +' + +clickhouse-client --query="CREATE TABLE IF NOT EXISTS rsyslog.basic ( id Int32, severity Int8, facility Int8, timestamp DateTime, ipaddress String, tag String, message String ) ENGINE = MergeTree() PARTITION BY severity Order By id" + +startup +injectmsg +shutdown_when_empty +wait_shutdown +clickhouse-client --query="SELECT id, severity, facility, ipaddress, tag, message FROM rsyslog.basic" > $RSYSLOG_OUT_LOG + +clickhouse-client --query="DROP TABLE rsyslog.basic" +export EXPECTED='0 7 20 127.0.0.1 tag msgnum:00000000:' +cmp_exact $RSYSLOG_OUT_LOG + +exit_test |