CODEWITHSUNDEEP
pythondjangodjango-models
GrantU
GrantU

Reputation: 6555

Django bulk_create function example

I'm trying to understand bulk_create in Django

This was my original query I'm trying to convert:

for e in q:
    msg = Message.objects.create(
        recipient_number=e.mobile,
        content=batch.content,
        sender=e.contact_owner,
        billee=batch.user,
        sender_name=batch.sender_name
    )

Does that mean doing the following (below) will loop and create all the entries first then hit the database? Is this right?

msg = Message.objects.bulk_create({
    Message (
        recipient_number=e.mobile,
        content=batch.content,
        sender=e.contact_owner,
        billee=batch.user,
        sender_name=batch.sender_name
    ),
})

Upvotes: 38

Views: 33399

Answers (3)

user11750605
user11750605

Reputation:

Simple, just do this:

class Entry(models.Model):
    blog = models.ForeignKey(Blog, on_delete=models.CASCADE)
    headline = models.CharField(max_length=255)
    body_text = models.TextField()
    pub_date = models.DateField()
    mod_date = models.DateField()

Now, to Bulk Create

Entry.objects.bulk_create([
        Entry(headline='This is a test'),
        Entry(headline='This is only a test'),
 ])

Upvotes: 2

Yagmur SAHIN
Yagmur SAHIN

Reputation: 325

name = request.data.get('name')
period = request.data.get('period')
email = request.data.get('email')
prefix = request.data.get('prefix')
bulk_number = int(request.data.get('bulk_number'))

bulk_list = list()
for _ in range(bulk_number):
    code = code_prefix + uuid.uuid4().hex.upper()
    bulk_list.append(
        DjangoModel(name=name, code=code, period=period, user=email))

bulk_msj = DjangoModel.objects.bulk_create(bulk_list)

Upvotes: 0

falsetru
falsetru

Reputation: 369424

The second code in the question create a single object, because it pass a set with a Message object.

To create multiple objects, pass multiple Message objects to bulk_create. For example:

objs = [
    Message(
        recipient_number=e.mobile,
        content=batch.content,
        sender=e.contact_owner,
        billee=batch.user,
        sender_name=batch.sender_name
    )
    for e in q
]
msg = Message.objects.bulk_create(objs)

Upvotes: 64

Related Questions