blob: e4620dc0956faf5bb7075d38f262a3399c892780 [file] [log] [blame]
// 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/sqlite_proto/key_value_table.h"
#include <stdint.h>
#include "base/strings/stringprintf.h"
#include "third_party/protobuf/src/google/protobuf/message_lite.h"
namespace sqlite_proto {
namespace internal {
void BindDataToStatement(const std::string& key,
const google::protobuf::MessageLite& data,
sql::Statement* statement) {
statement->BindString(0, key);
size_t size = data.ByteSizeLong();
std::vector<uint8_t> proto_buffer(size);
data.SerializeToArray(proto_buffer.data(), size);
statement->BindBlob(1, proto_buffer);
}
std::string GetSelectAllSql(const std::string& table_name) {
return base::StringPrintf("SELECT * FROM %s", table_name.c_str());
}
std::string GetReplaceSql(const std::string& table_name) {
return base::StringPrintf("REPLACE INTO %s (key, proto) VALUES (?,?)",
table_name.c_str());
}
std::string GetDeleteSql(const std::string& table_name) {
return base::StringPrintf("DELETE FROM %s WHERE key=?", table_name.c_str());
}
std::string GetDeleteAllSql(const std::string& table_name) {
return base::StringPrintf("DELETE FROM %s", table_name.c_str());
}
} // namespace internal
} // namespace sqlite_proto