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/pgsql-template.sh | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100755 tests/pgsql-template.sh (limited to 'tests/pgsql-template.sh') diff --git a/tests/pgsql-template.sh b/tests/pgsql-template.sh new file mode 100755 index 0000000..13e345c --- /dev/null +++ b/tests/pgsql-template.sh @@ -0,0 +1,32 @@ +#!/bin/bash +# This file is part of the rsyslog project, released under GPLv3 + +. ${srcdir:=.}/diag.sh init + +psql -h localhost -U postgres -f testsuites/pgsql-basic.sql + +generate_conf +add_conf ' +# putting the message in the SyslogTag field, so we know the template is actually used +$template mytemplate,"insert into SystemEvents (SysLogTag) values ' +add_conf "('%msg%')" +add_conf '",STDSQL + +$ModLoad ../plugins/ompgsql/.libs/ompgsql +:msg, contains, "msgnum:" :ompgsql:127.0.0.1,syslogtest,postgres,testbench;mytemplate +' +startup +injectmsg 0 5000 +shutdown_when_empty +wait_shutdown + +# we actually put the message in the SysLogTag field, so we know it doesn't use the default +# template, like in pgsql-basic +psql -h localhost -U postgres -d syslogtest -f testsuites/pgsql-select-syslogtag.sql -t -A > $RSYSLOG_OUT_LOG + +seq_check 0 4999 + +echo cleaning up test database +psql -h localhost -U postgres -c 'DROP DATABASE IF EXISTS syslogtest;' + +exit_test -- cgit v1.2.3