web_data_retriever.py

import MySQLdb  # or your preferred mysql library

class HealthDataRetriever:
    def __init__(self):
        self.config = {
            'host': 'localhost',
            'user': 'root',
            'passwd': 'iamrahul',
            'db': 'health_project'
        }

    def fetch_latest_vitals(self):
        try:
            # Connect to the database
            db = MySQLdb.connect(**self.config)
            cursor = db.cursor()

            # Fetch the most recent record
            query = """
                SELECT bpm, spo2, glucose, hrv, status
                FROM refined_health_data
                ORDER BY id DESC
                LIMIT 1
            """
            cursor.execute(query)
            data = cursor.fetchone()

            # Close connection
            db.close()

            if data:
                result = {
                    'bpm': data[0],
                    'spo2': data[1],
                    'glucose': data[2],
                    'hrv': data[3],
                    'status': data[4]
                }
                print("Latest Vitals Retrieved:")
                print(f"  BPM     : {result['bpm']}")
                print(f"  SpO2    : {result['spo2']}%")
                print(f"  Glucose : {result['glucose']} mg/dL")
                print(f"  HRV     : {result['hrv']} ms")
                print(f"  Status  : {result['status']}")
                return result
            else:
                print("No data found in refined_health_data table.")
                return None

        except Exception as e:
            print(f"Database Error: {e}")
            return None


# Example usage
if __name__ == "__main__":
    retriever = HealthDataRetriever()
    retriever.fetch_latest_vitals()