How can I create objects in a for-loop in python?

Question

I'm trying to create some objects in database through a for loop in python, but when I try, it only inserts last one.

This is the code I have, where 'langssplit' is a list, the result of spliting a string like '2-3' (the pks of the Language rows in the table). I need to create and insert an object into the database for each element on the list, but it only saves the last one. The newprofile is an object I have already created.

langsparam = request.GET.get('langs', '')
langssplit = langsparam.split('-')
for lan in langssplit:
        lang = Languages.objects.filter(pk=lan).first()
        newprofilelan = ProfilesLanguages(profile=newprofile, language=lang)
        newprofilelan.save()

What am I doing wrong?

Thanks for any help!

UPDATE WITH MODELS

class Profiles(models.Model):
    alias = models.CharField(max_length=40)
    mail = models.CharField(max_length=255)
    mainimg = models.ForeignKey(Multimedia, models.DO_NOTHING)
    birthdate = models.DateTimeField(blank=True, null=True)
    country = models.CharField(max_length=30, blank=True, null=True)
    password = models.CharField(max_length=255)
    terms = models.IntegerField(blank=True, null=True)
    device_token = models.CharField(max_length=500)

    class Meta:
        managed = False
        db_table = 'profiles'

class Languages(models.Model):
    name = models.CharField(max_length=30)

    def natural_key(self):
        return (self.pk, self.name)

    class Meta:
        managed = False
        db_table = 'languages'

class ProfilesLanguages(models.Model):
    profile = models.ForeignKey(Profiles, models.DO_NOTHING, primary_key=True)
    language = models.ForeignKey(Languages, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'profiles_languages'
        unique_together = (('profile', 'language'),)

Where is model?

Nishant Nawarkhede
– Nishant Nawarkhede

2019-09-17 08:20:53 +00:00
Commented Sep 17, 2019 at 8:20 — Nishant Nawarkhede
– Nishant Nawarkhede, Commented Sep 17, 2019 at 8:20
Models uploaded @NishantNawarkhede, forgot it.

Ian Ortega
– Ian Ortega

2019-09-17 08:24:44 +00:00
Commented Sep 17, 2019 at 8:24 — Ian Ortega
– Ian Ortega, Commented Sep 17, 2019 at 8:24

Nishant Nawarkhede · Accepted Answer · 2019-09-17 08:23:38Z

2

I think you need to you force_insert=True,

newprofilelan.save(force_insert=True)

answered Sep 17, 2019 at 8:23

Nishant Nawarkhede

8,40813 gold badges61 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ian Ortega Over a year ago

Will give a try. Thanks

Ian Ortega Over a year ago

Worked like a charm, thanks! Any explanation on why it doesn't insert by default when creating and saving an object? I'm curious...

Collectives™ on Stack Overflow

How can I create objects in a for-loop in python?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related