Welcome to the PUBG Database Management CLI, a Python-based command-line interface that provides a user-friendly experience for accessing and manipulating PUBG Mobile data. Whether you're a player tracking progress, a developer seeking insights, or an analyst exploring trends, our CLI empowers you to delve into the world of PUBG Mobile data, enabling you to explore, analyze, and make informed decisions based on your gaming experiences.
- Inserting Player Information
- Inserting Maps Information
- Inserting Weapons Information
- Inserting Clans Information
- Inserting Team Information
- Inserting Extension Information
- Inserting Player to Clan
- Inserting Match Details at Game Start
- Deleting a Map
- Deleting a Player from the Clan
- Updating Clan-Leader of a Clan
- Updating Match Details after Game End
- Updating Player Player_ID
- Updating Player's PLAYER-ID
- Showing List of Maps in a Game
- Showing List of Weapons in a Game
- Showing List of Players in a Game
- Showing Teams with Highest Win-Rate
- Showing Players with Highest Total Wins
- Showing Players Who Have Teamed-Up
- Showing the Weapon with Most Kills
- Showing the Output of List of All Game Maps
- Retrieving Extension for a Particular Gun
- Retrieving All Guns with Damage Greater Than a Particular Value
- Retrieving Top Gun for a Particular Player
- Retrieving Best Team Members for a Particular Value
- Retrieving Players Having KD Greater Than or Equal to a Particular Value
Note: I have also uploaded a video 'pubg-tut.mp4' in this same folder to demonstrate the implementation of some of the aforementioned queries!
- You can also check out the video link here : Video Link
- Clone the Repository:
git clone https://github.com/Tanishq-IIITH/PUBG-DB-CONSOLE-Tanishq.git cd PUBG-DB-CONSOLE-Tanishq - Install Dependencies: (upgrade to the newer version of pymysql if any)
pip install -r requirements.txt --upgrade
- Run the CLI:
- In the mysqlcursor.py file, edit your mysql username and password. Then run:
python3 main.py
- Also, Run test.sql file to import the PUBG-Database and work on it.
Follow the interactive prompts to perform various database operations and explore the rich functionality of the PUBG Database Management CLI.
Enjoy your journey into the world of PUBG Mobile data with our CLI. Explore, analyze, and make the most of your gaming experiences. Let the adventure begin!
🤝This project stands as a testament to the formidable power of collaboration. Our cohesive team of contributors, from coding virtuosos to creative minds shaping the user experience, has played an indispensable role in the evolution of this Database Management System.
The Team :
- KEVIN THAKKAR
- SAHIL PATEL
- GOPAL GARG
Together, we continue to build, innovate, and inspire! 🌐✨