File: test_sql_xml_func.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 (26 lines) | stat: -rw-r--r-- 976 bytes parent folder | download | duplicates (3) 
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
 
#! /bin/bash

export YES_COLOR=1

run_cap_test ./drive_sql "SELECT * FROM xpath('/abc[', '<abc/>')"

run_cap_test ./drive_sql "SELECT * FROM xpath('/abc', '<abc')"

run_cap_test ./drive_sql "SELECT * FROM xpath('/abc/def', '<abc/>')"

run_cap_test ./drive_sql "SELECT * FROM xpath('/abc/def[@a=\"b\"]', '<abc><def/><def a=\"b\">ghi</def></abc>')"

run_cap_test ./drive_sql "SELECT * FROM xpath('/abc/def', '<abc><def>Hello &gt;</def></abc>')"

run_cap_test ${lnav_test} -n \
    -c ";SELECT * FROM xpath('/catalog', (SELECT content FROM lnav_file LIMIT 1))" \
    ${test_dir}/invalid-books.xml

run_cap_test ${lnav_test} -n \
    -c ";SELECT * FROM xpath('/cat[alog', (SELECT content FROM lnav_file LIMIT 1))" \
    ${test_dir}/books.xml

run_cap_test env TEST_XP1="//book[1]/price" TEST_XP2="//book[2]/price" \
    ${lnav_test} -n \
    -c ";SELECT * FROM environ, xpath(environ.value, (SELECT content FROM lnav_file)) WHERE name LIKE 'TEST_XP%'" \
    ${test_dir}/books.xml