Skip to content

Instantly share code, notes, and snippets.

View moradology's full-sized avatar

Nathan Zimmerman moradology

  • Philadelphia, PA
View GitHub Profile
@ddohler
ddohler / extensions.py
Created September 29, 2015 17:34
Subclass F objects to provide JSONB field access in Django 1.8+
from django.db.models import F
# Needs expansion but may eventually allow things like:
# recs = Record.objects.annotate(num_killed=JBF('data').jbPath(Value("{Accident Details, Number killed}"))).filter(num_killed__asint=1)
class JBF(F):
JB_PATH = '#>'
JB_PATH_STR = '#>>'
JB_FIELD = '->'
JB_FIELD_STR = '->>'