my_events.py 581 B

12345678910111213141516
  1. from aiogram import types, Dispatcher
  2. from bot import database, sql
  3. from bot.functions import beauty_all_events
  4. async def my_events(call: types.CallbackQuery):
  5. db = database.Database()
  6. data = db.sql_fetchall(sql=sql.get_user_event(call.from_user.id))
  7. if len(data) == 0:
  8. await call.message.answer("Вы не планировали мероприятия")
  9. else:
  10. await call.message.answer(beauty_all_events(sorted(data, key=lambda d: d['e_date'])))
  11. def register(dp: Dispatcher):
  12. dp.register_callback_query_handler(my_events, text='my_events')