def test_get_datatype_regex_pattern_bit1_empty_string(self):
test_schema = SQLTableSchema('FULL_TEST')
bit1_pattern = test_schema.get_datatype_regex_pattern(
'BIT_WITHOUT_NULL')
test_string = ''
self.assertIsNone(bit1_pattern.match(test_string))
def test_get_datatype_regex_pattern_datetime2_date_yy_mm_dd(self):
test_schema = SQLTableSchema('FULL_TEST')
datetime2_pattern = test_schema.get_datatype_regex_pattern(
'DATETIME2_WITHOUT_NULL')
test_string = '20-05-14'
self.assertIsNone(datetime2_pattern.match(test_string))
def test_get_datatype_regex_pattern_nvarchar8_empty_string(self):
test_schema = SQLTableSchema('FULL_TEST')
test_string = ''
nvarchar8_pattern = test_schema.get_datatype_regex_pattern(
'NVARCHAR_WITHOUT_NULL')
self.assertIsNotNone(nvarchar8_pattern.match(test_string))
def test_get_datatype_regex_pattern_datetime2_invalid_string(self):
test_schema = SQLTableSchema('FULL_TEST')
datetime2_pattern = test_schema.get_datatype_regex_pattern(
'DATETIME2_WITHOUT_NULL')
test_string = 'An invalid string'
self.assertIsNone(datetime2_pattern.match(test_string))
def test_get_datatype_regex_pattern_datetime_date_dd_mm_yyyy(self):
test_schema = SQLTableSchema('FULL_TEST')
datetime_pattern = test_schema.get_datatype_regex_pattern(
'DATETIME_WITHOUT_NULL')
test_string = '14-05-2020'
self.assertIsNone(datetime_pattern.match(test_string))
def test_get_datatype_regex_pattern_int8_invalid_string(self):
test_schema = SQLTableSchema('FULL_TEST')
int8_pattern = test_schema.get_datatype_regex_pattern(
'INT_WITHOUT_NULL')
test_string = 'aA,;.:-)'
self.assertIsNone(int8_pattern.match(test_string))
def test_get_datatype_regex_pattern_int8_string_too_long(self):
test_schema = SQLTableSchema('FULL_TEST')
int8_pattern = test_schema.get_datatype_regex_pattern(
'INT_WITHOUT_NULL')
test_string = '123456789'
self.assertIsNone(int8_pattern.match(test_string))
def test_get_datatype_regex_pattern_bool1_invalid_string(self):
test_schema = SQLTableSchema('FULL_TEST')
bool1_pattern = test_schema.get_datatype_regex_pattern(
'BOOL_WITHOUT_NULL')
test_string = 'a'
self.assertIsNone(bool1_pattern.match(test_string))
