python - Django的bulk_create导致重复条目完整性错误

Question

我有以下模型:

class GeneratedContent(models.Model):
    entity = models.ForeignKey('companies.Entity')
    source_url = models.URLField(max_length=255)
    title = models.CharField(max_length=255, blank=True, null=True)
    desc = models.TextField(blank=True, null=True)
    created_at = models.DateTimeField(auto_now_add = True)
    updated_at = models.DateTimeField(auto_now = True)

    def __str__(self):  
        return self.entity.name +' Content'

然后我处理一些 url，然后保存大量这些对象，如下所示:

gen_content_list = []
        for e in entities:
            entity_status = get_tweets(e.twitter_handle())

            try:
                stat_url = re.search("(?P<url>https?://[^\s]+)", entity_status).group("url")
                gen_content = GeneratedContent.objects.create(
                    entity=e,
                    desc=entity_status,
                    source_url=stat_url,
                    crawled=False,
                    )
                gen_content_list.append(gen_content)
                self.stdout.write(self.style.SUCCESS(e.name+' status: '+stat_url.encode('ascii','replace')))
            except:
                pass
        if gen_content_list:
            GeneratedContent.objects.bulk_create(gen_content_list)

我收到以下错误:

django.db.utils.IntegrityError: (1062, "Duplicate entry '19' for key 'PRIMARY'")

我做错了什么？

Answer 1

问题在于您正在调用 create()(它在数据库中创建实例)，然后尝试执行 bulk_create()。相反，创建一个未保存的模型实例:

gen_content = GeneratedContent(...)