def test_ignore_in_string(self):
"""Test REGEX_DISTANT_SEMICOLIN ignore when in string"""
s = """ALTER TABLE `foo` COMMENT 'hello ;' ;"""
matches = REGEX_DISTANT_SEMICOLIN.findall(s)
self.assertEqual(len(matches), 1)
self.assertEqual(matches, [' ;'])
s = """ALTER TABLE `foo` COMMENT 'hello ;';"""
matches = REGEX_DISTANT_SEMICOLIN.findall(s)
self.assertFalse(matches)
def test_no_match(self):
"""Test REGEX_DISTANT_SEMICOLIN with no spaces"""
s = "CREATE DATABSE foobar;"
matches = REGEX_DISTANT_SEMICOLIN.search(s)
self.assertFalse(matches)
def test_tabs(self):
"""Test REGEX_DISTANT_SEMICOLIN with tabs"""
s = "CREATE DATABSE foobar ;"
matches = REGEX_DISTANT_SEMICOLIN.search(s)
self.assertTrue(matches)
def test_newline(self):
"""Test REGEX_DISTANT_SEMICOLIN with newline"""
s = """CREATE DATABSE foobar
;"""
matches = REGEX_DISTANT_SEMICOLIN.search(s)
self.assertTrue(matches)
def test_multiple_spaces(self):
"""Test REGEX_DISTANT_SEMICOLIN with multiple spaces"""
s = "CREATE DATABSE foobar ;"
matches = REGEX_DISTANT_SEMICOLIN.search(s)
self.assertTrue(matches)
