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