25#include <fmt/format.h>
26#include <boost/test/unit_test.hpp>
27#include <nanodbc/nanodbc.h>
43 return std::make_unique<ODBC_BACKEND>(
"",
"",
"", aConnectionString, 2 );
49 std::string
cs = fmt::format(
"Driver={{SQLite3}};Database={}/database.sqlite",
50 QA_DATABASE_FILE_LOCATION );
54 BOOST_CHECK_NO_THROW(
dc.Connect() );
71 dc.CacheTableInfo(
"Resistors", {
"Part ID",
"MPN" } );
72 dc.CacheTableInfo(
"Capacitors", {
"Part ID",
"Cost" } );
81 BOOST_CHECK_NO_THROW( std::any_cast<std::string>(
result.at(
"MPN" ) ) );
84 BOOST_CHECK(
dc.SelectOne(
"Capacitors", std::make_pair(
"Part ID",
"CAP-003" ),
result ) );
88 BOOST_CHECK_NO_THROW( std::any_cast<std::string>(
result.at(
"Cost" ) ) );
104 std::string
cs = fmt::format(
"Driver={{SQLite3}};Database={}/database.sqlite",
105 QA_DATABASE_FILE_LOCATION );
113 dc.CacheTableInfo(
"GeneratedTest", {
"part id",
"value",
"resistance",
"fulldesc" } );
117 BOOST_CHECK(
dc.SelectOne(
"GeneratedTest", std::make_pair(
"Part ID",
"GEN-001" ),
result ) );
122 BOOST_CHECK_NO_THROW( std::any_cast<std::string>(
result.at(
"FullDesc" ) ) );
135 m_path(
std::filesystem::temp_directory_path()
136 / fmt::format(
"kicad_qa_{}.sqlite",
std::random_device()() ) )
143 std::filesystem::remove(
m_path, ec );
148 return fmt::format(
"Driver={{SQLite3}};Database={}",
m_path.string() );
154 nanodbc::connection conn( nanodbc::string(
cs.begin(),
cs.end() ) );
155 nanodbc::execute( conn, nanodbc::string( aSql.begin(), aSql.end() ) );
166 db.
Execute(
"CREATE TABLE \"Part \"\"A\"\"\" (\"Part ID\" TEXT, \"Va\"\"lue\" TEXT)" );
167 db.
Execute(
"INSERT INTO \"Part \"\"A\"\"\" VALUES ('P1', '10K'), ('P2', '22K')" );
169 const std::string
table =
"Part \"A\"";
170 const std::string column =
"Va\"lue";
177 std::vector<DATABASE_CONNECTION::ROW>
rows;
188 dc.SetCacheParams( 0, 0 );
201 db.
Execute(
"CREATE TABLE Nums (\"Part ID\" TEXT, Val REAL)" );
202 db.
Execute(
"INSERT INTO Nums VALUES ('P1', 10012345), ('P2', 1234.5678)" );
208 std::vector<DATABASE_CONNECTION::ROW>
rows;
219 const char* connection = std::getenv(
"QA_DBLIB_PG_CONNECTION" );
220 boost::test_tools::assertion_result
result( connection && *connection );
221 result.message() <<
"QA_DBLIB_PG_CONNECTION is not set";
229 const std::string
cs = std::getenv(
"QA_DBLIB_PG_CONNECTION" );
230 const std::string
table = fmt::format(
"kicad_qa_decimal_{}", std::random_device()() );
233 nanodbc::connection conn( nanodbc::string(
cs.begin(),
cs.end() ) );
234 nanodbc::just_execute( conn, NANODBC_TEXT(
"CREATE TABLE " ) + nanodbc::string(
table.begin(),
table.end() )
235 + NANODBC_TEXT(
" (part_id TEXT, val NUMERIC(30,10))" ) );
244 nanodbc::connection conn( nanodbc::string(
m_cs.begin(),
m_cs.end() ) );
245 nanodbc::just_execute( conn, NANODBC_TEXT(
"DROP TABLE IF EXISTS " )
248 catch(
const std::exception& e )
259 nanodbc::connection conn( nanodbc::string(
cs.begin(),
cs.end() ) );
260 nanodbc::just_execute( conn, nanodbc::string( NANODBC_TEXT(
"INSERT INTO " ) )
261 + nanodbc::string(
table.begin(),
table.end() )
262 + NANODBC_TEXT(
" VALUES ('P1', 12345678901234567.89)" ) );
264 nanodbc::result
res = nanodbc::execute( conn, NANODBC_TEXT(
"SELECT val FROM " )
265 + nanodbc::string(
table.begin(),
table.end() ) );
268 BOOST_CHECK(
res.column_datatype( 0 ) == SQL_NUMERIC ||
res.column_datatype( 0 ) == SQL_DECIMAL );
275 std::vector<DATABASE_CONNECTION::ROW>
rows;
289 db.
Execute(
"CREATE TABLE PartAData (\"Part ID\" TEXT, Value TEXT)" );
290 db.
Execute(
"CREATE TABLE PartABCData (\"Part ID\" TEXT, Value TEXT)" );
291 db.
Execute(
"CREATE TABLE \"Part_%Data\" (\"Part ID\" TEXT, Value TEXT)" );
292 db.
Execute(
"INSERT INTO PartAData VALUES ('P1', 'wrong A')" );
293 db.
Execute(
"INSERT INTO PartABCData VALUES ('P1', 'wrong ABC')" );
294 db.
Execute(
"INSERT INTO \"Part_%Data\" VALUES ('P1', 'right')" );
298 BOOST_REQUIRE(
dc.CacheTableInfo(
"Part_%Data", {
"Part ID",
"Value" } ) );
A read-only source of tables.
A read-only view of a database library source.
std::map< std::string, std::any > ROW
A throwaway SQLite database whose tables are created by the test.
void Execute(const std::string &aSql) const
std::filesystem::path m_path
std::string ConnectionString() const
BOOST_AUTO_TEST_SUITE(CadstarPartParser)
BOOST_CHECK(res.column_datatype(0)==SQL_NUMERIC||res.column_datatype(0)==SQL_DECIMAL)
BOOST_REQUIRE_EQUAL(rows.size(), 1)
static std::unique_ptr< DATABASE_BACKEND > odbcBackend(const std::string &aConnectionString)
DATABASE_CONNECTION dc(odbcBackend(cs))
BOOST_AUTO_TEST_CASE(Connect)
BOOST_CHECK_EQUAL(std::any_cast< std::string >(rows[0].at("val")), "12345678901234567.89")
static boost::test_tools::assertion_result hasPostgresConnection(boost::unit_test::test_unit_id)
BOOST_REQUIRE_MESSAGE(dc.CacheTableInfo(table, { "part_id", "val" }), dc.GetLastError())
std::vector< DATABASE_CONNECTION::ROW > rows
BOOST_REQUIRE(res.columns()==1)
BOOST_AUTO_TEST_SUITE_END()
BOOST_TEST_MESSAGE("Polyline has "<< chain.PointCount()<< " points")
wxString result
Test unit parsing edge cases and error handling.