Re: my project doesnt insert into the database

Solved. I added a sleep at the end of my loop and it worked, I think it was getting stuck because the db was not able to keep up with the update from the app and so the session got interrupted.

Em sexta-feira, 28 de outubro de 2022 às 10:46:54 UTC-4, Otávio Augusto escreveu:

Greetings, I'm doing a integration projection, so I need to consume data from a RESTful API and then save that data inside a oracle db. My models migrated and succesfully created the tables, I was able to get the data from the API and parse trough it to filter the info I wanted and needed to save normally, then I first used 'objects.update_or_create' to populate my table, initially it seemed to work but after some time it got stuck and stopped inserting data into the table, I tried to switch to simply 'objects.create' but it didnt work. I dont seem to find the issue that is holding the insertion in place and decided to seek for help.

For illustration, this is how I builted the code block that is getting stuck:

for item in value_list['itens']:

     print(item)

     Item.objects.using('default').create(

              nature=item['nature'],

              date=item['date'],

              doc_number=item['doc_number'],

              name=item['name'],

              description=item['description']

    )

I even added .save(force_insert=True) to try and brute force the insertion on the table but no avail. Need help!

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/d37b05ad-7ea7-44a4-bdb2-86742c7622b7n%40googlegroups.com.