[Offline pages] Hooking up SQL store to Offline RequestQueue

components/offline_pages/background/request_queue_store_unittest.cc

 // Copyright 2016 The Chromium Authors. All rights reserved.
 // Use of this source code is governed by a BSD-style license that can be
 // found in the LICENSE file.
 
 #include "components/offline_pages/background/request_queue_store.h"
 
 #include <memory>
 
 #include "base/bind.h"
 #include "base/files/file_path.h"
@@ skipping 293 matching lines @@
   ASSERT_EQ(LastResult::kTrue, this->last_result());
   this->ClearResults();
 
   store->GetRequests(base::Bind(&RequestQueueStoreTestBase::GetRequestsDone,
                                 base::Unretained(this)));
   this->PumpLoop();
   ASSERT_EQ(LastResult::kTrue, this->last_result());
   ASSERT_TRUE(this->last_requests().empty());
 }
 
+class RequestQueueStoreSQLTest
+    : public RequestQueueStoreTest<RequestQueueStoreSQLFactory> {};
+
+// Makes sure that persistent DB is actually persisting requests across store
+// restarts.
+TEST_F(RequestQueueStoreSQLTest, SaveCloseReopenRead) {
+  std::unique_ptr<RequestQueueStore> store(BuildStore());
+  base::Time creation_time = base::Time::Now();
+  SavePageRequest original_request(kRequestId, kUrl, kClientId, creation_time);
+  store->AddOrUpdateRequest(
+      original_request, base::Bind(&RequestQueueStoreTestBase::AddOrUpdateDone,
+                                   base::Unretained(this)));
+  PumpLoop();
+  ClearResults();
+
+  // Resets the store, using the same temp directory. The contents should be
+  // intact. First reset is done separately to release DB lock.
+  store.reset();
+  store = BuildStore();
+  store->GetRequests(base::Bind(&RequestQueueStoreTestBase::GetRequestsDone,
+                                base::Unretained(this)));
+  ASSERT_EQ(LastResult::kNone, this->last_result());
+  this->PumpLoop();
+  ASSERT_EQ(LastResult::kTrue, this->last_result());
+  ASSERT_EQ(1ul, this->last_requests().size());
+  ASSERT_TRUE(original_request == this->last_requests()[0]);
+}
+
 }  // offline_pages