时间戳

首页 > 解决方案 > Django Json Field Query

django - Django Json Field Query

问题描述

I've a JSONField in my model which is storing below types of data.

[
   {
      "name":"Name A",
      "type":"Type1",
      "class_type":"Class A"
   },
   {
      "name":"Name B",
      "type":"Type1",
      "class_type":"Class A"
   },
   {
      "name":"Name C",
      "type":"Type2",
      "class_type":"Class A"
   }
]

I've tried with the example of django documentation. But still return Null

I've tried with SampleCategory.objects.filter(books__name = 'Name A')

标签： django

解决方案

根据文档，您可以book__name在定义 json 数据时使用，如下所示：

data = {
    "name":"Name A",
    "type":"Type1",
    "class_type":"Class A"
}

SampleCategory.objects.create(books=data)

SampleCategory.objects.filter(books__name = 'Name A')

或者，如果您将其定义为数组：

data = [
   {
      "name":"Name A",
      "type":"Type1",
      "class_type":"Class A"
   },
   {
      "name":"Name B",
      "type":"Type1",
      "class_type":"Class A"
   },
   {
      "name":"Name C",
      "type":"Type2",
      "class_type":"Class A"
   }
]
SampleCategory.objects.create(books={'book':data})
SampleCategory.objects.filter(books__0__name = 'Name A')

如果您有一个具有类似结构化字典的数组，请考虑制作单独的模型字段并创建不同的条目。像这样：

class Book(models.Model):
    name = models.CharField(max_length=255)
    type = models.CharField(max_length=255)
    class_type = models.CharField(max_length=255)

并将其用作 FK 以SampleCategory：

class SampleCategory(models.Model):
    books = models.ForeignKey(Book)

然后，您可以在给定问题中按照您想要的方式进行查询（例如SampleCategory.objects.filter(books__name = 'Name A')）。希望能帮助到你。

推荐阅读