From fc3fb39c90ab7fe5fccbe3f3bc0eb2645157bb96 Mon Sep 17 00:00:00 2001
From: Karen Arutyunov <karen@codesynthesis.com>
Date: Wed, 13 Dec 2023 21:57:53 +0300
Subject: Switch to build2

---
 common/query/basics/testscript | 150 +++++++++++++++++++++++++++++++++++++++++
 1 file changed, 150 insertions(+)
 create mode 100644 common/query/basics/testscript

(limited to 'common/query/basics/testscript')

diff --git a/common/query/basics/testscript b/common/query/basics/testscript
new file mode 100644
index 0000000..9086b66
--- /dev/null
+++ b/common/query/basics/testscript
@@ -0,0 +1,150 @@
+# file      : common/query/basics/testscript
+# license   : GNU GPL v2; see accompanying LICENSE file
+
+.include ../../../database-options.testscript
+
++cat <<EOI >=output
+  test 001
+  John Doe 30 married
+  Jane Doe 29 married
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+  test 002
+  Jane Doe 29 married
+  John Doe 30 married
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  test 003
+  John Doe 30 married
+
+  test 004
+  John Doe 30 married
+
+  test 005
+  John Doe 30 married
+
+  Joe Squeaky Dirt 31 single
+
+  test 006
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  test 007
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  test 008
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+
+  John Doe 30 married
+  Jane Doe 29 married
+
+  test 009
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  test 010
+  Jane Doe 29 married
+
+  John Doe 30 married
+  Jane Doe 29 married
+  Joe Squeaky Dirt 31 single
+
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  Jane Doe 29 married
+  John Doe 30 married
+
+  test 011
+  John Doe 30 married
+  Jane Doe 29 married
+
+  John Doe 30 married
+  Jane Doe 29 married
+  Joe Squeaky Dirt 31 single
+
+  test 012
+  Johansen J Johansen 32 single
+
+  test 013
+  Joe Squeaky Dirt 31 single
+
+  test 014
+  test 015
+  John Doe 30 married
+  Jane Doe 29 married
+
+  test 016
+  test 017
+  test 018
+  test 019
+  test 020
+  John Doe 30 married
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  Jane Doe 29 married
+
+
+  Jane Doe 29 married
+
+  EOI
+
+test.redirects += >>>../output
+
+: mysql
+:
+if $mysql
+{
+  .include ../../../mysql.testscript
+
+  $create_schema;
+  $*
+}
+
+: sqlite
+:
+if $sqlite
+{
+  .include ../../../sqlite.testscript
+
+  $*
+}
+
+: pgsql
+:
+if $pgsql
+{
+  .include ../../../pgsql.testscript
+
+  $create_schema;
+  $*
+}
-- 
cgit v1.1