def get_all_sudo_id(): stark = SESSION.query(SUDO).all() SESSION.close() return stark
def num_blacklist_filter_chats(): try: return SESSION.query(func.count(distinct( BlackListFilters.chat_id))).scalar() finally: SESSION.close()
def check_sudo_status(user_id): try: return SESSION.query(SUDO).get(user_id) finally: SESSION.close()
def num_blacklist_filters(): try: return SESSION.query(BlackListFilters).count() finally: SESSION.close()
def num_blacklist_chat_filters(chat_id): try: return (SESSION.query(BlackListFilters.chat_id).filter( BlackListFilters.chat_id == str(chat_id)).count()) finally: SESSION.close()
def num_warn_chats(): try: return SESSION.query(func.count(distinct(Warns.chat_id))).scalar() finally: SESSION.close()
def num_warns(): try: return SESSION.query(func.sum(Warns.num_warns)).scalar() or 0 finally: SESSION.close()
def get_all_chat_id(): stark = SESSION.query(Nightmode).all() SESSION.close() return stark
def check_afk_status(user_id): try: return SESSION.query(AFK).get(user_id) finally: SESSION.close()
def get_all_users(): stark = SESSION.query(Moidata).all() SESSION.close() return stark