def test_skip_when_tag_in_sql_file(self):
test_loader = TINCTestLoader()
test_suite = test_loader.loadTestsFromTestCase(MockSQLTestCaseForSkip)
test_case = None
for case in test_suite._tests:
if case.name == "MockSQLTestCaseForSkip.test_query01":
test_case = case
def test_infer_metadata(self):
test_loader = TINCTestLoader()
test_suite = test_loader.loadTestsFromTestCase(MockSQLTestCase)
test_case = None
for case in test_suite._tests:
if case.name == "MockSQLTestCase.test_query02":
test_case = case
def test_optimizer_mode_both(self):
test_loader = TINCTestLoader()
test_suite = test_loader.loadTestsFromTestCase(MockSQLTestCaseForOptimizerModeBoth)
for test in test_suite._tests:
# Data provider should exists for query01 and query03.
# query02 shouldn't have it, since its optimizer mode is overwritten with value 'off'
if test.name == "MockSQLTestCaseForOptimizerModeBoth.test_query01" or test.name == "MockSQLTestCaseForOptimizerModeBoth.test_query03":
self.assertEqual(test.optimizer_mode, "both")
self.assertEqual(test.data_provider, "optimizer_handling")
else:
self.assertNotEqual(test.optimizer_mode, "both")
self.assertTrue(test.data_provider is None)
def test_optimizer_mode_both(self):
test_loader = TINCTestLoader()
test_suite = test_loader.loadTestsFromTestCase(
MockSQLTestCaseForOptimizerModeBoth)
for test in test_suite._tests:
# Data provider should exists for query01 and query03.
# query02 shouldn't have it, since its optimizer mode is overwritten with value 'off'
if test.name == "MockSQLTestCaseForOptimizerModeBoth.test_query01" or test.name == "MockSQLTestCaseForOptimizerModeBoth.test_query03":
self.assertEqual(test.optimizer_mode, "both")
self.assertEqual(test.data_provider, "optimizer_handling")
else:
self.assertNotEqual(test.optimizer_mode, "both")
self.assertTrue(test.data_provider is None)
def test_infer_metadata(self):
test_loader = TINCTestLoader()
test_suite = test_loader.loadTestsFromTestCase(MockSQLTestCase)
test_case = None
for case in test_suite._tests:
if case.name == "MockSQLTestCase.test_query02":
test_case = case
self.assertNotEqual(test_case, None)
self.assertEqual(test_case.name, "MockSQLTestCase.test_query02")
self.assertEqual(test_case.author, 'kumara64')
self.assertEqual(test_case.description, 'test sql test case')
self.assertEqual(test_case.created_datetime, datetime.strptime('2012-07-05 12:00:00', '%Y-%m-%d %H:%M:%S'))
self.assertEqual(test_case.modified_datetime, datetime.strptime('2012-07-08 12:00:02', '%Y-%m-%d %H:%M:%S'))
self.assertEqual(test_case.tags, set(['orca', 'hashagg', 'executor']))
self.assertEqual(test_case.gucs, set(['gp_optimizer=on', 'gp_log_optimizer=on']))
def test_skip_when_tag_in_sql_file(self):
test_loader = TINCTestLoader()
test_suite = test_loader.loadTestsFromTestCase(MockSQLTestCaseForSkip)
test_case = None
for case in test_suite._tests:
if case.name == "MockSQLTestCaseForSkip.test_query01":
test_case = case
self.assertNotEqual(test_case, None)
self.assertEqual(test_case.name, "MockSQLTestCaseForSkip.test_query01")
with closing(_WritelnDecorator(StringIO())) as buffer:
test_result = TINCTextTestResult(buffer, True, 1)
test_case.run(test_result)
self.assertEqual(test_result.testsRun, 1)
self.assertEqual(len(test_result.failures), 0)
self.assertEqual(len(test_result.skipped), 1)
self.assertEqual(len(test_result.errors), 0)
def test_explicit_test_fixtures_through_loading(self):
test_loader = TINCTestLoader()
test_suite = test_loader.loadTestsFromTestCase(MockSQLTestCase)
# 4 tests for 3 sqls in the directory and 1 explicit test method
self.assertEqual(test_suite.countTestCases(), 4)
def test_explicit_test_fixtures_through_loading(self):
test_loader = TINCTestLoader()
test_suite = test_loader.loadTestsFromTestCase(MockSQLTestCase)
# 4 tests for 3 sqls in the directory and 1 explicit test method
self.assertEqual(test_suite.countTestCases(), 4)
