[Payments] Set cached manifest expiration date

components/payments/android/web_app_manifest_section_table.cc

 // Copyright 2017 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/payments/android/web_app_manifest_section_table.h"
 
 #include <stdint.h>
-
+#include <time.h>
 #include <memory>
 
+#include "base/time/time.h"
 #include "sql/statement.h"
 #include "sql/transaction.h"
 
 namespace payments {
 namespace {
+// Data valid duration in seconds.
+const time_t DATA_VALID_TIME_IN_SECONDS = 90 * 24 * 60 * 60;
 
 // Note that the fingerprint is calculated with SHA-256.
 const size_t kFingerPrintLength = 32;
 
 WebDatabaseTable::TypeKey GetKey() {
   // We just need a unique constant. Use the address of a static that
   // COMDAT folding won't touch in an optimizing linker.
   static int table_key = 0;
   return reinterpret_cast<void*>(&table_key);
 }
@@ skipping 39 matching lines @@
     WebDatabase* db) {
   return static_cast<WebAppManifestSectionTable*>(db->GetTable(GetKey()));
 }
 
 WebDatabaseTable::TypeKey WebAppManifestSectionTable::GetTypeKey() const {
   return GetKey();
 }
 
 bool WebAppManifestSectionTable::CreateTablesIfNecessary() {
   if (!db_->Execute("CREATE TABLE IF NOT EXISTS web_app_manifest_section ( "
+                    "expire_date INTEGER NOT NULL DEFAULT 0, "
                     "id VARCHAR, "
                     "min_version INTEGER NOT NULL DEFAULT 0, "
                     "fingerprints BLOB) ")) {
     NOTREACHED();
     return false;
   }
 
   return true;
 }
 
 bool WebAppManifestSectionTable::IsSyncable() {
   return false;
 }
 
 bool WebAppManifestSectionTable::MigrateToVersion(
     int version,
     bool* update_compatible_version) {
   return true;
 }
 
+void WebAppManifestSectionTable::RemoveExpiredData() {
+  const time_t now_date_in_seconds = base::Time::NowFromSystemTime().ToTimeT();
+  sql::Statement s(db_->GetUniqueStatement(
+      "DELETE FROM web_app_manifest_section WHERE expire_date < ? "));
+  s.BindInt64(0, now_date_in_seconds);
+  s.Run();
+}
+
 bool WebAppManifestSectionTable::AddWebAppManifest(
     const std::vector<mojom::WebAppManifestSectionPtr>& manifest) {
   DCHECK_LT(0U, manifest.size());
 
   sql::Transaction transaction(db_);
   if (!transaction.Begin())
     return false;
 
   sql::Statement s1(db_->GetUniqueStatement(
       "DELETE FROM web_app_manifest_section WHERE id=? "));
   s1.BindString(0, manifest[0]->id);
   if (!s1.Run())
     return false;
 
   sql::Statement s2(
       db_->GetUniqueStatement("INSERT INTO web_app_manifest_section "
-                              "(id, min_version, fingerprints) "
-                              "VALUES (?, ?, ?)"));
+                              "(expire_date, id, min_version, fingerprints) "
+                              "VALUES (?, ?, ?, ?)"));
+  const time_t expire_date_in_seconds =
+      base::Time::NowFromSystemTime().ToTimeT() + DATA_VALID_TIME_IN_SECONDS;
   for (const auto& section : manifest) {
     DCHECK_EQ(manifest[0]->id, section->id);
     int index = 0;
+    s2.BindInt64(index++, expire_date_in_seconds);
     s2.BindString(index++, section->id);
     s2.BindInt64(index++, section->min_version);
     std::unique_ptr<std::vector<uint8_t>> serialized_fingerprints =
         SerializeFingerPrints(section->fingerprints);
     s2.BindBlob(index, serialized_fingerprints->data(),
                 serialized_fingerprints->size());
     if (!s2.Run())
       return false;
     s2.Reset(true);
   }
@@ skipping 32 matching lines @@
       break;
     }
 
     manifest.emplace_back(std::move(section));
   }
 
   return manifest;
 }
 
 }  // namespace payments