summaryrefslogtreecommitdiff
path: root/sqlite3/testscript
diff options
context:
space:
mode:
authorKaren Arutyunov <karen@codesynthesis.com>2020-01-29 23:08:12 +0300
committerKaren Arutyunov <karen@codesynthesis.com>2020-01-29 23:08:12 +0300
commit018586c2aad72ee2944105d443ec98eb02aa8974 (patch)
tree0a4585c2fde5f3e430ee6100a1bb2fc9a16bb387 /sqlite3/testscript
parent0a054f609f7022f7d27f59094041641b8b48b3d8 (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/testscript23
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'
+}