Advertisement
Guest User

Untitled

a guest
Nov 21st, 2019
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1.  
  2.  
  3.  
  4. def bd(message, num):
  5. print('test 2')
  6. conn = sqlite3.connect("telegram_group.db")
  7. cursor = conn.cursor()
  8. nick = message.from_user.first_name
  9. print('test 5', message.from_user.id)
  10. user_id = message.from_user.id
  11. now = datetime.datetime.now()
  12. sql = f"SELECT * FROM users WHERE user_id = '{user_id}'"
  13. result = ''
  14.  
  15. for result in cursor.execute(sql):
  16. print(result)
  17.  
  18. sql = f"""
  19. SELECT last_message_date FROM users
  20. WHERE last_message_date <= '{now.year}-{now.month}-{now.day - 14}';
  21. """
  22. for old in cursor.execute(sql):
  23. print(old)
  24. print(old[0])
  25.  
  26. sql = f"""
  27. SELECT count(id) FROM users;
  28. """
  29.  
  30. for count in cursor.execute(sql):
  31. print(count)
  32. print(count[0])
  33.  
  34. if not result:
  35. # Если нету в БД
  36. if not num:
  37. bot.kick_chat_member(message.chat.id, '{kickid}'.format(kickid=message.from_user.id))
  38. else:
  39. sql = f"""
  40. INSERT INTO users
  41. VALUES ({count[0]}, '{nick}', '{user_id}', '{now.year}-{now.month}-{now.day}');
  42. """
  43. cursor.execute(sql)
  44. conn.commit()
  45. group(message)
  46.  
  47. else:
  48. # Если уже есть
  49. sql = f"""
  50. UPDATE users
  51. SET nick_name = '{nick}', last_message_date = '{now.year}-{now.month}-{now.day}'
  52. WHERE user_id = '{user_id}';
  53. """
  54. cursor.execute(sql)
  55. conn.commit()
  56. group(message)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement