首页 文章

django:从postgres数据库导入数据时无法调整错误

提问于
浏览
4

从转储数据安装夹具我遇到了奇怪的错误 . 我正在使用psycopg2和django1.1.1

silver:probsbox oleg$ python manage.py loaddata /Users/oleg/probs.json 
Installing json fixture '/Users/oleg/probs' from '/Users/oleg/probs'.
Problem installing fixture '/Users/oleg/probs.json': Traceback (most recent call last):
  File "/opt/local/lib/python2.5/site-packages/django/core/management/commands/loaddata.py", line 153, in handle
    obj.save()
  File "/opt/local/lib/python2.5/site-packages/django/core/serializers/base.py", line 163, in save
    models.Model.save_base(self.object, raw=True)
  File "/opt/local/lib/python2.5/site-packages/django/db/models/base.py", line 495, in save_base
    result = manager._insert(values, return_id=update_pk)
  File "/opt/local/lib/python2.5/site-packages/django/db/models/manager.py", line 177, in _insert
    return insert_query(self.model, values, **kwargs)
  File "/opt/local/lib/python2.5/site-packages/django/db/models/query.py", line 1087, in insert_query
    return query.execute_sql(return_id)
  File "/opt/local/lib/python2.5/site-packages/django/db/models/sql/subqueries.py", line 320, in execute_sql
    cursor = super(InsertQuery, self).execute_sql(None)
  File "/opt/local/lib/python2.5/site-packages/django/db/models/sql/query.py", line 2369, in execute_sql
    cursor.execute(sql, params)
  File "/opt/local/lib/python2.5/site-packages/django/db/backends/util.py", line 19, in execute
    return self.cursor.execute(sql, params)
ProgrammingError: can't adapt

首先,我在互联网上检查了类似的问题 . 这个似乎非常相关:http://code.djangoproject.com/ticket/5996,因为我的数据有很多非ASCII符号

但实际上我已经检查了我的django安装,它没关系

你能说出错的吗?

====

根据第一个答案建议添加打印声明后继续调查 . 日志看起来像这样:

silver:probsbox oleg$ python manage.py loaddata /Users/oleg/probs.json 
Installing json fixture '/Users/oleg/probs' from '/Users/oleg/probs'.
<DeserializedObject: Novice>
<DeserializedObject: Junior>
<DeserializedObject: Chess enthusiast>
<DeserializedObject: Experienced player >
<DeserializedObject: Smart player>
Problem installing fixture '/Users/oleg/probs.json': Traceback (most recent call last):
  File "/opt/local/lib/python2.5/site-packages/django/core/management/commands/loaddata.py", line 153, in handle
    print obj
  File "/opt/local/lib/python2.5/site-packages/django/core/serializers/base.py", line 155, in __repr__
    return "<DeserializedObject: %s>" % smart_str(self.object)
  File "/opt/local/lib/python2.5/site-packages/django/utils/encoding.py", line 107, in smart_str
    return str(s)
  File "/opt/local/lib/python2.5/site-packages/django/db/models/base.py", line 335, in __str__
    return force_unicode(self).encode('utf-8')
  File "/opt/local/lib/python2.5/site-packages/django/utils/encoding.py", line 71, in force_unicode
    s = unicode(s)
  File "/Users/oleg/Sites/probsbox/registration/models.py", line 58, in __unicode__
    return u"%s's profile" %(self.user.username)
  File "/opt/local/lib/python2.5/site-packages/django/db/models/fields/related.py", line 257, in __get__
    rel_obj = QuerySet(self.field.rel.to).get(**params)
  File "/opt/local/lib/python2.5/site-packages/django/db/models/query.py", line 305, in get
    % self.model._meta.object_name)
DoesNotExist: User matching query does not exist.

silver:probsbox oleg$

最后一条评论出错

<DeserializedObject: qwert2000's profile>

问题安装夹具'/Users/oleg/probs.json':Traceback(最近一次调用最后一次):文件“/opt/local/lib/python2.5/site-packages/django/core/management/commands/loaddata.py “,第154行,句柄obj.save()文件”/opt/local/lib/python2.5/site-packages/django/core/serializers/base.py“,第163行,保存模型.Model.save_base (self.object,raw = True)文件“/opt/local/lib/python2.5/site-packages/django/db/models/base.py”,第495行,在save_base结果= manager._insert(values, return_id = update_pk)文件“/opt/local/lib/python2.5/site-packages/django/db/models/manager.py”,第177行,在_insert中返回insert_query(self.model,values,** kwargs)文件“/opt/local/lib/python2.5/site-packages/django/db/models/query.py”,第1087行,在insert_query中返回query.execute_sql(return_id)文件“/ opt / local / lib / python2 .5 / site-packages / django / db / models / sql / subqueries.py“,第320行,在execute_sql cursor = super(InsertQuery,self).execute_sql(无)文件”/opt/local/lib/python2.5 /站点包/ Django的/ DB /月dels / sql / query.py“,第2369行,在execute_sql cursor.execute(sql,params)文件”/opt/local/lib/python2.5/site-packages/django/db/backends/util.py“,第19行,在执行中返回self.cursor.execute(sql,params)ProgrammingError:无法适应

2 回答

  • 0

    psycopg2收到的数据类型没有't know how to translate into a value for a SQL statement. For example, if you accidentally pass a list, say, for a value that is supposed to be an integer, psycopg2 will raise this can't适应错误时会引发 can't adapt 错误 .

    与psycopg2的源代码分发一起提供的 faq.txt 文档以这种方式解释:

    为什么!cursor.execute()引发异常无法适应? Psycopg通过查看对象类来转换SQL字符串表示形式的Python对象 . 当您尝试将没有为其类注册的适配器的对象作为查询参数传递时,会引发异常 . 请参阅:ref:adapting-new-types for informa .

    在找到有问题的值时,你可能最好的第一步是在完全冗长的模式下运行loaddata:python manage.py loaddata --verbosity = 2 /Users/oleg/probs.json

    好吧,我希望loaddata详细程度能够正常工作,我绝不会找到一种优雅的调试适配错误的方法,因为django 's loaddata. In the past, I'已经在django 's loaddata function so that I can see the values being deserialized when the error occurs. I' ve编辑 django/core/management/loaddata.py 中插入了打印语句 . 在 handle() 函数中查看 obj.save() . 我希望这个忏悔鼓励某人分享更好的解决方案:-)

  • 5

    好的,我结束了从我的数据库中复制转储,并在没有python的情况下在本地恢复...

相关问题