Code reviewHardcr-p003

Subject SecurityLevel Mid–Senior~18 minCommon in Security interviewsIndustries Software development

Question

Review this endpoint handler.

What a strong answer looks like

Separate real bugs from style. Rank issues by severity, point at the root cause rather than the symptom, and suggest a concrete fix — specific and kind.

Learn the concepts

Talk through your review

Code to reviewpython

1def get_user(request):2    uid = request.args['id']3    rows = db.execute("SELECT * FROM users WHERE id = '" + uid + "'")4    return rows[0]

Run or narrate your approach, then ask the coach.