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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
Feature: I/O commands
Scenario: edit sql in file with external editor
When we start external editor providing a file name
and we type "select * from abc" in the editor
and we exit the editor
then we see dbcli prompt
and we see "select * from abc" in prompt
Scenario: tee output from query
When we tee output
and we wait for prompt
and we select "select 123456"
and we wait for prompt
and we notee output
and we wait for prompt
then we see 123456 in tee output
Scenario: set delimiter
When we query "delimiter $"
then delimiter is set to "$"
Scenario: set delimiter twice
When we query "delimiter $"
and we query "delimiter ]]"
then delimiter is set to "]]"
Scenario: set delimiter and query on same line
When we query "select 123; delimiter $ select 456 $ delimiter %"
then we see tabular result "123"
and we see tabular result "456"
and delimiter is set to "%"
Scenario: send output to file
When we query "\o /tmp/output1.sql"
and we query "select 123"
and we query "system cat /tmp/output1.sql"
then we see csv result "123"
Scenario: send output to file two times
When we query "\o /tmp/output1.sql"
and we query "select 123"
and we query "\o /tmp/output2.sql"
and we query "select 456"
and we query "system cat /tmp/output2.sql"
then we see csv result "456"
Scenario: shell style redirect to file
When we query "select 123 as constant $> /tmp/output1.csv"
and we query "system cat /tmp/output1.csv"
then we see csv 123 in file output
Scenario: shell style redirect to command
When we query "select 100 $| wc"
then we see space 12 in command output
Scenario: shell style redirect to multiple commands
When we query "select 100 $| head -1 $| wc"
then we see space 6 in command output
Scenario: shell style redirect to multiple commands with minimal spaces
When we query "select 100$|head -1$|wc"
then we see space 6 in command output
Scenario: shell style redirect to multiple commands containing single quotes
When we query "select 100 $| head '-1' $| wc"
then we see space 6 in command output
Scenario: shell style redirect to multiple commands containing single quotes and minimal spaces
When we query "select 100$|head '-1'$|wc"
then we see space 6 in command output
Scenario: shell style redirect to multiple commands containing mixed quoted and unquoted arg
When we query "select 100 $| head -'1' $| wc"
then we see space 6 in command output
Scenario: shell style redirect to multiple commands containing double quotes
When we query "select 100 $| head ""-1"" $| wc"
then we see space 6 in command output
Scenario: shell style redirect with commands and capture to file
When we query "select 100 $| head -1 $| wc $> /tmp/output1.txt"
and we query "system cat /tmp/output1.txt"
then we see text 6 in file output
Scenario: shell style redirect with append to file
When we query "select 100 $> /tmp/output1.csv"
and we query "select 200 $>> /tmp/output1.csv"
and we query "system cat /tmp/output1.csv"
then we see csv 100 in file output
and we see csv 200 in file output
Scenario: shell style redirect with command and append to file
When we query "select 300 $| grep 0 $> /tmp/output1.csv"
and we query "select 400 $| grep 0 $>> /tmp/output1.csv"
and we query "system cat /tmp/output1.csv"
then we see csv 300 in file output
and we see csv 400 in file output
|
