o <6j @sddlmZmZddlmZddlmZddlmZddl m Z m Z m Z dede dee fd d Zdedee fd d Zded e de de de f ddZdede defddZdede defddZdede de defddZdS))ListOptional)select) AsyncSession) joinedload)Admin AdminRoleUsersession telegram_idreturncs>|tttjtj|kt tjIdH}| S)z#Telegram ID bo'yicha adminni topishN) executerrjoinuserwherer r optionsrscalar_one_or_none)r r resultrD/var/www/www-root/data/www/ai-bot.pdev.uz/bot/database/crud/admin.pyget_admin_by_telegram_id s   rcs2|ttttjIdH}t|S)zBarcha adminlar ro'yxatiN) r rrrrrlistscalarsall)r rrrrget_all_adminss  rrroleadded_bycs>t|j||d}|||IdH||IdH|S)zYangi admin qo'shish)user_idrrN)ridaddcommitrefresh)r rrradminrrr add_admins r#cs<t||IdH}|s dS||IdH|IdHdS)z,Adminni o'chirish. Returns True agar topilsaNFT)rdeleter r r r"rrr remove_admin1sr&cst||IdH}|duS)z)Foydalanuvchi admin ekanligini tekshirishN)rr%rrris_admin=sr'new_rolecs2t||IdH}|s dS||_|IdHdS)zAdmin rolini o'zgartirishNFT)rrr )r r r(r"rrrupdate_admin_roleCsr)N)typingrr sqlalchemyrsqlalchemy.ext.asynciorsqlalchemy.ormrbot.database.modelsrrr intrrr#boolr&r'r)rrrrsR