In Django ORM, how does one get_or_create for values in JSONField?

Question

I am having a Django model like:

class Subscription(models.Model):
    data = JSONField(default=dict)

I want to do something like this:

data = {"product_id": 123, "available": False}
subscription, new = Subscription.objects.get_or_create(data__product_id=123, 
data__available=False)

I tried doing the above but it just set the field as empty dictionary.

try this subscription, new = Subscription.objects.get_or_create(product_id=data['product_id'], available=data['available']) — Exprator, Jul 05 '17 at 12:09
I believe you're looking for this `Subscription.objects.get_or_create(data=data)` — Kamil, Jul 05 '17 at 12:11
`Subscription.objects.get_or_create(data={'product_id': 123, available=False})` — alfonso.kim, Jul 05 '17 at 13:26

score 0 · Answer 1 · answered Jul 05 '17 at 14:32

0

Try this:-

models.py :-
class Subscription(models.Model):
    data = JSONField(db_index=True,null=True)

views.py:-
DictToStore = {"product_id": 123, "available": False}
subscription, new = Subscription.objects.get_or_create(data=DictToStore)

answered Jul 05 '17 at 14:32

Piyush S. Wanare

4,703
6
37
54

In Django ORM, how does one get_or_create for values in JSONField?

1 Answers1