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_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))