Hi everyone,
I'm just starting with Django and I created the following queryset but I
can't seem to make the JOIN connect to the one I've defined in my queryset
values(..., '*user__uservote__event'*, ...)
*My model declaration:*
> class UserVote(TimeStampedModel):
> event = models.ForeignKey('events.Event')
> fightchoice = models.ForeignKey('fights.FightChoice')
> user = models.ForeignKey(User)
>
> class UserEvent(TimeStampedModel):
> event = models.ForeignKey('events.Event')
> user = models.ForeignKey('users.User')
*My queryset:*
user_season_events = UserEvent.objects\
> .filter(event__season=season_id, user=request.user.id,
> user__uservote__user=request.user.id)\
> .order_by('-event__event_on') \
> .select_related('event')\
> .values('event', 'user__uservote__fightchoice__points',*
> 'user__uservote__event',*
> 'user__uservote__fightchoice__howitended',
> 'user__uservote__fightchoice__fighter')
*Return the following SQL:*
SELECT "users_userevent"."event_id", "fights_fightchoice"."points",
> "users_uservote"."event_id", "fights_fightchoice"."howitended_id",
> "fights_fightchoice"."fighter_id"
> FROM "users_userevent"
> INNER JOIN "events_event" ON ( "users_userevent"."event_id" =
> "events_event"."id" )
> INNER JOIN "users_user" ON ( "users_userevent"."user_id" =
> "users_user"."id" )
> LEFT OUTER JOIN "users_uservote" ON ( "users_user"."id" =
> "users_uservote"."user_id" )
> LEFT OUTER JOIN "fights_fightchoice" ON (
> "users_uservote"."fightchoice_id" = "fights_fightchoice"."id" )
> WHERE ("events_event"."season_id" = 1 AND "users_userevent"."user_id" =
> 199 AND "users_uservote"."user_id" = 199 ) ORDER BY
> "events_event"."event_on" DESC
*My issue is:*
I want:
LEFT OUTER JOIN "users_uservote" ON "users_user"."id" =
"users_uservote"."user_id" )
to be (on *events_event* not users_user) like this:
LEFT OUTER JOIN users_uservote ON *events_event.id =
users_uservote.event_id*
When I added 'user__uservote__event' to the values in my queryset should it
not create it?
Thank you for you help.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/9c9ae9bc-b92a-4fd6-8f1f-15a03eb29469%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
