Blame: test/test_sql.sh - tstack/lnav

tstack / lnav UNCLAIMED

Log file navigator

0 0 10 C++

[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`#! /bin/bash`

[date_time] missed some TZ stuff 2023-08-11 10:06:28 -07:00			`export TZ=UTC`
[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`export YES_COLOR=1`

[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`lnav_test="${top_builddir}/src/lnav-test"`
[tests] try to fix sql test 2021-08-29 22:00:21 -07:00			`unset XDG_CONFIG_HOME`
[sqlite] implement .dump SQL command 2021-03-28 13:50:26 -07:00
[docs] fill out search-table docs 2022-07-13 22:24:49 -07:00			`run_cap_test ${lnav_test} -nN \`
			`-c ";SELECT 1 = ?"`

[tests] set timestamp on file 2024-11-10 09:41:43 -08:00			`# XXX The timestamp on the file is used to determine the year for syslog files.`
			`touch -t 200711030923 ${test_dir}/logfile_syslog.0`
[sql] fixes for .dump command 2024-11-09 21:57:26 -08:00			`run_cap_test ${lnav_test} -n \`
			`-c ";.dump syslog_log.sql syslog_log" \`
			`${test_dir}/logfile_syslog.0`

			`run_cap_test cat syslog_log.sql`

[db] move lnav tables to a separate DB Related to #1525 2025-10-09 06:27:34 -07:00			`run_cap_test ${lnav_test} -n \`
			`-c ";CREATE TABLE syslog_copy AS SELECT * FROM syslog_log" \`
			`-c ";.save syslog_copy.db" \`
			`${test_dir}/logfile_syslog.0`

			`run_cap_test sqlite3 syslog_copy.db "SELECT * FROM syslog_copy"`

			`run_cap_test ${lnav_test} -n \`
			`-c ";CREATE TABLE syslog_copy AS SELECT * FROM syslog_log" \`
			`-c ";.save /bad/bad/bad" \`
			`${test_dir}/logfile_syslog.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sqlite] implement .dump SQL command 2021-03-28 13:50:26 -07:00			`-c ";.read nonexistent-file" \`
			`${test_dir}/logfile_empty.0`

			`run_test ${lnav_test} -n \`
			`-c ";.read ${test_dir}/file_for_dot_read.sql" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_syslog.0`

			`check_output ".read did not work?" <<EOF`
			`log_line,log_body`
			`1, attempting to mount entry /auto/opt`
			`EOF`


[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[docs] add report generation to cookbook 2021-02-25 15:47:36 -08:00			`-c ";SELECT replicate('foobar', 120)" \`
			`${test_dir}/logfile_empty.0`

[log_format] change w3c_log to put extra columns into a JSON column 2020-12-18 22:35:23 -08:00			`cp ${srcdir}/logfile_syslog.2 logfile_syslog_test.2`
			`touch -t 201511030923 logfile_syslog_test.2`
[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[log_format] change w3c_log to put extra columns into a JSON column 2020-12-18 22:35:23 -08:00			`-c ";SELECT *, log_msg_schema FROM all_logs" \`
			`-c ":write-csv-to -" \`
			`logfile_syslog_test.2`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[formats] add logfmt 2021-10-02 23:17:33 -07:00			`-c ";SELECT fields FROM logfmt_log" \`
			`-c ":write-json-to -" \`
			`${test_dir}/logfile_logfmt.0`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[log_format] change w3c_log to put extra columns into a JSON column 2020-12-18 22:35:23 -08:00			`-c ";SELECT sc_substatus FROM w3c_log" \`
			`-c ":write-json-to -" \`
[formats] add w3c extended log format impl Fiexes #798 2020-12-05 21:51:46 -08:00			`${test_dir}/logfile_w3c.3`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[log_format] change w3c_log to put extra columns into a JSON column 2020-12-18 22:35:23 -08:00			`-c ";SELECT cs_headers FROM w3c_log" \`
			`-c ":write-json-to -" \`
			`${test_dir}/logfile_w3c.3`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sqlite] include generate_series() extension 2021-03-23 22:23:08 -07:00			`-c ";SELECT * FROM generate_series()" \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sqlite] include generate_series() extension 2021-03-23 22:23:08 -07:00			`-c ";SELECT * FROM generate_series(1)" \`
			`${test_dir}/logfile_access_log.0`

[session] add time_offset of files to session exports 2022-07-21 15:44:30 -07:00			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT 1 AS inum, NULL AS nul, 2.0 AS fnum, 'abc' AS str" \`
			`-c ";SELECT \$inum, \$nul, \$fnum, \$str, raise_error('oops!')" \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] add more TUI tests 2021-02-04 23:10:44 -08:00			`-c ";SELECT raise_error('oops!')" \`
			`${test_dir}/logfile_access_log.0`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[test] try to fix test 2021-03-07 14:59:22 -08:00			`-c ";SELECT basename(filepath) as name, content, length(content) FROM lnav_file" \`
[sql] add lnav_top_file() SQL function 2021-03-05 16:17:28 -08:00			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_empty.0`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[sql] add lnav_top_file() SQL function 2021-03-05 16:17:28 -08:00			`-c ";SELECT distinct xp.node_text FROM lnav_file, xpath('//author', content) as xp" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/books.xml`

			`gzip -c ${srcdir}/logfile_json.json > logfile_json.json.gz`
			`dd if=logfile_json.json.gz of=logfile_json-trunc.json.gz bs=64 count=2`

[filters] fix previews when created in the editor 2021-03-18 15:59:39 -07:00			`# TODO re-enable this`
			`#run_test ${lnav_test} -n \`
			`# -c ";SELECT content FROM lnav_file" \`
			`# logfile_json-trunc.json.gz`

			`#check_error_output "invalid gzip file working?" <<EOF`
			`#command-option:1: error: unable to uncompress: logfile_json-trunc.json.gz -- buffer error`
			`#EOF`
