khoinguyen-hub / sponge_who

Sponge_Who

by: Seak Yith, Khoi Nguyen, Daniel Nazeri, Omar Mughal, Daiwei Chen, Shane Hazelquist

Web application to search for related quotes in SpongeBob SquarePants episodes using Python and SQLAlchemy.

sponge_who's Issues

Parse through all the text files in transcript and store in database

highlight query in output

• highlight user input in the quotes on the result page.

Front end basic look

create the first look for the website

database entry for popular searches

New models and looks for front end

• add and polish the html template to look nicer and have more things going on.

Push seasons and Episodes into database in relation to speaker and quote

I will assign to myself if no one pick it up when I get to this

Quote of the day portion on homepage

• adding a section on the homepage that automatically generates a quote and displays it.

Flask render templates and functionality

• render html templates from front end.
• implement functionality to retrieve and return data for quote.

paginator for multiple results

• retrieve and display results as a page.
• each page should contain the same amount of quotes from the result query.
• only display one page at a time and switch to a page when it is clicked.

Evaluate and Source Missing Transcripts

Some episodes on the wiki are either not in the transcripts directory or are concatenated to some other entry.
Because of this issue we cannot fully resolve issue #14 because it conflicts with issue #21

• Find transcripts mentioned in the wiki but do not have their own file in transcripts directory
• Evaluate parsing and merges for issue #14

Database schema

create a schema for the movie transcripts

Adding animation for output quote

-adding animation to the output quotes.
-for example, animated gradient text

Setting up loading/transition animation between pages

change form from post to get

• allow users to share their favorite quote by doing this.

AI to speak the lines from the result page

• add a button next to each quote.
• when a button is clicked for a quote, use vs.code to generate an audio file for that specific quote and play it.

Result screen

• html template for result screen.
• basic result screen should show the speaker of the quote and the full quote returned from querying.

Back end search mechanism and flask functionality

-create methods in python to search database for results that match user input.
-implement flask functionality to render html templates

add character image next to their quote in the result page

• An image of the speaker of the quote on the result page.
• Spongebob image should appear next to whatever quote he spoke on the result page.

Refactor Database: add filename to the entities,

• add file names to the entities in the database to use as a reference to link character, quote, episode, and season together.

Docker implementation possibly for database

just gonna leave it here, if anyone wants to do this, assign urself to it.