ORM Doubts

Hi,

below is model

class Employee(models.Model):   name = models.CharField(max_length=50, primary_key=True)   dep = models.CharField(max_length=10)   class Meta(object):     db_table = u'employee'  class EmpSal(models.Model):   emp_name = models.ForeignKey(Employee, db_column='emp_name')   emp_sal = models.FloatField()   class Meta(object):     db_table = u'empsal'  class EmpWork(models.Model):   emp_wrk = models.ForeignKey(Employee, db_column='emp_wrk')   emp_doj = models.DateField()   class Meta(object):     db_table = u'empwork' 

here i can make join from EMployee and EmpWork

 EmpWork.object.filter(emp_wrk__dep) 

here i can make join from EMployee and EmpSal

   EmpSal.object.filter(emp_name__dep) 

My Questions:

• how to make a relation between EmpWork and EMPSal

• how to join all three once Employee,EMPWork,EMPSal

• if i want to make a relation

Employee.objects.filter(empsal__emp_sal=10000).values('name') ?

this return empty list ?

• how to get all the employee sal who's doj is example '2010-10-15' ?

If possible can you please give example with making relation with ORM

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/R0xscklQV0NOUXdK.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.