Add evolution tests to odb-tests

Also clean up some buildfiles and manifests.

1 files changed, 54 insertions, 0 deletions

diff --git a/odb-tests/evolution/data/testscript b/odb-tests/evolution/data/testscript
new file mode 100644
index 0000000..5c91396
--- /dev/null
+++ b/odb-tests/evolution/data/testscript
@@ -0,0 +1,54 @@
+# file      : evolution/data/testscript
+# license   : GNU GPL v2; see accompanying LICENSE file
+
+.include ../../database-options.testscript
+.include ../../$db-schema.testscript
+
+test.arguments += $($(db)_options)
+
+: basics
+:
+if! $sqlite
+{
+  ss =; # Schema modification base file names.
+
+  # Drop everything.
+  #
+  for s: $schemas
+    ss =+ $s
+  end;
+
+  # Add base schema.
+  #
+  ss += test3-002-pre test3-002-post;
+
+  # Add migration.
+  #
+  ss += test3-003-pre test3-003-post;
+
+  # Run tests.
+  #
+  for s: $ss
+    f = $out_base/"$s".sql
+
+    if $mysql
+      cat $f | $create_schema_cmd
+    elif $pgsql
+      $create_schema_cmd -f $f
+    end
+
+    if ($s == 'test3-002-post')
+      $* 1
+    elif ($s == 'test3-003-pre')
+      $* 2
+    elif ($s == 'test3-003-post')
+      $* 3
+    end
+  end
+}
+else
+{
+  $* 1 &odb-test.db;
+  $* 2;
+  $* 3
+}