Hi.
I have the following model:
class User(models.Model):
id_user = models.AutoField(primary_key = True)
username = models.CharField(maxlength = 30, unique = True, null =
True)
name = models.CharField(maxlength = 50, unique = True)
class Meta:
db_table = 'users'
class Consultant(models.Model):
user = models.OneToOneField(User, db_column = 'id_user')
consultant_id = models.IntegerField()
class Meta:
db_table = 'consultants'
Now I want to do something like this simple SQL query:
SELECT name, consultant_id FROM users INNER JOIN consultants ORDER BY
name;
How do I do that with the database API?
I've tried these statements, and some variations, but they all fail:
- Consultant.objects.all().order_by('name')
- Consultant.objects.all().order_by('users.name')
- Consultant.objects.values('consultant_id', 'name') #
.order_by('name')
- Consultant.objects.values('consultant_id', 'user.name')
- Consultant.objects.values('consultant_id', 'user').order_by('name')
...
How am I supposed to do this, without dropping to SQL?
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
