File: test_sql_search_table.sh

package info (click to toggle)
lnav 0.13.2-1
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 60,084 kB
  • sloc: cpp: 215,599; ansic: 59,220; sh: 4,650; makefile: 3,578; python: 1,197; sql: 315; xml: 264; javascript: 18
file content (33 lines) | stat: -rw-r--r-- 1,028 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
#! /bin/bash

export TZ=UTC
export YES_COLOR=1

run_cap_test ${lnav_test} -n \
    -c ';SELECT * FROM procstate_procs' \
    ${test_dir}/logfile_procstate.0

run_cap_test ${lnav_test} -n \
    -c ';SELECT *,log_body FROM vpx_lro_begin' \
    ${test_dir}/logfile_vpxd.0

run_cap_test ${lnav_test} -n \
    -c ";select * from vpx_lro_begin where log_line > 3 and lro_id = 'lro-846064'" \
    -c ";select * from vpx_lro_begin where lro_id = 'lro-846064'" \
    ${test_dir}/logfile_vpxd.0

run_cap_test ${lnav_test} -n \
    -c ";select * from procstate_procs where cmd_name = '[kthreadd]'" \
    -c ";select * from procstate_procs where cmd_name = '[kthreadd]'" \
    ${test_dir}/logfile_procstate.0

touch -t 202211030923 ${test_dir}/logfile_syslog.3

run_cap_test ${lnav_test} -n \
    -c ':create-search-table asl_mod ASL Module "(?<name>[^"]+)"' \
    -c ';SELECT * FROM asl_mod' \
    ${test_dir}/logfile_syslog.3

run_cap_test ${lnav_test} -n \
    -c ';SELECT * FROM mysql_slow_stats' \
    ${test_dir}/logfile_mysql_slow.0