def test_all_views(self): """Test all views are returned for indexing.""" job = base_job.Job(os.path.join(os.getcwd(), 'all_views_oracle.json')) job.connect_to_database() base_views_to_keep = [('GDB_ITEMRELATIONSHIPS_VW', 'GDB1'), ('GDB_ITEMS_VW', 'GDB1'), ('RUNWAY_A_EVW', 'GDB1'), ('RUNWAY_L_EVW', 'GDB1'), ('RUNWAY_P_EVW', 'GDB1'), ('SLIPWAY_A_EVW', 'GDB1'), ('SLIPWAY_L_EVW', 'GDB1'), ('SLIPWAY_P_EVW', 'GDB1'), ('SUBWAY_L_EVW', 'GDB1')] self.assertEqual(base_views_to_keep, oracle_worker.get_views(job))
def test_views_wildcards(self): """Test including & excluding views with wildcards.""" job = base_job.Job(os.path.join(os.getcwd(), 'views_wildcards_oracle.json')) job.connect_to_database() base_views = ['RUNWAY_A_EVW', 'RUNWAY_P_EVW'] self.assertEqual(base_views, sorted(oracle_worker.get_views(job)))
def test_views_schema_user(self): """Test views for schema=user.""" job = base_job.Job(os.path.join(os.getcwd(), 'views_schema_user_oracle.json')) job.connect_to_database() base_views = ['RUNWAY_A_EVW', 'RUNWAY_L_EVW', 'RUNWAY_P_EVW'] self.assertEqual(base_views, sorted(oracle_worker.get_views(job)))
def test_one_view(self): """Test one view is returned for indexing.""" job = base_job.Job(os.path.join(os.getcwd(), 'one_view_oracle.json')) job.connect_to_database() self.assertEqual([('RUNWAY_A_EVW', u'GDB1')], oracle_worker.get_views(job))