banco => CREATE EXTENSION hstore;
-------------------------------------
select
id, campo->'chave'
from
tabela
where
campo->'chave' = 'Valor'
# Terminal
$ pip install -e \
django-hstore-flattenfields \
git+git://github.com/multmeio/django-hstore
# settings.py
DATABSES = {
'default': {
'engine':
'django_hstore.postgresql_psycopg2',
...
}
PG_VERSION = (9, 1)
INSTALLED_APPS = (
'hstore_flattenfields',
'django_hstore',
)
# models.py
from django.db import models
from hstore_flattenfields.models import *
class Person(HStoreModel):
name = models.CharField(max_lenght=100)
+----------------------------------------+ | tabela | +----------------------------------------+ | ID | NAME | campo_hstore | | 1 | 'JESUS' | {'RG':'19216801'} | | 2 | 'MARIA' | {'SEXO':'F'} | | 3 | 'JOSE' | {'IDADE':'21'} | +----------------------------------------+
+----------------------------------------+ | tabela |
+----------------------------------------+ | ID | NAME | campo_hstore | | 1 | 'JESUS' | {'RG':'19216801'} | | 2 | 'MARIA' | {'SEXO':'F'} | | 3 | 'JOSE' | {'IDADE':'21'} | +----------------------------------------+
>>> Person.objects.count()
10
>>> Person.objects.filter(idade__gte=21).count()
3
>>> Person.objects.exclude(idade__lt=21).count()
7
>>> Person.objects.values('data_nasc')
[{'data_nasc': datetime.date(2013, 7, 26)}]
>>> Book.objects.values('author__data_nasc')
from hstore_flattenfields.db import aggregates
>>> Book.objects.aggregate(
aggregates.HstoreSum('pages'),
aggregates.HstoreAvg('pages')
[{'pages__avg': 3, 'pages__sum': 28}]
>>> from model_mommy import mommy
>>> b = mommy.make(Book, pages=22)
>>> b.pages
22
By Luan Fonseca de Farias
