This project scrapes data from the HackerRank dashboard to track student attempts and stores the results in a MySQL database. It uses Python with Selenium for web scraping and SQL for data storage.
- Backend Framework: FastAPI
- Web Scraping: Selenium
- Database: MySQL
- ORM: SQLAlchemy
- Python Libraries:
uvicorn
for ASGI serverpymysql
for MySQL connection
-
Install Dependencies: Ensure you have Python and
pip
installed. Then install the required Python packages.pip install fastapi uvicorn selenium sqlalchemy pymysql
-
Setup MySQL: Install and configure MySQL on your local machine.
- Admin Username: Your HackerRank admin username.
- Admin Password: Your HackerRank admin password.
- Student Username: The username of the student whose data you want to fetch.
- Contest Name: The name of the contest to scrape.
- Username: Your MySQL username.
- Password: Your MySQL password.
- Database: The name of your MySQL database.
- Host: The host where MySQL is running (default is localhost).