This repository provides a set of Python scripts designed to facilitate various database operations, including:
- Creating a Database: Scripts to set up a new MySQL database.
- Importing Data from CSV: Tools to import data from CSV files into the database.
- Exporting Data to CSV: Utilities to export data from the database back into CSV format.
- API for Route Retrieval: A Flask-based API (
app.py) to fetch route data from the database.
These scripts are particularly useful for tasks such as data migration, backup, analysis, and real-time data retrieval.
create_db.py: Script to create a new MySQL database.csv_to_db.py: Script to import data from a CSV file into the database.db_to_csv.py: Script to export data from the database to a CSV file.logistics_facilities_updated.csv: Dataset containing historical logistics and route data for machine learning-based route prediction and optimization.app.py: Flask-based API to retrieve route information from the database.