aboutsummaryrefslogtreecommitdiffstats
path: root/tests/00-db-migration-0-to-1/run
diff options
context:
space:
mode:
authorGustav Eek <gustav.eek@fripost.org>2019-06-27 21:03:23 +0200
committerGuilhem Moulin <guilhem@fripost.org>2019-06-27 21:20:31 +0200
commitb62c567af680d569ee3c6393de77468dfc874288 (patch)
tree4dc33be6c963fb97c67f48b90013b46bf2843f3b /tests/00-db-migration-0-to-1/run
parent53ea6efb89aade69c921fc57ad809eb61e9133a8 (diff)
test suite: import+dump before comparing SQLite dumps.
The dumping quoting style differ between sqlite versions. Compensate with re-dumping also the reference file
Diffstat (limited to 'tests/00-db-migration-0-to-1/run')
-rw-r--r--tests/00-db-migration-0-to-1/run9
1 files changed, 8 insertions, 1 deletions
diff --git a/tests/00-db-migration-0-to-1/run b/tests/00-db-migration-0-to-1/run
index e4eb770..757fe04 100644
--- a/tests/00-db-migration-0-to-1/run
+++ b/tests/00-db-migration-0-to-1/run
@@ -18,9 +18,16 @@ sqlite3 "$XDG_DATA_HOME/interimap/remote.db" >"$TMPDIR/dump.sql" <<-EOF
.dump
EOF
+# re-import and dump the expected dump to work around SQLite format
+# differences across versions
+sqlite3 "$XDG_DATA_HOME/interimap/remote2.db" <"$TESTDIR/after.sql"
+sqlite3 "$XDG_DATA_HOME/interimap/remote2.db" >"$TMPDIR/dump-expected.sql" <<-EOF
+ .dump
+EOF
+
# XXX need 'user_version' PRAGMA in the dump for future migrations
# http://sqlite.1065341.n5.nabble.com/dump-command-and-user-version-td101228.html
diff -u --label="a/dump.sql" --label="b/dump.sql" \
- "$TESTDIR/after.sql" "$TMPDIR/dump.sql"
+ "$TMPDIR/dump-expected.sql" "$TMPDIR/dump.sql"
# vim: set filetype=sh :