SearchableText.objects.filter(searchterm__term__in=('is',
'another')).order_by('searchterm__term')is this what you need? On Sat, Oct 29, 2016 at 7:03 PM, Yaşar Arabacı <[email protected]> wrote: > Hi, > > I am trying to migrate my mysql application into django orm. I need help > converting my sql statements into it. Here are my models > > class SearchableText(models.Model): > searchable_text = models.TextField() > class SearchTerm(models.Model): > searchabletext = models.ForeignKey(SearchableText, > on_delete=models.CASCADE) > term = models.CharField(max_length=100) > > > This is basically a table to store some textual information, and another > table to use as index of searchable terms. > > Consider it like this > > SearchableText > id searchable_text > 1 "this is text" > 2 "this is another text" > > SearchTerm > id searchable_text term > 1 1 this > 2 1 is > 3 1 text > 4 2 this > 5 2 is > 6 2 another > 7 2 text > > I would normally do a sql query like this; > > Select SearchableText.* > Right Join SearchTerm on SearchTerm.searchable_text = SearchableText.id > Where term in ("is","another") > group by SearchTerm.searchable_text ORDER BY COUNT(SearchTerm.term ) DESC > LIMIT > > Right now, I don't even know where to start writing a complex sql like > this using django-orm so any help is appreciated. > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/django-users/c6481fa3-1d35-4957-b70e-3d9912715546%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/c6481fa3-1d35-4957-b70e-3d9912715546%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFWa6tLyTgXJz%2BuYYooAZi0okdG5%2BZ211L9DSk5_S9DA3T87zw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
