1 /*
2 * Copyright (c) 2023 Huawei Device Co., Ltd.
3 * Licensed under the Apache License, Version 2.0 (the "License");
4 * you may not use this file except in compliance with the License.
5 * You may obtain a copy of the License at
6 *
7 * http://www.apache.org/licenses/LICENSE-2.0
8 *
9 * Unless required by applicable law or agreed to in writing, software
10 * distributed under the License is distributed on an "AS IS" BASIS,
11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12 * See the License for the specific language governing permissions and
13 * limitations under the License.
14 */
15 #include "sql_util.h"
16
17 namespace OHOS {
18 namespace HiviewDFX {
19 namespace SqlUtil {
CreateTable(const std::string & table,const std::vector<std::pair<std::string,std::string>> & fields)20 std::string CreateTable(const std::string& table, const std::vector<std::pair<std::string, std::string>>& fields)
21 {
22 // default field: seq
23 std::string sql = "CREATE TABLE IF NOT EXISTS " + table + "(" + "seq INTEGER PRIMARY KEY AUTOINCREMENT";
24 for (auto field : fields) {
25 sql += ", " + field.first + " " + field.second;
26 }
27 sql += ")";
28 return sql;
29 }
30
DropTable(const std::string & table)31 std::string DropTable(const std::string& table)
32 {
33 std::string sql = "DROP TABLE IF EXISTS " + table;
34 return sql;
35 }
36 } // namespace SqlUtil
37 } // namespace HiviewDFX
38 } // namespace OHOS
39