You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2022/10/16 16:38:55 UTC

[GitHub] [airflow] o-nikolas commented on a diff in pull request #26974: Add FTP Operator

o-nikolas commented on code in PR #26974:
URL: https://github.com/apache/airflow/pull/26974#discussion_r996459193


##########
airflow/providers/ftp/operators/ftp.py:
##########
@@ -0,0 +1,135 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+"""This module contains FTP operator."""
+from __future__ import annotations
+
+import os
+from pathlib import Path
+from typing import Any, Sequence
+
+from airflow.compat.functools import cached_property
+from airflow.exceptions import AirflowException
+from airflow.models import BaseOperator
+from airflow.providers.ftp.hooks.ftp import FTPHook
+
+
+class FTPOperation:
+    """Operation that can be used with FTP"""
+
+    PUT = 'put'
+    GET = 'get'
+
+
+class FTPOperator(BaseOperator):
+    """
+    FTPOperator for transferring files from remote host to local or vice a versa.
+    This operator uses an FTPHook to open ftp transport channel that serve as basis
+    for file transfer.
+
+    :param ftp_conn_id: :ref:`ftp connection id<howto/connection:ftp>`
+        from airflow Connections.
+    :param local_filepath: local file path to get or put. (templated)
+    :param remote_filepath: remote file path to get or put. (templated)
+    :param operation: specify operation 'get' or 'put', defaults to put
+    :param create_intermediate_dirs: create missing intermediate directories when
+        copying from remote to local and vice-versa. Default is False.
+
+        Example: The following task would copy ``file.txt`` to the remote host
+        at ``/tmp/tmp1/tmp2/`` while creating ``tmp``,``tmp1`` and ``tmp2`` if they
+        don't exist. If the parameter is not passed it would error as the directory
+        does not exist. ::
+
+            put_file = FTPOperator(
+                task_id="test_ftp",
+                ftp_conn_id="ftp_default",
+                local_filepath="/tmp/file.txt",
+                remote_filepath="/tmp/tmp1/tmp2/file.txt",
+                operation="put",
+                create_intermediate_dirs=True,
+                dag=dag
+            )
+
+    """
+
+    template_fields: Sequence[str] = ('local_filepath', 'remote_filepath')
+
+    def __init__(
+        self,
+        *,
+        ftp_conn_id: str,

Review Comment:
   Use your new `default_ftp` conn as a default here?



##########
docs/apache-airflow-providers-ftp/operators/index.rst:
##########
@@ -0,0 +1,64 @@
+.. Licensed to the Apache Software Foundation (ASF) under one
+    or more contributor license agreements.  See the NOTICE file
+    distributed with this work for additional information
+    regarding copyright ownership.  The ASF licenses this file
+    to you under the Apache License, Version 2.0 (the
+    "License"); you may not use this file except in compliance
+    with the License.  You may obtain a copy of the License at
+
+ ..   http://www.apache.org/licenses/LICENSE-2.0
+
+ .. Unless required by applicable law or agreed to in writing,
+    software distributed under the License is distributed on an
+    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+    KIND, either express or implied.  See the License for the
+    specific language governing permissions and limitations
+    under the License.
+
+
+
+.. _howto/operator:FTPOperator:
+
+FTPOperator
+===============
+
+
+Use the FTPOperator to get or
+pull files to/from an FTP server.
+
+Using the Operator
+^^^^^^^^^^^^^^^^^^
+
+| **ftp_conn_id**: id referencing an FTP Connection **str**
+| **local_filepath**: local file path to get or put. **str**
+| **remote_filepath**: remote file path to get or put. **str**
+| **operation**: specify operation 'get' or 'put' **str** - Default: **PUT**
+| **create_intermediate_dirs**: create missing intermediate directories when copying from remote to local and vice-versa. **bool** - Default: **False**
+|
+
+Example: The following task would copy ``file.txt`` to the remote host
+at ``/tmp/tmp1/tmp2/`` while creating ``tmp``, ``tmp1`` and ``tmp2`` if they
+don't exist. If the ``create_immediate_dirs`` parameter is not passed it would error as the directory
+does not exist. ::
+
+    put_file = FTPOperator(

Review Comment:
   You could consider adding an example dag. It's something users can use to get started using your operator and you can link to the example usage of the task from the example, which again helps to keep the docs up to date. But not all provider packages use them.
   
   [Here is an example example-dag](https://github.com/apache/airflow/blob/providers-amazon/3.3.0/airflow/providers/amazon/aws/example_dags/example_ftp_to_s3.py)
   
   [And here is the doc linking to a code snippets from that example](https://airflow.apache.org/docs/apache-airflow-providers-amazon/3.3.0/operators/transfer/ftp_to_s3.html#ftp-to-amazon-s3) 



##########
airflow/providers/ftp/operators/ftp.py:
##########
@@ -0,0 +1,135 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+"""This module contains FTP operator."""
+from __future__ import annotations
+
+import os
+from pathlib import Path
+from typing import Any, Sequence
+
+from airflow.compat.functools import cached_property
+from airflow.exceptions import AirflowException
+from airflow.models import BaseOperator
+from airflow.providers.ftp.hooks.ftp import FTPHook
+
+
+class FTPOperation:
+    """Operation that can be used with FTP"""
+
+    PUT = 'put'
+    GET = 'get'
+
+
+class FTPOperator(BaseOperator):
+    """
+    FTPOperator for transferring files from remote host to local or vice a versa.
+    This operator uses an FTPHook to open ftp transport channel that serve as basis
+    for file transfer.
+
+    :param ftp_conn_id: :ref:`ftp connection id<howto/connection:ftp>`
+        from airflow Connections.
+    :param local_filepath: local file path to get or put. (templated)
+    :param remote_filepath: remote file path to get or put. (templated)
+    :param operation: specify operation 'get' or 'put', defaults to put
+    :param create_intermediate_dirs: create missing intermediate directories when
+        copying from remote to local and vice-versa. Default is False.
+
+        Example: The following task would copy ``file.txt`` to the remote host
+        at ``/tmp/tmp1/tmp2/`` while creating ``tmp``,``tmp1`` and ``tmp2`` if they
+        don't exist. If the parameter is not passed it would error as the directory

Review Comment:
   ```suggestion
           at ``/tmp/tmp1/tmp2/`` while creating ``tmp``,``tmp1`` and ``tmp2`` if they
           don't exist. If the ``create_intermediate_dirs`` parameter is not passed it would error as the directory
   ```



##########
airflow/providers/ftp/operators/ftp.py:
##########
@@ -0,0 +1,135 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+"""This module contains FTP operator."""
+from __future__ import annotations
+
+import os
+from pathlib import Path
+from typing import Any, Sequence
+
+from airflow.compat.functools import cached_property
+from airflow.exceptions import AirflowException
+from airflow.models import BaseOperator
+from airflow.providers.ftp.hooks.ftp import FTPHook
+
+
+class FTPOperation:
+    """Operation that can be used with FTP"""
+
+    PUT = 'put'
+    GET = 'get'
+
+
+class FTPOperator(BaseOperator):
+    """
+    FTPOperator for transferring files from remote host to local or vice a versa.
+    This operator uses an FTPHook to open ftp transport channel that serve as basis
+    for file transfer.
+
+    :param ftp_conn_id: :ref:`ftp connection id<howto/connection:ftp>`
+        from airflow Connections.
+    :param local_filepath: local file path to get or put. (templated)
+    :param remote_filepath: remote file path to get or put. (templated)
+    :param operation: specify operation 'get' or 'put', defaults to put
+    :param create_intermediate_dirs: create missing intermediate directories when
+        copying from remote to local and vice-versa. Default is False.
+
+        Example: The following task would copy ``file.txt`` to the remote host
+        at ``/tmp/tmp1/tmp2/`` while creating ``tmp``,``tmp1`` and ``tmp2`` if they
+        don't exist. If the parameter is not passed it would error as the directory
+        does not exist. ::
+
+            put_file = FTPOperator(
+                task_id="test_ftp",
+                ftp_conn_id="ftp_default",
+                local_filepath="/tmp/file.txt",
+                remote_filepath="/tmp/tmp1/tmp2/file.txt",
+                operation="put",
+                create_intermediate_dirs=True,
+                dag=dag
+            )
+
+    """
+
+    template_fields: Sequence[str] = ('local_filepath', 'remote_filepath')
+
+    def __init__(
+        self,
+        *,
+        ftp_conn_id: str,
+        local_filepath: str | list[str],
+        remote_filepath: str | list[str],
+        operation: str = FTPOperation.PUT,
+        create_intermediate_dirs: bool = False,
+        **kwargs,
+    ) -> None:
+        super().__init__(**kwargs)
+        self.ftp_conn_id = ftp_conn_id
+        self.operation = operation
+        self.create_intermediate_dirs = create_intermediate_dirs
+
+        self.local_filepath_was_str = False
+        if isinstance(local_filepath, str):
+            self.local_filepath = [local_filepath]
+        else:
+            self.local_filepath = local_filepath
+
+        if isinstance(remote_filepath, str):
+            self.remote_filepath = [remote_filepath]
+        else:
+            self.remote_filepath = remote_filepath
+
+        if len(self.local_filepath) != len(self.remote_filepath):
+            raise ValueError(
+                f'{len(self.local_filepath)} paths in local_filepath '
+                f'!= {len(self.remote_filepath)} paths in remote_filepath'
+            )
+
+        if self.operation.lower() not in [FTPOperation.GET, FTPOperation.PUT]:
+            raise TypeError(
+                f"Unsupported operation value {self.operation}, "
+                f"expected {FTPOperation.GET} or {FTPOperation.PUT}."
+            )
+
+    @cached_property
+    def hook(self) -> FTPHook:
+        """Create and return an FTPHook."""
+        return FTPHook(ftp_conn_id=self.ftp_conn_id)
+
+    def execute(self, context: Any) -> str | list[str] | None:
+        file_msg = None
+        try:
+            for local_filepath, remote_filepath in zip(self.local_filepath, self.remote_filepath):
+                if self.operation.lower() == FTPOperation.GET:
+                    local_folder = os.path.dirname(local_filepath)
+                    if self.create_intermediate_dirs:
+                        Path(local_folder).mkdir(parents=True, exist_ok=True)
+                    file_msg = f"from {remote_filepath} to {local_filepath}"
+                    self.log.info("Starting to transfer %s", file_msg)
+                    self.hook.retrieve_file(remote_filepath, local_filepath)
+                else:
+                    remote_folder = os.path.dirname(remote_filepath)
+                    if self.create_intermediate_dirs:
+                        self.hook.create_directory(remote_folder)
+                    file_msg = f"from {local_filepath} to {remote_filepath}"
+                    self.log.info("Starting to transfer file %s", file_msg)
+                    self.hook.store_file(remote_filepath, local_filepath)
+        except Exception as e:
+            raise AirflowException(f"Error while transferring {file_msg}, error: {str(e)}")

Review Comment:
   Minor nit:
   Catching general `Exception` is a slight code-smell (most IDEs will yell at you for doing it, for exampole) and I'm not sure throwing a new `AirflowException` adds much here, you'll get the `During handling of the above exception, another exception occurred:` double exception output which I find just confuses a lot of people if the second exception isn't actually a problem.
   
   If you just want to add more context you can log an error message in a `finally` block and then just let the original exception bubble up.
   
   P.S. You could also use the py3 syntax `raise <new exception> from <old exception>` but you still get the double stacked exception output in that case, but it's now logged as `The above exception was the direct cause of the following exception:` which I still think causes more confusion than it solves.



##########
airflow/providers/ftp/operators/ftp.py:
##########
@@ -0,0 +1,135 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+"""This module contains FTP operator."""
+from __future__ import annotations
+
+import os
+from pathlib import Path
+from typing import Any, Sequence
+
+from airflow.compat.functools import cached_property
+from airflow.exceptions import AirflowException
+from airflow.models import BaseOperator
+from airflow.providers.ftp.hooks.ftp import FTPHook
+
+
+class FTPOperation:
+    """Operation that can be used with FTP"""
+
+    PUT = 'put'
+    GET = 'get'
+
+
+class FTPOperator(BaseOperator):
+    """
+    FTPOperator for transferring files from remote host to local or vice a versa.
+    This operator uses an FTPHook to open ftp transport channel that serve as basis
+    for file transfer.
+
+    :param ftp_conn_id: :ref:`ftp connection id<howto/connection:ftp>`
+        from airflow Connections.
+    :param local_filepath: local file path to get or put. (templated)
+    :param remote_filepath: remote file path to get or put. (templated)
+    :param operation: specify operation 'get' or 'put', defaults to put
+    :param create_intermediate_dirs: create missing intermediate directories when
+        copying from remote to local and vice-versa. Default is False.
+
+        Example: The following task would copy ``file.txt`` to the remote host
+        at ``/tmp/tmp1/tmp2/`` while creating ``tmp``,``tmp1`` and ``tmp2`` if they
+        don't exist. If the parameter is not passed it would error as the directory
+        does not exist. ::
+
+            put_file = FTPOperator(
+                task_id="test_ftp",
+                ftp_conn_id="ftp_default",
+                local_filepath="/tmp/file.txt",
+                remote_filepath="/tmp/tmp1/tmp2/file.txt",
+                operation="put",
+                create_intermediate_dirs=True,
+                dag=dag
+            )
+
+    """
+
+    template_fields: Sequence[str] = ('local_filepath', 'remote_filepath')
+
+    def __init__(
+        self,
+        *,
+        ftp_conn_id: str,
+        local_filepath: str | list[str],
+        remote_filepath: str | list[str],
+        operation: str = FTPOperation.PUT,
+        create_intermediate_dirs: bool = False,
+        **kwargs,
+    ) -> None:
+        super().__init__(**kwargs)
+        self.ftp_conn_id = ftp_conn_id
+        self.operation = operation
+        self.create_intermediate_dirs = create_intermediate_dirs
+
+        self.local_filepath_was_str = False

Review Comment:
   This looks unused?



##########
docs/apache-airflow-providers-ftp/operators/index.rst:
##########
@@ -0,0 +1,64 @@
+.. Licensed to the Apache Software Foundation (ASF) under one
+    or more contributor license agreements.  See the NOTICE file
+    distributed with this work for additional information
+    regarding copyright ownership.  The ASF licenses this file
+    to you under the Apache License, Version 2.0 (the
+    "License"); you may not use this file except in compliance
+    with the License.  You may obtain a copy of the License at
+
+ ..   http://www.apache.org/licenses/LICENSE-2.0
+
+ .. Unless required by applicable law or agreed to in writing,
+    software distributed under the License is distributed on an
+    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+    KIND, either express or implied.  See the License for the
+    specific language governing permissions and limitations
+    under the License.
+
+
+
+.. _howto/operator:FTPOperator:
+
+FTPOperator
+===============
+
+
+Use the FTPOperator to get or
+pull files to/from an FTP server.
+
+Using the Operator
+^^^^^^^^^^^^^^^^^^
+
+| **ftp_conn_id**: id referencing an FTP Connection **str**
+| **local_filepath**: local file path to get or put. **str**
+| **remote_filepath**: remote file path to get or put. **str**
+| **operation**: specify operation 'get' or 'put' **str** - Default: **PUT**
+| **create_intermediate_dirs**: create missing intermediate directories when copying from remote to local and vice-versa. **bool** - Default: **False**

Review Comment:
   Just link to the class using `:class:` (search around for examples in `airflow/docs` I can't link one easily since Github will just render the rst and not deep link to the code line)  instead of hardcoding the current set of arguments here, this will quickly become out of date/sync.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org