show_weapon_kills.py

import pymysql
import redis
from mysqlcursor import cur, con

# Initialize Redis client
redis_client = redis.Redis(host='localhost', port=6379, db=0)

def option_19():
    "This is to output the Weapon with Most Kills"
    try:
        # Check if the result is cached in Redis
        cache_key = "weapon_with_most_kills"
        if redis_client.exists(cache_key):
            print("Data found in cache:")
            cached_data = redis_client.hgetall(cache_key)
            for key, value in cached_data.items():
                print(value.decode('utf-8'))
        else:
            query = """
            SELECT * 
            FROM Weapons 
            WHERE Weapon_ID IN (
                SELECT Weapon_ID 
                FROM Kills 
                GROUP BY Weapon_ID 
                ORDER BY COUNT(Weapon_ID) DESC 
                LIMIT 1
            )
            """
            cur.execute(query)
            print("Weapon_ID\tWeapon_Name\tAmmo\tFire_Rate\tDamage\tExtension_ID")
            for row in cur:
                weapon_info = f"{row['Weapon_ID']}\t{row['Weapon_Name']}\t{row['Ammo']}\t{row['Fire_Rate']}\t{row['Damage']}\t{row['Extension_ID']}"
                print(weapon_info)

            # Cache the result in Redis
            if row:
                redis_client.hmset(cache_key, {"result": weapon_info})
                print("Data cached in Redis")
            else:
                print("No weapons found")

        con.commit()

    except Exception as e:
        con.rollback()
        print("Failed to fetch from database")
        print(">>>>>>>>>>>>>", e)