Mercurial > sqlpython

annotate sqlpython/exampleSession.txt @ 306:ed02c8b1a9b6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
folded in py session work
author catherine@dellzilla
date Wed, 25 Mar 2009 14:37:34 -0400
parents 6ffe31149306
children 0473ad96ddb7
rev   line source
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
1 SQL.No_Connection> connect testschema/testschema@orcl
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
2 0:testschema@orcl> CREATE TABLE play (
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
3 > title VARCHAR2(40) CONSTRAINT xpk_play PRIMARY KEY,
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
4 > author VARCHAR2(40));
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
5
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
6 Executed (1 rows)
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
7
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
8 0:testschema@orcl> INSERT INTO play VALUES ('Twelfth Night', 'Shakespeare');
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
9
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
10 Executed (1 rows)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
11
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
12 0:testschema@orcl> INSERT INTO play VALUES ('The Tempest', 'Shakespeare');
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
13
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
14 Executed (1 rows)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
15
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
16 0:testschema@orcl> INSERT INTO play VALUES ('Agamemnon', 'Aeschylus');
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
17
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
18 Executed (1 rows)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
19
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
20 0:testschema@orcl> commit;
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
21
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
22 Executed
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
23
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
24 0:testschema@orcl> select
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
25 > *
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
26 > from
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
27 > play;
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
28
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
29 TITLE AUTHOR
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
30 ------------- -----------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
31 Twelfth Night Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
32 The Tempest Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
33 Agamemnon Aeschylus
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
34
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
35 3 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
36
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
37 0:testschema@orcl> ls
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
38
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
39 NAME
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
40 --------------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
41 INDEX/XPK_PLAY
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
42 TABLE/PLAY
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
43
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
44 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
45
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
46 0:testschema@orcl> ls table/*
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
47
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
48 NAME
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
49 ----------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
50 TABLE/PLAY
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
51
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
52 1 row selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
53
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
54 0:testschema@orcl> desc play
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
55 TABLE TESTSCHEMA.PLAY
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
56
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
57 COLUMN_NAME Null? DATA_TYPE
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
58 ----------- -------- ------------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
59 TITLE NOT NULL VARCHAR2(40)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
60 AUTHOR NULL VARCHAR2(40)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
61
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
62 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
63
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
64 0:testschema@orcl> COMMENT ON COLUMN play.author IS 'Primary author (if multiple)';
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
65
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
66 Executed
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
67
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
68 0:testschema@orcl> COMMENT ON TABLE play IS 'I like plays.';
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
69
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
70 Executed
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
71
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
72 0:testschema@orcl> comments play
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
73 TABLE TESTSCHEMA.PLAY: I like plays.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
74
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
75 COLUMN_NAME COMMENTS
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
76 ----------- ----------------------------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
77 TITLE None
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
78 AUTHOR Primary author (if multiple)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
79
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
80 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
81
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
82 0:testschema@orcl> cat play
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
83
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
84 TITLE AUTHOR
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
85 ------------- -----------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
86 Twelfth Night Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
87 The Tempest Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
88 Agamemnon Aeschylus
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
89
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
90 3 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
91
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
92 0:testschema@orcl> help terminators
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
93 ; standard Oracle format
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
94 \c CSV (with headings)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
95 \C CSV (no headings)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
96 \g list
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
97 \G aligned list
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
98 \h HTML table
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
99 \i INSERT statements
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
100 \j JSON
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
101 \s CSV (with headings)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
102 \S CSV (no headings)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
103 \t transposed
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
104 \x XML
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
105 \l line plot, with markers
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
106 \L scatter plot (no lines)
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
107 \b bar graph
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
108 \p pie chart
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
109 0:testschema@orcl> select * from play where author='Shakespeare'\c
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
110
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
111 TITLE,AUTHOR
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
112 "Twelfth Night","Shakespeare"
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
113 "The Tempest","Shakespeare"
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
114
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
115 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
116
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
117 0:testschema@orcl> select * from play where author='Shakespeare'\g
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
118
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
119
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
120
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
121 **** Row: 1
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
122 TITLE: Twelfth Night
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
123 AUTHOR: Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
124
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
125 **** Row: 2
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
126 TITLE: The Tempest
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
127 AUTHOR: Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
128
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
129
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
130 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
131
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
132 0:testschema@orcl> select * from play where author='Shakespeare'\h
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
133
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
134 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
135 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
136 <head>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
137 <title>play</title>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
138 <meta http-equiv="content-type" content="text/html;charset=utf-8"/>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
139 </head>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
140 <body>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
141 <table id="play" summary="Result set from query on table play">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
142 <tr>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
143 <th id="header_title">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
144 title
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
145 </th><th id="header_author">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
146 author
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
147 </th>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
148 </tr>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
149 <tr>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
150 <td headers="header_title">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
151 Twelfth Night
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
152 </td><td headers="header_author">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
153 Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
154 </td>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
155 </tr><tr>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
156 <td headers="header_title">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
157 The Tempest
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
158 </td><td headers="header_author">
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
159 Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
160 </td>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
161 </tr>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
162 </table>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
163 </body>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
164 </html>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
165
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
166 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
167
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
168 0:testschema@orcl> select * from play\i
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
169
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
170
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
171 INSERT INTO play (TITLE, AUTHOR) VALUES ('Twelfth Night', 'Shakespeare');
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
172 INSERT INTO play (TITLE, AUTHOR) VALUES ('The Tempest', 'Shakespeare');
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
173 INSERT INTO play (TITLE, AUTHOR) VALUES ('Agamemnon', 'Aeschylus');
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
174
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
175 3 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
176
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
177 0:testschema@orcl> select * from play where author='Shakespeare'\t
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
178
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
179
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
180 COLUMN NAME ROW N.1 ROW N.2
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
181 ----------- ------------- -----------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
182 TITLE Twelfth Night The Tempest
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
183 AUTHOR Shakespeare Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
184
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
185 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
186
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
187 0:testschema@orcl> select * from play where author='Shakespeare'\x
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
188
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
190 <xml>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
191 <play_resultset>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
192 <play>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
193 <title>Twelfth Night</title>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
194 <author>Shakespeare</author>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
195 </play>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
196 <play>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
197 <title>The Tempest</title>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
198 <author>Shakespeare</author>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
199 </play>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
200 </play_resultset>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
201 </xml>
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
202
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
203 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
204
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
205 0:testschema@orcl> set
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
206 autobind: False
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
207 commit_on_exit: True
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
208 continuation_prompt: >
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
209 default_file_name: afiedt.buf
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
210 echo: False
232
52adb09094b3 fixed bugs in VC introduced by sort-order options
catherine@dellzilla
parents: 210
diff changeset
211 editor: gedit
52adb09094b3 fixed bugs in VC introduced by sort-order options
catherine@dellzilla
parents: 210
diff changeset
212 heading: True
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
213 maxfetch: 1000
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
214 maxtselctrows: 10
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
215 prompt: 0:testschema@orcl>
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
216 result_history_max_mbytes: 10
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
217 scan: True
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
218 serveroutput: True
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
219 sql_echo: False
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
220 timeout: 30
232
52adb09094b3 fixed bugs in VC introduced by sort-order options
catherine@dellzilla
parents: 210
diff changeset
221 timing: False
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
222 wildsql: False
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
223
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
224 0:testschema@orcl> set autobind on
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
225 autobind - was: False
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
226 now: True
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
227
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
228 0:testschema@orcl> select * from play where author like 'A%';
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
229
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
230 TITLE AUTHOR
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
231 --------- ---------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
232 Agamemnon Aeschylus
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
233
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
234 1 row selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
235
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
236 0:testschema@orcl> print
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
237 :1 = Agamemnon
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
238 :2 = Aeschylus
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
239 :author = Aeschylus
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
240 :title = Agamemnon
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
241 0:testschema@orcl> select * from play where title = :1;
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
242
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
243 TITLE AUTHOR
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
244 --------- ---------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
245 Agamemnon Aeschylus
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
246
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
247 1 row selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
248
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
249 0:testschema@orcl> select * from play where author = :author;
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
250
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
251 TITLE AUTHOR
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
252 --------- ---------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
253 Agamemnon Aeschylus
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
254
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
255 1 row selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
256
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
257 0:testschema@orcl> help grep
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
258 grep PATTERN TABLE - search for term in any of TABLE's fields
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
259 Usage: grep [options] arg
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
260
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
261 Options:
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
262 -h, --help show this help message and exit
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
263 -i, --ignore-case Case-insensitive search
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
264
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
265 0:testschema@orcl> grep -i EM play
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
266 play
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
267
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
268 TITLE AUTHOR
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
269 ----------- -----------
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
270 The Tempest Shakespeare
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
271 Agamemnon Aeschylus
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
272
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
273 2 rows selected.
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
274
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
275 0:testschema@orcl> -- \d command inspired by postgresql's psql
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
276 0:testschema@orcl> \dt
201
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
277
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
278 TABLE_NAME TYPE
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
279 ---------- -----
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
280 PLAY TABLE
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
281
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
282 1 row selected.
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
283
277
6ffe31149306 now passing tests
catherine@Elli.myhome.westell.com
parents: 276
diff changeset
284 0:testschema@orcl> \di play
201
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
285
277
6ffe31149306 now passing tests
catherine@Elli.myhome.westell.com
parents: 276
diff changeset
286 OWNER INDEX_NAME INDEX_TYPE
6ffe31149306 now passing tests
catherine@Elli.myhome.westell.com
parents: 276
diff changeset
287 ---------- ---------- ----------
6ffe31149306 now passing tests
catherine@Elli.myhome.westell.com
parents: 276
diff changeset
288 TESTSCHEMA XPK_PLAY NORMAL
201
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
289
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
290 1 row selected.
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
291
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
292 0:testschema@orcl> CREATE OR REPLACE VIEW review
201
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
293 > AS
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
294 > SELECT title, author, 'A masterpiece!' review
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
295 > FROM play;
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
296
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
297 Executed
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
298
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
299 0:testschema@orcl> \dv
201
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
300
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
301 VIEW_NAME TYPE
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
302 --------- ----
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
303 REVIEW VIEW
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
304
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
305 1 row selected.
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
306
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
307 0:testschema@orcl> cat review
201
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
308
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
309 TITLE AUTHOR REVIEW
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
310 ------------- ----------- --------------
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
311 Twelfth Night Shakespeare A masterpiece!
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
312 The Tempest Shakespeare A masterpiece!
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
313 Agamemnon Aeschylus A masterpiece!
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
314
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
315 3 rows selected.
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
316
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
317 0:testschema@orcl> drop view review;
201
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
318
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
319 Executed
6e69f866b702 tests for \dv
catherine@dellzilla
parents: 198
diff changeset
320
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
321 0:testschema@orcl> drop table play;
189
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
322
c5398d87498e cat bug
catherine@dellzilla
parents:
diff changeset
323 Executed
210
78ddfa41e5c1 test almost fixed
catherine@Elli.myhome.westell.com
parents: 201
diff changeset
324
276
0b7031c2229e autobind unit test failing
catherine@Elli.myhome.westell.com
parents: 232
diff changeset
325 0:testschema@orcl> foo
210
78ddfa41e5c1 test almost fixed
catherine@Elli.myhome.westell.com
parents: 201
diff changeset
326
78ddfa41e5c1 test almost fixed
catherine@Elli.myhome.westell.com
parents: 201
diff changeset
327 bar