[sql] add lnav_top_file() SQL function 2021-03-05 16:17:28 -08:00
			`run_test ${lnav_test} -n \`
			`-c ";SELECT jget(rc.content, '/ts') AS ts FROM lnav_file, regexp_capture(lnav_file.content, '.*\n') as rc" \`
			`-c ":write-csv-to -" \`
			`logfile_json.json.gz`

			`check_output "jget on file content not working?" <<EOF`
			`ts`
			`2013-09-06T20:00:48.124817Z`
			`2013-09-06T20:00:49.124817Z`
			`2013-09-06T22:00:49.124817Z`
			`2013-09-06T22:00:59.124817Z`
			`2013-09-06T22:00:59.124817Z`
[log_format] display an error if there is a JSON timestamp property, but it does not parse correctly 2026-01-21 09:28:00 -08:00			`xxx`
[sql] add lnav_top_file() SQL function 2021-03-05 16:17:28 -08:00			`2013-09-06T22:00:59.124817Z`
			`2013-09-06T22:00:59.124817Z`
[log_format] detect time format change in JSON logs Related to #1215 2024-01-03 09:59:23 -08:00			`2013-09-06 22:01:00Z`
[sql] add lnav_top_file() SQL function 2021-03-05 16:17:28 -08:00			`2013-09-06T22:01:49.124817Z`
			`2013-09-06T22:01:49.124817Z`
			`2013-09-06T22:01:49.124817Z`
			`2013-09-06T22:01:49.124817Z`
			`2013-09-06T22:01:49.124817Z`
			`EOF`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[session] allow the name 2020-04-25 07:32:05 -07:00			`-c ";UPDATE lnav_file SET filepath='foo' WHERE endswith(filepath, '_log.0')" \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[session] allow the name 2020-04-25 07:32:05 -07:00			`-c "\|rename-stdin" \`
[tests] try to fix breakage 2020-04-25 13:30:28 -07:00			`${test_dir}/logfile_access_log.0 < /dev/null`
[session] allow the name 2020-04-25 07:32:05 -07:00
[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[session] allow the name 2020-04-25 07:32:05 -07:00			`-c "\|rename-stdin foo" \`
[build] try again 2020-04-25 17:22:59 -07:00			`${test_dir}/logfile_access_log.0 < /dev/null`
[session] allow the name 2020-04-25 07:32:05 -07:00
[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[session] allow the name 2020-04-25 07:32:05 -07:00			`-c "\|rename-stdin foo" \`
[remote] add some tailer tests 2021-05-25 22:27:09 -07:00			`-c ";SELECT filepath FROM lnav_file" <<EOF`
			`Hello, World!`
			`EOF`
[session] allow the name 2020-04-25 07:32:05 -07:00
[time-offset] fixes Defect Number: Reviewed By: Testing Done: 2019-03-12 07:03:32 -07:00			`run_test ${lnav_test} -n \`
[tests] fix a test 2019-03-15 22:38:10 -07:00			`-c ";SELECT basename(filepath),format,lines,time_offset FROM lnav_file LIMIT 2" \`
[time-offset] fixes Defect Number: Reviewed By: Testing Done: 2019-03-12 07:03:32 -07:00			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_access_log.0 \`
			`${test_dir}/logfile_access_log.1`

			`check_output "lnav_file table is not working?" <<EOF`
[sql] change base_time to time_offset 2019-03-12 22:41:39 -07:00			`basename(filepath),format,lines,time_offset`
[time-offset] fixes Defect Number: Reviewed By: Testing Done: 2019-03-12 07:03:32 -07:00			`logfile_access_log.0,access_log,3,0`
			`logfile_access_log.1,access_log,1,0`
			`EOF`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sql] change base_time to time_offset 2019-03-12 22:41:39 -07:00			`-c ";UPDATE lnav_file SET time_offset = 60 * 1000" \`
[time-offset] fixes Defect Number: Reviewed By: Testing Done: 2019-03-12 07:03:32 -07:00			`${test_dir}/logfile_access_log.0 \`
			`${test_dir}/logfile_access_log.1`

[format] add a postgres log format 2025-08-13 10:44:21 -07:00			`run_cap_test ${lnav_test} -n \`
[remote] add some config options and remove the copied tailer binary Also fix time offset issue 2021-05-19 22:05:21 -07:00			`-c ";UPDATE lnav_file SET time_offset=14400000 WHERE endswith(filepath, 'logfile_block.1')" \`
			`${test_dir}/logfile_block.1 \`
			`${test_dir}/logfile_block.2`

[sql] do not dump the log on an empty SQL result Related to #466 2024-06-13 15:37:28 -07:00			`run_cap_test ${lnav_test} -n \`
[build] fix a typo in test_sql.sh 2018-10-17 07:54:59 -07:00			`-c ";SELECT * FROM access_log LIMIT 0" \`
[headless] always switch to the DB view after executing a SQL command, even if the result set is empty 2017-08-18 21:46:38 -07:00			`${test_dir}/logfile_access_log.0`

[sql] do not dump the log on an empty SQL result Related to #466 2024-06-13 15:37:28 -07:00			`run_cap_test ${lnav_test} -n \`
			`-c "\|${test_dir}/empty-result.lnav" \`
			`${test_dir}/logfile_access_log.0`
[headless] always switch to the DB view after executing a SQL command, even if the result set is empty 2017-08-18 21:46:38 -07:00
[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[test] test SQL state funcs 2021-02-01 22:51:02 -08:00			`-c ":goto 2" \`
[sql] add log_msg_line() function Related to #1219 2024-01-05 08:49:27 -08:00			`-c ";SELECT log_top_line(), log_msg_line()" \`
[test] test SQL state funcs 2021-02-01 22:51:02 -08:00			`${test_dir}/logfile_uwsgi.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] add more TUI tests 2021-02-04 23:10:44 -08:00			`-c ":goto 2" \`
[sql] add log_msg_line() function Related to #1219 2024-01-05 08:49:27 -08:00			`-c ";SELECT log_top_line(), log_msg_line()" \`
[tests] add more TUI tests 2021-02-04 23:10:44 -08:00			`${test_dir}/logfile_empty.0`

[sql] add log_msg_line() function Related to #1219 2024-01-05 08:49:27 -08:00			`run_cap_test ${lnav_test} -n \`
			`-c ":goto 1" \`
			`-c ";SELECT log_top_line(), log_msg_line()" \`
			`${test_dir}/logfile_multiline.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[test] test SQL state funcs 2021-02-01 22:51:02 -08:00			`-c ":goto 2" \`
			`-c ";SELECT log_top_datetime()" \`
			`${test_dir}/logfile_uwsgi.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] add more TUI tests 2021-02-04 23:10:44 -08:00			`-c ":goto 2" \`
			`-c ";SELECT log_top_datetime()" \`
			`${test_dir}/logfile_empty.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[loader] fix format loader and add $schema refs to formats 2020-09-24 13:12:43 -07:00			`-c ";SELECT * FROM uwsgi_log LIMIT 1" \`
			`-c ':switch-to-view db' \`
			`${test_dir}/logfile_uwsgi.0`

[log_format] change w3c_log to put extra columns into a JSON column 2020-12-18 22:35:23 -08:00			`run_test ${lnav_test} -n \`
			`-c ";SELECT s_runtime FROM uwsgi_log LIMIT 5" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_uwsgi.0`

			`check_output "uwsgi scaling not working?" <<EOF`
			`s_runtime`
			`0.129`
			`0.035`
			`6.8e-05`
			`0.016`
			`0.01`
[loader] fix format loader and add $schema refs to formats 2020-09-24 13:12:43 -07:00			`EOF`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test env TZ=UTC ${lnav_test} -n \`
[formats] support for CSV/TSV log formats Defect Number: Reviewed By: Testing Done: 2017-04-23 07:11:21 -07:00			`-c ";SELECT bro_conn_log.bro_duration as duration, bro_conn_log.bro_uid, group_concat( distinct (bro_method \|\| ' ' \|\| bro_host)) as req from bro_http_log, bro_conn_log where bro_http_log.bro_uid = bro_conn_log.bro_uid group by bro_http_log.bro_uid order by duration desc limit 10" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_bro_http.log.0 ${test_dir}/logfile_bro_conn.log.0`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test env TZ=UTC ${lnav_test} -n \`
[formats] support for CSV/TSV log formats Defect Number: Reviewed By: Testing Done: 2017-04-23 07:11:21 -07:00			`-c ";SELECT * FROM bro_http_log LIMIT 5" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_bro_http.log.0`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test env TZ=UTC ${lnav_test} -n \`
[formats] support for CSV/TSV log formats Defect Number: Reviewed By: Testing Done: 2017-04-23 07:11:21 -07:00			`-c ";SELECT * FROM bro_http_log WHERE log_level = 'error'" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_bro_http.log.0`
more issues related-to/uncovered-by time cutoffs 2025-11-12 11:02:03 -08:00
			`run_cap_test env TZ=UTC ${lnav_test} -n \`
			`-c ":close" \`
			`-c ";SELECT * FROM bro_http_log WHERE log_level = 'error'" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_bro_http.log.0`
[formats] support for CSV/TSV log formats Defect Number: Reviewed By: Testing Done: 2017-04-23 07:11:21 -07:00
[spectro] add some better error messages for the spectrogram command and fix some vtable glitches 2016-04-08 06:21:58 -07:00			`run_test ${lnav_test} -n \`
			`-c ';select log_time from access_log where log_line > 100000' \`
			`-c ':switch-to-view db' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "out-of-range query failed?" <<EOF`
			`EOF`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[spectro] add some better error messages for the spectrogram command and fix some vtable glitches 2016-04-08 06:21:58 -07:00			`-c ';select log_time from access_log where log_line > -100000' \`
			`${test_dir}/logfile_access_log.0`

			`run_test ${lnav_test} -n \`
			`-c ';select log_time from access_log where log_line < -10000' \`
			`-c ':switch-to-view db' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "out-of-range query failed?" <<EOF`
			`EOF`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[spectro] add some better error messages for the spectrogram command and fix some vtable glitches 2016-04-08 06:21:58 -07:00			`-c ';select log_time from access_log where log_line > -10000' \`
			`${test_dir}/logfile_access_log.0`

			`run_test ${lnav_test} -n \`
			`-c ';select log_time from access_log where log_line < 0' \`
			`-c ':switch-to-view db' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "out-of-range query failed?" <<EOF`
			`EOF`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[spectro] add some better error messages for the spectrogram command and fix some vtable glitches 2016-04-08 06:21:58 -07:00			`-c ';select log_time from access_log where log_line <= 0' \`
			`-c ':switch-to-view db' \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[spectro] add some better error messages for the spectrogram command and fix some vtable glitches 2016-04-08 06:21:58 -07:00			`-c ';select log_time from access_log where log_line >= 0' \`
			`-c ':switch-to-view db' \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[spectro] add some better error messages for the spectrogram command and fix some vtable glitches 2016-04-08 06:21:58 -07:00			`-c ';select sc_bytes from access_log' \`
			`-c ':spectrogram sc_bytes' \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[spectro] add some better error messages for the spectrogram command and fix some vtable glitches 2016-04-08 06:21:58 -07:00			`-c ';select log_time,sc_bytes from access_log' \`
			`-c ':spectrogram sc_byes' \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[spectro] add some better error messages for the spectrogram command and fix some vtable glitches 2016-04-08 06:21:58 -07:00			`-c ';select log_time,c_ip from access_log' \`
			`-c ':spectrogram c_ip' \`
			`${test_dir}/logfile_access_log.0`

[tests] try to fix a couple issues 2024-04-04 22:19:40 -07:00			`run_cap_test env TZ=UTC LC_ALL=C ${lnav_test} -n \`
[spectro] fix key colors 2022-06-28 23:15:50 -07:00			`-c ':spectrogram bro_response_body_len' \`
			`${test_dir}/logfile_bro_http.log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[spectro] log_time must be in ascending order 2016-05-02 22:59:04 -07:00			`-c ';select log_time,sc_bytes from access_log order by log_time desc' \`
			`-c ':spectrogram sc_bytes' \`
			`${test_dir}/logfile_access_log.0`

[build] fix issues with test files 2020-09-03 22:13:21 -07:00			`cp ${srcdir}/logfile_syslog_with_mixed_times.0 logfile_syslog_with_mixed_times_test.0`
			`touch -t 201511030923 logfile_syslog_with_mixed_times_test.0`
[ui] highlight out-of-time-order messages in yellow with an underline 2016-03-03 06:05:26 -08:00			`run_test ${lnav_test} -n \`
			`-c ";select log_time,log_actual_time from syslog_log" \`
			`-c ':write-csv-to -' \`
[build] fix issues with test files 2020-09-03 22:13:21 -07:00			`logfile_syslog_with_mixed_times_test.0`
[ui] highlight out-of-time-order messages in yellow with an underline 2016-03-03 06:05:26 -08:00
			`check_output "log_actual_time column not working" <<EOF`
			`log_time,log_actual_time`
[time_util] use std::chrono::microseconds instead of timeval 2025-10-28 11:41:51 -07:00			`2015-09-13 00:58:45.000000,2015-09-13 00:58:45.000000`
			`2015-09-13 00:59:30.000000,2015-09-13 00:59:30.000000`
			`2015-09-13 01:23:54.000000,2015-09-13 01:23:54.000000`
			`2015-09-13 03:12:04.000000,2015-09-13 03:12:04.000000`
			`2015-09-13 03:12:04.000000,2015-09-13 03:12:04.000000`
			`2015-09-13 03:12:04.000000,2015-09-13 01:25:39.000000`
			`2015-09-13 03:12:04.000000,2015-09-13 03:12:04.000000`
			`2015-09-13 03:12:58.000000,2015-09-13 03:12:58.000000`
			`2015-09-13 03:46:03.000000,2015-09-13 03:46:03.000000`
			`2015-09-13 03:46:03.000000,2015-09-13 03:46:03.000000`
			`2015-09-13 03:46:03.000000,2015-09-13 03:46:03.000000`
			`2015-09-13 03:46:03.000000,2015-09-13 03:13:16.000000`
			`2015-09-13 03:46:03.000000,2015-09-13 03:46:03.000000`
[ui] highlight out-of-time-order messages in yellow with an underline 2016-03-03 06:05:26 -08:00			`EOF`


[sql] allow log_part to be updated 2015-12-22 05:27:36 -08:00			`run_test ${lnav_test} -n \`
			`-c ";update access_log set log_part = 'middle' where log_line = 1" \`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`-c ';select log_line, log_part from access_log' \`
[sql] allow log_part to be updated 2015-12-22 05:27:36 -08:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "setting log_part is not working" <<EOF`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`log_line,log_part`
			`0,<NULL>`
			`1,middle`
			`2,middle`
