From 018586c2aad72ee2944105d443ec98eb02aa8974 Mon Sep 17 00:00:00 2001 From: Karen Arutyunov Date: Wed, 29 Jan 2020 23:08:12 +0300 Subject: Release version 3.27.2+1 Enable zlib usage Stop using cc.poptions variable as it now come after c.poptions --- sqlite3/testscript | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 sqlite3/testscript (limited to 'sqlite3/testscript') 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' +} -- cgit v1.1