aion-code-reviewer / data /security.py
Wall-E-30's picture
Deploy upgraded Aion Code Reviewer platform
11b8022
Raw History Blame Contribute Delete
288 Bytes
import sqlite3
def get_user_data(user_id):
conn = sqlite3.connect('users.db')
cursor = conn.cursor()
# VULNERABLE: Direct string formatting leads to SQL Injection
query = f"SELECT * FROM users WHERE id = '{user_id}'"
cursor.execute(query)
return cursor.fetchone()