Django get_or_create返回models.DoesNotExist导入CSV [英] Django get_or_create returning models.DoesNotExist while importing a CSV

问题描述

我已经花了很多时间来弄清楚这一点。我只想使用Python的csv模块和Django的get_or_create（）导入CSV文件。

这是我的简单代码（建立在此代码）：

  import csv 
从.models import Person 
 
 def import_data（）：
 with open（'/ path / to / csv / people_list.csv'）as f：
 reader = csv.reader （f）读者中的行
 
 _，created = Org.objects.get_or_create（
 name = row [0]，
 p_id = row [1]，
 current_status = row [2]，
）
  

当我发现以下错误在shell上运行import_data（）

  peoplelisting.models.DoesNotExist：人物匹配查询不存在。 
  

是的，这个特定的人不存在，但是不是使用get_or_create（）的整个点？如果它不存在，创建它？

解决方案

经过很多的玩耍，最后想到的问题是： p>

我的csv还包含一个我不忽略的标题行。我以为我会进行一顿饭，只有在我得到csv导入工作后才忽略标题，但是标头本身正在创建问题（感谢这个（间接）帮了很多）。标题中的值与模式（max_length等）不匹配，而且 Person匹配查询不存在是指的。忽略标题使其工作。我只希望错误信息更具描述性。希望它有助于别人节省我花了很多时间来调试一个简单的事情。这是正确的代码：

  import csv 
 from .models import Person 
 
 def import_data （）：
 with open（'/ path / to / csv / people_list.csv'）as f：
 reader = csv.reader（f）
 for reader in reader：
如果row [0]！='Person_name'：#where Person_name是第一列的名称
 _，created = Org.objects.get_or_create（
 name = row [0]，
 p_id =行[1]，
 current_status =行[2]，
）
  

I have spent quite sometime to figure this out. I am simply trying to import a CSV file using Python's csv module and Django's get_or_create().

This is my simple code (built upon this code):

import csv
from .models import Person

def import_data():
    with open('/path/to/csv/people_list.csv') as f:
           reader = csv.reader(f)
           for row in reader:
               _, created = Org.objects.get_or_create(
                   name=row[0],
                   p_id=row[1],
                   current_status=row[2],
                   )

I get the following error when I run import_data() on the shell

peoplelisting.models.DoesNotExist: Person matching query does not exist.

Yes, this particular Person does not exist but isnt that the whole point of using get_or_create()? If it doesnt exist, create it?

解决方案

After a lot of playing around, finally figured the issue was the following:

My csv also contained a header row which I was not ignoring. I thought I'll proceed piece-meal and ignore the header only after I get the csv importing to work but the header itself was creating the problem (thanks to this post which (indirectly) helped a lot). The values in the header did not match the schema (max_length etc.) and thats what Person matching query does not exist was referring to. Ignoring the header made it work. I just hope that the error message was more descriptive though. Hope it helps someone else save the hours I spent debugging a simple thing. Here's the correct code:

import csv
from .models import Person

def import_data():
    with open('/path/to/csv/people_list.csv') as f:
           reader = csv.reader(f)
           for row in reader:
              if row[0] != 'Person_name': #where Person_name is first column's name
                 _, created = Org.objects.get_or_create(
                     name=row[0],
                     p_id=row[1],
                     current_status=row[2],
                     )

这篇关于Django get_or_create返回models.DoesNotExist导入CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！