From 2640109887655b3aa0cb1a2d06ddb093282d03b7 Mon Sep 17 00:00:00 2001
From: "Thiago Marcos P. Santos" <tmpsantos@gmail.com>
Date: Mon, 21 Aug 2017 17:58:36 +0300
Subject: [tests] Enforce the schema downgrade behavior

Which is, delete and recreate the database.
---
 test/fixtures/offline_database/v999.db | Bin 0 -> 19456 bytes
 test/storage/offline_database.test.cpp |  24 ++++++++++++++++++++++++
 2 files changed, 24 insertions(+)
 create mode 100644 test/fixtures/offline_database/v999.db

diff --git a/test/fixtures/offline_database/v999.db b/test/fixtures/offline_database/v999.db
new file mode 100644
index 0000000000..97c36cce36
Binary files /dev/null and b/test/fixtures/offline_database/v999.db differ
diff --git a/test/storage/offline_database.test.cpp b/test/storage/offline_database.test.cpp
index 872310e46f..243d0dc43c 100644
--- a/test/storage/offline_database.test.cpp
+++ b/test/storage/offline_database.test.cpp
@@ -698,3 +698,27 @@ TEST(OfflineDatabase, MigrateFromV4Schema) {
     // Synchronous setting should be FULL (2) after migration to v5.
     EXPECT_EQ(2, databaseSyncMode("test/fixtures/offline_database/v5.db"));
 }
+
+TEST(OfflineDatabase, DowngradeSchema) {
+    using namespace mbgl;
+
+    // v999.db is a v999 database, it should be deleted
+    // and recreated with the current schema.
+
+    deleteFile("test/fixtures/offline_database/migrated.db");
+    writeFile("test/fixtures/offline_database/migrated.db", util::read_file("test/fixtures/offline_database/v999.db"));
+
+    {
+        OfflineDatabase db("test/fixtures/offline_database/migrated.db", 0);
+    }
+
+    EXPECT_EQ(5, databaseUserVersion("test/fixtures/offline_database/migrated.db"));
+
+    EXPECT_EQ((std::vector<std::string>{ "id", "url_template", "pixel_ratio", "z", "x", "y",
+                                         "expires", "modified", "etag", "data", "compressed",
+                                         "accessed" }),
+              databaseTableColumns("test/fixtures/offline_database/migrated.db", "tiles"));
+    EXPECT_EQ((std::vector<std::string>{ "id", "url", "kind", "expires", "modified", "etag", "data",
+                                         "compressed", "accessed" }),
+              databaseTableColumns("test/fixtures/offline_database/migrated.db", "resources"));
+}
-- 
cgit v1.2.1