🍽️ Food Delivery Chatbot

Python • FastAPI • Dialogflow • MySQL

A chatbot-based food ordering application with backend logic, database integration, and order tracking.

📌 About the Project

Food Delivery Chatbot is a chatbot-based food ordering project developed using Python, FastAPI, Dialogflow, and MySQL.

The application processes chatbot requests through a FastAPI webhook and manages food orders using Python backend logic and a MySQL database.

✨ Features

• 🍔 Add food items to an order
• ➖ Remove food items from an order
• 🧾 Complete an order
• 🔢 Generate an order ID
• 💰 Calculate the total order price
• 📦 Track order status using an order ID
• 💾 Store order information in MySQL
• 🔄 Maintain ongoing orders using session IDs
• 🔗 Process Dialogflow webhook requests using FastAPI

🛠️ Tech Stack

🏗️ How It Works

User
↓
Dialogflow
↓
FastAPI Webhook
↓
Python Backend
↓
MySQL Database

📂 Project Structure

File	Description
main.py	FastAPI application and chatbot request handling.
db_helper.py	MySQL database operations.
generic_helper.py	Helper functions used by the application.
extra.py	Additional project functionality.
pandeyji_eatery.sql	SQL database script.
index.html	HTML interface.
style.css	CSS styling for the interface.

🔄 Order Processing

1. The user interacts with the chatbot.
2. Dialogflow identifies the user's intent.
3. The request is sent to the FastAPI webhook.
4. The Python backend processes the request.
5. Order information is stored or retrieved from MySQL.
6. The chatbot returns the appropriate response.

📦 Order Management

The application supports an ongoing order workflow where food items can be added or removed before the order is completed.

Once an order is completed, the system calculates the order total, generates an order ID, and stores tracking information.

📊 Database

The project uses MySQL for storing and managing food ordering and order tracking data.

The repository includes the SQL database script:

pandeyji_eatery.sql

🧠 Concepts Practiced

• Python backend development
• FastAPI webhooks
• Dialogflow integration
• MySQL database integration
• Session-based order management
• CRUD/database operations
• API request and response handling

🎯 Purpose

This project was developed to practice building a backend-driven chatbot application and integrating conversational interfaces with Python and a relational database.

---

👩‍💻 Shrutika Dubey
Computer Science Graduate

Python • FastAPI • Dialogflow • MySQL