python - Django get query value with manytomanyfield through -

python - Django get query value with manytomanyfield through -

i'm new in django. practice how save info database before. don't know how query info out. please help me.thank you.

here model: utilize manytomanyfiled through on movietheater.

class movie(models.model): link = models.urlfield() title = models.charfield(max_length=255, null=true) title_en = models.charfield(max_length=255, null=true) class movietheater(models.model): movietheater = models.manytomanyfield(movie,null=true,blank=true,through="movieshowtime") movie_theater = models.charfield(max_length=255, null=true) class movieshowtime(models.model): theatre = models.foreignkey( movietheater, null=true,blank=true,related_name = 'theater' ) film = models.foreignkey( movie, null=true,blank=true,related_name = 'movie' ) time = models.textfield(null=true,blank=true)

in views.py :

from django.core.paginator import paginator, emptypage, pagenotaninteger movie.models import movie,movieshowtime django.shortcuts import render def index(request): movies = movie.objects.all() times = movieshowtime.objects.all() contacts = get_paginator(request, movies, 10) homecoming render(request, "movie/index.html", {'contacts':contacts,'movies':movies,'times':times}) def get_paginator(request, object_list, num_per_page): paginator = paginator(object_list, num_per_page) page = request.get.get('page') try: ret = paginator.page(page) except pagenotaninteger: ret = paginator.page(1) except emptypage: ret = paginator.page(paginator.num_pages) homecoming ret

my movie/index.html:

<div class="activity"> {% film in contacts %} <div class="col-md-12 item"> <p><h3>{{ movie.title }}</h3></p> {{movie.id}} <div class="theater"> {% theatre in movie.movietheater_set.all %} {{ theater.movie_theater }} {{ theater.id}} <!--i have filter {{movie.id}} , {{ theater.id}} time like: movieshowtime.objects.filter(movie_id='9',theater_id='5')so can movietime.(i don't know if normal way,it's can think now,please guide me) don't know how do. --> {% endfor %} </div> </div> {% endfor %} </div>

{% theatre in movie.movietheater_set.all %} {% showtime in theater.theater.all %} {{ showtime.time }} {% endfor %} {% endfor %}

it's confusing because of related names. related name name oposite entity access 1 defined.

if do:

class movieshowtime(models.model): theatre = models.foreignkey(movietheater, null=true, related_name='showtimes' ) film = models.foreignkey(movie, null=true, related_name='showtimes' )

then access movieshowtime like:

theater = movietheater.object.get(movie_theater='test') showtime in theater.showtimes.all: print "movie: {} - time: {}".format(showtime.movie.title, showtime.time)

python django