1 // 2 // ODBCSQLiteTest.h 3 // 4 // Definition of the ODBCSQLiteTest class. 5 // 6 // Copyright (c) 2006, Applied Informatics Software Engineering GmbH. 7 // and Contributors. 8 // 9 // SPDX-License-Identifier: BSL-1.0 10 // 11 12 13 #ifndef ODBCSQLiteTest_INCLUDED 14 #define ODBCSQLiteTest_INCLUDED 15 16 17 #include "Poco/Data/ODBC/ODBC.h" 18 #include "ODBCTest.h" 19 20 21 class ODBCSQLiteTest: public ODBCTest 22 /// SQLite3 ODBC test class 23 /// Tested: 24 /// 25 /// Driver | DB | OS 26 /// ------------+---------------+------------------------------------------ 27 /// 00.70.00.00 | SQLite 3.* | MS Windows XP Professional x64 v.2003/SP1 28 { 29 public: 30 ODBCSQLiteTest(const std::string& name); 31 ~ODBCSQLiteTest(); 32 33 void testBareboneODBC(); 34 void testAffectedRows(); 35 void testNull(); 36 37 static CppUnit::Test* suite(); 38 39 private: 40 void dropObject(const std::string& type, const std::string& name); 41 void recreateNullableTable(); 42 void recreatePersonTable(); 43 void recreatePersonBLOBTable(); 44 void recreatePersonDateTimeTable(); 45 void recreateStringsTable(); 46 void recreateIntsTable(); 47 void recreateFloatsTable(); 48 void recreateTuplesTable(); 49 void recreateVectorsTable(); 50 void recreateAnysTable(); 51 void recreateNullsTable(const std::string& notNull = ""); 52 void recreateMiscTable(); 53 void recreateLogTable(); 54 55 static ODBCTest::SessionPtr _pSession; 56 static ODBCTest::ExecPtr _pExecutor; 57 static std::string _driver; 58 static std::string _dsn; 59 static std::string _uid; 60 static std::string _pwd; 61 static std::string _connectString; 62 }; 63 64 65 #endif // ODBCSQLiteTest_INCLUDED 66