django-hstore,postgresqldb

155 views
Skip to first unread message

Jayesh Dhamunshe

unread,
Oct 16, 2012, 5:40:08 AM10/16/12
to opendataca...@googlegroups.com



hello sir,
i'am trying to use django-hstore with postgresqldb

using this link:


 models.py


from django.db import models
from django_hstore import hstore



class Product(models.Model):
    name = models.CharField(max_length=250)
    data = hstore.DictionaryField(db_index=True)
    objects = hstore.HStoreManager()

    def __unicode__(self):
        return self.name

done with syncdb
using shell command

python manage,py shell

In python prompt 

>>> from product.models import *
>>> from django_hstore import hstore
>>> Product.objects.create(name='Django Pony', data={'rating': '5'})
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/models/manager.py", line 138, in create
    return self.get_query_set().create(**kwargs)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/models/query.py", line 360, in create
    obj.save(force_insert=True, using=self.db)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/models/base.py", line 460, in save
    self.save_base(using=using, force_insert=force_insert, force_update=force_update)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/models/base.py", line 553, in save_base
    result = manager._insert(values, return_id=update_pk, using=using)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/models/manager.py", line 195, in _insert
    return insert_query(self.model, values, **kwargs)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/models/query.py", line 1436, in insert_query
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 791, in execute_sql
    cursor = super(SQLInsertCompiler, self).execute_sql(None)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 735, in execute_sql
    cursor.execute(sql, params)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/backends/util.py", line 34, in execute
    return self.cursor.execute(sql, params)
  File "/home/jayesh/SFC/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute
    return self.cursor.execute(query, args)
DatabaseError: can't adapt type 'HStoreDictionary'

------please help



Reply all
Reply to author
Forward
0 new messages