How to add telegram user id to sqlite database?

Question

Python

How to make it so that when you click /start, the person's id is automatically entered into the sqlite database?

Answer 1

connection = sqlite3.connect("PATH")
cursor = connection.cursor()
cursor.execute("INSERT OR IGNORE INTO users (id) VALUES (:id)", {"id": id})

OR IGNOREso that if the user is already registered, nothing happens (otherwise there will be an error)
All this needs to be placed in a decorator that is responsible for the /start command. It's also a good idea to write a special class for the database so you don't have to open it every time.

Answer 2

Nikita Shoshin , by the way, have you come across such an error by chance?
sqlite3.InterfaceError: Error binding parameter :id - probably unsupported type.

Answer 3

SQLite for simple needs is no different than mysql if you're interested in the syntax.