jquery - Best way to make a simple orderable playlist in django -
simple django orm question:
i've got pretty classic example of playlist , track models:
class track(models.model): name = models.charfield(max_length = 50) mp3 = models.filefield(upload_to="track/") class playlist(models.model): name = models.charfield(max_length = 50) class playlisttrack(models.model): playlist = models.foreignkey('track.playlist') track = models.foreignkey('track.track') position = models.integerfield() #here's crux of problem
is best way of making orderable playlist?
i doubt it, if so, how ordered queryset
? (i serialising json, queryset
prefered, if have different, simple, way of making json i'd love hear it!)
here's have far:
playlist = track.objects.filter(playlisttrack__playlist__exact=1)
but doesn't preserve ordering, according playlisttrack.position
field...
thanks!
if notice playlisttrack model nothing more many-2-many intermediate table, things become more obvious (check this):
class playlist(models.model): name = models.charfield(max_length = 50) tracks = models.manytomanyfield('track', through='playlisttrack') class playlisttrack(models.model): playlist = models.foreignkey('track.playlist') track = models.foreignkey('track.track') position = models.integerfield() #here's crux of problem class meta: ordering = ['position']
now can do:
my_playlist.tracks.all()
Comments
Post a Comment