django-json-field2 is a flexible quering JSONField and associated form field
It is a compilation and adaptation of the following projects
- https://bitbucket.org/schinckel/django-jsonfield
- https://github.com/derek-schaefer/django-json-field
- https://github.com/bradjasper/django-jsonfield
- https://github.com/certae/django-softmachine/blob/master/src/protoLib/fields.py
- https://github.com/frol/django-quering-jsonfield
- http://cramer.io/2009/04/14/cleaning-up-with-json-and-sql/
- http://natebeacham.com/blog/nate-beacham/31/
South support Form field Form widget Model field Python3 support
django-jsonfield2 is also compatible with South, Django 1.8 and Python 3.
Install from PyPI:
pip install django-jsonfield2
git clone git://github.com/DarioGT/django-jsonfield2.git
Add jsonfield2 to your PYTHONPATH and INSTALLED_APPS setting:
INSTALLED_APPS = (
...
'jsonfield2',
...
)
from django.db import models
from jsonfield2 import JSONField, JSONAwareManager
class JsonModel(models.Model):
code = models.CharField( blank=False, null=False, max_length=20 )
status = models.CharField( blank=True, null=True, max_length=20 )
info = JSONField(default={})
objects = JSONAwareManager(json_fields = ['info'])
def __str__(self):
return self.code
...
obj = Person.objects.create(name = "Bill")
obj.info = {
'sex': 'male',
'address': {
'country', 'Canada',
}
}
obj.save()
Person.objects.filter(info__address__country = 'Canada')
>>> [Person: "Bill"]
Now, it will validate the JSON on entry, and store it as a text in the database. When you instantiate/fetch the object, it will be turned back into a python list/dict/string.
This allows you to convert a python data structure into JSON within a template:
{% load jsonify %}
<script>
var foo = {{ bar|jsonify }};
</script>
python runtest.py
Allow order_by when json criteria are used
django-jsonfield2 is licensed under the New BSD license.