Hi,
I have the necessity to make a LEFT JOIN for a "translated" model
object.
See the example:
"""
from django.db import models
class Bulletin(models.Model):
pub_date = models.DateField()
class BulletinTranslation(model.Model):
title = models.CharField(max_length=128)
body = models.TextField()
language_code = models.CharField(max_length=2, core=True)
bulletin = models.ForeignKey(Bulletin)
"""
So a Bulletin object could have some translations.
The problem is that I need to display also the objects that have not
the translation in the current view language, so a LEFT JOIN is
basilar.
The behavior requested is that Bulletin have some extra fields from
BulletinTranslation or, at least, a cached BulletinTranslation in one
query (similar to select_related()).
A query for every Bulletin object, in order to get the correct
translation, is a problem because it explode the queries of my site
from 5 to more of 100 per page, so it is really a bad situation.
The other problem is that I can't use a raw SQL because I need some
important functions of the object in order to process some special
fields (not in the example).
The queryset-refactor documentation lacks, so it is very hard to
understand how to build a custom Q object.
This is very important for me, but I tried for an entire week on the
queryset-refactor without results.
How can I create a custom Q object in order to add a this simple LEFT
JOIN?
Example of the join:
"""
"SELECT bulletin.*, bulletintranslation.* FROM bulletin
LEFT JOIN bulletintranslation ON (bulletin.id =
bulletintranslation.bulletin_id AND bulletintranslation.language_code
= '%s');" % get_language_code()
"""
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
