Skip to main content

A JSON field for Oracle backends.

Project description

# Oracle Json Field
django_json_field is a reusable Django field that allows you to store validated JSON your database and your model
It is heavily inspired by the Postgres Json Field and this generic json field:

## PreRequisites
To use oracle-json-field you will need Django 2.0+ and Python3+

## Installation
Install via pip

pip install oracle-json-field

Or install via source

python install

## Setup
Update Django settings as follows

INSTALLED_APPS += ('oracle_json_field',)

## Define your models

from oracle_json_field.fields import JSONField
from oracle_json_field.managers import JsonQueryManager

class JsonModel(models.Model):
json = JSONField()
default_json = JSONField(default={"key1": 50})
complex_default_json = JSONField(default=[{"key1": 50}])
empty_default = JSONField(default={})

objects = JsonQueryManager()

## Create and **Natively** query any field in your json
"person": {
"age": 25,
"first_name": "Joe",
"last_name": "Blogs",
"address": {
"number": "52",
"street": "Here Terrace",
"post_code": "ABC 123",
"city": "Anytown",


JsonModel.objects.filter_json(json__person__address__city__in=['Anytown', 'Sometown'])

## Running the test suite:
In order to run the test suite, you will need to create an oracle user
and export the following environment variables:


This link describes how to setup the testing user:

Then run the following command

python test

You should then see:

running test
Creating test database for alias 'default'...
Creating test user...
System check identified no issues (0 silenced).
Preserving test database for alias 'default'...
Ran 38 tests in 4.900s


Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

oracle-json-field-0.0.7.tar.gz (7.3 kB view hashes)

Uploaded source

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page