I have the following pieces of code:
this part generates the CSV in memory:
def to_csv(events: list) -> io.BytesIO():
if not events:
return None
bio = io.BytesIO()
iow = io.TextIOWrapper(bio)
writer = csv.DictWriter(iow, fieldnames=events[0].keys())
writer.writeheader()
writer.writerows(events)
iow.flush()
bio.seek(0)
return bio
this part sends this file to the FTP server:
def send_data(self, bytes: io.BytesIO) -> str:
filename = f"{time.time()}.csv"
if not bytes:
self.__logger.warning("No data to send")
return None
try:
self.__ftp.storbinary(f"STOR {filename}", bytes)
except ftp.all_errors as e:
self.__logger.error(
"FTP fail data send",
extra={
"host": self.__cfg.ftp.host,
"type": type(e).__name__,
"line": e.__traceback__.tb_lineno,
"file": __file__,
"detail": e,
},
)
return None
The file that is passed to send_data is closed. How do I reopen it? I tried to do something like this:
f = open(bytes, "rb")
print(f.getvalue())
But an error is returned:
expected str, bytes or os.PathLike object, not _io.BytesIO
Traceback:
Traceback (most recent call last):
File "/home/airflow/.local/lib/python3.7/site-packages/airflow/operators/python.py", line 171, in execute
return_value = self.execute_callable()
File "/home/airflow/.local/lib/python3.7/site-packages/airflow/operators/python.py", line 189, in execute_callable
return self.python_callable(*self.op_args, **self.op_kwargs)
File "/opt/airflow/dags/accounting/main.py", line 29, in process_events
result = Uploader(logger, cfg).send_data(csv_file)
File "/opt/airflow/dags/accounting/packages/uploader.py", line 57, in send_data
self.__ftp.storbinary(f"STOR {filename}", bytes)
File "/usr/local/lib/python3.7/ftplib.py", line 513, in storbinary
buf = fp.read(blocksize)
ValueError: I/O operation on closed file.
CodePudding user response:
Once to_csv
is done using the io.TextIOWrapper
, it needs to detach the wrapper from the underlying io.BytesIO
object, to stop the wrapper from trying to close the BytesIO object:
iow.detach()