def get_chat_warn_filters(chat_id): try: return (SESSION.query(WarnFilters).filter( WarnFilters.chat_id == str(chat_id)).all()) finally: SESSION.close()
def num_disabled(): try: return SESSION.query(Disable).count() finally: SESSION.close()
def is_approved(chat_id, user_id): try: return SESSION.query(Approvals).get((str(chat_id), user_id)) finally: SESSION.close()
def curr_connection(chat_id): try: return SESSION.query(Connection).get((str(chat_id))) finally: SESSION.close()
def get_connected_chat(user_id): try: return SESSION.query(Connection).get((int(user_id))) finally: SESSION.close()
def num_chats(): try: return SESSION.query(Chats).count() finally: SESSION.close()
def num_users(): try: return SESSION.query(Users).count() finally: SESSION.close()
def get_all_users(): try: return SESSION.query(Users).all() finally: SESSION.close()
def get_user_num_chats(user_id): try: return (SESSION.query(ChatMembers).filter( ChatMembers.user == int(user_id)).count()) finally: SESSION.close()
def get_all_chats(): try: return SESSION.query(Chats).all() finally: SESSION.close()
def get_chat_members(chat_id): try: return SESSION.query(ChatMembers).filter( ChatMembers.chat == str(chat_id)).all() finally: SESSION.close()
def get_name_by_userid(user_id): try: return SESSION.query(Users).get(Users.user_id == int(user_id)).first() finally: SESSION.close()
def get_userid_by_name(username): try: return (SESSION.query(Users).filter( func.lower(Users.username) == username.lower()).all()) finally: SESSION.close()
def check_afk_status(user_id): try: return SESSION.query(AFK).get(user_id) finally: SESSION.close()