How to delete a user from the database after he deleted the bot in telegram?

Question

Python

I have a telegram bot. How to remove a user from the database after he deleted the bot in telegram

Answer 1

You can only find out what he deleted when the bot sends a message and receives an execut that he was deleted.
You need to catch the exception and call the deletion from the database.

try:
    bot.send_message(user_id, text)
except telebot.apihelper.ApiException:
    logging.exception(f'Send Notification ERROR - {telebot.apihelper.ApiException}')
    delete_user(user_id)

where the removal of the user from the database is called, where he is likely to be sent.

def delete_user(user_id):
    del_user_query = f'DELETE FROM {users_t} WHERE {users_col["user_id"]} = {user_id};'
    post_sql_query(del_user_query)