def test_when_database_not_provided_then_short_object_name_in_delete(self): mock_cursor = Mock() mock_connection_provider = self.get_mock_connection_provider( mock_cursor) provider = BaseDynamicProvider(self.get_mock_provider(), mock_connection_provider, 'TESTOBJECT', []) provider.delete("test_name", { "name": "test_name", }) mock_cursor.execute.assert_has_calls( [call("\n".join([f"DROP TESTOBJECT test_name"]))])
def test_when_database_and_schema_given_in_provider_then_do_not_appear_in_delete( self): mock_cursor = Mock() mock_connection_provider = self.get_mock_connection_provider( mock_cursor) mock_provider = self.get_mock_provider() mock_provider.database = "test_provider_db" mock_provider.schema = "test_provider_schema" provider = BaseDynamicProvider(mock_provider, mock_connection_provider, 'TESTOBJECT', []) provider.delete("test_name", {"name": "test_name"}) mock_cursor.execute.assert_has_calls( [call("\n".join([f"DROP TESTOBJECT test_name"]))])
def test_when_database_and_schema_provided_then_fully_qualified_object_name_in_delete( self): mock_cursor = Mock() mock_connection_provider = self.get_mock_connection_provider( mock_cursor) provider = BaseDynamicProvider(self.get_mock_provider(), mock_connection_provider, 'TESTOBJECT', []) provider.delete("test_name", { "database": "test_db", "schema": "test_schema", "name": "test_name", }) mock_cursor.execute.assert_has_calls([ call("\n".join([f"DROP TESTOBJECT test_db.test_schema.test_name"])) ])