Mercurial > hg > orthanc
annotate UnitTestsSources/SQLiteChromiumTests.cpp @ 1677:a903d57d9f0c db-changes
adaptation of search with patient tags at study level
| author | Sebastien Jodogne <s.jodogne@gmail.com> |
|---|---|
| date | Mon, 05 Oct 2015 16:40:14 +0200 |
| 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 } |