django postgres JSONField |查询以 checkin 值列表(包含)

Question

在 django 1.9(使用 postgresdb)中，我们正在使用 JSONField(在模型中)，其条目如下所示:

**Entry 1**(in a row of that table):
data: {
  "key1": "value1",
  "key2": "value2",
  "key3": "value3",
  "key4": "value4"
}

**Entry 2**(in a row of that table):
data: {
  "key5": "value4",
  "key6": "value2",
  "key7": "value2",
  "key8": "value4"
}

我想查询值，比如 data__value__contains='value4'

Django 支持“键”(has_key, has_any_keys, has_keys) 相关查询

查询上述需求的好方法是什么？

Answer 1

如何使用 HStoreField 而不是 JSONField，这样您就可以访问 values查找。

MyModel.objects.filter(data__values__contains='value4')

如 Django docs 中所述，JSON 字段只有这些查找:

Containment and key operations¶

JSONField shares lookups relating to containment and keys with HStoreField.

• contains (accepts any JSON rather than just a dictionary of strings)
• contained_by (accepts any JSON rather than just a dictionary of strings)
• has_key
• has_any_keys
• has_keys