Hi Ivan,
Thanks for the reply. Ok that makes sense, but I'm assuming I would
then have to query the database again to get the name of that game for
each result that is returned? This sounds like a lot of queries just
to get a list - this is something I would usually handle by doing a
JOIN query, is this possible in Django?
So i'm guessing the code would be something like this:
song_listing = []
list = UserSong.objects.filter( user=U )
for song in list
for song_list in Song.objects.filter(id=song.id):
song_dict = {}
song_dict['list_object'] = song_list
song_listing.append(song_dict)
On Jan 7, 11:08 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> Something like this should return an iterable list of UserSong records
> for user U
>
> >>> list = UserSong.objects.filter( user=U )
>
> Then you can iterate over it or pass that list to a template that
> iterates over it
>
> >>> for song in list:
> >>> doSomething
>
> Look here for morehttp://www.djangoproject.com/documentation/db-api/
>
> On Jan 7, 3:01 pm, Darthmahon <[EMAIL PROTECTED]> wrote:
>
> > Hey,
>
> > My ongoing quest to get a basic app working will hopefully be answered
> > by this question :)
>
> > I have the following model.py file:
>
> > File: model.py
> > ==================================
>
> > from django.db import models
> > from django.contrib.auth.models import User
>
> > class Song(models.Model):
> > title = models.CharField(maxlength=500)
>
> > # return title of game
> > def __str__(self):
> > return self.title
>
> > class User Song(models.Model):
> > # Link to user and song
> > user = models.ForeignKey(User)
> > song = models.ForeignKey(Song)
>
> > ==================================
>
> > In my views.py file I have a function that displays all songs:
>
> > File: views.py
> > ==================================
>
> > ...import calls...
>
> > def song(request):
>
> > song_listing = []
> > for song_list in Song.objects.all():
> > song_dict = {}
> > song_dict['list_object'] = song_list
> > song_listing.append(song_dict)
> > return render_to_response('song/song.html', { song_listing':
> > song_listing }, context_instance=RequestContext(request))
>
> > ==================================
>
> > That prints out all of the songs in the database using the song/
> > song.html template which works perfectly.
>
> > Now I want to be able to print ONLY the songs a user has added to
> > their profile. This is done using a separate function, but the models
> > have been setup (I believe) correctly to link the two (Song and User).
>
> > This is where I am struggling - how do I perform a function in my
> > views.py file that only gets the names of the songs a user has added?
> > I've been looking for some real examples of Django doing this and I
> > can't find anything, anyone got any advice?
>
> > Cheers,
> > Chris
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
