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
|
/*
$Id: annotated-interactive.sql,v 1.4 2004/06/16 23:48:02 unsaved Exp $
See readme.txt in this directory for how to unit test SqlTool.
This is an annotated example. Don't use this as a template. See
the readme.txt file about that.
This is an annotated example on how to test SqlTool run in interactive
mode. SqlTool will be run without any filename arguments, and this
file will be fed to SqlTool via stdin.
This SQL test file runs SqlTool in interactive mode by virtue of using
"inputAsFile" false (the default) and not specifying any SQL filename
(or "-") with "arg".
N.b. that there are no annotations between the "HARNESS_METADATA BEGIN"
line and the "HARNESS_METADATA END" lines below. This is because only
harness metadata name/value pairs are permitted between those lines.
In general, you are best off using urlid of "mem", which we assume that
the user has configured as a memory-only database (as documented in the
readme.txt file). You specify the urlid to be used by this file by
using the 'arg' setting as described below.
Harness metadata settings:
arg: An argument for SqlTool.
Unless you are testing bad command-line args, you
must give at least a urlid as an arg.
The only SqlTool arg that you do not give is, if
you set inputAsFile to true (see below), you do not
use 'arg' to specify this file name.
jvmarg: An argument to come between "java" and
"org.hsqldb.util.SqlTool"
requireStdoutRegex: Regular expression to require from stdout of SqlTool
rejectStdoutRegex: Regular expression to reject from stdout of SqlTool
requireErroutRegex: Regular expression to require from errout of SqlTool
rejectErroutRegex: Regular expression to reject from errout of SqlTool
exitValue: Required exit value from the SqlTool run.
Default is 0. Specify no value at all (i.e.
a line containing just "exitValue") to ignore
the exit value.
inputAsFile: "true" or "false" (defaults to "false").
If "false", this file you are reading will be
passed to SqlTool via stdin.
If "true", the filename of the file you are reading
will be given to SqlTool as the last command-line
argument (do NOT give it with 'arg' or SqlTool
will get that argument twice!).
All settings are optional. For all but the last 2, you can give as many
as you want. You could, for example give 3 args, 2 jvmargs, 20
requireStdoutRegexes. The reason for the exception where a filename
'arg' is automatically added if inputAsFile is true, is so you don't
have to maintain hard-coded file names in SQL files, and you don't need
to be concerned about operating system case sensitivity or case-munging
problems.
You can add args for other filenames, to test "SqlTool... file1 file2...",
just be aware that this current file will be appended in last position
if inputAsFile is true.
This specific example emulates the command:
SqlTool --sql '\p Print message from --sql argument.' mem
Then pipes this entire file into stdin of SqlTool.
This test will INTENTIONALLY FAIL since the required regular expression
does not show up in Stdout.
HARNESS_METADATA BEGIN
requireStdoutRegex Nonexistent string
arg --sql
arg \p Print message from --sql argument.
arg mem
HARNESS_METADATA END
*/
\p Print message from normal SQL file area.
|
