tests.dal package

Submodules

tests.dal.test_explain_query_plan module

test class

class tests.dal.test_explain_query_plan.ExplainQueryPlanTest(methodName='runTest')

Bases: unittest.case.TestCase

test the SQLite Query execution test

setUp()

testIsReadOnlyIfFalseBecauseOfAlter()

test IsReadOnly if it is False because it is a alter query

testIsReadOnlyIfFalseBecauseOfDrop()

test IsReadOnly if it is False because it is a drop query

testIsReadOnlyIfFalseBecauseOfError()

test IsReadOnly with erroneous SQL query

testIsReadOnlyIfFalseBecauseOfWarning()

test IsReadOnly with erroneous SQL query

testIsReadOnlyIfTrue()

test IsReadOnly if it is True

tests.dal.test_sqlite_database_information module

test class

class tests.dal.test_sqlite_database_information.SQLiteDatabaseInformationTest(methodName='runTest')

Bases: unittest.case.TestCase

test the SQLite Query execution test

testGetRequiredTables()

get the required tables if nothing went wrong

testGetRequiredTablesWithError()

get the required tables if anything went wrong

testGetTableColumnsAndType()

get columns for the table nodata with every possible type.

testGetTableColumnsAndTypeWithError()

get the columns for the table if anything went wrong

testGetTableColumnsAndTypeWithNoTables()

get the columns for the table if the table can not be found.

tests.dal.test_sqlite_query_execution module

test class

class tests.dal.test_sqlite_query_execution.SQLiteQueryExecutionTest(methodName='runTest')

Bases: unittest.case.TestCase

test the SQLite Query execution test

setUp()

testExecuteQueryDetailedJoinNoData()

test the execution of a join Query with no data

testExecuteQueryDetailedJoinNoDataNoSpace()

test the execution of a join Query with no data

testExecuteQueryDetailedSimple()

test the execution of a simple Query

testExecuteQueryDetailedSimpleNoData()

test the execution of a simple Query

testExecuteQueryDetailedWithAliasForTable()

test the execution of a more complex Query

testExecuteQueryDetailedWithAliasWithUnderscore()

test the execution of a more complex Query

testExecuteQueryDetailedWithAliasWithUnderscore2()

test the execution of a more complex Query

testExecuteQueryDetailedWithAliasWithUnderscore3()

test the execution of a more complex Query

testExecuteQueryDetailedWithJoin()

test the execution of a more complex Query

testExecuteQueryDetailedWithJoinAndAliasForTable()

test the execution of a more complex Query

testExecuteQueryDetailedWithJoinAndAliasWithUnderscore()

test the execution of a more complex Query

testExecuteQueryDetailedWithJoinAndNoTable()

test the execution of a more complex Query

testExecuteQueryDetailedWithOneDuplicateColumnNames()

test the execution of a simple Query with one duplicate column name

testExecuteQueryDetailedWithSpecialCharacters()

test the execution of a more complex Query

testExecuteQueryDetailedWithTwoDuplicateColumnNames()

test the execution of a simple Query with two duplicate column names

testExecuteQueryReadOnlyWithAliasForMultipleTable()

test the execution of a more complex Query

testExecuteQuerySimple()

test the execution of a simple Query

testExecuteReadOnlyQueryWithErrorBecauseOfAlter()

test execute read only with a alter rename query

testExecuteReadOnlyQueryWithErrorBecauseOfDrop()

test execute read only with a drop query

testExecuteReadOnlyQueryWithSelect()

test execute read only with a simple select query

testExecuteReadOnlyQueryWithWarning()

test execute read only with two queries at the same time

testMultipleTestAfterOneAnother()

test two querys after another to test the connection is still open

testQueryErrorNoSuchColumn()

test two querys after another to test the connection is still open

testQueryErrorNoSuchTable()

test two querys after another to test the connection is still open

testQueryWarning()

test two querys after another to test the connection is still open

testRollbackWorks()

testing if the rollback works

testTryToConnect()

try to connect without error

testTryToConnectWithError()

try to connect 2 times resulting in a error

tests.dal.test_sqlite_type_helper module

test class

class tests.dal.test_sqlite_type_helper.SQLiteQueryExecutionTest(methodName='runTest')

Bases: unittest.case.TestCase

test the SQLite Query execution test

setUp()

testAddMissingTypesFromSchemaForMultipleOneTable()

test getting missing types from schema multiple tables

testAddMissingTypesFromSchemaForOnlyOneTable()

test getting missing types from schema if only one table

testColumnTypeForMultipleTables()

test getting the column type for multiple table

testColumnTypeForOnlyOneTable()

test getting the column type for only one table

testGetColumnDescriptionEmpty()

test getting column description if description is empty.

testGetColumnDescriptionNone()

test getting column description if description is none.

testGetColumnDescriptionWithElements()

test getting column description if description is not empty.

testGetDuplicateColumnNamesIfDistinct()

test a distinct list

testGetDuplicateColumnNamesIfMultipleDuplicates()

test a duplicate list with multiple duplicates

testGetDuplicateColumnNamesIfOneDuplicate()

test a duplicate list with one duplicate

testGetEndOfTableIfNotAliasEasy()

test get the end of a table with easy query

testGetEndOfTableIfNotAliasWithAliasAfterWithComma()

test get the end of a table with alias after

testGetEndOfTableIfNotAliasWithAliasAfterWithSpace()

test get the end of a table with alias after

testGetEndOfTableIfNotAliasWithAliasBefore()

test get the end of a table with alias before

testGetEndOfTableIfNotAliasWithMultipleAliasBefore()

test get the end of a table with alias before

testGetEndOfTableIfNotAliasWithOnlyAlias()

test get the end of a table with only an alias

testGetPositionAfterSeparatorComma()

test getting position after comma

testGetPositionAfterSeparatorCommaAndMultipleSpaceBeforeAndAfter()

test getting position after comma and multiple space before and after comma

testGetPositionAfterSeparatorCommaAndSpace()

test getting position after comma and space.

testGetPositionAfterSeparatorCommaAndSpaceAfter()

test getting position after comma and space afterwards

testGetPositionAfterSeparatorCommaAndSpaceBeforeAndAfter()

test getting position after comma and space before and after comma

testGetPositionAfterSeparatorSpace()

test getting position after space

Module contents