summaryrefslogtreecommitdiff
path: root/test/test-postgresql.cpp
diff options
context:
space:
mode:
authorDan Goodliffe <dan@randomdan.homeip.net>2021-06-13 02:42:26 +0100
committerDan Goodliffe <dan@randomdan.homeip.net>2021-06-13 02:42:26 +0100
commitd8025ff93d66ec1ff7a6ffd90783e877e9eaafff (patch)
tree2ca815e4ffb42430acbe290858f859157356336e /test/test-postgresql.cpp
parentCreate and drop PostgreSQL mock DBs as needed (diff)
downloadmygrate-d8025ff93d66ec1ff7a6ffd90783e877e9eaafff.tar.bz2
mygrate-d8025ff93d66ec1ff7a6ffd90783e877e9eaafff.tar.xz
mygrate-d8025ff93d66ec1ff7a6ffd90783e877e9eaafff.zip
Support creating a PostgreSQL mock DB and filling it with a schema script
Diffstat (limited to 'test/test-postgresql.cpp')
-rw-r--r--test/test-postgresql.cpp8
1 files changed, 8 insertions, 0 deletions
diff --git a/test/test-postgresql.cpp b/test/test-postgresql.cpp
index 38feb3c..faafcc0 100644
--- a/test/test-postgresql.cpp
+++ b/test/test-postgresql.cpp
@@ -82,3 +82,11 @@ BOOST_AUTO_TEST_CASE(mock)
auto rs = MyGrate::DbStmt<"SELECT CURRENT_DATABASE()">::execute(&mdb);
BOOST_CHECK_EQUAL(rs->at(0, 0).get<std::string_view>().substr(0, 13), "mygrate_test_");
}
+
+BOOST_AUTO_TEST_CASE(mock_schema)
+{
+ MyGrate::Testing::PqConnDB db {ROOT "/db/schema.sql"};
+ auto mdb = db.mock();
+ auto rs = MyGrate::DbStmt<"SELECT COUNT(*) FROM mygrate.source">::execute(&mdb);
+ BOOST_CHECK_EQUAL(rs->at(0, 0).operator unsigned int(), 0);
+}