Ict.Common.DB.Testing.TTestCommonDB Class Reference

Public Member Functions
void	Init ()
	init More...
void	TearDown ()
	tear down More...
void	TestForeignKeyConstraints ()
	test the order of statements in a transaction More...
void	TestOrderStatementsInTransaction ()
	test the order of statements in a transaction More...
void	TestInsertMultipleRows ()
	insert multiple rows in one statement. More...
void	TestSequence ()
	test sequences More...
void	TestTimeStamp ()
	test timestamp More...
void	TestPostgreSQL_ILIKE ()
	Test LIKE -> ILIKE substitution in PostgreSQL More...
void	TestDBAccess_GNoETransaction_throws_proper_ExceptionOnWrongMinimumIsolationLevel ()
	This Test asserts that GetNewOrExistingTransaction will throw the proper Exceptions once it gets called and a DB Transaction is running and the minimum IsolationLevel that is asked for by the caller cannot be met. More...
void	TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_ExpectEDBNullTransactionException ()
	This Test asserts that calling CheckRunningDBTransactionIsolationLevelIsCompatible when there is no current DB Transaction throws EDBNullTransactionException. More...
void	TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_ExpectTrue2 ()
	This Test asserts that calling CheckRunningDBTransactionIsolationLevelIsCompatible returns true. More...
void	TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_WithMinimumIsolationLevel_ExpectFalse ()
	This Test asserts that calling CheckRunningDBTransactionIsolationLevelIsCompatible and asking for a minimum IsolationLevel that isn't met by the running DB Transactions' IsolationLevel returns false. More...
void	TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_WithMinimumIsolationLevel_ExpectTrue ()
	This Test asserts that calling CheckRunningDBTransactionIsolationLevelIsCompatible and asking for a minimum IsolationLevel that is met by the running DB Transactions' IsolationLevel returns true. More...
void	TestDBAccess_working_after_ExecuteNonQuery_threw_DBLevel_Exception ()
	Tests that TDataBase.ExecuteNonQuery is working fine when a previous call to TDataBase.ExecuteNonQuery raised an Exception in the RDBMS driver. More...
void	TestDBAccess_SimpleAutoDBConnAndReadTransactionSelector_RequestedConnectionJoin ()
	Tests SimpleAutoDBConnAndReadTransactionSelector() will join an existing compatible transaction on a particular requested DB connection. More...

Detailed Description

This is a testing program for Ict.Common.DB.dll Please note that this is a Partial Class which continues with Tests in the file test.Multithreading.cs!

This is a testing program for Ict.Common.DB.dll Please note that this is a Partial Class which continues the Tests that are written in the file test.cs!

Member Function Documentation

Init()

void Ict.Common.DB.Testing.TTestCommonDB.Init ( )

inline

init

TearDown()

void Ict.Common.DB.Testing.TTestCommonDB.TearDown ( )

inline

tear down

TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_ExpectEDBNullTransactionException()

void Ict.Common.DB.Testing.TTestCommonDB.TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_ExpectEDBNullTransactionException ( )

inline

This Test asserts that calling CheckRunningDBTransactionIsolationLevelIsCompatible when there is no current DB Transaction throws EDBNullTransactionException.

TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_ExpectTrue2()

void Ict.Common.DB.Testing.TTestCommonDB.TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_ExpectTrue2 ( )

inline

This Test asserts that calling CheckRunningDBTransactionIsolationLevelIsCompatible returns true.

TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_WithMinimumIsolationLevel_ExpectFalse()

void Ict.Common.DB.Testing.TTestCommonDB.TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_WithMinimumIsolationLevel_ExpectFalse ( )

inline

This Test asserts that calling CheckRunningDBTransactionIsolationLevelIsCompatible and asking for a minimum IsolationLevel that isn't met by the running DB Transactions' IsolationLevel returns false.

TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_WithMinimumIsolationLevel_ExpectTrue()

void Ict.Common.DB.Testing.TTestCommonDB.TestDBAccess_CheckRunningDBTransactionIsolationLevelIsCompatible_WithMinimumIsolationLevel_ExpectTrue ( )

inline

This Test asserts that calling CheckRunningDBTransactionIsolationLevelIsCompatible and asking for a minimum IsolationLevel that is met by the running DB Transactions' IsolationLevel returns true.

TestDBAccess_GNoETransaction_throws_proper_ExceptionOnWrongMinimumIsolationLevel()

void Ict.Common.DB.Testing.TTestCommonDB.TestDBAccess_GNoETransaction_throws_proper_ExceptionOnWrongMinimumIsolationLevel ( )

inline

This Test asserts that GetNewOrExistingTransaction will throw the proper Exceptions once it gets called and a DB Transaction is running and the minimum IsolationLevel that is asked for by the caller cannot be met.

TestDBAccess_SimpleAutoDBConnAndReadTransactionSelector_RequestedConnectionJoin()

void Ict.Common.DB.Testing.TTestCommonDB.TestDBAccess_SimpleAutoDBConnAndReadTransactionSelector_RequestedConnectionJoin ( )

inline

Tests SimpleAutoDBConnAndReadTransactionSelector() will join an existing compatible transaction on a particular requested DB connection.

TestDBAccess_working_after_ExecuteNonQuery_threw_DBLevel_Exception()

void Ict.Common.DB.Testing.TTestCommonDB.TestDBAccess_working_after_ExecuteNonQuery_threw_DBLevel_Exception ( )

inline

Tests that TDataBase.ExecuteNonQuery is working fine when a previous call to TDataBase.ExecuteNonQuery raised an Exception in the RDBMS driver.

Similar tests for other public Methods of the TDataBase class could be written to ensure that that class itself plus the DB connection aren't left in some 'troublesome state' after RDBMS-level Exceptions have been raised.

TestForeignKeyConstraints()

void Ict.Common.DB.Testing.TTestCommonDB.TestForeignKeyConstraints ( )

inline

test the order of statements in a transaction

TestInsertMultipleRows()

void Ict.Common.DB.Testing.TTestCommonDB.TestInsertMultipleRows ( )

inline

insert multiple rows in one statement.

TestOrderStatementsInTransaction()

void Ict.Common.DB.Testing.TTestCommonDB.TestOrderStatementsInTransaction ( )

inline

test the order of statements in a transaction

TestPostgreSQL_ILIKE()

void Ict.Common.DB.Testing.TTestCommonDB.TestPostgreSQL_ILIKE ( )

inline

Test LIKE -> ILIKE substitution in PostgreSQL

TestSequence()

void Ict.Common.DB.Testing.TTestCommonDB.TestSequence ( )

inline

test sequences

TestTimeStamp()

void Ict.Common.DB.Testing.TTestCommonDB.TestTimeStamp ( )

inline

test timestamp

---

The documentation for this class was generated from the following files:

• csharp/ICT/Testing/lib/Common/DB/test.cs
• csharp/ICT/Testing/lib/Common/DB/test.Multithreading.cs