[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 <memory>
 
+#include "base/time/time.h"
 #include "sql/statement.h"
 #include "sql/transaction.h"
 
 namespace payments {
 namespace {
+// Data valid time in seconds.
+const time_t DATA_VALID_TIME_IN_SECONDS = 90 * 24 * 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;
 }
 
@@ skipping 16 matching lines @@
     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::Now().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);
   }
 
   if (!transaction.Commit())
     return false;
 
   return true;
 }
 
 std::vector<mojom::WebAppManifestSectionPtr>
 WebAppManifestSectionTable::GetWebAppManifest(const std::string& web_app) {
-  sql::Statement s(
-      db_->GetUniqueStatement("SELECT id, min_version, fingerprints "
-                              "FROM web_app_manifest_section "
-                              "WHERE id=?"));
+  sql::Statement s(db_->GetUniqueStatement(
+      "SELECT expire_date, id, min_version, fingerprints "
+      "FROM web_app_manifest_section "
+      "WHERE id=?"));
   s.BindString(0, web_app);
 
+  const time_t now_time_in_seconds = base::Time::Now().ToTimeT();
   std::vector<mojom::WebAppManifestSectionPtr> manifest;
   while (s.Step()) {
+    int index = 0;
+    if (now_time_in_seconds > s.ColumnInt64(index++)) {
+      manifest.clear();
+      break;
+    }
+
     mojom::WebAppManifestSectionPtr section =
         mojom::WebAppManifestSection::New();
 
-    int index = 0;
     section->id = s.ColumnString(index++);
     section->min_version = s.ColumnInt64(index++);
 
     std::vector<uint8_t> fingerprints;
     if (!s.ColumnBlobAsVector(index, &fingerprints)) {
       manifest.clear();
       break;
     }
 
     if (!DeserializeFingerPrints(fingerprints, section->fingerprints)) {
       manifest.clear();
       break;
     }
 
     manifest.emplace_back(std::move(section));
   }
 
   return manifest;
 }
 
 }  // namespace payments