1 /*
2 * Copyright (C) 2020 The Android Open Source Project
3 *
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
7 *
8 * http://www.apache.org/licenses/LICENSE-2.0
9 *
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
15 */
16
17 #include "src/trace_processor/sqlite/sqlite_utils.h"
18
19 #include "test/gtest_and_gmock.h"
20
21 namespace perfetto {
22 namespace trace_processor {
23 namespace sqlite_utils {
24
25 namespace {
26
27 class GetColumnsForTableTest : public ::testing::Test {
28 public:
GetColumnsForTableTest()29 GetColumnsForTableTest() {
30 sqlite3* db = nullptr;
31 PERFETTO_CHECK(sqlite3_initialize() == SQLITE_OK);
32 PERFETTO_CHECK(sqlite3_open(":memory:", &db) == SQLITE_OK);
33 db_.reset(db);
34 }
35
PrepareValidStatement(const std::string & sql)36 void PrepareValidStatement(const std::string& sql) {
37 int size = static_cast<int>(sql.size());
38 sqlite3_stmt* stmt;
39 ASSERT_EQ(sqlite3_prepare_v2(*db_, sql.c_str(), size, &stmt, nullptr),
40 SQLITE_OK);
41 stmt_.reset(stmt);
42 }
43
RunStatement(const std::string & sql)44 void RunStatement(const std::string& sql) {
45 PrepareValidStatement(sql);
46 ASSERT_EQ(sqlite3_step(stmt_.get()), SQLITE_DONE);
47 }
48
49 protected:
50 ScopedDb db_;
51 ScopedStmt stmt_;
52 };
53
TEST_F(GetColumnsForTableTest,ValidInput)54 TEST_F(GetColumnsForTableTest, ValidInput) {
55 RunStatement("CREATE TABLE foo (name STRING, ts INT, dur INT);");
56 std::vector<SqliteTable::Column> columns;
57 auto status = sqlite_utils::GetColumnsForTable(*db_, "foo", columns);
58 ASSERT_TRUE(status.ok());
59 }
60
TEST_F(GetColumnsForTableTest,UnknownType)61 TEST_F(GetColumnsForTableTest, UnknownType) {
62 // Currently GetColumnsForTable does not work with tables containing types it
63 // doesn't recognise. This just ensures that the query fails rather than
64 // crashing.
65 RunStatement("CREATE TABLE foo (name NUM, ts INT, dur INT);");
66 std::vector<SqliteTable::Column> columns;
67 auto status = sqlite_utils::GetColumnsForTable(*db_, "foo", columns);
68 ASSERT_FALSE(status.ok());
69 }
70
TEST_F(GetColumnsForTableTest,UnknownTableName)71 TEST_F(GetColumnsForTableTest, UnknownTableName) {
72 std::vector<SqliteTable::Column> columns;
73 auto status = sqlite_utils::GetColumnsForTable(*db_, "unknowntable", columns);
74 ASSERT_FALSE(status.ok());
75 }
76
TEST(SqliteUtilsTest,ExtractFromSqlValueInt32)77 TEST(SqliteUtilsTest, ExtractFromSqlValueInt32) {
78 std::optional<int32_t> int32;
79
80 static constexpr int64_t kMin = std::numeric_limits<int32_t>::min();
81 static constexpr int64_t kMax = std::numeric_limits<int32_t>::max();
82
83 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(1234), int32).ok());
84 ASSERT_EQ(*int32, 1234);
85
86 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(kMin), int32).ok());
87 ASSERT_EQ(*int32, kMin);
88
89 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(kMax), int32).ok());
90 ASSERT_EQ(*int32, kMax);
91
92 ASSERT_TRUE(ExtractFromSqlValue(SqlValue(), int32).ok());
93 ASSERT_FALSE(int32.has_value());
94
95 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::Long(kMax + 1), int32).ok());
96 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::Double(1.0), int32).ok());
97 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::String("foo"), int32).ok());
98 }
99
TEST(SqliteUtilsTest,ExtractFromSqlValueUint32)100 TEST(SqliteUtilsTest, ExtractFromSqlValueUint32) {
101 std::optional<uint32_t> uint32;
102
103 static constexpr int64_t kMin = std::numeric_limits<uint32_t>::min();
104 static constexpr int64_t kMax = std::numeric_limits<uint32_t>::max();
105
106 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(1234), uint32).ok());
107 ASSERT_EQ(*uint32, 1234u);
108
109 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(kMin), uint32).ok());
110 ASSERT_EQ(*uint32, kMin);
111
112 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(kMax), uint32).ok());
113 ASSERT_EQ(*uint32, kMax);
114
115 ASSERT_TRUE(ExtractFromSqlValue(SqlValue(), uint32).ok());
116 ASSERT_FALSE(uint32.has_value());
117
118 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::Long(kMax + 1), uint32).ok());
119 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::Double(1.0), uint32).ok());
120 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::String("foo"), uint32).ok());
121 }
122
TEST(SqliteUtilsTest,ExtractFromSqlValueInt64)123 TEST(SqliteUtilsTest, ExtractFromSqlValueInt64) {
124 std::optional<int64_t> int64;
125
126 static constexpr int64_t kMin = std::numeric_limits<int64_t>::min();
127 static constexpr int64_t kMax = std::numeric_limits<int64_t>::max();
128
129 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(1234), int64).ok());
130 ASSERT_EQ(*int64, 1234);
131
132 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(kMin), int64).ok());
133 ASSERT_EQ(*int64, kMin);
134
135 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Long(kMax), int64).ok());
136 ASSERT_EQ(*int64, kMax);
137
138 ASSERT_TRUE(ExtractFromSqlValue(SqlValue(), int64).ok());
139 ASSERT_FALSE(int64.has_value());
140
141 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::Double(1.0), int64).ok());
142 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::String("foo"), int64).ok());
143 }
144
TEST(SqliteUtilsTest,ExtractFromSqlValueDouble)145 TEST(SqliteUtilsTest, ExtractFromSqlValueDouble) {
146 std::optional<double> doub;
147
148 static constexpr double kMin = std::numeric_limits<double>::min();
149 static constexpr double kMax = std::numeric_limits<double>::max();
150
151 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Double(1234.1), doub).ok());
152 ASSERT_EQ(*doub, 1234.1);
153
154 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Double(kMin), doub).ok());
155 ASSERT_EQ(*doub, kMin);
156
157 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::Double(kMax), doub).ok());
158 ASSERT_EQ(*doub, kMax);
159
160 ASSERT_TRUE(ExtractFromSqlValue(SqlValue(), doub).ok());
161 ASSERT_FALSE(doub.has_value());
162
163 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::Long(1234), doub).ok());
164 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::String("foo"), doub).ok());
165 }
166
TEST(SqliteUtilsTest,ExtractFromSqlValueString)167 TEST(SqliteUtilsTest, ExtractFromSqlValueString) {
168 std::optional<const char*> string;
169
170 ASSERT_TRUE(ExtractFromSqlValue(SqlValue::String("foo"), string).ok());
171 ASSERT_STREQ(*string, "foo");
172
173 ASSERT_TRUE(ExtractFromSqlValue(SqlValue(), string).ok());
174 ASSERT_FALSE(string.has_value());
175
176 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::Long(1234), string).ok());
177 ASSERT_FALSE(ExtractFromSqlValue(SqlValue::Double(123.1), string).ok());
178 }
179
180 } // namespace
181 } // namespace sqlite_utils
182 } // namespace trace_processor
183 } // namespace perfetto
184