Code reviewMediumcr-g521

Subject CorrectnessLevel Entry–Mid~14 minCommon in Security · Databases & SQL · Code quality & review · Algorithms & data structures interviewsIndustries Software development

Question

Review this Python code that looks up a user by name.

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 find_user(conn, name):2    query = "SELECT * FROM users WHERE name = '" + name + "'"3    return conn.execute(query).fetchall()

Run or narrate your approach, then ask the coach.