view_encrypted_database.py

from app import create_app, db
from app.models import User, Medicine
import json
from sqlalchemy import text

def main():
    """Display encrypted vs decrypted data for medicine table"""
    app = create_app()
    
    with app.app_context():
        # Medicines table  
        medicines = Medicine.query.all()
        for medicine in medicines:
            print(f"MEDICINE {medicine.id}:")
            
            # Get raw encrypted data
            result = db.session.execute(
                text('SELECT name, description FROM medicine WHERE id = :id'), 
                {'id': medicine.id}
            ).fetchone()
            
            if result:
                print(f"  Name (encrypted): {result[0]}")
                print(f"  Name (decrypted): {medicine.name}")
                print(f"  Description (encrypted): {result[1]}")
                print(f"  Description (decrypted): {medicine.description}")
            
            # Time fields
            time_fields = ['time_mon', 'time_tue', 'time_wed', 'time_thu', 'time_fri', 'time_sat', 'time_sun']
            days = ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday']
            
            for i, field in enumerate(time_fields):
                result = db.session.execute(
                    text(f'SELECT {field} FROM medicine WHERE id = :id'), 
                    {'id': medicine.id}
                ).fetchone()
                
                if result and result[0]:
                    decrypted_value = getattr(medicine, field)
                    print(f"  {days[i]} (encrypted): {result[0]}")
                    print(f"  {days[i]} (decrypted): {decrypted_value}")
            
            print(f"  Secure ID: {medicine.secure_id}")
            print(f"  User ID: {medicine.user_id}")
            print(f"  Data Hash: {medicine.data_hash}")
            print()

if __name__ == '__main__':
    main()