summaryrefslogtreecommitdiffstats
path: root/test/test_sql_regexp.sh
diff options
context:
space:
mode:
Diffstat (limited to 'test/test_sql_regexp.sh')
-rw-r--r--test/test_sql_regexp.sh30
1 files changed, 30 insertions, 0 deletions
diff --git a/test/test_sql_regexp.sh b/test/test_sql_regexp.sh
new file mode 100644
index 0000000..d2fc5f8
--- /dev/null
+++ b/test/test_sql_regexp.sh
@@ -0,0 +1,30 @@
+#! /bin/bash
+
+export YES_COLOR=1
+
+run_cap_test ${lnav_test} -n \
+ -c ";SELECT * FROM syslog_log, regexp_capture_into_json(log_body, '"'"'"(?<value>[^"'"'"]+)')" \
+ -c ":write-csv-to -" \
+ ${test_dir}/logfile_syslog.3
+
+run_cap_test ${lnav_test} -n \
+ -c ";SELECT * from regexp_capture_into_json('foo=0x123e;', '(?<key>\w+)=(?<value>[^;]+)')" \
+ ${test_dir}/logfile_syslog.3
+
+run_cap_test ${lnav_test} -n \
+ -c ";SELECT * from regexp_capture_into_json('foo=0x123e;', '(?<key>\w+)=(?<value>[^;]+)', json_object('convert-numbers', json('false')))" \
+ ${test_dir}/logfile_syslog.3
+
+run_cap_test ${lnav_test} -n \
+ -c ";SELECT * from regexp_capture_into_json('foo=0x123e;', '(?<key>\w+)=(?<value>[^;]+)', '{abc')" \
+ ${test_dir}/logfile_syslog.3
+
+run_cap_test ${lnav_test} -n \
+ -c ";SELECT * from regexp_capture_into_json('foo=123e;', '(?<key>\w+)=(?<value>[^;]+)')" \
+ ${test_dir}/logfile_syslog.3
+
+run_cap_test ${lnav_test} -nN \
+ -c ";SELECT * from regexp_capture('abc=def;ghi=jkl;', '^(\w+)=([^;]+);')"
+
+run_cap_test ${lnav_test} -nN \
+ -c ";SELECT * from regexp_capture_into_json('abc=def;ghi=jkl;', '^(\w+)=([^;]+);')"