def test_load_ini_staplesdata_off(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'staples_data_off.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests()
self.assertTrue(not x)
def test_load_ini_bigquery_sql(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'bigquery_sql.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests()
test1 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY, 'logical.calcs.bigquery_sql', 'cast_calcs.bigquery_sql.tds', '', 'logicaltests/setup/calcs/setup.*.bigquery_sql.xml', test_config.dsname)
test2 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY, 'logical.staples.bigquery_sql', 'Staples.bigquery_sql.tds', 'Filter.Trademark', 'logicaltests/setup/staples/setup.*.bigquery_sql.xml', test_config.dsname)
test3 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY, 'logical.lod.bigquery_sql', 'Staples.bigquery_sql.tds', '', 'logicaltests/setup/lod/setup.*.bigquery_sql.xml', test_config.dsname)
test4 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY, 'expression.standard.bigquery_sql', 'cast_calcs.bigquery_sql.tds', 'string.ascii,string.char,string.bind_trim,string.left.real,string.right.real,dateparse,math.degree,math.radians,cast.str,cast.int.nulls,logical', 'exprtests/standard/setup.*.txt', test_config.dsname)
test5 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY, 'expression_test_dates.bigquery_sql', 'cast_calcs.bigquery_sql_dates.tds', 'string.ascii,string.char,string.bind_trim,string.left.real,string.right.real,dateparse,math.degree,math.radians,cast.str,cast.int.nulls', 'exprtests/standard/', test_config.dsname)
test6 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY, 'expression_test_dates2.bigquery_sql', 'cast_calcs.bigquery_sql_dates2.tds', 'string.ascii,string.char,string.bind_trim,string.left.real,string.right.real,dateparse,math.degree,math.radians,cast.str,cast.int.nulls', 'exprtests/standard/', test_config.dsname)
test7 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY, 'expression.lod.bigquery_sql', 'cast_calcs.bigquery_sql.tds', '', 'exprtests/lodcalcs/setup.*.txt', test_config.dsname)
test8 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY, 'logical_test_dates.bigquery_sql', 'cast_calcs.bigquery_sql.tds', '', 'exprtests/standard/setup.*.bigquery_dates.xml', test_config.dsname)
tests = [test1, test2, test3, test4, test5, test6, test7, test8]
for test in tests:
found = [y for y in x if y == test]
self.assertTrue(found, "[Did not find expected value of [{0}]".format(test))
def test_load_ini(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'aurora.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests()
test1 = LogicalTestSet('aurora', TEST_DIRECTORY, 'logical.calcs.aurora', 'cast_calcs.aurora.tds', '',
'logicaltests/setup/calcs/setup.*.bool_.xml', test_config.dsname)
test2 = LogicalTestSet('aurora', TEST_DIRECTORY, 'logical.staples.aurora', 'Staples.aurora.tds', 'Filter.Trademark',
'logicaltests/setup/staples/setup.*.bool_.xml', test_config.dsname)
test3 = LogicalTestSet('aurora', TEST_DIRECTORY, 'logical.lod.aurora', 'Staples.aurora.tds', '',
'logicaltests/setup/lod/setup.*.bool_.xml', test_config.dsname)
test4 = ExpressionTestSet('aurora', TEST_DIRECTORY, 'expression.standard.aurora', 'cast_calcs.aurora.tds',
'string.char,dateparse', 'exprtests/standard/setup.*.txt', test_config.dsname)
test5 = ExpressionTestSet('aurora', TEST_DIRECTORY, 'expression.lod.aurora', 'cast_calcs.aurora.tds', '',
'exprtests/lodcalcs/setup.*.txt', test_config.dsname)
tests = [test1, test2, test3, test4, test5]
for test in tests:
found = [y for y in x if y == test]
msg = "[Did not find expected value of [{0}]".format(test)
self.assertTrue(found, msg)
def test_load_run_as_perf_false(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'perf_false.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
self.assertFalse(
test_config.run_as_perf,
'run_as_perf did not match: ' + str(test_config.run_as_perf))
def test_load_ini_new_tests(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'new_tests.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests(
)
test1 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY,
'logical_test1.bigquery_sql_test',
'Staples.bigquery.tds', '',
'logicaltests/setup.*.bigquery.xml',
test_config.dsname)
test2 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY,
'logical_test2.bigquery_sql_test',
'Staples.bigquery_sql_test.tds', '',
'logicaltests/setup.*.bigquery.xml',
test_config.dsname)
test3 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY,
'expression_test1.bigquery_sql_test',
'cast_calcs.bigquery_sql_dates2.tds',
'string.ascii', 'exprtests/standard/',
test_config.dsname)
test4 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY,
'expression_test2.bigquery_sql_test',
'cast_calcs.bigquery_sql_test.tds',
'string.char', 'exprtests/standard/',
test_config.dsname)
tests = [test1, test2, test3, test4]
for test in tests:
found = [y for y in x if y == test]
self.assertTrue(
found, "[Did not find expected value of [{0}]".format(test))
def test_load_ini_bigquery(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'bigquery.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests(
)
test1 = LogicalTestSet(
test_config.dsname, TEST_DIRECTORY, 'logical.calcs.bigquery',
'cast_calcs.bigquery.tds', '',
'logicaltests/setup/calcs/setup.*.bigquery.xml',
test_config.dsname)
test2 = LogicalTestSet(
test_config.dsname, TEST_DIRECTORY, 'logical.staples.bigquery',
'Staples.bigquery.tds', '',
'logicaltests/setup/staples/setup.*.bigquery.xml',
test_config.dsname)
test3 = ExpressionTestSet(
test_config.dsname,
TEST_DIRECTORY,
'expression.standard.bigquery',
'cast_calcs.bigquery.tds',
'string.ascii,string.char,string.bind_trim,string.left.real,string.right.real,dateparse', # noqa: E501
'exprtests/standard/setup.*.txt',
test_config.dsname)
tests = [test1, test2, test3]
for test in tests:
found = [y for y in x if y == test]
self.assertTrue(
found, "[Did not find expected value of [{0}]".format(test))
def test_load_ini_missing2(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'aurora_missing2.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests(
)
test1 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY,
'logical.calcs.aurora', 'cast_calcs.aurora.tds',
'',
'logicaltests/setup/calcs/setup.*.bool_.xml',
test_config.dsname)
test2 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY,
'logical.staples.aurora', 'Staples.aurora.tds',
'',
'logicaltests/setup/staples/setup.*.bool_.xml',
test_config.dsname)
test3 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY,
'expression.standard.aurora',
'cast_calcs.aurora.tds', '',
'exprtests/standard/setup.*.txt',
test_config.dsname)
tests = [test1, test2, test3]
for test in tests:
found = [y for y in x if y == test]
self.assertTrue(
found, "[Did not find expected value of [{0}]".format(test))
def test_load_tabquery_override(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'postgres_jdbc_tabquerytool.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
self.assertTrue(test_config.run_time_config.get_tabquery_path("darwin") == 'tabquerytool_mac')
self.assertTrue(test_config.run_time_config.get_tabquery_path("linux") == 'tabquerytool_linux')
self.assertTrue(test_config.run_time_config.get_tabquery_path("win32") == 'tabquerytool_windows.exe')
def test_load_ini_logical_config(self):
config = configparser.ConfigParser()
#Preserve the case of elements.
config.optionxform = str
config.read(get_path('tool_test/ini', 'logical_config.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
cfg = test_config.logical_config['my_logical_query']
self.assertTrue(test_config.logical_config_name == 'my_logical_query')
self.assertTrue(cfg['tablename'] == 'CRAZYTABLE_$dsName')
self.assertTrue(cfg['tablePrefix'] == '[LOCO].')
self.assertTrue(cfg['tablenameUpper'] == 'True')
def test_load_ini_password_file(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'password_file.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests()
expected_password_file = "a_wrong.password"
self.assertTrue(len(x) == 10, "[Did not find expected number of tests. Found [{0}]".format(len(x)))
for test in x:
actual_file = os.path.split(test.get_password_file_name())[1]
self.assertTrue(actual_file == expected_password_file,
"[Did not find expected value of [{0}, found {1} instead.]".format(expected_password_file, actual_file)) # noqa: E50
def test_load_ini_staplesdata_on(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'staples_data.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests()
test1 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY, 'expression.staples.bigquery', 'Staples.bigquery.tds', '', 'exprtests/staples/setup.*.txt', test_config.dsname)
tests = [test1]
for test in tests:
found = [y for y in x if y == test]
self.assertTrue(found, "[Did not find expected value of [{0}]".format(test))
def test_load_command_line_override(self):
config = configparser.ConfigParser()
config.read(get_path('tool_test/ini', 'override.ini', __name__))
test_config = datasource_list.load_test(config, TEST_DIRECTORY)
x = test_config.get_logical_tests() + test_config.get_expression_tests()
test1 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY, 'logical.calcs.bigquery', 'cast_calcs.bigquery.tds', '', 'logicaltests/setup/calcs/setup.*.bigquery.xml', test_config.dsname)
test2 = LogicalTestSet(test_config.dsname, TEST_DIRECTORY, 'logical.staples.bigquery', 'Staples.bigquery.tds', '', 'logicaltests/setup/staples/setup.*.bigquery.xml', test_config.dsname)
test3 = ExpressionTestSet(test_config.dsname, TEST_DIRECTORY, 'expression.standard.bigquery', 'cast_calcs.bigquery.tds', '', 'exprtests/standard/setup.*.txt', test_config.dsname)
tests = [test1, test2, test3]
self.assertTrue(test_config.run_time_config.d_override == 'WorkFaster=True Override=TurnOff:yes,TurnOn:no', 'Override did not match: ' + test_config.run_time_config.d_override)
for test in tests:
found = [y for y in x if y == test]
self.assertTrue(found, "[Did not find expected value of [{0}]".format(test))
