summaryrefslogtreecommitdiff
path: root/sqlite3/testscript
diff options
context:
space:
mode:
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'
+}