啊,我现在更好地理解这个问题了。只需利用您和 Jay 的代码元素,以下可能是一种方法。可能不太优雅。但似乎有效。
def get_sentences(my_tokens):
counts = dict()
for t in my_tokens:
counts[t] = my_tokens.count(t)
results = Sentence.objects
for k, v in counts.iteritems():
results = results.filter(tokens__token=k).annotate(n=Count('tokens',distinct=True)).filter(n__gte=v)
return results
>>> from django.db.models import Count
>>> from my.models import Sentence, Tokens
>>> s1 = Sentence.objects.create(name="S1")
>>> t10 = Tokens.objects.create(token="I", sentence=s1)
>>> t20 = Tokens.objects.create(token="like", sentence=s1)
>>> t30 = Tokens.objects.create(token="apples", sentence=s1)
>>> s2 = Sentence.objects.create(name="S2")
>>> t11 = Tokens.objects.create(token="I", sentence=s2)
>>> t21 = Tokens.objects.create(token="like", sentence=s2)
>>> t31 = Tokens.objects.create(token="oranges", sentence=s2)
>>> s3 = Sentence.objects.create(name="S3")
>>> t31 = Tokens.objects.create(token="I", sentence=s3)
>>> t32 = Tokens.objects.create(token="I", sentence=s3)
>>> t33 = Tokens.objects.create(token="I", sentence=s3)
>>> my_toks = ("I", "like", "apples")
>>> sentences = get_sentences(my_toks)
>>> sentences[0].name
u'S1'
>>> my_toks = ("I", "I", "I")
>>> sentences = get_sentences(my_toks)
>>> sentences[0].name
u'S3'
为了准确参考,我的模型如下所示:
class Sentence(Model):
name = models.CharField(max_length=16)
class Tokens(Model):
token = models.CharField(max_length=16)
sentence = models.ForeignKey(Sentence, related_name='tokens')