# create the mailboxes from the database
doveadm -u "local"  mailbox create "a.b1.c1" "a.b1.c2" "a.b2.c" "a2"
doveadm -u "remote" mailbox create "a.b1.c1" "a.b1.c2" "a.b2.c" "a2"

# import an existing non-migrated database
sqlite3 "$XDG_DATA_HOME/interimap/remote.db" <"$TESTDIR/before.sql" || error "Couldn't import DB"

# migrate
interimap || error "Couldn't upgrade DB"

grep -Fx "Upgrading database version from 0" <"$STDERR" || error "Couldn't upgrade DB"
check_mailboxes_status "a.b1.c1" "a.b1.c2" "a.b2.c" "a2"

# verify that the new schema is as expected
sqlite3 "$XDG_DATA_HOME/interimap/remote.db" >"$TMPDIR/dump.sql" <<-EOF
	DELETE FROM local;
	DELETE FROM remote;
	.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" \
    "$TMPDIR/dump-expected.sql" "$TMPDIR/dump.sql" \
    || error "DB dumps differ"

# vim: set filetype=sh :