def test_check_table_fully_qualified_table(self):
line = 'ALTER TABLE ONLY public.ao_index_table\n'
search_str = ' ONLY '
schema = 'public'
dump_tables = [('public', 'ao_index_table')]
self.assertTrue(check_table(schema, line, search_str, dump_tables))
def test_check_table_mismatched_table(self):
line = 'ALTER TABLE ONLY public.ao_index_table\n'
search_str = ' ONLY '
schema = 'public'
dump_tables = [('public', 'ao_part_table')]
self.assertFalse(check_table(schema, line, search_str, dump_tables))
def test_check_table_trailing_text(self):
line = 'CREATE UNIQUE INDEX ON public.ao_index_table CLUSTER\n'
search_str = ' ON '
schema = 'public'
dump_tables = [('public', 'ao_index_table')]
self.assertTrue(check_table(schema, line, search_str, dump_tables))
def test_check_table_bad_search_str(self):
line = 'ALTER TABLE ONLY ao_index_table\n'
search_str = ' TO '
schema = 'public'
dump_tables = [('public', 'ao_index_table')]
self.assertFalse(check_table(schema, line, search_str, dump_tables))
def test_check_table_fully_qualified_table(self):
line = 'ALTER TABLE ONLY public.ao_index_table\n'
search_str = ' ONLY '
schema = 'public'
dump_tables = [('public', 'ao_index_table')]
self.assertTrue(check_table(schema, line, search_str, dump_tables))
def test_check_table_trailing_text(self):
line = 'CREATE UNIQUE INDEX ON ao_index_table CLUSTER\n'
search_str = ' ON '
schema = 'public'
dump_tables = [('public', 'ao_index_table')]
self.assertTrue(check_table(schema, line, search_str, dump_tables))
def test_check_table_mismatched_table(self):
line = 'ALTER TABLE ONLY ao_index_table\n'
search_str = ' ONLY '
schema = 'public'
dump_tables = [('public', 'ao_part_table')]
self.assertFalse(check_table(schema, line, search_str, dump_tables))
def test_check_table_bad_search_str(self):
line = 'ALTER TABLE ONLY ao_index_table\n'
search_str = ' TO '
schema = 'public'
dump_tables = [('public', 'ao_index_table')]
self.assertFalse(check_table(schema, line, search_str, dump_tables))
