class News(models.Model):
id = models.AutoField(primary_key=True, verbose_name='id')
writer = models.CharField(max_length=200, verbose_name='writer')
title = models.CharField(max_length=200, blank=True, verbose_name='title')
text = models.TextField(blank=True)
url = models.URLField(blank=True)

python
Copy
def __str__(self):
    if self.writer :
        return u'%s -- %s' % (self.title , self.writer)
    else:
        return u'%s' % (self.title)
class Reviews(models.Model):
id = models.AutoField(primary_key=True, verbose_name='id')
writer = models.CharField(max_length=200, verbose_name='writer')
text = models.TextField(blank=True)
url = models.URLField(blank=True)

python
Copy
def __str__(self):
    if self.writer :
        return u'%s -- %s' % (self.url , self.writer)
    else:
        return u'%s' % (self.url)
class Film(models.Model):
id = models.AutoField(primary_key=True, verbose_name='id')
title = models.CharField(max_length=150, db_index=True, blank=True, verbose_name='title')
type = models.IntegerField(choices=((1, 'movies'), (2, 'series')), verbose_name='type')
ageClassification = models.CharField(max_length=150, db_index=True, verbose_name='ageClassification',null=True)
runtime = models.CharField(max_length=150, db_index=True, verbose_name='runtime')
featureYear = models.IntegerField(blank=True,null=True)
description = HTMLField(blank=True, verbose_name='description',null=True)
keyWordUrl = models.URLField(blank=True, verbose_name='keyWordLink',null=True)
storyLineUrl = models.URLField(blank=True, verbose_name='storyLineLink',null=True)
newsUrl = models.URLField(blank=True, verbose_name='newsLink',null=True)
criticUrl = models.URLField(blank=True, verbose_name='criticLink',null=True)
storyline= HTMLField(blank=True, verbose_name='storyline',null=True)
sysnopse= HTMLField(blank=True, verbose_name='synopse',null=True)
imdbScoreRate = models.FloatField(null=True, blank=True, verbose_name="imdbScore")
MetaScoreRate = models.FloatField(null=True, blank=True, verbose_name="metaScore")
imdbLink = models.URLField(verbose_name='ImdbLink',unique=True)
productionStatus = models.CharField(max_length=200, blank=True,null=True, verbose_name='productionStatus')
numVotes = models.FloatField(null=True, blank=True, verbose_name="numVotes")
stars = models.CharField(max_length=250, blank=True,null=True)
writers = models.CharField(max_length=250, blank=True,null=True)
directors = models.CharField(max_length=250, blank=True,null=True)
releaseDate = models.DateField(blank=True, null=True)
artists = models.ManyToManyField(Artist, related_name='artists', through='Role', blank=True, verbose_name='artists',null=True)
engagementStatistics = models.IntegerField(blank=True, verbose_name='engagementStatistics',null=True)
genre = models.JSONField(blank=True,null=True)
boxOffice = models.JSONField(blank=True,null=True)
company = models.JSONField(blank=True,null=True)
cast = models.JSONField(blank=True,null=True)
relatedReviews = models.ManyToManyField(Reviews,through='FilmReviews', related_name='reviews',blank=True,verbose_name='reviews')
relatedReviewsJson = models.JSONField(blank=True,null=True)
relatedNewsJson = models.JSONField(blank=True,null=True)
relatedNews = models.ManyToManyField(News,through='FilmNews',related_name='news',blank=True, verbose_name='news' )
pubDate = models.DateTimeField('date published', auto_now_add=True, db_index=True)
periodPriority = models.JSONField(blank=True,null=True)
ThreeMonthPriority = models.FloatField(null=True, blank=True)
SixMonthPriority = models.FloatField(null=True, blank=True)
FarMonthPriority = models.FloatField(null=True, blank=True)
priorityMaxEngCompany = models.FloatField(null=True, blank=True)
priorityMaxMovieActor = models.FloatField(null=True, blank=True)
priorityMaxMovieDirecotr = models.FloatField(null=True, blank=True)
priorityMeta = models.FloatField(null=True, blank=True)
priority_meta_group = models.CharField(max_length=20, blank=True, null=True)
modifyDate = models.DateTimeField(auto_now=True, db_index=True)
InYearPriority = models.FloatField(null=True, blank=True)

class FilmNews(models.Model):
film = models.ForeignKey(Film, on_delete=models.CASCADE)
news = models.ForeignKey(News, on_delete=models.CASCADE)

class FilmReviews(models.Model):
film = models.ForeignKey(Film, on_delete=models.CASCADE)
review = models.ForeignKey(Reviews, on_delete=models.CASCADE)
conside my django models below i want to see the reviews that connected to a specific film