Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2020
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 2.90 KB | None | 0 0
  1. # Проверка группы (Reply)
  2. def connect(message: types.Message):
  3.     cursor.execute('SELECT grup FROM Users WHERE id = ?', (message.from_user.id,))
  4.     result = cursor.fetchone()
  5.     if result is not None:
  6.         print('not none')
  7.     return result
  8. # Проверка группы (Inline)
  9. def connect1(call: CallbackQuery):
  10.     cursor.execute('SELECT grup FROM Users WHERE id = ?', (call.from_user.id,))
  11.     result = cursor.fetchone()
  12.     if result is not None:
  13.         print('not none')
  14.     return result
  15.  
  16.  
  17. @dp.message_handler(text='ПН')
  18. async def pn(message: types.Message):
  19.     result = connect(message=message)
  20.     for row in result:
  21.         if row == 'СВ-31':
  22.             cursor.execute("SELECT `raspisanie` FROM `Schedule` WHERE `grup` = 'SV_31__PN_n'")
  23.             row = cursor.fetchone()
  24.             await message.answer(row[0], reply_markup=il_1)
  25.  
  26. @dp.message_handler(text='ВТ')
  27. async def send_text(message: types.Message):
  28.     result = connect(message=message)
  29.     if result is None:
  30.         print('none')
  31.     for row in result:
  32.         if row == 'СВ-31':
  33.             cursor.execute("SELECT `raspisanie` FROM `Schedule` WHERE `grup` = 'SV_31__VT_n'")
  34.             row = cursor.fetchone()
  35.             await message.answer(row[0], reply_markup=il_3)
  36.  
  37.  
  38. @dp.callback_query_handler(text='PN_p')
  39. async def answer(call: CallbackQuery):
  40.     result = connect1(call)
  41.     if result is None:
  42.         print('none')
  43.     for row in result:
  44.         if row == 'СВ-31':
  45.             cursor.execute("SELECT `raspisanie` FROM `Schedule` WHERE `grup` = 'SV_31__PN_p'")
  46.             row = cursor.fetchone()
  47.             await call.message.answer(row[0], reply_markup=il_2)
  48.  
  49.  
  50. @dp.callback_query_handler(text='PN_n')
  51. async def answer(call: CallbackQuery):
  52.     result = connect1(call)
  53.     if result is None:
  54.         print('none')
  55.     for row in result:
  56.         if row == 'СВ-31':
  57.             cursor.execute("SELECT `raspisanie` FROM `Schedule` WHERE `grup` = 'SV_31__PN_n'")
  58.             row = cursor.fetchone()
  59.             await call.message.answer(row[0], reply_markup=il_1)
  60.  
  61.  
  62. @dp.callback_query_handler(text='VT_p')
  63. async def answer(call: CallbackQuery):
  64.     result = connect1(call)
  65.     if result is None:
  66.         print('none')
  67.     for row in result:
  68.         if row == 'СВ-31':
  69.             cursor.execute("SELECT `raspisanie` FROM `Schedule` WHERE `grup` = 'SV_31__VT_p'")
  70.             row = cursor.fetchone()
  71.             await call.message.answer(row[0], reply_markup=il_4)
  72.  
  73.  
  74. @dp.callback_query_handler(text='VT_n')
  75. async def answer(call: CallbackQuery):
  76.     result = connect1(call)
  77.     if result is None:
  78.         print('none')
  79.     for row in result:
  80.         if row == 'СВ-31':
  81.             cursor.execute("SELECT `raspisanie` FROM `Schedule` WHERE `grup` = 'SV_31__VT_n'")
  82.             row = cursor.fetchone()
  83.             await call.message.answer(row[0], reply_markup=il_3)
  84.  
  85.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement