def get_name(uid: int) -> str:
data = vk.method("users.get", {"user_ids": uid})[0]
return "{} {}".format(data["first_name"], data["last_name"])
if not is_user_statlisted(user_id):
insert_statlist(user_id, get_name(user_id))
def is_user_statlisted(user_id: int) -> bool:
cmd = "select count(user_id) from statlist where user_id = %d" % (user_id)
c.execute(cmd)
result = c.fetchone()[0]
print("Проверка айди на наличие в статлисте")
return result > 0
def insert_statlist(user_id: int, name):
cmd = "INSERT INTO statlist(user_id, sms, name) VALUES (%d, 0, %s)" % (user_id, name)
c.execute(cmd)
conn.commit()
print("Пользователь добавлен в статлист")
Логи
OperationalError('near "Падший": syntax error')