Practice · 2 of 2

Unique Means Unique

CHALLENGE

Difficulty: intermediate+25 XP

Implement add_user(conn, email) inserting into users(id INTEGER PRIMARY KEY, email TEXT NOT NULL UNIQUE). A duplicate email must raise ValueError('duplicate email') — translate the sqlite3.IntegrityError (module 5 chaining!).

Press Submit to check your solution.

Back to lesson: Practice: Transaction Drills