Advertisement
oquidave

django inner joins

Apr 23rd, 2014
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.06 KB | None | 0 0
  1. //models
  2. #Questions model
  3. class Qns(models.Model):
  4.      qn = models.TextField()
  5.      ref = models.TextField(null=True)
  6.      
  7.      class Meta:
  8.         verbose_name_plural="qns"
  9.      def __unicode__(self):
  10.         return self.qn
  11.  
  12. #themes
  13. class Themes(models.Model):
  14.     """Model for quiz themes or categories. Each qn should belong to a theme"""
  15.     theme = models.TextField()
  16.     description = models.TextField(null=True)
  17.     author = models.CharField(max_length=255, null=True)
  18.  
  19.     class Meta:
  20.         verbose_name_plural="themes"
  21.     def __unicode__(self):
  22.         return self.theme
  23.  
  24. #themes-questions map
  25. class QnsThemes(models.Model):
  26.     """Models many-to-many relationship between theme and Questions"""
  27.     qn = models.ForeignKey(Qns)
  28.     theme = models.ForeignKey(Themes)
  29.  
  30.     class Meta:
  31.         verbose_name_plural="qns_themes"
  32.     def __unicode__(self):
  33.         return self.theme
  34.  
  35. """
  36. How do i do an inner join between the Qns models and the QnsThemes models like
  37. select qns.qn_id, qns.qn, qns.ref from themes_qns inner join qns on qns.qn_id = qns_themes.qn_id  where qns_themes.theme_id = 1 order by qns.qn_id asc  
  38.  
  39. """
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement