On 9/26/16, David Raymond <[email protected]> wrote:
> So the .help on .testcase says:
> .testcase NAME Begin redirecting output to 'testcase-out.txt'
>
> And .check says:
> .check GLOB Fail if output since .testcase does not match
These dot-commands help in writing scripts that test various SQL
language features in SQLite.
For example, I could test various row-value comparisons using a script
like this:
.testcase 100
SELECT (1,2,3)<(1,2,4), (1,2,3)<(1,NULL,4), (1,2,3)<(2,NULL,1);
.check 1||1
Running that script using:
./sqlite3 <script.txt
Generates output: "testcase-100 ok". Or, it generates an error
message if the expected result does not appear.
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
