refined_value.py

import mysql.connector

class RefinedUploader:
    def __init__(self):
        self.config = {
            'host': 'localhost',
            'user': 'root',
            'password': 'iamrahul', # Update if needed
            'database': 'health_project'
        }
        self.conn = mysql.connector.connect(**self.config)
        self.cursor = self.conn.cursor()

    def upload_to_db(self, bpm, spo2, metrics):
        """
        Takes raw values and the dictionary from health_metrics.py
        """
        try:
            sql = """INSERT INTO refined_health_data 
                     (bpm, spo2, glucose, hrv, pi, rr, status) 
                     VALUES (%s, %s, %s, %s, %s, %s, %s)"""
            
            values = (
                bpm, 
                spo2, 
                metrics['glucose'], 
                metrics['hrv'], 
                metrics['pi'], 
                metrics['respiratory_rate'], 
                metrics['status']
            )
            
            self.cursor.execute(sql, values)
            self.conn.commit()
            print(">>> Successfully saved refined data to MySQL.")
        except Exception as e:
            print(f"Upload Error: {e}")

    def close(self):
        self.cursor.close()
        self.conn.close()