Code RoomPagination offset parameter swapped
MediumPrep Room Coding #1760

Pagination offset parameter swapped

Code reviewNetworking & APIsMid–Senior~25 min

Review this SQL-backed Python pagination.

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.

0:00 of about 25 min
Mark a line and say what kind of problem it is.0 findings
1def page(conn, page_num, size=20):
2 offset = page_num * size
3 cur = conn.execute(
4 'SELECT id, name FROM items ORDER BY created_at LIMIT ? OFFSET ?',
5 (size, offset),
6 )
7 return cur.fetchall()
Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.