foreign key relations in django bulk_create query?

Question

Is it possible to use bulk_create method on columns with foreign key relations??

class Reports(models.Model):
    groupname=models.CharField(max_length=250, null=True, blank=True);
    datecreated = models.DateTimeField(null=True, blank=True);


class Reportsquery(models.Model):
    group = models.ForeignKey(Reports,null=True, blank=True);
    queryset=models.CharField(max_length=1000, null=True, blank=True);

list=[Reportsquery({"group__id":6,"queryset":"abc"}),....,...]

Reportsquery.objects.bulk_create(list)

similar query works on get_or_create() method but returns an error when used with bulk_create() eg:

Reportsquery.objects.get_or_create(group__id=6,quseryset="abc")

The above example inserts group__id=6 into Reportsquery table

Answer 1

If what you're trying to do is create instances of Reports alongside the Reportsquery, then no bulk_create() won't do this. However, if the instances of Reports already exist in the database then you could manually add their pk's to the list you pass to bulk_create(). Then the Reportquery instances will be created with the correct relations to Reports.