Django自定义查询集和自定义筛选器

Question

存储在Django模型中的元素如下

class Transcript(models.Model):
    text = models.CharField(max_length=10000, default="")
    confidence = models.FloatField(default=0)

示例数据如下：

text = "Word1(1.00-1.50) Word2(1.50-2.15) Word3(2.40-2.80) Word4(3.10-3.25) Word5(3.44-4.12) Word6(4.55-5.12) Word7(6.00-7.00) Word8(7.34-8.00)"
Transcript.object.create(text=text, confidence=99)

.

Transcript.objects.filter(text = "Word2 Word3")

结果：找到对象-

Transcript.objects.filter(text = "Word5 Word6 Word7 Word8")

结果：找到对象-

Transcript.objects.filter(text = "Word3 Word5")

结果：找到对象-

Transcript.objects.filter(text = "Word10 Word9")

结果：未找到对象

如何使用过滤器和正则表达式进行这些查询？

Answer 1

您可以尝试：

# case sensitive:
Transcript.objects.filter(text__contains = "Word1")

# case insensitive 
Transcript.objects.filter(text__icontains = "Word1")

您可以组合参数来查找带有“Word1”和“Word2”的转录本，如：

Transcript.objects.filter(
    text__contains = "Word1",
    text__contains = "Word2"
)

细节：https://docs.djangoproject.com/en/3.1/topics/db/search/