Ingredient-to-Recipe-Search-Engine

Identified system requirements and designed a relational database schema that met the constraints and gave the list of recipes for the given input list of ingredients. 45000 recipes were scrapped from foodnetwork.com using Python to populate the database. MySQL was used to query the designed database. An Interface was created using Flask (Python Web Framework).

Video Demo

DB Schema

Installing virtualenv

pip3 install virtualenv

To check whether virtualenv exists and its version

virtualenv --version

Creating virtual environment in directory

cd flaskproj
virtualenv env

virtualenv env: Creates env folder

Start Windows Subsystem for Linux (WSL) by typing:

WSL

Activate the virtualenv:

source env/Scripts/activate

Inside virtualenv:

Install flask_MYsql:

pip3 install pymysql

To run the code:

python3 main.py

This code reads the parsed JSON and creates the database and the following tables:

• receipe_title
• receipe_instru
• receipe_ingre