Testing notes
-------------

I've included a very rudimentary test harness for confirming basic
operation of the SQLite library and shell.

test.sqdb is an SQLite database file containing a table named 'temp',
which contains a couple of records.

test.sql is an SQL script which creates, populates and queries a
temporary table, with both file and memory temporary storage.

To run:

OS_prompt> <shell_exe> test.sqdb
SQLite version 3.6.23.1
Enter ".help" for instructions
sqlite> .output test.log
sqlite> .read test.sql
sqlite> .output stdout
sqlite> .q

The file test.log should have the following contents:

---8<---8<---8<---8<---
current schema:
 
creating temporary table...
 
current schema:
CREATE TABLE tmp01 (id integer primary key, word text);
 
temporary table contents:
1|think
2|plan
3|do
 
switch to using memory for temporary storage...
current schema:
 
creating temporary table...
 
current schema:
CREATE TABLE tmp01 (id integer primary key, word text);
 
temporary table contents:
1|think
2|plan
3|do
 
switch to using files for temporary storage...
current schema:
 
---8<---8<---8<---8<---

