Mercurial > hg > orthanc
annotate UnitTestsSources/SQLiteChromiumTests.cpp @ 1751:fb569ee09a69 db-changes
LookupResource complete
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Tue, 27 Oct 2015 16:05:42 +0100 |
parents | 6e7e5ed91c2d |
children | b1291df2f780 |
rev | line source |
---|---|
827
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
1 /** |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
2 * Orthanc - A Lightweight, RESTful DICOM Store |
1288
6e7e5ed91c2d
upgrade to year 2015
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
967
diff
changeset
|
3 * Copyright (C) 2012-2015 Sebastien Jodogne, Medical Physics |
6e7e5ed91c2d
upgrade to year 2015
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
967
diff
changeset
|
4 * Department, University Hospital of Liege, Belgium |
827
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
5 * |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
6 * This program is free software: you can redistribute it and/or |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
7 * modify it under the terms of the GNU General Public License as |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
8 * published by the Free Software Foundation, either version 3 of the |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
9 * License, or (at your option) any later version. |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
10 * |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
11 * In addition, as a special exception, the copyright holders of this |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
12 * program give permission to link the code of its release with the |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
13 * OpenSSL project's "OpenSSL" library (or with modified versions of it |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
14 * that use the same license as the "OpenSSL" library), and distribute |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
15 * the linked executables. You must obey the GNU General Public License |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
16 * in all respects for all of the code used other than "OpenSSL". If you |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
17 * modify file(s) with this exception, you may extend this exception to |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
18 * your version of the file(s), but you are not obligated to do so. If |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
19 * you do not wish to do so, delete this exception statement from your |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
20 * version. If you delete this exception statement from all source files |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
21 * in the program, then also delete it here. |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
22 * |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
23 * This program is distributed in the hope that it will be useful, but |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
24 * WITHOUT ANY WARRANTY; without even the implied warranty of |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
26 * General Public License for more details. |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
27 * |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
28 * You should have received a copy of the GNU General Public License |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
29 * along with this program. If not, see <http://www.gnu.org/licenses/>. |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
30 **/ |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
31 |
3d6f9b7d0add
precompiled headers in unit tests
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
632
diff
changeset
|
32 |
831
84513f2ee1f3
pch for unit tests and server
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
827
diff
changeset
|
33 #include "PrecompiledHeadersUnitTests.h" |
0 | 34 #include "gtest/gtest.h" |
35 | |
36 #include "../Core/Toolbox.h" | |
37 #include "../Core/SQLite/Connection.h" | |
38 #include "../Core/SQLite/Statement.h" | |
39 #include "../Core/SQLite/Transaction.h" | |
40 | |
41 #include <sqlite3.h> | |
42 | |
138 | 43 |
63 | 44 using namespace Orthanc; |
138 | 45 using namespace Orthanc::SQLite; |
0 | 46 |
47 | |
48 /******************************************************************** | |
49 ** Tests from | |
50 ** http://src.chromium.org/viewvc/chrome/trunk/src/sql/connection_unittest.cc | |
51 ********************************************************************/ | |
52 | |
53 class SQLConnectionTest : public testing::Test | |
54 { | |
55 public: | |
56 SQLConnectionTest() | |
57 { | |
58 } | |
59 | |
60 virtual ~SQLConnectionTest() | |
61 { | |
62 } | |
63 | |
64 virtual void SetUp() | |
65 { | |
66 db_.OpenInMemory(); | |
67 } | |
68 | |
69 virtual void TearDown() | |
70 { | |
71 db_.Close(); | |
72 } | |
73 | |
138 | 74 Connection& db() |
0 | 75 { |
76 return db_; | |
77 } | |
78 | |
79 private: | |
138 | 80 Connection db_; |
0 | 81 }; |
82 | |
83 | |
84 | |
85 TEST_F(SQLConnectionTest, Execute) | |
86 { | |
87 // Valid statement should return true. | |
88 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)")); | |
89 EXPECT_EQ(SQLITE_OK, db().GetErrorCode()); | |
90 | |
91 // Invalid statement should fail. | |
92 ASSERT_EQ(SQLITE_ERROR, | |
93 db().ExecuteAndReturnErrorCode("CREATE TAB foo (a, b")); | |
94 EXPECT_EQ(SQLITE_ERROR, db().GetErrorCode()); | |
95 } | |
96 | |
97 TEST_F(SQLConnectionTest, ExecuteWithErrorCode) { | |
98 ASSERT_EQ(SQLITE_OK, | |
99 db().ExecuteAndReturnErrorCode("CREATE TABLE foo (a, b)")); | |
100 ASSERT_EQ(SQLITE_ERROR, | |
101 db().ExecuteAndReturnErrorCode("CREATE TABLE TABLE")); | |
102 ASSERT_EQ(SQLITE_ERROR, | |
103 db().ExecuteAndReturnErrorCode( | |
138 | 104 "INSERT INTO foo(a, b) VALUES (1, 2, 3, 4)")); |
0 | 105 } |
106 | |
107 TEST_F(SQLConnectionTest, CachedStatement) { | |
138 | 108 StatementId id1("foo", 12); |
0 | 109 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)")); |
110 ASSERT_TRUE(db().Execute("INSERT INTO foo(a, b) VALUES (12, 13)")); | |
111 | |
112 // Create a new cached statement. | |
113 { | |
138 | 114 Statement s(db(), id1, "SELECT a FROM foo"); |
0 | 115 ASSERT_TRUE(s.Step()); |
116 EXPECT_EQ(12, s.ColumnInt(0)); | |
117 } | |
118 | |
119 // The statement should be cached still. | |
120 EXPECT_TRUE(db().HasCachedStatement(id1)); | |
121 | |
122 { | |
123 // Get the same statement using different SQL. This should ignore our | |
124 // SQL and use the cached one (so it will be valid). | |
138 | 125 Statement s(db(), id1, "something invalid("); |
0 | 126 ASSERT_TRUE(s.Step()); |
127 EXPECT_EQ(12, s.ColumnInt(0)); | |
128 } | |
129 | |
130 // Make sure other statements aren't marked as cached. | |
131 EXPECT_FALSE(db().HasCachedStatement(SQLITE_FROM_HERE)); | |
132 } | |
133 | |
134 TEST_F(SQLConnectionTest, IsSQLValidTest) { | |
135 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)")); | |
136 ASSERT_TRUE(db().IsSQLValid("SELECT a FROM foo")); | |
137 ASSERT_FALSE(db().IsSQLValid("SELECT no_exist FROM foo")); | |
138 } | |
139 | |
140 | |
141 | |
142 TEST_F(SQLConnectionTest, DoesStuffExist) { | |
143 // Test DoesTableExist. | |
144 EXPECT_FALSE(db().DoesTableExist("foo")); | |
145 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)")); | |
146 EXPECT_TRUE(db().DoesTableExist("foo")); | |
147 | |
148 // Should be case sensitive. | |
149 EXPECT_FALSE(db().DoesTableExist("FOO")); | |
150 | |
151 // Test DoesColumnExist. | |
152 EXPECT_FALSE(db().DoesColumnExist("foo", "bar")); | |
153 EXPECT_TRUE(db().DoesColumnExist("foo", "a")); | |
154 | |
155 // Testing for a column on a nonexistent table. | |
156 EXPECT_FALSE(db().DoesColumnExist("bar", "b")); | |
157 } | |
158 | |
159 TEST_F(SQLConnectionTest, GetLastInsertRowId) { | |
160 ASSERT_TRUE(db().Execute("CREATE TABLE foo (id INTEGER PRIMARY KEY, value)")); | |
161 | |
162 ASSERT_TRUE(db().Execute("INSERT INTO foo (value) VALUES (12)")); | |
163 | |
164 // Last insert row ID should be valid. | |
165 int64_t row = db().GetLastInsertRowId(); | |
166 EXPECT_LT(0, row); | |
167 | |
168 // It should be the primary key of the row we just inserted. | |
138 | 169 Statement s(db(), "SELECT value FROM foo WHERE id=?"); |
0 | 170 s.BindInt64(0, row); |
171 ASSERT_TRUE(s.Step()); | |
172 EXPECT_EQ(12, s.ColumnInt(0)); | |
173 } | |
174 | |
175 TEST_F(SQLConnectionTest, Rollback) { | |
176 ASSERT_TRUE(db().BeginTransaction()); | |
177 ASSERT_TRUE(db().BeginTransaction()); | |
178 EXPECT_EQ(2, db().GetTransactionNesting()); | |
179 db().RollbackTransaction(); | |
180 EXPECT_FALSE(db().CommitTransaction()); | |
181 EXPECT_TRUE(db().BeginTransaction()); | |
182 } | |
183 | |
184 | |
185 | |
186 | |
187 /******************************************************************** | |
188 ** Tests from | |
189 ** http://src.chromium.org/viewvc/chrome/trunk/src/sql/statement_unittest.cc | |
190 ********************************************************************/ | |
191 | |
138 | 192 namespace Orthanc |
0 | 193 { |
138 | 194 namespace SQLite |
195 { | |
196 class SQLStatementTest : public SQLConnectionTest | |
197 { | |
198 }; | |
0 | 199 |
138 | 200 TEST_F(SQLStatementTest, Run) { |
201 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)")); | |
202 ASSERT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (3, 12)")); | |
0 | 203 |
138 | 204 Statement s(db(), "SELECT b FROM foo WHERE a=?"); |
205 // Stepping it won't work since we haven't bound the value. | |
206 EXPECT_FALSE(s.Step()); | |
0 | 207 |
138 | 208 // Run should fail since this produces output, and we should use Step(). This |
209 // gets a bit wonky since sqlite says this is OK so succeeded is set. | |
210 s.Reset(true); | |
211 s.BindInt(0, 3); | |
212 EXPECT_FALSE(s.Run()); | |
213 EXPECT_EQ(SQLITE_ROW, db().GetErrorCode()); | |
0 | 214 |
138 | 215 // Resetting it should put it back to the previous state (not runnable). |
216 s.Reset(true); | |
0 | 217 |
138 | 218 // Binding and stepping should produce one row. |
219 s.BindInt(0, 3); | |
220 EXPECT_TRUE(s.Step()); | |
221 EXPECT_EQ(12, s.ColumnInt(0)); | |
222 EXPECT_FALSE(s.Step()); | |
223 } | |
0 | 224 |
138 | 225 TEST_F(SQLStatementTest, BasicErrorCallback) { |
226 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a INTEGER PRIMARY KEY, b)")); | |
227 // Insert in the foo table the primary key. It is an error to insert | |
228 // something other than an number. This error causes the error callback | |
229 // handler to be called with SQLITE_MISMATCH as error code. | |
230 Statement s(db(), "INSERT INTO foo (a) VALUES (?)"); | |
231 s.BindCString(0, "bad bad"); | |
232 EXPECT_THROW(s.Run(), OrthancException); | |
233 } | |
0 | 234 |
138 | 235 TEST_F(SQLStatementTest, Reset) { |
236 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)")); | |
237 ASSERT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (3, 12)")); | |
238 ASSERT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (4, 13)")); | |
0 | 239 |
138 | 240 Statement s(db(), "SELECT b FROM foo WHERE a = ? "); |
241 s.BindInt(0, 3); | |
242 ASSERT_TRUE(s.Step()); | |
243 EXPECT_EQ(12, s.ColumnInt(0)); | |
244 ASSERT_FALSE(s.Step()); | |
0 | 245 |
138 | 246 s.Reset(false); |
247 // Verify that we can get all rows again. | |
248 ASSERT_TRUE(s.Step()); | |
249 EXPECT_EQ(12, s.ColumnInt(0)); | |
250 EXPECT_FALSE(s.Step()); | |
0 | 251 |
138 | 252 s.Reset(true); |
253 ASSERT_FALSE(s.Step()); | |
254 } | |
255 } | |
0 | 256 } |
257 | |
258 | |
259 | |
260 | |
261 | |
262 | |
263 /******************************************************************** | |
264 ** Tests from | |
265 ** http://src.chromium.org/viewvc/chrome/trunk/src/sql/transaction_unittest.cc | |
266 ********************************************************************/ | |
267 | |
268 class SQLTransactionTest : public SQLConnectionTest | |
269 { | |
270 public: | |
271 virtual void SetUp() | |
272 { | |
273 SQLConnectionTest::SetUp(); | |
274 ASSERT_TRUE(db().Execute("CREATE TABLE foo (a, b)")); | |
275 } | |
276 | |
277 // Returns the number of rows in table "foo". | |
278 int CountFoo() | |
279 { | |
138 | 280 Statement count(db(), "SELECT count(*) FROM foo"); |
0 | 281 count.Step(); |
282 return count.ColumnInt(0); | |
283 } | |
284 }; | |
285 | |
286 | |
287 TEST_F(SQLTransactionTest, Commit) { | |
288 { | |
138 | 289 Transaction t(db()); |
0 | 290 EXPECT_FALSE(t.IsOpen()); |
291 t.Begin(); | |
292 EXPECT_TRUE(t.IsOpen()); | |
293 | |
294 EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); | |
295 | |
296 t.Commit(); | |
297 EXPECT_FALSE(t.IsOpen()); | |
298 } | |
299 | |
300 EXPECT_EQ(1, CountFoo()); | |
301 } | |
302 | |
303 TEST_F(SQLTransactionTest, Rollback) { | |
304 // Test some basic initialization, and that rollback runs when you exit the | |
305 // scope. | |
306 { | |
138 | 307 Transaction t(db()); |
0 | 308 EXPECT_FALSE(t.IsOpen()); |
309 t.Begin(); | |
310 EXPECT_TRUE(t.IsOpen()); | |
311 | |
312 EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); | |
313 } | |
314 | |
315 // Nothing should have been committed since it was implicitly rolled back. | |
316 EXPECT_EQ(0, CountFoo()); | |
317 | |
318 // Test explicit rollback. | |
138 | 319 Transaction t2(db()); |
0 | 320 EXPECT_FALSE(t2.IsOpen()); |
321 t2.Begin(); | |
322 | |
323 EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); | |
324 t2.Rollback(); | |
325 EXPECT_FALSE(t2.IsOpen()); | |
326 | |
327 // Nothing should have been committed since it was explicitly rolled back. | |
328 EXPECT_EQ(0, CountFoo()); | |
329 } | |
330 | |
331 // Rolling back any part of a transaction should roll back all of them. | |
332 TEST_F(SQLTransactionTest, NestedRollback) { | |
333 EXPECT_EQ(0, db().GetTransactionNesting()); | |
334 | |
335 // Outermost transaction. | |
336 { | |
138 | 337 Transaction outer(db()); |
0 | 338 outer.Begin(); |
339 EXPECT_EQ(1, db().GetTransactionNesting()); | |
340 | |
341 // The first inner one gets committed. | |
342 { | |
138 | 343 Transaction inner1(db()); |
0 | 344 inner1.Begin(); |
345 EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); | |
346 EXPECT_EQ(2, db().GetTransactionNesting()); | |
347 | |
348 inner1.Commit(); | |
349 EXPECT_EQ(1, db().GetTransactionNesting()); | |
350 } | |
351 | |
352 // One row should have gotten inserted. | |
353 EXPECT_EQ(1, CountFoo()); | |
354 | |
355 // The second inner one gets rolled back. | |
356 { | |
138 | 357 Transaction inner2(db()); |
0 | 358 inner2.Begin(); |
359 EXPECT_TRUE(db().Execute("INSERT INTO foo (a, b) VALUES (1, 2)")); | |
360 EXPECT_EQ(2, db().GetTransactionNesting()); | |
361 | |
362 inner2.Rollback(); | |
363 EXPECT_EQ(1, db().GetTransactionNesting()); | |
364 } | |
365 | |
366 // A third inner one will fail in Begin since one has already been rolled | |
367 // back. | |
368 EXPECT_EQ(1, db().GetTransactionNesting()); | |
369 { | |
138 | 370 Transaction inner3(db()); |
63 | 371 EXPECT_THROW(inner3.Begin(), OrthancException); |
0 | 372 EXPECT_EQ(1, db().GetTransactionNesting()); |
373 } | |
374 } | |
375 EXPECT_EQ(0, db().GetTransactionNesting()); | |
376 EXPECT_EQ(0, CountFoo()); | |
377 } |