Don't save anything if error on save method

[elcaiaimar]

Hello,

I' ve an application where I upload a CSV file and save all its rows in a database. This is ok, but, at the moment, when I upload the file and it exists some error on it, it saves all rows until the wrong row. What I want to achieve is that if there is an error when I save, don't save anything. Is there any way to do that?

if formularioarchivomedios.is_valid():

            

   reader = csv.DictReader(request.FILES['docfile'], delimiter=',') 

   for row in reader:

                try:                

                    titulo=row['titulo']

                    url=row['url']

                    my_file = Medios(titulo=titulo, url=url)

                    

                    my_file.save()

Thank you in advance!

[Michal Petrucha]

This is exactly the purpose of database transactions. All you need to
do is to wrap the block of code in transaction.atomic(), like this::

from django.db import transaction

[...]

if formularioarchivomedios.is_valid():
reader = csv.DictReader(request.FILES['docfile'], delimiter=',')

try:
with transaction.atomic():
for row in reader:
titulo = row['titulo']
url = row['url']

my_file = Medios(titulo=titulo, url=url)

my_file.save()

except WhateverErrorYouWantToHandle as e:
handle_error(e)

Just make sure to handle the error outside of the atomic block; that
way, the transaction will be automatically rolled back if an error
does happen. If you handle the error inside the atomic block, Django
will think there was no error, and it will happily try to commit the
transaction as if everything was all right.

Good luck,

Michal