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
