def num_chats(): try: return SESSION.query(func.count(distinct(Rules.chat_id))).scalar() finally: SESSION.close()
def get_all_chat_notes(chat_id): try: return (SESSION.query(Notes).filter( Notes.chat_id == str(chat_id)).order_by(Notes.name.asc()).all()) finally: SESSION.close()
def num_warn_filter_chats(): try: return SESSION.query(func.count(distinct( WarnFilters.chat_id))).scalar() finally: SESSION.close()
def get_all_chat_id(): stark = SESSION.query(Nightmode).all() SESSION.close() return stark
def num_warn_chat_filters(chat_id): try: return (SESSION.query(WarnFilters.chat_id).filter( WarnFilters.chat_id == str(chat_id)).count()) finally: SESSION.close()
def num_warn_filters(): try: return SESSION.query(WarnFilters).count() finally: SESSION.close()
def num_warns(): try: return SESSION.query(func.sum(Warns.num_warns)).scalar() or 0 finally: SESSION.close()
def get_warn_filter(chat_id, keyword): try: return SESSION.query(WarnFilters).get((str(chat_id), keyword)) finally: SESSION.close()
def get_chat_warn_filters(chat_id): try: return (SESSION.query(WarnFilters).filter( WarnFilters.chat_id == str(chat_id)).all()) finally: SESSION.close()