diff PostgreSQL/UnitTests/PostgreSQLTests.cpp @ 266:cc7af42d4f23

Store revisions for metadata and attachments in PostgreSQL
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 20 Apr 2021 17:41:44 +0200
parents d663d9e44f8d
children 16aac0287485
line wrap: on
line diff
--- a/PostgreSQL/UnitTests/PostgreSQLTests.cpp	Tue Apr 20 16:14:04 2021 +0200
+++ b/PostgreSQL/UnitTests/PostgreSQLTests.cpp	Tue Apr 20 17:41:44 2021 +0200
@@ -86,9 +86,18 @@
   std::unique_ptr<PostgreSQLDatabase> pg(CreateTestDatabase());
 
   ASSERT_FALSE(pg->DoesTableExist("Test"));
+  ASSERT_FALSE(pg->DoesColumnExist("Test", "value"));
+  ASSERT_FALSE(pg->DoesTableExist("TEST"));
+  ASSERT_FALSE(pg->DoesTableExist("test"));
   pg->ExecuteMultiLines("CREATE TABLE Test(name INTEGER, value BIGINT)");
   ASSERT_TRUE(pg->DoesTableExist("Test"));
+  ASSERT_TRUE(pg->DoesTableExist("TEST"));
+  ASSERT_TRUE(pg->DoesTableExist("test"));
 
+  ASSERT_TRUE(pg->DoesColumnExist("Test", "Value"));
+  ASSERT_TRUE(pg->DoesColumnExist("TEST", "VALUE"));
+  ASSERT_TRUE(pg->DoesColumnExist("test", "value"));
+  
   PostgreSQLStatement s(*pg, "INSERT INTO Test VALUES ($1,$2)");
   s.DeclareInputInteger(0);
   s.DeclareInputInteger64(1);