import logging
from aiogram import Bot, Dispatcher, executor, types
import pymysql
bot = Bot(token="5405471485:AAH1-5sX7Z7GMHCuNEIsenddaoic4FDrtE4")
dp= Dispatcher(bot)
logging.basicConfig(level=logging.INFO)

users = {1,1}
@dp.message_handler(commands=['start'])
async def cmd_start(message: types.Message):
    users.add(message.from_user.id)
    await bot.send_message(message.from_user.id,"Егор Бахмет БОТ")

con = pymysql.connect(host="185.231.153.103", user="study",password="study123", database="egor")
@dp.message_handler(commands=['select_version'])
async def cmd_select_version(message: types.Message):
    with con:
        cur = con.cursor()
        cur.execute("SELECT VERSION()")
        version = cur.fetchone()
        await bot.send_message(message.from_user.id, f"{version[0]}")
@dp.message_handler(commands=['boom'])
async  def cmd_boom(message: types.Message):
    users.add(message.from_user.id)
    await  bot.send_message(message.from_user.id, "\n".join(f"* {user_id}" for user_id in users))


if __name__ == "__main__":
    executor.start_polling(dp)