qal.sql.tests package

Submodules

qal.sql.tests.test_macros module

Created on Sep 26, 2013

@author: Nicklas Boerjesson

class qal.sql.tests.test_macros.Test(methodName='runTest')[source]

Bases: unittest.case.TestCase

setUp()[source]
test_1_create_table_skeleton()[source]
test_2_make_insert_sql_with_parameters()[source]
test_3_copy_to_temp_table()[source]
test_4_select_all_skeleton()[source]
test_5_select_all_skeleton_columns()[source]

qal.sql.tests.test_meta module

Created on Sep 21, 2010

@author: Nicklas Boerjesson @note: These tests have no real purpose since they in practice only tests what objects there are in the SQL-unit. The tests need to be redesigned to have a point. Therefore, they have been commented out.

class qal.sql.tests.test_meta.Test(methodName='runTest')[source]

Bases: unittest.case.TestCase

qal.sql.tests.test_sql module

Created on May 23, 2010

@author: Nicklas Boerjesson

qal.sql.tests.test_sql.gen_complex_conditions()[source]
qal.sql.tests.test_sql.gen_complex_expression()[source]
qal.sql.tests.test_sql.gen_complex_function()[source]
qal.sql.tests.test_sql.gen_simple_case()[source]
qal.sql.tests.test_sql.gen_simple_cast()[source]
qal.sql.tests.test_sql.gen_simple_condition_1()[source]
qal.sql.tests.test_sql.gen_simple_condition_2()[source]
qal.sql.tests.test_sql.gen_simple_conditions()[source]
qal.sql.tests.test_sql.gen_simple_create()[source]
qal.sql.tests.test_sql.gen_simple_expression_2()[source]
qal.sql.tests.test_sql.gen_simple_field_1()[source]
qal.sql.tests.test_sql.gen_simple_field_2()[source]
qal.sql.tests.test_sql.gen_simple_function()[source]
qal.sql.tests.test_sql.gen_simple_insert()[source]
qal.sql.tests.test_sql.gen_simple_select()[source]
qal.sql.tests.test_sql.gen_simple_source_1()[source]
qal.sql.tests.test_sql.gen_simple_source_2()[source]
qal.sql.tests.test_sql.gen_simple_update()[source]
qal.sql.tests.test_sql.gen_simpleexpression_1()[source]
class qal.sql.tests.test_sql.parameter_test(methodName='runTest')[source]

Bases: unittest.case.TestCase

test_00_ParameterCondition_simple()[source]
test_01_ParameterCondition_complex()[source]
test_02_ParameterExpression_simple()[source]
test_03_ParameterCast_simple()[source]
test_04_ParameterFunction_simple()[source]
test_05_ParameterCase()[source]
test_06_VerbSelect()[source]
test_07_parameter_create_table()[source]
test_08_VerbInsert()[source]
test_09_VerbUpdate()[source]
test_10_parameter_create_index()[source]
test_11_parameter_drop_table()[source]

qal.sql.tests.test_xml module

Created on Sep 21, 2010

@author: Nicklas Boerjesson @note: The xml_to_sql_structure-to-sql_structure_to_xml conversion is not at all times reversable as classes have default values which may make the output file differ from the input unless all fields are set.

From test 6 and forward, also SQL:s for all platforms are being tested in the same test. This is done here instead of in the sql_test for convenience and that those tests use datasets.

class qal.sql.tests.test_xml.class_SQL_Meta_XML_Test(methodName='runTest')[source]

Bases: unittest.case.TestCase

maxDiff = None
test_1_generate_xml_Schema()[source]
test_2_create_table()[source]
test_3_select()[source]
test_4_insert()[source]
test_5_create_index()[source]
test_6_insert_matrix_csv()[source]
test_7_delete()[source]
test_8_update()[source]
test_9_resource()[source]
qal.sql.tests.test_xml.sql_for_all_databases(_SQLObj)[source]

Module contents