class Users(models.Model):
userId = models.IntegerField(max_length=2, primary_key=True)
userName = models.CharField(max_length=10, null=False,
blank=False)
def __unicode__(self):
return self.userName
class MotherTongue(models.Model):
MT_id = models.IntegerField(max_length=2, null=False, blank=False,
unique=True)
MT_value = models.CharField(max_length=15, null=False,
blank=False)
def __unicode__(self):
return self.MT_value
class Sr_Pr_MotherTongue(models.Model):
Sr_Pr_userId = models.ForeignKey(Users, to_field='userId')
Sr_Pr_MT_id = models.ForeignKey(MotherTongue, to_field='MT_id')
Sr_Pr_type = models.CharField(max_length=7, null=False,
blank=False)
def __unicode__(self):
return self.Sr_Pr_type
mysql> select * from polls_users;
+--------+----------+
| userId | userName |
+--------+----------+
| 1 | django3 |
| 2 | django2 |
| 3 | django1 |
+--------+----------+
mysql> select * from polls_mothertongue;
+----+-------+----------+
| id | MT_id | MT_value |
+----+-------+----------+
| 1 | 1 | Telugu |
| 2 | 2 | English |
| 3 | 3 | Hindi |
| 4 | 4 | Sindi |
+----+-------+----------+
mysql> select * from polls_sr_pr_mothertongue;
+----+-----------------+----------------+------------+
| id | Sr_Pr_userId_id | Sr_Pr_MT_id_id | Sr_Pr_type |
+----+-----------------+----------------+------------+
| 2 | 1 | 1 | search |
| 3 | 2 | 2 | pref |
| 4 | 3 | 4 | search |
+----+-----------------+----------------+------------+
mysql>select a.mt_value, b.Sr_Pr_type, c.userName from
polls_mothertongue a, polls_sr_pr_mothertongue b, polls_users c where
a.mt_id = b.sr_pr_mt_id_id and c.userId=1 and
c.userId=b.Sr_Pr_userId_id;
Django ---------> ??????????????
step1 - p = Users.objects.get(pk=1) => get the user id object
step2 - not able to proceed further
+----------+------------+----------+
| mt_value | Sr_Pr_type | userName |
+----------+------------+----------+
| Telugu | search | django3 |
+----------+------------+----------+
Could some one please guide me how I can achieve the above mysql
result from django query
Regards,
Lokesh
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
