Hi Vijay,
Thanks very much for your assistance and recommendation. i will get back to
you if needed more help.
Sum
On Fri, Jan 9, 2015 at 3:15 PM, Vijay Khemlani <vkhem...@gmail.com> wrote:
> Well, you can do something like this
>
> one_leave = leave.objects.get(pk=1) # Asuming there is a leave with pk 1
> print one_leave.staff.First_Name # Automatically joins with the staff
> table to print the first name of the associated staff
>
> Or something like this
>
> one_staff = staff.objects.get(pk=1) # Asuming there is a staff with pk 1
> staff_leaves = one_staff.leave_set.all()
> for staff_leave in staff_leaves:
> print staff leaves # Print all the leaves of a
> particular staff
>
> Also, I recommend you to follow Python and Django naming conventions, that
> is classes in CamelCase ("Staff" and "Leave" instead of "staff" and
> "leave") and fields in underscore (first_name instead of First_Name, etc)
>
> On Thu, Jan 8, 2015 at 11:41 PM, sum abiut <suab...@gmail.com> wrote:
>
>> Hi,
>> i am trying to pull out all the information in both model. i can pull out
>> information in each table but i am a but confuse in joining the two tables
>> together. something like NATURAL JOIN in mysql.
>>
>> Cheers,
>>
>>
>> On Fri, Jan 9, 2015 at 12:07 PM, Vijay Khemlani <vkhem...@gmail.com>
>> wrote:
>>
>>> OK, what query are you trying to make? or what information do you want
>>> to display?
>>>
>>> On Thu, Jan 8, 2015 at 6:50 PM, sum abiut <suab...@gmail.com> wrote:
>>>
>>>> Hi Vijay,
>>>> Thank you for your email. Here is my models. i want to be able to pull
>>>> out all the data from both table and display them. i am a bit new to django
>>>> still finding my way out.
>>>>
>>>>
>>>> class staff(models.Model):
>>>> First_Name = models.CharField(max_length=45)
>>>> Last_Name =models.CharField(max_length=45)
>>>> employee_Date=models.DateField()
>>>> position=models.CharField(max_length =45)
>>>> department=models.CharField(max_length =45)
>>>> qualification=models.CharField(max_length =45)
>>>> VNPF_no =models.CharField(max_length =45)
>>>> salary =models.IntegerField()
>>>> montly_salary=models.IntegerField()
>>>> Training=models.TextField()
>>>> username =models.ForeignKey(User, default =1)
>>>>
>>>> def __unicode__(self):
>>>> return self.First_Name
>>>>
>>>> class leave(models.Model):
>>>> leave_type =models.CharField(max_length=45)
>>>> Specify_details=models.TextField(default="")
>>>> start_Date =models.DateField()
>>>> end_date=models.DateField()
>>>> total_working_days=models.IntegerField()
>>>> authorization =models.CharField(max_length=45)
>>>> authorized_by=models.CharField(max_length=45, default ="")
>>>> remarks=models.TextField()
>>>> authorizaion_date =models.DateField()
>>>> username =models.ForeignKey(User, default =1)
>>>> staff =models.ForeignKey(staff, default =1)
>>>>
>>>> def __unicode__(self):
>>>> return self.leave_type
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Fri, Jan 9, 2015 at 8:32 AM, Vijay Khemlani <vkhem...@gmail.com>
>>>> wrote:
>>>>
>>>>> Please be more specific in your question, how are these tables
>>>>> related? what models are they associated with?
>>>>>
>>>>> On Thu, Jan 8, 2015 at 6:01 PM, sum abiut <suab...@gmail.com> wrote:
>>>>>
>>>>>> Hi,
>>>>>> can someone please help. i am trying to pull data from two table in
>>>>>> django and display the results. can someone please point me to the right
>>>>>> direction.
>>>>>>
>>>>>> kind regards,
>>>>>> Sum A
>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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 django-users+unsubscr...@googlegroups.com.
>>>>>> To post to this group, send email to django-users@googlegroups.com.
>>>>>> Visit this group at http://groups.google.com/group/django-users.
>>>>>> To view this discussion on the web visit
>>>>>> https://groups.google.com/d/msgid/django-users/CAPCf-y6DxaBuSiLYNr2dc3sAn70qB46_G5MTJzPoJPkG1-57PA%40mail.gmail.com
>>>>>> <https://groups.google.com/d/msgid/django-users/CAPCf-y6DxaBuSiLYNr2dc3sAn70qB46_G5MTJzPoJPkG1-57PA%40mail.gmail.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 django-users+unsubscr...@googlegroups.com.
>>>>> To post to this group, send email to django-users@googlegroups.com.
>>>>> Visit this group at http://groups.google.com/group/django-users.
>>>>> To view this discussion on the web visit
>>>>> https://groups.google.com/d/msgid/django-users/CALn3ei0qKOsMrV-nVLrABSfBpbPAOCHgQDsaYXDS_EkNS4QEZw%40mail.gmail.com
>>>>> <https://groups.google.com/d/msgid/django-users/CALn3ei0qKOsMrV-nVLrABSfBpbPAOCHgQDsaYXDS_EkNS4QEZw%40mail.gmail.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 django-users+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to django-users@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/django-users.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/django-users/CAPCf-y7%3D2xjk0xApyXpSnqvGHogYSdf7ztqnQUJtpvXSSamntQ%40mail.gmail.com
>>>> <https://groups.google.com/d/msgid/django-users/CAPCf-y7%3D2xjk0xApyXpSnqvGHogYSdf7ztqnQUJtpvXSSamntQ%40mail.gmail.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 django-users+unsubscr...@googlegroups.com.
>>> To post to this group, send email to django-users@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/django-users.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/django-users/CALn3ei3OudzfSz6408Mt8wd7n6xXyyXdVyBdSVRLqzNuw9rCag%40mail.gmail.com
>>> <https://groups.google.com/d/msgid/django-users/CALn3ei3OudzfSz6408Mt8wd7n6xXyyXdVyBdSVRLqzNuw9rCag%40mail.gmail.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 django-users+unsubscr...@googlegroups.com.
>> To post to this group, send email to django-users@googlegroups.com.
>> Visit this group at http://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/CAPCf-y5bSoxnbjtradesJha5FO6AJBw65ka3eKZz%3DQ9Qz1oupQ%40mail.gmail.com
>> <https://groups.google.com/d/msgid/django-users/CAPCf-y5bSoxnbjtradesJha5FO6AJBw65ka3eKZz%3DQ9Qz1oupQ%40mail.gmail.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 django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CALn3ei2_GOuY8YvoZhZfGC5Qs4LjF_FfU4VRrM0TqXf%3D2goB_Q%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CALn3ei2_GOuY8YvoZhZfGC5Qs4LjF_FfU4VRrM0TqXf%3D2goB_Q%40mail.gmail.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 django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAPCf-y4k%2BBX88WCWLYMN6BKasOOQb2p81zgo%3DxwMPgYVbQ0U2A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