[sql] allow log_part to be updated 2015-12-22 05:27:36 -08:00			`EOF`

			`run_test ${lnav_test} -n \`
			`-c ";update access_log set log_part = 'middle' where log_line = 1" \`
			`-c ";update access_log set log_part = NULL where log_line = 1" \`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`-c ';select log_line, log_part from access_log' \`
[sql] allow log_part to be updated 2015-12-22 05:27:36 -08:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "setting log_part is not working" <<EOF`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`log_line,log_part`
			`0,<NULL>`
			`1,<NULL>`
			`2,<NULL>`
[sql] allow log_part to be updated 2015-12-22 05:27:36 -08:00			`EOF`

			`run_test ${lnav_test} -n \`
			`-c ";update access_log set log_part = 'middle' where log_line = 1" \`
			`-c ";update access_log set log_part = NULL where log_line = 2" \`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`-c ';select log_line, log_part from access_log' \`
[sql] allow log_part to be updated 2015-12-22 05:27:36 -08:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "setting log_part is not working" <<EOF`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`log_line,log_part`
			`0,<NULL>`
			`1,middle`
			`2,middle`
[sql] allow log_part to be updated 2015-12-22 05:27:36 -08:00			`EOF`


[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[sql] exec .sql files in format dirs 2015-11-26 22:19:53 -08:00			`-I "${top_srcdir}/test" \`
			`-c ";select * from web_status" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`-c ";select * from access_log" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`-c ";select * from access_log where log_level >= 'warning'" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`-c ";select * from syslog_log" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_syslog.0`

[sql] missed a null check on log_time in vt_filter Fixes #518 2018-05-22 06:45:54 -07:00			`run_test ${lnav_test} -n \`
			`-c ";select * from syslog_log where log_time >= NULL" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_syslog.0`

			`check_output "log_time collation failed on null" <<EOF`
[sql] do not dump the log on an empty SQL result Related to #466 2024-06-13 15:37:28 -07:00			`log_line,log_time,log_level,log_hostname,log_msgid,log_pid,log_pri,log_procname,log_struct,log_syslog_tag,syslog_version,log_part,log_idle_msecs,log_mark,log_comment,log_tags,log_annotations,log_filters`
[sql] missed a null check on log_time in vt_filter Fixes #518 2018-05-22 06:45:54 -07:00			`EOF`


[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`run_test ${lnav_test} -n \`
[views] add a breadcrumb view 2022-05-10 21:58:32 -07:00			`-c ";select log_line from syslog_log where log_time >= datetime('2007-11-03T09:47:02.000')" \`
[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_syslog.0`

			`check_output "log_time collation is wrong" <<EOF`
[views] add a breadcrumb view 2022-05-10 21:58:32 -07:00			`log_line`
			`3`
[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`EOF`


[perf] fixing slow queries 2022-07-01 16:02:14 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`-c ':filter-in sudo' \`
			`-c ";select * from logline" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_syslog.0`

[cmd] do not error out if filter exists, just enable it Defect Number: Reviewed By: Testing Done: 2014-11-05 21:29:31 -08:00			`run_test ${lnav_test} -n \`
			`-c ':goto 1' \`
[build] try some more things to fix travis test failures 2018-08-22 05:55:58 -07:00			`-c ";select log_line, log_pid, col_0 from logline" \`
[cmd] do not error out if filter exists, just enable it Defect Number: Reviewed By: Testing Done: 2014-11-05 21:29:31 -08:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_syslog.1`

			`check_output "logline table is not working" <<EOF`
[build] try some more things to fix travis test failures 2018-08-22 05:55:58 -07:00			`log_line,log_pid,col_0`
			`1,16442,/auto/opt`
[cmd] do not error out if filter exists, just enable it Defect Number: Reviewed By: Testing Done: 2014-11-05 21:29:31 -08:00			`EOF`

[sql] do some minimal parsing/annotation of SQL statements Defect Number: Reviewed By: Testing Done: 2017-03-26 06:02:53 -07:00			`run_test ${lnav_test} -n \`
			`-c ";select sc_bytes from logline" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "logline table is not working for defined columns" <<EOF`
			`sc_bytes`
			`134`
			`46210`
			`78929`
			`EOF`

[cmd] do not error out if filter exists, just enable it Defect Number: Reviewed By: Testing Done: 2014-11-05 21:29:31 -08:00
[db] missed checking for a null progress callback Fixes #404 2017-01-18 06:17:55 -08:00			`run_test ${lnav_test} -n \`
			`-c ':goto 1' \`
			`-c ":summarize col_0" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_syslog.1`

			`check_output "summarize is not working" <<EOF`
			`c_col_0,count_col_0`
			`/auto/opt,1`
			`EOF`


[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00			`-c ";update access_log set log_mark = 1 where sc_bytes > 60000" \`
			`-c ':write-to -' \`
			`${test_dir}/logfile_access_log.0`

[partition] make partitions a separate bookmark type 2014-03-07 05:20:49 -08:00			`export SQL_ENV_VALUE="foo bar,baz"`
[tests] add some tests that use headless mode 2014-03-02 08:55:00 -08:00
			`run_test ${lnav_test} -n \`
			`-c ';select $SQL_ENV_VALUE as val' \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "env vars are not working in SQL" <<EOF`
			`val`
			`"foo bar,baz"`
			`EOF`


[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`run_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";SELECT name,value FROM environ WHERE name = 'SQL_ENV_VALUE'" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "environ table is not working in SQL" <<EOF`
			`name,value`
			`SQL_ENV_VALUE,"foo bar,baz"`
			`EOF`


[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`-c ';INSERT INTO environ (name) VALUES (null)' \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`-c ';INSERT INTO environ (name, value) VALUES (null, null)' \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";INSERT INTO environ (name, value) VALUES ('', null)" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";INSERT INTO environ (name, value) VALUES ('foo=bar', 'bar')" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";INSERT INTO environ (name, value) VALUES ('SQL_ENV_VALUE', 'bar')" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`${test_dir}/logfile_access_log.0`

			`run_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";INSERT OR IGNORE INTO environ (name, value) VALUES ('SQL_ENV_VALUE', 'bar')" \`
			`-c ";SELECT * FROM environ WHERE name = 'SQL_ENV_VALUE'" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "insert into environ table works" <<EOF`
			`name,value`
			`SQL_ENV_VALUE,"foo bar,baz"`
			`EOF`


			`run_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";REPLACE INTO environ (name, value) VALUES ('SQL_ENV_VALUE', 'bar')" \`
			`-c ";SELECT * FROM environ WHERE name = 'SQL_ENV_VALUE'" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "replace into environ table works" <<EOF`
			`name,value`
			`SQL_ENV_VALUE,bar`
			`EOF`


			`run_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";INSERT INTO environ (name, value) VALUES ('foo_env', 'bar')" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`-c ';SELECT $foo_env as val' \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "insert into environ table does not work" <<EOF`
			`val`
			`bar`
			`EOF`


			`run_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";UPDATE environ SET name='NEW_ENV_VALUE' WHERE name='SQL_ENV_VALUE'" \`
[build] revive freebsd release build Some misc fixes for filtering as well 2019-02-17 07:40:35 -08:00			`-c ";SELECT * FROM environ WHERE name like '%ENV_VALUE'" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "update environ table does not work" <<EOF`
			`name,value`
			`NEW_ENV_VALUE,"foo bar,baz"`
			`EOF`


			`run_test ${lnav_test} -n \`
[tests] use proper quoting in SQL strings 2024-10-25 13:27:03 -07:00			`-c ";DELETE FROM environ WHERE name='SQL_ENV_VALUE'" \`
			`-c ";SELECT * FROM environ WHERE name like '%ENV_VALUE'" \`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "delete from environ table does not work" <<EOF`
[sql] do not dump the log on an empty SQL result Related to #466 2024-06-13 15:37:28 -07:00			`name,value`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`EOF`


			`run_test ${lnav_test} -n \`
			`-c ';DELETE FROM environ' \`
			`-c ';SELECT * FROM environ' \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "delete environ table does not work" <<EOF`
[sql] do not dump the log on an empty SQL result Related to #466 2024-06-13 15:37:28 -07:00			`name,value`
[sql] add an environ virtual table Defect Number: Reviewed By: Testing Done: 2014-05-06 21:26:05 -07:00			`EOF`

[vtab] add all_opids and all_thread_ids vtabs 2025-09-16 11:39:32 -07:00			`${lnav_test} -n -c ';.schema' ${test_dir}/logfile_access_log.0 \| \`
			`run_cap_test env TEST_NAME=schema_dump head -n21`
[headless] report output from commands/queries that were executed Also, add some negative test cases. 2014-03-02 16:52:18 -08:00
[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[headless] report output from commands/queries that were executed Also, add some negative test cases. 2014-03-02 16:52:18 -08:00			`-c ";select * from nonexistent_table" \`
			`${test_dir}/logfile_access_log.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[headless] report output from commands/queries that were executed Also, add some negative test cases. 2014-03-02 16:52:18 -08:00			`-c ";delete from access_log" \`
			`${test_dir}/logfile_access_log.0`

[build] update news and fix test failure 2018-07-22 07:27:59 -07:00			`touch -t 201504070732 ${test_dir}/logfile_pretty.0`
[partition] make partitions a separate bookmark type 2014-03-07 05:20:49 -08:00			`run_test ${lnav_test} -n \`
			`-c ":goto 1" \`
			`-c ":partition-name middle" \`
[sql] the log_part column was not correct in some cases 2018-07-22 06:51:05 -07:00			`-c ":goto 21" \`
			`-c ":partition-name end" \`
			`-c ";select log_line,log_part,log_time from syslog_log" \`
[partition] make partitions a separate bookmark type 2014-03-07 05:20:49 -08:00			`-c ":write-csv-to -" \`
[sql] the log_part column was not correct in some cases 2018-07-22 06:51:05 -07:00			`${test_dir}/logfile_pretty.0`
[partition] make partitions a separate bookmark type 2014-03-07 05:20:49 -08:00
[partition] use an underline to mark a partition boundary 2014-03-07 06:29:20 -08:00			`check_output "partition-name does not work" <<EOF`
[sql] the log_part column was not correct in some cases 2018-07-22 06:51:05 -07:00			`log_line,log_part,log_time`
[time_util] use std::chrono::microseconds instead of timeval 2025-10-28 11:41:51 -07:00			`0,<NULL>,2015-04-07 00:49:42.000000`
			`1,middle,2015-04-07 05:49:53.000000`
			`18,middle,2015-04-07 07:31:56.000000`
			`20,middle,2015-04-07 07:31:56.000000`
			`21,end,2015-04-07 07:31:56.000000`
			`22,end,2015-04-07 07:32:56.000000`
[partition] make partitions a separate bookmark type 2014-03-07 05:20:49 -08:00			`EOF`
[partition] use an underline to mark a partition boundary 2014-03-07 06:29:20 -08:00
[tests] more coverage for logfile_sub_source 2024-11-15 10:05:22 -08:00			`run_cap_test ${lnav_test} -n \`
			`-c ":goto 1" \`
			`-c ":partition-name middle" \`
			`-c ":goto 21" \`
			`-c ":partition-name end" \`
			`-c ":goto 0" \`
			`-c ":next-section" \`
			`-c ";SELECT log_top_line()" \`
			`-c ":write-csv-to -" \`
			`-c ":switch-to-view log" \`
			`-c ":next-section" \`
			`-c ";SELECT log_top_line()" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_pretty.0`

[partition] use an underline to mark a partition boundary 2014-03-07 06:29:20 -08:00			`run_test ${lnav_test} -n \`
			`-c ":goto 1" \`
			`-c ":partition-name middle" \`
			`-c ":clear-partition" \`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`-c ";select log_line, log_part from access_log" \`
[partition] use an underline to mark a partition boundary 2014-03-07 06:29:20 -08:00			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_access_log.0`

			`check_output "clear-partition does not work" <<EOF`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`log_line,log_part`
			`0,<NULL>`
			`1,<NULL>`
			`2,<NULL>`
[partition] use an underline to mark a partition boundary 2014-03-07 06:29:20 -08:00			`EOF`

			`run_test ${lnav_test} -n \`
			`-c ":goto 1" \`
			`-c ":partition-name middle" \`
			`-c ":goto 2" \`
			`-c ":clear-partition" \`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`-c ";select log_line, log_part from access_log" \`
[partition] use an underline to mark a partition boundary 2014-03-07 06:29:20 -08:00			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_access_log.0`

			`check_output "clear-partition does not work when in the middle of a part" <<EOF`
[filters] add a log_filters column to log tables that contains the matched filters Related to #597 2019-02-14 22:42:44 -08:00			`log_line,log_part`
			`0,<NULL>`
			`1,<NULL>`
			`2,<NULL>`
[partition] use an underline to mark a partition boundary 2014-03-07 06:29:20 -08:00			`EOF`
[format] add OpenAM log formats 2014-06-17 21:29:42 -07:00
[partitions] revive partition functionality 2024-03-21 08:47:29 -07:00			`# test the partitions defined in the format`
			`run_cap_test ${lnav_test} -n \`
			`-I ${test_dir} \`
			`-c ";SELECT log_line, log_part, log_body FROM syslog_log" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_partitions.0`
[format] add OpenAM log formats 2014-06-17 21:29:42 -07:00
[prql] refinements 2024-03-26 21:49:39 -07:00			`run_cap_test ${lnav_test} -n \`
[format] add OpenAM log formats 2014-06-17 21:29:42 -07:00			`-c ";SELECT * FROM openam_log" \`
			`-c ":write-json-to -" \`
			`${test_dir}/logfile_openam.0`

[tests] fix syslog timestamps in log 2024-01-10 09:42:14 -08:00			`touch -t 200711030000 ${srcdir}/logfile_for_join.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -d "/tmp/lnav.err" -n \`
[perf] fixing slow queries 2022-07-01 16:02:14 -07:00			`-c ";select log_line, col_0 from logline" \`
[logline] add a log_msg_instance column to the table 2015-10-02 21:24:52 -07:00			`${test_dir}/logfile_for_join.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -d "/tmp/lnav.err" -n \`
[perf] fixing slow queries 2022-07-01 16:02:14 -07:00			`-c ";select col_0 from logline where log_line > 4" \`
[logline] add a log_msg_instance column to the table 2015-10-02 21:24:52 -07:00			`${test_dir}/logfile_for_join.0`

[filter] some improvements to the core filtering code 2014-10-19 22:16:40 -07:00			`run_test ${lnav_test} -d "/tmp/lnav.err" -n \`
			`-c ":goto 1" \`
			`-c ":create-logline-table join_group" \`
			`-c ":goto 2" \`
			`-c ";select logline.log_line as llline, join_group.log_line as jgline from logline, join_group where logline.col_0 = join_group.col_2" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_for_join.0`

			`check_output "create-logline-table is not working" <<EOF`
			`llline,jgline`
			`2,1`
			`2,8`
			`9,1`
			`9,8`
			`EOF`
[headless] completely read stdin in headless mode before running commands 2015-04-06 02:48:12 -07:00

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[remote] add some tailer tests 2021-05-25 22:27:09 -07:00			`-c ";select log_body from syslog_log where log_procname = 'automount'" \`
			`< ${test_dir}/logfile_syslog.0`
[headless] completely read stdin in headless mode before running commands 2015-04-06 02:48:12 -07:00
[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[remote] add some tailer tests 2021-05-25 22:27:09 -07:00			`-c ";select log_body from syslog_log where log_procname = 'sudo'" \`
			`< ${test_dir}/logfile_syslog.0`
[headless] completely read stdin in headless mode before running commands 2015-04-06 02:48:12 -07:00
[build] Get rid of the sqlite3 dependency. 2015-04-15 19:14:25 -07:00			`# Create a dummy database for the next couple of tests to consume.`
[tests] fix test_sql.sh 2015-11-15 06:16:59 -08:00			`touch empty`
[console] colorize console output 2022-04-12 16:07:13 -07:00			`rm simple-db.db`
[build] Get rid of the sqlite3 dependency. 2015-04-15 19:14:25 -07:00			`run_test ${lnav_test} -n \`
			`-c ";ATTACH DATABASE 'simple-db.db' as 'db'" \`
			`-c ";CREATE TABLE IF NOT EXISTS db.person ( id integer PRIMARY KEY, first_name text, last_name, age integer )" \`
			`-c ";INSERT INTO db.person(id, first_name, last_name, age) VALUES (0, 'Phil', 'Myman', 30)" \`
			`-c ";INSERT INTO db.person(id, first_name, last_name, age) VALUES (1, 'Lem', 'Hewitt', 35)" \`
			`-c ";DETACH DATABASE 'db'" \`
[tests] fix test_sql.sh 2015-11-15 06:16:59 -08:00			`empty`
[build] Get rid of the sqlite3 dependency. 2015-04-15 19:14:25 -07:00
			`check_output "Could not create db?" <<EOF`
			`EOF`

[test] Add tests for attaching to sqlite3 db. * Test for attaching db when passed in through as a command line argument. * Test for attaching db from within lnav. 2015-04-12 18:21:33 -07:00			`# Test to see if lnav can recognize a sqlite3 db file passed in as an argument.`
[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n -c ";select * from person order by age asc" \`
[test] Add tests for attaching to sqlite3 db. * Test for attaching db when passed in through as a command line argument. * Test for attaching db from within lnav. 2015-04-12 18:21:33 -07:00			`simple-db.db`

			`# Test to see if lnav can recognize a sqlite3 db file passed in as an argument.`
[glob] ignore files picked up by a glob that are not readable 2015-11-14 22:17:59 -08:00			`# XXX: Need to pass in a file, otherwise lnav keeps trying to open syslog`
[test] Add tests for attaching to sqlite3 db. * Test for attaching db when passed in through as a command line argument. * Test for attaching db from within lnav. 2015-04-12 18:21:33 -07:00			`# and we might not have sufficient privileges on the system the tests are being`
			`# run on.`
[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[build] Get rid of the sqlite3 dependency. 2015-04-15 19:14:25 -07:00			`-c ";attach database 'simple-db.db' as 'db'" \`
[test] Add tests for attaching to sqlite3 db. * Test for attaching db when passed in through as a command line argument. * Test for attaching db from within lnav. 2015-04-12 18:21:33 -07:00			`-c ';select * from person order by age asc' \`
use an empty file 2015-11-14 22:47:04 -08:00			`empty`
[test] Add tests for attaching to sqlite3 db. * Test for attaching db when passed in through as a command line argument. * Test for attaching db from within lnav. 2015-04-12 18:21:33 -07:00
[secure-mode] Prevent users from attaching db files. Prevent the users from attaching an external db file which they may not have ownership of. The current authorizer method is hooked in only when the LNAVSECURE variable is set. This is done deliberately, since the method will be called on every sqlite query and I did not want to incur a performance hit. If the scope of this authorizer increases, we should consider passing in the lnav_data as pUserData and do the checks inside the authorizer itself. 2016-05-02 18:43:14 -07:00			`# Test to see if we can attach a database in LNAVSECURE mode.`
			`export LNAVSECURE=1`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[secure-mode] Prevent users from attaching db files. Prevent the users from attaching an external db file which they may not have ownership of. The current authorizer method is hooked in only when the LNAVSECURE variable is set. This is done deliberately, since the method will be called on every sqlite query and I did not want to incur a performance hit. If the scope of this authorizer increases, we should consider passing in the lnav_data as pUserData and do the checks inside the authorizer itself. 2016-05-02 18:43:14 -07:00			`-c ";attach database 'simple-db.db' as 'db'" \`
			`empty`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[secure-mode] Prevent users from attaching db files. Prevent the users from attaching an external db file which they may not have ownership of. The current authorizer method is hooked in only when the LNAVSECURE variable is set. This is done deliberately, since the method will be called on every sqlite query and I did not want to incur a performance hit. If the scope of this authorizer increases, we should consider passing in the lnav_data as pUserData and do the checks inside the authorizer itself. 2016-05-02 18:43:14 -07:00			`-c ";attach database ':memdb:' as 'db'" \`
			`empty`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[secure-mode] Prevent users from attaching db files. Prevent the users from attaching an external db file which they may not have ownership of. The current authorizer method is hooked in only when the LNAVSECURE variable is set. This is done deliberately, since the method will be called on every sqlite query and I did not want to incur a performance hit. If the scope of this authorizer increases, we should consider passing in the lnav_data as pUserData and do the checks inside the authorizer itself. 2016-05-02 18:43:14 -07:00			`-c ";attach database '/tmp/memdb' as 'db'" \`
			`empty`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[secure-mode] Prevent users from attaching db files. Prevent the users from attaching an external db file which they may not have ownership of. The current authorizer method is hooked in only when the LNAVSECURE variable is set. This is done deliberately, since the method will be called on every sqlite query and I did not want to incur a performance hit. If the scope of this authorizer increases, we should consider passing in the lnav_data as pUserData and do the checks inside the authorizer itself. 2016-05-02 18:43:14 -07:00			`-c ";attach database 'file:memdb?cache=shared' as 'db'" \`
			`empty`

			`unset LNAVSECURE`

[logfile] lay groundwork for bounding log file times Related to #1188 2025-11-10 11:37:22 -08:00			`#touch -t 201503240923 ${test_dir}/logfile_syslog_with_access_log.0`
			`#run_cap_test ${lnav_test} -n -d /tmp/lnav.err \`
			`# -c ";select * from access_log" \`
			`# -c ':write-csv-to -' \`
			`# ${test_dir}/logfile_syslog_with_access_log.0`
[fmt] highlight identifiers in module formats 2015-07-19 02:40:02 -07:00
[sql] multiline text was not returned correctly 2015-08-04 21:49:13 -07:00			`run_test ${lnav_test} -n \`
			`-c ";select log_text from generic_log" \`
			`-c ":write-json-to -" \`
			`${test_dir}/logfile_multiline.0`

			`check_output "multiline data is not right?" <<EOF`
			`[`
			`{`
			`"log_text": "2009-07-20 22:59:27,672:DEBUG:Hello, World!\n How are you today?"`
			`},`
			`{`
			`"log_text": "2009-07-20 22:59:30,221:ERROR:Goodbye, World!"`
			`}`
			`]`
			`EOF`
[sql] add a log_search table 2015-08-05 23:18:19 -07:00
[misc] fix a perf issue when previewing commands and some sql fixes 2018-02-07 11:06:59 -08:00			`run_test ${lnav_test} -n \`
			`-c ";select log_text from generic_log where log_line = 1" \`
			`-c ":write-json-to -" \`
			`${test_dir}/logfile_multiline.0`

			`check_output "able to select a continued line?" <<EOF`
[sql] do not dump the log on an empty SQL result Related to #466 2024-06-13 15:37:28 -07:00			`[`

			`]`
[misc] fix a perf issue when previewing commands and some sql fixes 2018-02-07 11:06:59 -08:00			`EOF`

[sql] add a log_search table 2015-08-05 23:18:19 -07:00
[sql_util] add pattern guess for measure_with_units 2025-03-17 21:29:50 -07:00			`run_cap_test ${lnav_test} -n \`
			`-c ":create-search-table est_size estimated size (?<size>\d+\.\d+ \w+)" \`
			`-c ";SELECT log_line, size FROM est_size ORDER BY size DESC" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_spark.0`


[sql] add a log_search table 2015-08-05 23:18:19 -07:00			`run_test ${lnav_test} -n \`
the log_search table regex should be case-insensitive 2015-11-03 22:17:11 -08:00			`-c ":create-search-table search_test1 (\w+), world!" \`
[perf] fixing slow queries 2022-07-01 16:02:14 -07:00			`-c ";select col_0 from search_test1" \`
[sql] add a log_search table 2015-08-05 23:18:19 -07:00			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_multiline.0`

			`check_output "create-search-table is not working?" <<EOF`
[perf] fixing slow queries 2022-07-01 16:02:14 -07:00			`col_0`
			`Hello`
			`Goodbye`
[logline] add a log_msg_instance column to the table 2015-10-02 21:24:52 -07:00			`EOF`

			`run_test ${lnav_test} -n \`
			`-c ":create-search-table search_test1 (\w+), World!" \`
[perf] fixing slow queries 2022-07-01 16:02:14 -07:00			`-c ";select col_0 from search_test1 where log_line > 0" \`
[logline] add a log_msg_instance column to the table 2015-10-02 21:24:52 -07:00			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_multiline.0`

			`check_output "create-search-table is not working with where clause?" <<EOF`
[perf] fixing slow queries 2022-07-01 16:02:14 -07:00			`col_0`
			`Goodbye`
[sql] add a log_search table 2015-08-05 23:18:19 -07:00			`EOF`

			`run_test ${lnav_test} -n \`
			`-c ":create-search-table search_test1 (?<word>\w+), World!" \`
[search-table] guess the column types based on the regex 2015-08-07 20:04:28 -07:00			`-c ";select word, typeof(word) from search_test1" \`
[sql] add a log_search table 2015-08-05 23:18:19 -07:00			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_multiline.0`

			`check_output "create-search-table is not working?" <<EOF`
[search-table] guess the column types based on the regex 2015-08-07 20:04:28 -07:00			`word,typeof(word)`
			`Hello,text`
			`Goodbye,text`
			`EOF`

			`run_test ${lnav_test} -n \`
			`-c ":create-search-table search_test1 eth(?<ethnum>\d+)" \`
			`-c ";select typeof(ethnum) from search_test1" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_syslog.2`

			`check_output "regex type guessing is not working?" <<EOF`
			`typeof(ethnum)`
			`integer`
			`integer`
			`integer`
[sql] add a log_search table 2015-08-05 23:18:19 -07:00			`EOF`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sql] add a log_search table 2015-08-05 23:18:19 -07:00			`-c ":delete-search-table search_test1" \`
			`${test_dir}/logfile_multiline.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sql] add a log_search table 2015-08-05 23:18:19 -07:00			`-c ":create-logline-table search_test1" \`
			`-c ":delete-search-table search_test1" \`
			`${test_dir}/logfile_multiline.0`

[errors] try to improve some errors 2022-06-22 22:53:52 -07:00			`run_cap_test ${lnav_test} -n \`
[sql] add a log_search table 2015-08-05 23:18:19 -07:00			`-c ":create-search-table search_test1 bad(" \`
			`${test_dir}/logfile_multiline.0`

[sql] missed checking for null in graphable columns 2015-11-29 20:10:40 -08:00			`NULL_GRAPH_SELECT_1=$(cat <<EOF`
			`;SELECT value FROM (`
			`SELECT 10 as value`
			`UNION ALL SELECT null as value)`
			`EOF`
			`)`

			`run_test ${lnav_test} -n \`
			`-c "$NULL_GRAPH_SELECT_1" \`
			`-c ":write-csv-to -" \`
			`${test_dir}/logfile_multiline.0`

			`check_output "number column with null does not work?" <<EOF`
			`value`
			`10`
			`<NULL>`
			`EOF`
[sql] add a regexp_capture tablue-valued function Fixup the release makefile a bit. 2017-03-15 17:01:58 -07:00
			`run_test ${lnav_test} -n \`
			`-c ";SELECT regexp_capture.content FROM access_log, regexp_capture(access_log.cs_version, 'HTTP/(\d+\.\d+)') WHERE regexp_capture.capture_index = 1" \`
			`-c ':write-csv-to -' \`
			`${test_dir}/logfile_access_log.0`

			`check_output "joining log table with regexp_capture is not working?" <<EOF`
			`content`
			`1.0`
			`1.0`
			`1.0`
			`EOF`
[tests] coverage for some state functions 2022-08-16 20:28:03 -07:00
			`run_cap_test ${lnav_test} -n \`
			`-c ';SELECT echoln(sc_bytes), 123 FROM access_log' \`
			`${test_dir}/logfile_access_log.0`

			`run_cap_test ${lnav_test} -n \`
			`-c ';SELECT lnav_top_file()' \`
			`${test_dir}/logfile_access_log.0`

			`run_cap_test ${lnav_test} -n \`
			`-c ':switch-to-view db' \`
			`-c ';SELECT lnav_top_file()' \`
			`${test_dir}/logfile_access_log.0`
[view_curses] add a unit type to line_range Fixes #1033 2022-09-03 08:49:47 -07:00
			`run_cap_test ${lnav_test} -Nn \`
			`-c ";select *,case match_index when 2 then replicate('abc', 1000) else '' end from regexp_capture_into_json('10;50;50;50;', '(\d+);')"`
[sql] fix .msgformats command 2024-01-09 20:41:23 -08:00
			`run_cap_test ${lnav_test} -n \`
			`-c ";.msgformats" \`
			`${test_dir}/logfile_for_join.0`
[db] show errors for __lnav_style__ 2025-01-18 22:13:48 -08:00
			`run_cap_test ${lnav_test} -Nn \`
			`-c ";SELECT log_line, sc_bytes, json_object('columns', json_object('sc_bytes', json_object('color', '#f00'))) AS __lnav_style__ FROM access_log" \`
			`${test_dir}/logfile_access_log.0`

			`run_cap_test ${lnav_test} -Nn \`
			`-c ";SELECT log_line, sc_bytes, json_object('columns', json_object('sc_ytes', json_object('color', '#f00'))) AS __lnav_style__ FROM access_log" \`
			`${test_dir}/logfile_access_log.0`
[docs] add a performance section 2025-01-23 09:42:43 -08:00
			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT bro_response_body_len AS bro_response_body_len1, humanize_file_size(bro_response_body_len) AS bro_response_body_len2 FROM bro_http_log ORDER BY bro_response_body_len DESC" \`
			`${test_dir}/logfile_bro_http.log.0`

			`run_cap_test ${lnav_test} -nN \`
			`-c ";SELECT '1us' AS Duration UNION ALL SELECT '500ms' UNION ALL SELECT '1s'"`
[management] add a "format test" sub command 2025-01-24 06:30:05 -08:00
			`run_cap_test env TEST_COMMENT="alignment demo" ${lnav_test} -nN -f- <<'EOF'`
			`;SELECT 'left' AS "Alignment Demo", '{"columns": {"Alignment Demo": {"text-align": "start"}}}' AS __lnav_style__`
			`UNION ALL`
			`SELECT 'center', '{"columns": {"Alignment Demo": {"text-align": "center"}}}' AS __lnav_style__`
			`UNION ALL`
			`SELECT 'right', '{"columns": {"Alignment Demo": {"text-align": "end"}}}' AS __lnav_style__`
			`:switch-to-view db`
			`EOF`
[db] add support for hiding columns 2025-01-29 22:17:45 -08:00
			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT * FROM access_log" \`
			`-c ":hide-fields log_time" \`
			`${test_dir}/logfile_access_log.0`

			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT * FROM access_log" \`
			`-c ":hide-fields bad" \`
			`${test_dir}/logfile_access_log.0`
[prompt] completion for :delete-logline-table Fix log_opid column search not working 2025-03-05 21:24:38 -08:00
			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT log_line FROM vmw_log WHERE log_opid = '7e1280cf'" \`
			`${test_dir}/logfile_vpxd.0`
[logline] add permalinks for log messages Related to #1380 2025-03-11 13:51:33 -07:00
			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT log_line_link FROM access_log WHERE log_line = 1" \`
			`-c ';SELECT log_line FROM access_log WHERE log_line_link = $log_line_link' \`
			`${test_dir}/logfile_access_log.0`

			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT log_line_link FROM access_log WHERE log_line = 1" \`
			`-c ';SELECT log_line FROM access_log WHERE log_line_link > $log_line_link' \`
			`${test_dir}/logfile_access_log.0`

			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT log_line_link FROM access_log WHERE log_line = 1" \`
			`-c ':switch-to-view log' \`
			`-c ':eval :goto $log_line_link' \`
			`${test_dir}/logfile_access_log.0`
[sql] add lnav_focused_msg view Fixes #57 2025-03-25 10:43:27 -07:00
			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT * FROM lnav_focused_msg" \`
			`${test_dir}/logfile_access_log.0`

			`run_cap_test ${lnav_test} -n \`
			`-c ";UPDATE lnav_focused_msg SET log_mark = 1" \`
			`-c ":switch-to-view log" \`
			`${test_dir}/logfile_access_log.0`
[format] add fields for source file/line Knowing the source file/line context in a log message can help find log messages when using log2src. 2025-09-09 10:00:44 -07:00
			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT log_line, log_src_file, log_src_line FROM all_logs" \`
			`${test_dir}/logfile_glog.0`
[vtab] add all_opids and all_thread_ids vtabs 2025-09-16 11:39:32 -07:00
			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT * FROM all_thread_ids" \`
			`${test_dir}/logfile_glog.0`

			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT * FROM all_thread_ids" \`
			`${test_dir}/logfile_generic.0`

			`run_cap_test ${lnav_test} -n \`
			`-c ";SELECT * FROM all_opids" \`
			`${test_dir}/logfile_vpxd.0`