How can I prevent duplicate records from being entered into the database?

Question

Python

The user's city is entered into the database when he writes his city. If he writes the city again, then the bot crashes, because. there is already a city in the database. How to solve this problem?

Mistake:

sqlite3.IntegrityError: UNIQUE constraint failed: user_city

Answer 1

Check for city before writing
or
handle IntegrityError with try except

Answer 2

Your entire column is made unique, so you can't add a subsequent entry with that city

Answer 3

depending on what you want to achieve. If the city really needs to be unique, check for the existence of such a city before recording. If more than 1 user can live in one city, remove uniqueness.