How to create self destructive csv file

Asked Dec 21 '20 at 11:19

Active Dec 21 '20 at 11:19

Viewed 148 times

I have an django app which create csv file from database queryset and send it to api as following

#create queryset
qs=Apple.objects.filter(args)
#create csv file 
with open('foo.csv','wb') as f:
    write(qs,f)
    res=requests.post(url,{'file':f})

I didnt list full code of creating csv from queryset because it isnt important for me. My focus is on csv file itself. I want to create csv, send it than destroy it. Because neccesity in csv file only that api where i send data receive data only in csv. And data which i put in csv have in my darabase. Currently after sending file i delete it by os.remove but i didnt like it. I was thinking about temporary file or any another solution

asked Dec 21 '20 at 11:19

Наглый Спамер

2

OK, what's wrong with a temp file? – juanpa.arrivillaga Dec 21 '20 at 11:22
See [this](https://stackoverflow.com/questions/8577137/how-can-i-create-a-tmp-file-in-python) post for dealing with temporary files in Python. – costaparas Dec 21 '20 at 11:23
3

You can use an in-memory file using https://docs.python.org/3/library/io.html#text-i-o – Iain Shelvington Dec 21 '20 at 11:24

How to create self destructive csv file

0 Answers0