summaryrefslogtreecommitdiffstats
path: root/tests/clickhouse-bulk.sh
diff options
context:
space:
mode:
Diffstat (limited to '')
-rwxr-xr-xtests/clickhouse-bulk.sh39
1 files changed, 39 insertions, 0 deletions
diff --git a/tests/clickhouse-bulk.sh b/tests/clickhouse-bulk.sh
new file mode 100755
index 0000000..297df36
--- /dev/null
+++ b/tests/clickhouse-bulk.sh
@@ -0,0 +1,39 @@
+#!/bin/bash
+# add 2018-12-07 by Pascal Withopf, released under ASL 2.0
+. ${srcdir:=.}/diag.sh init
+export NUMMESSAGES=10
+generate_conf
+add_conf '
+module(load="../plugins/omclickhouse/.libs/omclickhouse")
+
+template(name="outfmt" option.stdsql="on" type="string" string="INSERT INTO rsyslog.bulk (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"
+ user="default" pwd="" template="outfmt")
+'
+
+clickhouse-client --query="CREATE TABLE IF NOT EXISTS rsyslog.bulk ( 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.bulk ORDER BY id" > $RSYSLOG_OUT_LOG
+
+export EXPECTED='0 7 20 127.0.0.1 tag msgnum:00000000:
+1 7 20 127.0.0.1 tag msgnum:00000001:
+2 7 20 127.0.0.1 tag msgnum:00000002:
+3 7 20 127.0.0.1 tag msgnum:00000003:
+4 7 20 127.0.0.1 tag msgnum:00000004:
+5 7 20 127.0.0.1 tag msgnum:00000005:
+6 7 20 127.0.0.1 tag msgnum:00000006:
+7 7 20 127.0.0.1 tag msgnum:00000007:
+8 7 20 127.0.0.1 tag msgnum:00000008:
+9 7 20 127.0.0.1 tag msgnum:00000009:'
+cmp_exact $RSYSLOG_OUT_LOG
+
+clickhouse-client --query="DROP TABLE rsyslog.bulk"
+exit_test