On 6/29/06, Mikko Nylén <[EMAIL PROTECTED]> wrote:
The idea is to use
Color.objects.exclude(...).extra(where=[...])
to insert extra WHEREs clause that will be ANDed to the list of all the other WHEREs that will be automatically produced by the exclude. That way you don't have to completely reconstruct the joins, etc - you just augment the automatically generated query with enough extras to get the right results.
If you need to know table names, etc to put into your where clause, try:
Color.objects.exclude(...)._get_sql_clause()
That will give you a peek into the internals of the automatically generated SQL.
Russ Magee %-)
Hand writing the SQL might work, though, I would need to hand-write the whole query, including other filters, and turn the results manually as Color objects. How exactly would "where/tables clauses in a filter" you mentioned work?
The idea is to use
Color.objects.exclude(...).extra(where=[...])
to insert extra WHEREs clause that will be ANDed to the list of all the other WHEREs that will be automatically produced by the exclude. That way you don't have to completely reconstruct the joins, etc - you just augment the automatically generated query with enough extras to get the right results.
If you need to know table names, etc to put into your where clause, try:
Color.objects.exclude(...)._get_sql_clause()
That will give you a peek into the internals of the automatically generated SQL.
Russ Magee %-)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
