shannonturner/bechdel

If your movie doesn't pass the Bechdel test, we'll find you a better one

bechdel's Issues

Clarify number of movies shown in browsing

In the following pages,

• Browse by Genre
• Browse by Parental Rating
• Browse by Years,

make the message at the top show the number of movies in the subset rather than the totals every time.

Slowly unfollow accounts from Bechdelbot

I remember in the documentation that you can only follow 2000 people. Since the Bechdelbot has followed 1500 people who have tweeted about the bechdel test in 10 days, I'll need to start unfollowing people soon.

I think it makes the most sense to unfollow people who aren't following the Bechdelbot back, but I don't want to do it in an abusive way that upsets twitter, so it should probably be a phased unfollow, just a few at a time.

Some Imdb ratings have mismatched color labels

Repeatable: http://shannonvturner.com/bechdel/movie/9 (and many others)

A 6.7 should not have a red color label (danger).

Improve genre matching

Currently, the suggestions will match a higher-rated movie where there is overlap of at least one genre.

Requiring that at least two genres matched would improve the reliability of the genre matching, reduce the number of highly-unrelated movies being recommended, and improve the diversity in which movies are suggested.

Responsive design (mobile) needs work

It's not very navigable on mobile.

Reduce page load times

The following pages need their page load times reduced:

• All movies A-Z
• Browse by Parental Rating
• Browse by Years

Speed Optimizations: Update only every 90 days

Before checking every movie to see if stored info about it should be updated, first check to see if the info is 90 or more days old.

IMDB Top 250

Show a list of the IMDB Top 250, with a summary of each movie and its ratings.

The ETL process for making sure I have an up-to-date Top 250 will be a bit trickier.

Movies without Imdb rating break page (when trying to show suggestions)

Repeatable: http://shannonvturner.com/bechdel/movie/235

At line 321 in get_context_data():

    imdb_rating__gt=float(movie.imdb_rating) - 1.5, 

But when movie.imdb_rating is (correctly) None for movies without a rating (yet), this fails.

Allow flexibility in IMDB/Tomato ratings when offering suggestions

Currently, when you search for a movie that has a less than perfect bechdel score, it offers suggestions based on a movie with all three of:

• a higher Bechdel score
• a higher IMDB score
• a higher Tomato score

But some movies with a bad Bechdel score but a high IMDB / Tomato score (Toy Story, for instance) will be impossible to match all three criteria. Allowing some flexibility when there are no matches would improve diversity of suggestions. For example, the system could take into account:

• a higher Bechdel score
• an IMDB score within +/- 1.5
• a Tomato score within +/- 15

Speed Optimizations: Use select_related()

This may lower the number of additional queries made as the template is loading.

Best-picture-winners

Right now I have it listed as 'Award-winning failures' in the plan but it might be more interesting just to see all of the Best Picture winners.

Also consider expanding to other awards.

Don't display empty table when no suggestions could be found

Instead of displaying an empty table when no higher-rated movie suggestions could be found, instead display a note saying that no suggestions could be found.

Tweet facts from the bechdel bot

Following folks who tweet about the bechdel test is working to promote the bot; having additional shareable content would work well too.

Encoding problems in movie titles (and perhaps other text fields) break page

Repeatable: http://shannonvturner.com/bechdel/movie/88

Ugh I hate dealing with encoding issues I can never remember how to do it right

Some searches fail; bypassing the error handling

The normal (graceful) error handling appears to be bypassed - and it goes straight to a 500 Internal Server Error with no helpful information (logs will probably reveal the issue).

Replicate by:

Search for Matrix. The Matrix Trilogy will appear, as will Armitage: Dual Matrix. Click Armitage: Dual Matrix. Receive 500 Internal Server Error.

http://[ link ]/bechdel/rating?imdbid=tt0303678&year=2002&rating=1&dubious=1&title=Armitage:%20Dual%20Matrix

Add facebook opengraph tags to facilitate sharing

Here are the ones I'll need:

    <meta property="og:title" content="">
    <meta property="og:site_name" content="">
    <meta property="og:url" content="">
    <meta property="og:description" content="">
    <meta property="og:image" content="">

Add relevant links/articles to the What is the Bechdel test page

Articles to include:

• http://en.wikipedia.org/wiki/Bechdel_test
• http://io9.com/why-the-bechdel-test-is-more-important-than-you-realize-1586135613
• http://fivethirtyeight.com/features/the-dollar-and-cents-case-against-hollywoods-exclusion-of-women/
• http://thehathorlegacy.com/why-film-schools-teach-screenwriters-not-to-pass-the-bechdel-test/
• http://www.theguardian.com/world/2013/nov/06/swedish-cinemas-bechdel-test-films-gender-bias
• http://www.feministfrequency.com/2012/02/the-2012-oscars-and-the-bechdel-test/
• http://thehathorlegacy.com/the-bechdel-test-its-not-about-passing/
• http://theangryblackwoman.com/2009/09/01/the-bechdel-test-and-race-in-popular-fiction/

