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
|
check()
{
tag=$1
test_prompt=$2
name_test_file="./t/${tag}.test.sql"
name_prefix="./r/${tag}"
name_result="${name_prefix}.result"
name_etalon="${name_prefix}.result.etalon"
name_diff="${name_prefix}.diff"
./test_parse_sql_statemets $tag $name_test_file > $name_result
compare_results $name_etalon $name_result $name_diff
fc_result=$?
print_test_res "$test_prompt" $fc_result
}
print_title "test extracting partial statements from sql query"
check use "extracting use statements"
check load "extracting load statements"
check delimiter "extracting delimiter statements"
check exit "extracting exit statements"
check help "extracting help statements"
check start "extracting start transaction statements"
check commit "extracting commit transaction statements"
check rollback "extracting rollback transaction statements"
print_footer
exit $one_of_tests_failed
|
