summaryrefslogtreecommitdiff
path: root/chromium/components/offline_pages/core/background/request_queue_store_sql.cc
diff options
context:
space:
mode:
Diffstat (limited to 'chromium/components/offline_pages/core/background/request_queue_store_sql.cc')
-rw-r--r--chromium/components/offline_pages/core/background/request_queue_store_sql.cc47
1 files changed, 24 insertions, 23 deletions
diff --git a/chromium/components/offline_pages/core/background/request_queue_store_sql.cc b/chromium/components/offline_pages/core/background/request_queue_store_sql.cc
index b601100955b..1f8342fc15f 100644
--- a/chromium/components/offline_pages/core/background/request_queue_store_sql.cc
+++ b/chromium/components/offline_pages/core/background/request_queue_store_sql.cc
@@ -35,21 +35,22 @@ using SuccessCallback = base::OnceCallback<void(bool)>;
const bool kUserRequested = true;
bool CreateRequestQueueTable(sql::Connection* db) {
- const char kSql[] = "CREATE TABLE IF NOT EXISTS " REQUEST_QUEUE_TABLE_NAME
- " (request_id INTEGER PRIMARY KEY NOT NULL,"
- " creation_time INTEGER NOT NULL,"
- " activation_time INTEGER NOT NULL DEFAULT 0,"
- " last_attempt_time INTEGER NOT NULL DEFAULT 0,"
- " started_attempt_count INTEGER NOT NULL,"
- " completed_attempt_count INTEGER NOT NULL,"
- " state INTEGER NOT NULL DEFAULT 0,"
- " url VARCHAR NOT NULL,"
- " client_namespace VARCHAR NOT NULL,"
- " client_id VARCHAR NOT NULL,"
- " original_url VARCHAR NOT NULL DEFAULT '',"
- " request_origin VARCHAR NOT NULL DEFAULT '',"
- " fail_state INTEGER NOT NULL DEFAULT 0"
- ")";
+ static const char kSql[] =
+ "CREATE TABLE IF NOT EXISTS " REQUEST_QUEUE_TABLE_NAME
+ " (request_id INTEGER PRIMARY KEY NOT NULL,"
+ " creation_time INTEGER NOT NULL,"
+ " activation_time INTEGER NOT NULL DEFAULT 0,"
+ " last_attempt_time INTEGER NOT NULL DEFAULT 0,"
+ " started_attempt_count INTEGER NOT NULL,"
+ " completed_attempt_count INTEGER NOT NULL,"
+ " state INTEGER NOT NULL DEFAULT 0,"
+ " url VARCHAR NOT NULL,"
+ " client_namespace VARCHAR NOT NULL,"
+ " client_id VARCHAR NOT NULL,"
+ " original_url VARCHAR NOT NULL DEFAULT '',"
+ " request_origin VARCHAR NOT NULL DEFAULT '',"
+ " fail_state INTEGER NOT NULL DEFAULT 0"
+ ")";
return db->Execute(kSql);
}
@@ -66,7 +67,7 @@ bool UpgradeWithQuery(sql::Connection* db, const char* upgrade_sql) {
}
bool UpgradeFrom57(sql::Connection* db) {
- const char kSql[] =
+ static const char kSql[] =
"INSERT INTO " REQUEST_QUEUE_TABLE_NAME
" (request_id, creation_time, activation_time, last_attempt_time, "
"started_attempt_count, completed_attempt_count, state, url, "
@@ -80,7 +81,7 @@ bool UpgradeFrom57(sql::Connection* db) {
}
bool UpgradeFrom58(sql::Connection* db) {
- const char kSql[] =
+ static const char kSql[] =
"INSERT INTO " REQUEST_QUEUE_TABLE_NAME
" (request_id, creation_time, activation_time, last_attempt_time, "
"started_attempt_count, completed_attempt_count, state, url, "
@@ -94,7 +95,7 @@ bool UpgradeFrom58(sql::Connection* db) {
}
bool UpgradeFrom61(sql::Connection* db) {
- const char kSql[] =
+ static const char kSql[] =
"INSERT INTO " REQUEST_QUEUE_TABLE_NAME
" (request_id, creation_time, activation_time, last_attempt_time, "
"started_attempt_count, completed_attempt_count, state, url, "
@@ -183,7 +184,7 @@ std::unique_ptr<SavePageRequest> MakeSavePageRequest(
// Get a request for a specific id.
std::unique_ptr<SavePageRequest> GetOneRequest(sql::Connection* db,
const int64_t request_id) {
- const char kSql[] =
+ static const char kSql[] =
"SELECT request_id, creation_time, activation_time,"
" last_attempt_time, started_attempt_count, completed_attempt_count,"
" state, url, client_namespace, client_id, original_url, request_origin,"
@@ -199,7 +200,7 @@ std::unique_ptr<SavePageRequest> GetOneRequest(sql::Connection* db,
}
ItemActionStatus DeleteRequestById(sql::Connection* db, int64_t request_id) {
- const char kSql[] =
+ static const char kSql[] =
"DELETE FROM " REQUEST_QUEUE_TABLE_NAME " WHERE request_id=?";
sql::Statement statement(db->GetCachedStatement(SQL_FROM_HERE, kSql));
statement.BindInt64(0, request_id);
@@ -211,7 +212,7 @@ ItemActionStatus DeleteRequestById(sql::Connection* db, int64_t request_id) {
}
ItemActionStatus Insert(sql::Connection* db, const SavePageRequest& request) {
- const char kSql[] =
+ static const char kSql[] =
"INSERT OR IGNORE INTO " REQUEST_QUEUE_TABLE_NAME
" (request_id, creation_time, activation_time,"
" last_attempt_time, started_attempt_count, completed_attempt_count,"
@@ -244,7 +245,7 @@ ItemActionStatus Insert(sql::Connection* db, const SavePageRequest& request) {
}
ItemActionStatus Update(sql::Connection* db, const SavePageRequest& request) {
- const char kSql[] =
+ static const char kSql[] =
"UPDATE OR IGNORE " REQUEST_QUEUE_TABLE_NAME
" SET creation_time = ?, activation_time = ?, last_attempt_time = ?,"
" started_attempt_count = ?, completed_attempt_count = ?, state = ?,"
@@ -328,7 +329,7 @@ bool InitDatabase(sql::Connection* db, const base::FilePath& path) {
void GetRequestsSync(sql::Connection* db,
scoped_refptr<base::SingleThreadTaskRunner> runner,
RequestQueueStore::GetRequestsCallback callback) {
- const char kSql[] =
+ static const char kSql[] =
"SELECT request_id, creation_time, activation_time,"
" last_attempt_time, started_attempt_count, completed_attempt_count,"
" state, url, client_namespace, client_id, original_url, request_origin,"