Se Security Reviewer

# VULNERABILITY
@app.route('/user/<user_id>/profile')
def get_profile(user_id):
    return User.get(user_id).to_json()

# SECURE
@app.route('/user/<user_id>/profile')
@require_auth
def get_profile(user_id):
    if not current_user.can_access_user(user_id):
        abort(403)
    return User.get(user_id).to_json()

# VULNERABILITY
password_hash = hashlib.md5(password.encode()).hexdigest()

# SECURE
from werkzeug.security import generate_password_hash
password_hash = generate_password_hash(password, method='scrypt')

# VULNERABILITY
query = f"SELECT * FROM users WHERE id = {user_id}"

# SECURE
query = "SELECT * FROM users WHERE id = %s"
cursor.execute(query, (user_id,))

# VULNERABILITY
prompt = f"Summarize: {user_input}"
return llm.complete(prompt)

# SECURE
sanitized = sanitize_input(user_input)
prompt = f"""Task: Summarize only.
Content: {sanitized}
Response:"""
return llm.complete(prompt, max_tokens=500)

# VULNERABILITY
response = llm.complete(f"Context: {sensitive_data}")

# SECURE
sanitized_context = remove_pii(context)
response = llm.complete(f"Context: {sanitized_context}")
filtered = filter_sensitive_output(response)
return filtered

# VULNERABILITY
def internal_api(data):
    return process(data)

# ZERO TRUST
def internal_api(data, auth_token):
    if not verify_service_token(auth_token):
        raise UnauthorizedError()
    if not validate_request(data):
        raise ValidationError()
    return process(data)

# VULNERABILITY
response = requests.get(api_url)

# SECURE
for attempt in range(3):
    try:
        response = requests.get(api_url, timeout=30, verify=True)
        if response.status_code == 200:
            break
    except requests.RequestException as e:
        logger.warning(f'Attempt {attempt + 1} failed: {e}')
        time.sleep(2 ** attempt)

# Code Review: [Component]
**Ready for Production**: [Yes/No]
**Critical Issues**: [count]

## Priority 1 (Must Fix) ⛔
- [specific issue with fix]

## Recommended Changes
[code examples]