o <6j ã@sÌddlmZmZddlmZmZddlmZddlm Z dedee fdd„Z ded e dee fd d „Z dded e d e de dee dee de fdd„Zded e defdd„Zdedee fdd„Zd S)é)ÚListÚOptional)ÚselectÚdelete)Ú AsyncSession)ÚMandatoryChannelÚsessionÚreturncÃs:| ttƒ tjdk¡ tj¡¡IdH}t| ¡  ¡ƒS)z0Barcha aktiv majburiy kanallar (tartib bo'yicha)TN) ÚexecuterrÚwhereÚ is_activeÚorder_byÚorderÚlistÚscalarsÚall©rÚresult©rúF/var/www/www-root/data/www/ai-bot.pdev.uz/bot/database/crud/channel.pyÚget_active_channels s€  ýrÚ channel_idcÃs*| ttƒ tj|k¡¡IdH}| ¡S)N)r rrr rÚscalar_one_or_none)rrrrrrÚget_channel_by_ids € ÿrNÚ channel_titleÚadded_byÚchannel_usernameÚ invite_linkc Ãsz| ttjƒ tj ¡¡ d¡¡IdH}| ¡pd}t||||||dd}| |¡|  ¡IdH|  |¡IdH|S)zYangi majburiy kanal qo'shishéNr)rrrrrr) r rrrr ÚdescÚlimitrÚaddÚcommitÚrefresh) rrrrrrrÚ last_orderÚchannelrrrÚ add_channels"€  ÿ ú r&cÃsJ| ttƒ tj|k¡¡IdH}| ¡}|sdSd|_| ¡IdHdS)z5Majburiy kanalni o'chirish. Returns True agar topilsaNFT)r rrr rrr r")rrrr%rrrÚremove_channel9s€ ÿr'cÃs.| ttƒ tj¡¡IdH}t| ¡ ¡ƒS)z-Admin uchun: barcha kanallar (noaktivlar ham)N)r rrr rrrrrrrrÚget_all_channelsFs € ÿr()NN)ÚtypingrrÚ sqlalchemyrrÚsqlalchemy.ext.asynciorÚbot.database.modelsrrÚintrÚstrr&Úboolr'r(rrrrÚs>   ÿÿ þúÿþýüûú ù