On 10/24/06, Christian Joergensen <[EMAIL PROTECTED]> wrote:
> Hello
>
> To understand the problem, assume I have a model consisting of Country
> and SoccerTeam.
>
> The SoccerTeam has a country = models.ForeignKey(Country).
>
> Say, I need to find the countries having one or more related soccer
> teams. I was not able to come up with a solution using the ORM...
>
> ...Do I really need to use custom SQL here, or does the django ORM provide
> the means to solve this problem?
You could use QuerySet's "extra" method to add the custom SQL
required, which might be something like the following in this case
(you'd need to replace "appname" with the name of the application the
models belong to, of course):
Country.objects.all().extra(
where=['(SELECT COUNT(*) FROM appname_soccerteam WHERE
appname_soccerteam.country_id = appname_country.id) > 0']
)
Jonathan.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
