diff options
Diffstat (limited to 'sqlite3/testscript')
-rw-r--r-- | sqlite3/testscript | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sqlite3/testscript b/sqlite3/testscript new file mode 100644 index 0000000..cfc48c8 --- /dev/null +++ b/sqlite3/testscript @@ -0,0 +1,23 @@ +# file : testscript +# copyright : not copyrighted - public domain + +: basics +: +{ + sql = 'CREATE TABLE test (id INTEGER PRIMARY KEY); +INSERT INTO test VALUES(123); +SELECT * FROM test;' + + $* ':memory:' "$sql" >'123' +} + +: archive +: +{ + echo 'abc' >=f.txt; + $* f.sqlar -Ac f.txt &f.sqlar; # Creates archive adding a file. + $* f.sqlar -At >f.txt; # Lists files in archive. + rm f.txt; + $* f.sqlar -Ax; # Extracts files from archive. + cat f.txt >'abc' +} |