summaryrefslogtreecommitdiff
path: root/test/test-postgresql.cpp
blob: 5940b38ce7c3bed3bd94c909f71d7a424200148f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
#define BOOST_TEST_MODULE PostgreSQL
#include <boost/test/unit_test.hpp>

#include <dbTypes.h>
#include <output/pq/pqConn.h>
#include <stdexcept>

BOOST_AUTO_TEST_CASE(simple)
{
	BOOST_CHECK_THROW(([]() {
		MyGrate::Output::Pq::PqConn {"nonsense"};
	}()),
			std::runtime_error);
	MyGrate::Output::Pq::PqConn c {"user=postgres"};
	BOOST_CHECK_NO_THROW(c.query("SET application_name = ''"));
	BOOST_CHECK_NO_THROW(c.query("SET application_name = 'something'"));
	BOOST_CHECK_THROW(c.query("SET application_name = "), std::runtime_error);
	// BOOST_CHECK_THROW(c.query("SET application_name = $1", {}), std::logic_error);
	BOOST_CHECK_NO_THROW(c.query("SET application_name = 'something'", {}));
	c.query("DROP TABLE IF EXISTS test");
	c.query("CREATE TABLE test(c text)");
	BOOST_CHECK_NO_THROW(c.query("INSERT INTO test VALUES($1)", {1}));
	BOOST_CHECK_NO_THROW(c.query("INSERT INTO test VALUES($1)", {"string_view"}));
	BOOST_CHECK_NO_THROW(c.query("INSERT INTO test VALUES($1)", {nullptr}));
	BOOST_CHECK_NO_THROW(c.query("INSERT INTO test VALUES($1)", {1.2}));
	BOOST_CHECK_THROW(c.query("INSERT INTO test VALUES($1)", {MyGrate::Time {}}), std::runtime_error);
	c.query("DROP TABLE test");
}