diff options
author | Karen Arutyunov <karen@codesynthesis.com> | 2020-01-29 23:08:12 +0300 |
---|---|---|
committer | Karen Arutyunov <karen@codesynthesis.com> | 2020-01-29 23:08:12 +0300 |
commit | 018586c2aad72ee2944105d443ec98eb02aa8974 (patch) | |
tree | 0a4585c2fde5f3e430ee6100a1bb2fc9a16bb387 /sqlite3/testscript | |
parent | 0a054f609f7022f7d27f59094041641b8b48b3d8 (diff) |
Release version 3.27.2+1v3.27.2+1
Enable zlib usage
Stop using cc.poptions variable as it now come after c.poptions
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' +} |