set_password.py

import pyodbc
from werkzeug.security import generate_password_hash

# Database connection string
DB_CONNECTION = 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=LAPTOP-0JSMQTER;DATABASE=Apotek;Trusted_Connection=yes'

def set_password(id_apoteker, password):
    try:
        # Generate password hash
        password_hash = generate_password_hash(password)
        
        # Connect to database
        conn = pyodbc.connect(DB_CONNECTION)
        cursor = conn.cursor()
        
        # Update password hash
        cursor.execute("""
            UPDATE Apoteker 
            SET password_hash = ? 
            WHERE id_apoteker = ?
        """, (password_hash, id_apoteker))
        
        conn.commit()
        cursor.close()
        conn.close()
        
        print(f"Password updated successfully for apoteker {id_apoteker}")
        
    except Exception as e:
        print(f"Error updating password: {str(e)}")

if __name__ == '__main__':
    # Example usage
    id_apoteker = input("Enter apoteker ID: ")
    password = input("Enter new password: ")
    set_password(id_apoteker, password)