From dcc721a95bef6f0d8e6d8775b8efe33e5aecd562 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Mon, 15 Apr 2024 18:28:20 +0200 Subject: Adding upstream version 8.2402.0. Signed-off-by: Daniel Baumann --- tests/clickhouse-load.sh | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100755 tests/clickhouse-load.sh (limited to 'tests/clickhouse-load.sh') diff --git a/tests/clickhouse-load.sh b/tests/clickhouse-load.sh new file mode 100755 index 0000000..40e00b9 --- /dev/null +++ b/tests/clickhouse-load.sh @@ -0,0 +1,31 @@ +#!/bin/bash +# add 2018-12-07 by Pascal Withopf, released under ASL 2.0 +. ${srcdir:=.}/diag.sh init +export NUMMESSAGES=1000 + +generate_conf +add_conf ' +module(load="../plugins/omclickhouse/.libs/omclickhouse") + +template(name="outfmt" option.stdsql="on" type="string" string="INSERT INTO rsyslog.load (id, ipaddress, message) VALUES (%msg:F,58:2%, ' +add_conf "'%fromhost-ip%', '%msg:F,58:2%')" +add_conf '") + + +:syslogtag, contains, "tag" action(type="omclickhouse" server="localhost" usehttps="off" + user="default" pwd="" template="outfmt" + bulkmode="off") +' + +clickhouse-client --query="CREATE TABLE IF NOT EXISTS rsyslog.load ( id Int32, ipaddress String, message String ) ENGINE = MergeTree() PARTITION BY ipaddress Order By id" + +startup +injectmsg +shutdown_when_empty +wait_shutdown +clickhouse-client --query="SELECT message FROM rsyslog.load ORDER BY id" > $RSYSLOG_OUT_LOG + +clickhouse-client --query="DROP TABLE rsyslog.load" +seq_check 0 $(( NUMMESSAGES - 1 )) + +exit_test -- cgit v1.2.3