Mercurial > hg > orthanc-databases

comparison PostgreSQL/UnitTests/PostgreSQLTests.cpp @ 237:35598014f140

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
refactoring to remove GlobalProperties.cpp
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 08 Apr 2021 19:09:04 +0200
parents 675f8322eb7c
children b97a537f4613
comparison
equal deleted inserted replaced
236:d1d2edbbe6fb 237:35598014f140
84 TEST(PostgreSQL, Basic) 84 TEST(PostgreSQL, Basic)
85 { 85 {
86 std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase()); 86 std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase());
87 87
88 ASSERT_FALSE(pg->DoesTableExist("Test")); 88 ASSERT_FALSE(pg->DoesTableExist("Test"));
89 pg->Execute("CREATE TABLE Test(name INTEGER, value BIGINT)"); 89 pg->ExecuteMultiLines("CREATE TABLE Test(name INTEGER, value BIGINT)");
90 ASSERT_TRUE(pg->DoesTableExist("Test")); 90 ASSERT_TRUE(pg->DoesTableExist("Test"));
91 91
92 PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)"); 92 PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)");
93 s.DeclareInputInteger(0); 93 s.DeclareInputInteger(0);
94 s.DeclareInputInteger64(1); 94 s.DeclareInputInteger64(1);
156 156
157 TEST(PostgreSQL, String) 157 TEST(PostgreSQL, String)
158 { 158 {
159 std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase()); 159 std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase());
160 160
161 pg->Execute("CREATE TABLE Test(name INTEGER, value VARCHAR(40))"); 161 pg->ExecuteMultiLines("CREATE TABLE Test(name INTEGER, value VARCHAR(40))");
162 162
163 PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)"); 163 PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)");
164 s.DeclareInputInteger(0); 164 s.DeclareInputInteger(0);
165 s.DeclareInputString(1); 165 s.DeclareInputString(1);
166 166
202 202
203 TEST(PostgreSQL, Transaction) 203 TEST(PostgreSQL, Transaction)
204 { 204 {
205 std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase()); 205 std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase());
206 206
207 pg->Execute("CREATE TABLE Test(name INTEGER, value INTEGER)"); 207 pg->ExecuteMultiLines("CREATE TABLE Test(name INTEGER, value INTEGER)");
208 208
209 { 209 {
210 PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)"); 210 PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)");
211 s.DeclareInputInteger(0); 211 s.DeclareInputInteger(0);
212 s.DeclareInputInteger(1); 212 s.DeclareInputInteger(1);
281 TEST(PostgreSQL, LargeObject) 281 TEST(PostgreSQL, LargeObject)
282 { 282 {
283 std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase()); 283 std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase());
284 ASSERT_EQ(0, CountLargeObjects(*pg)); 284 ASSERT_EQ(0, CountLargeObjects(*pg));
285 285
286 pg->Execute("CREATE TABLE Test(name VARCHAR, value OID)"); 286 pg->ExecuteMultiLines("CREATE TABLE Test(name VARCHAR, value OID)");
287 287
288 // Automatically remove the large objects associated with the table 288 // Automatically remove the large objects associated with the table
289 pg->Execute("CREATE RULE TestDelete AS ON DELETE TO Test DO SELECT lo_unlink(old.value);"); 289 pg->ExecuteMultiLines("CREATE RULE TestDelete AS ON DELETE TO Test DO SELECT lo_unlink(old.value);");
290 290
291 { 291 {
292 PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)"); 292 PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)");
293 s.DeclareInputString(0); 293 s.DeclareInputString(0);
294 s.DeclareInputLargeObject(1); 294 s.DeclareInputLargeObject(1);