Mercurial > hg > orthanc-databases
annotate PostgreSQL/UnitTests/UnitTestsMain.cpp @ 522:c49136b34891 large-queries tip
use a prepared statement for InsertOrUpdateMetadata
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Fri, 05 Jul 2024 09:15:54 +0200 |
| parents | 54d518dcd74a |
| children |
| rev | line source |
|---|---|
| 0 | 1 /** |
| 2 * Orthanc - A Lightweight, RESTful DICOM Store | |
| 3 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics | |
| 4 * Department, University Hospital of Liege, Belgium | |
|
507
54d518dcd74a
updated copyright, as Orthanc Team now replaces Osimis
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
459
diff
changeset
|
5 * Copyright (C) 2017-2023 Osimis S.A., Belgium |
|
54d518dcd74a
updated copyright, as Orthanc Team now replaces Osimis
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
459
diff
changeset
|
6 * Copyright (C) 2024-2024 Orthanc Team SRL, Belgium |
|
459
ecd0b719cff5
update year to 2024
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
403
diff
changeset
|
7 * Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium |
| 0 | 8 * |
| 9 * This program is free software: you can redistribute it and/or | |
| 10 * modify it under the terms of the GNU Affero General Public License | |
| 11 * as published by the Free Software Foundation, either version 3 of | |
| 12 * the License, or (at your option) any later version. | |
| 13 * | |
| 14 * This program is distributed in the hope that it will be useful, but | |
| 15 * WITHOUT ANY WARRANTY; without even the implied warranty of | |
| 16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
| 17 * Affero General Public License for more details. | |
| 18 * | |
| 19 * You should have received a copy of the GNU Affero General Public License | |
| 20 * along with this program. If not, see <http://www.gnu.org/licenses/>. | |
| 21 **/ | |
| 22 | |
| 23 | |
| 24 #include "../Plugins/PostgreSQLIndex.h" | |
| 25 | |
| 152 | 26 #include <Logging.h> |
| 267 | 27 #include <Toolbox.h> |
| 0 | 28 #include <gtest/gtest.h> |
| 29 | |
| 30 OrthancDatabases::PostgreSQLParameters globalParameters_; | |
| 31 | |
| 32 #include "../../Framework/Plugins/IndexUnitTests.h" | |
|
226
a4918d57435c
DatabaseManager doesn't IDatabaseFactory anymore
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
225
diff
changeset
|
33 #include "../../Framework/PostgreSQL/PostgreSQLDatabase.h" |
| 0 | 34 |
| 35 | |
|
14
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
36 #if ORTHANC_POSTGRESQL_STATIC == 1 |
|
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
37 # include <c.h> // PostgreSQL includes |
|
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
38 |
|
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
39 TEST(PostgreSQL, Version) |
|
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
40 { |
|
172
8c7bb94adff7
trying upgrade from libpq 9.6.1 to 13.1
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
152
diff
changeset
|
41 ASSERT_STREQ("13.1", PG_VERSION); |
|
14
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
42 } |
|
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
43 #endif |
|
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
44 |
|
9774802fd05f
PostgreSQLStorageArea working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
45 |
| 0 | 46 TEST(PostgreSQLParameters, Basic) |
| 47 { | |
| 48 OrthancDatabases::PostgreSQLParameters p; | |
| 49 p.SetDatabase("world"); | |
| 50 | |
| 51 ASSERT_EQ("postgresql://localhost:5432/world", p.GetConnectionUri()); | |
| 52 | |
| 53 p.ResetDatabase(); | |
| 54 ASSERT_EQ("postgresql://localhost:5432/", p.GetConnectionUri()); | |
| 55 | |
| 56 p.SetDatabase("hello"); | |
| 57 ASSERT_EQ("postgresql://localhost:5432/hello", p.GetConnectionUri()); | |
| 58 | |
| 59 p.SetHost("server"); | |
| 60 ASSERT_EQ("postgresql://server:5432/hello", p.GetConnectionUri()); | |
| 61 | |
| 62 p.SetPortNumber(1234); | |
| 63 ASSERT_EQ("postgresql://server:1234/hello", p.GetConnectionUri()); | |
| 64 | |
| 65 p.SetPortNumber(5432); | |
| 66 ASSERT_EQ("postgresql://server:5432/hello", p.GetConnectionUri()); | |
| 67 | |
| 68 p.SetUsername("user"); | |
| 69 p.SetPassword("pass"); | |
| 70 ASSERT_EQ("postgresql://user:pass@server:5432/hello", p.GetConnectionUri()); | |
| 71 | |
| 72 p.SetPassword(""); | |
| 73 ASSERT_EQ("postgresql://user@server:5432/hello", p.GetConnectionUri()); | |
| 74 | |
| 75 p.SetUsername(""); | |
| 76 p.SetPassword("pass"); | |
| 77 ASSERT_EQ("postgresql://server:5432/hello", p.GetConnectionUri()); | |
| 78 | |
| 79 p.SetUsername(""); | |
| 80 p.SetPassword(""); | |
| 81 ASSERT_EQ("postgresql://server:5432/hello", p.GetConnectionUri()); | |
| 82 | |
| 83 p.SetConnectionUri("hello://world"); | |
| 84 ASSERT_EQ("hello://world", p.GetConnectionUri()); | |
| 85 } | |
| 86 | |
| 87 | |
| 88 TEST(PostgreSQLIndex, Lock) | |
| 89 { | |
| 90 OrthancDatabases::PostgreSQLParameters noLock = globalParameters_; | |
| 91 noLock.SetLock(false); | |
| 92 | |
| 93 OrthancDatabases::PostgreSQLParameters lock = globalParameters_; | |
| 94 lock.SetLock(true); | |
| 95 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
96 OrthancDatabases::PostgreSQLIndex db1(NULL, noLock); |
| 0 | 97 db1.SetClearAll(true); |
|
225
94c9908e6aca
removed DatabaseManager member out of class IndexBackend
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
98 |
|
403
91124cc8a8c7
database plugins are informed about the identifier tags
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
389
diff
changeset
|
99 std::list<OrthancDatabases::IdentifierTag> identifierTags; |
|
91124cc8a8c7
database plugins are informed about the identifier tags
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
389
diff
changeset
|
100 std::unique_ptr<OrthancDatabases::DatabaseManager> manager1(OrthancDatabases::IndexBackend::CreateSingleDatabaseManager(db1, false, identifierTags)); |
| 0 | 101 |
| 102 { | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
103 OrthancDatabases::PostgreSQLIndex db2(NULL, lock); |
|
403
91124cc8a8c7
database plugins are informed about the identifier tags
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
389
diff
changeset
|
104 std::unique_ptr<OrthancDatabases::DatabaseManager> manager2(OrthancDatabases::IndexBackend::CreateSingleDatabaseManager(db2, false, identifierTags)); |
| 0 | 105 |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
106 OrthancDatabases::PostgreSQLIndex db3(NULL, lock); |
|
403
91124cc8a8c7
database plugins are informed about the identifier tags
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
389
diff
changeset
|
107 ASSERT_THROW(OrthancDatabases::IndexBackend::CreateSingleDatabaseManager(db3, false, identifierTags), Orthanc::OrthancException); |
| 0 | 108 } |
| 109 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
110 OrthancDatabases::PostgreSQLIndex db4(NULL, lock); |
|
403
91124cc8a8c7
database plugins are informed about the identifier tags
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
389
diff
changeset
|
111 std::unique_ptr<OrthancDatabases::DatabaseManager> manager4(OrthancDatabases::IndexBackend::CreateSingleDatabaseManager(db4, false, identifierTags)); |
| 0 | 112 } |
| 113 | |
| 114 | |
| 115 int main(int argc, char **argv) | |
| 116 { | |
| 117 if (argc < 6) | |
| 118 { | |
| 119 std::cerr << "Usage: " << argv[0] << " <host> <port> <username> <password> <database>" | |
| 120 << std::endl << std::endl | |
| 121 << "Example: " << argv[0] << " localhost 5432 postgres postgres orthanctest" | |
| 122 << std::endl << std::endl; | |
| 123 return -1; | |
| 124 } | |
| 125 | |
| 126 globalParameters_.SetHost(argv[1]); | |
| 127 globalParameters_.SetPortNumber(boost::lexical_cast<uint16_t>(argv[2])); | |
| 128 globalParameters_.SetUsername(argv[3]); | |
| 129 globalParameters_.SetPassword(argv[4]); | |
| 130 globalParameters_.SetDatabase(argv[5]); | |
| 131 | |
| 132 ::testing::InitGoogleTest(&argc, argv); | |
| 267 | 133 Orthanc::Toolbox::InitializeOpenSsl(); |
| 0 | 134 Orthanc::Logging::Initialize(); |
| 135 Orthanc::Logging::EnableInfoLevel(true); | |
|
335
7ec461718edb
unit test of metadata and tags in UTF8
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
267
diff
changeset
|
136 //Orthanc::Logging::EnableTraceLevel(true); |
| 0 | 137 |
| 138 int result = RUN_ALL_TESTS(); | |
| 139 | |
| 140 Orthanc::Logging::Finalize(); | |
| 267 | 141 Orthanc::Toolbox::FinalizeOpenSsl(); |
| 0 | 142 |
| 143 return result; | |
| 144 } |