Suggest additional articles below:

Speed Optimizations: Other movies suggestions might be too taxing

Since gathering the other movie suggestions is done as a list and then pared down, it might be too costly as compared with other means of limiting the number of records returned.

There's got to be a better way to accomplish this:

    other_movies = Movie.objects.select_related('parental_rating', 'genre').filter(
                bechdel_rating=3,
                imdb_rating__gt=float(movie.imdb_rating) - 1.5,
                parental_rating__id__lte=movie.parental_rating.id,
                ).exclude(id=movie.id)

            for genre in movie.genre.all()[:2 if len(movie.genre.all()) >= 2 else len(movie.genre.all())]:
                other_movies = other_movies.filter(genre__name=genre.name)

            other_movies = list(other_movies)

        # Get a random top 10
        context['other_movies'] = random.sample(other_movies, 10 if len(other_movies) >= 10 else len(other_movies))

Consider parental rating in movie suggestions

Currently, when suggesting a better-rated movie to watch, the site does not take parental rating into account, which leads to funny results like the Godfather Part III being recommended instead of a children's movie, because the Godfather happens to have a very high Bechdel, IMDB, and Tomato rating.

Considering parental rating when offering suggestions (must be at least as G-friendly as the movie searched for) would improve the matches as well as offer better diversity of matches.

Recommendation links don't terminate properly

On pages where the Bechdel score is lower than three, the page will display recommendations for additional movies to watch. Now that the database is mostly populated, some bugs that I missed before had emerged.

The links to click on have a lot of garbage leftover, as though the link didn't terminate properly. It should be a relatively easy fix.

http://[ the link ]/bechdel/index?search=tt0047396%3E%3Cb%3ERear%20Window%3C/b%3E%3C/a%3E%3C/td%3E%20%3Ctd%3E3%3C/td%3E%20%3Ctd%3E8.6%3C/td%3E%20%3Ctd%3E100%3C/td%3E%20%3Ctd%3EMystery,%20Thriller%3C/td%3E%20%3C/tr%3E%3Ctr%3E%20%3Ctd%3E%3Ca%20href=

Some tweets don't use all words in search

In https://twitter.com/HOLLYWOOD_Lorii/status/602235241772797954, the user tweeted "fast and the furious" at the bechdelbot.

In the bot's reply, https://twitter.com/BechdelBot/status/602235576847216640, the reply found too many movies because the search only included part of the query, "fast" instead of the full "fast and the furious"

Speed Optimizations: Benchmark and Test Indexes

To see whether indexes could improve speed.

Stats page

Create a page showing stats/analysis of the Bechdel test / Imdb ratings.

Spaghetti at the wall ideas:

• Box office receipts by score (would need to control for inflation)
• Share of each score over time (example: in 1970, 25% were 1, 33 were 2 ...)
• Scores by gender of the director; of the writer
• Scores by genre
• Scores by parental rating
• Gender analysis of plot synopsis
• Scores by country

Speed Optimizations: On All (browse) page, don't load all movies first

Instead of doing a Movie.objects.all() and then filtering based on criteria chosen, figure out a way to avoid loading all 5000+ objects and cutting it down in python.

Rewrite the whole thing using Django

It'll be good practice for migrating existing data into a new system, and there's also a lot of information that's not yet being saved, like parental rating.

New feature for Bechdel bot: follow

Add functionality to the bechdel twitter bot (https://twitter.com/bechdelbot) to follow people who tweet about the bechdel test.

Hashtags / key words to look for:
bechdel
bechdeltest
bechdel test

Some searches return a blank screen; bypassing all error handling

Some searches return a blank screen, bypassing all error handling - from the graceful error handling provided by the error page to the 500 Internal Server Error for larger errors.

It's as though there's a return "" somewhere. The server logs will probably hold a clue.

Replicate by searching for Lawnmower or Lawnmower man, as well as other searches.

Speed Optimizations: Use Movie.objects.count() where possible

Looks like using len(Movie.objects.all()) is NOT best practice, especially for a site with so many records.

Using Movie.objects.count() may lead to speed improvements.

Add twitter cards

See https://dev.twitter.com/docs/cards for more details

See also shutthatdown.com for example implementation

Add favicon

[bechdelbot] Handle common user entry "mistakes"

Bechdelbot won't give a response to a tweet unless it can find the movie the user asked for. That's the preferred behavior, but often, people will include extra punctuation (for example) as part of the tweet, and Bechdelbot thinks this is part of the movie's title, doesn't find it, and doesn't reply.

Example:
(at) bechdelbot jaws?

will fail because there's no question mark in the title of the movie. But this has been a common point of failure.

tl;dr: .strip() out question marks from the tweets

Show other movies in similar genres and parental rating when bechdel score is 3

Currently, it just takes you back to the search page and does nothing.

It would be great to show other movies that got a bechdel rating of 3 for other movies in a similar genre.