summaryrefslogtreecommitdiffstats
path: root/tests/pgsql-template-threads-cnf6.sh
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-15 16:28:20 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-15 16:28:20 +0000
commitdcc721a95bef6f0d8e6d8775b8efe33e5aecd562 (patch)
tree66a2774cd0ee294d019efd71d2544c70f42b2842 /tests/pgsql-template-threads-cnf6.sh
parentInitial commit. (diff)
downloadrsyslog-dcc721a95bef6f0d8e6d8775b8efe33e5aecd562.tar.xz
rsyslog-dcc721a95bef6f0d8e6d8775b8efe33e5aecd562.zip
Adding upstream version 8.2402.0.upstream/8.2402.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/pgsql-template-threads-cnf6.sh')
-rwxr-xr-xtests/pgsql-template-threads-cnf6.sh36
1 files changed, 36 insertions, 0 deletions
diff --git a/tests/pgsql-template-threads-cnf6.sh b/tests/pgsql-template-threads-cnf6.sh
new file mode 100755
index 0000000..99ece41
--- /dev/null
+++ b/tests/pgsql-template-threads-cnf6.sh
@@ -0,0 +1,36 @@
+#!/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 '
+template(name="pgtemplate" type="list" option.sql="on") {
+ constant(value="INSERT INTO SystemEvents (SysLogTag) values ('"'"'")
+ property(name="msg")
+ constant(value="'"'"')")
+}
+
+module(load="../plugins/ompgsql/.libs/ompgsql")
+if $msg contains "msgnum" then {
+ action(type="ompgsql" server="127.0.0.1"
+ db="syslogtest" user="postgres" pass="testbench"
+ template="pgtemplate" queue.workerthreads="4")
+}'
+
+startup
+injectmsg 0 5000
+shutdown_when_empty
+wait_shutdown
+
+
+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