def get_notes(chat_id): try: return SESSION.query(Notes).filter(Notes.chat_id == str(chat_id)).all() finally: SESSION.close()
def remove_all_filters(chat_id): saved_filter = SESSION.query(Filters).filter( Filters.chat_id == str(chat_id)) if saved_filter: saved_filter.delete() SESSION.commit()
def unmute(sender, chat_id): rem = SESSION.query(Mute).get((str(sender), str(chat_id))) if rem: SESSION.delete(rem) SESSION.commit()
def get_gbanuser(chat_id): try: return SESSION.query(GBan).get(str(chat_id)) finally: SESSION.close()
def get_all_gbanned(): rem = SESSION.query(GBan).all() SESSION.close() return rem
def delCommand(command): rem = SESSION.query(CMD).get(str(command)) if rem: SESSION.delete(rem) SESSION.commit()
def get_all_approved(): rem = SESSION.query(PMPermit).all() SESSION.close() return rem
def is_in_broadcastlist(keywoard, group_id): with CATBROADCAST_INSERTION_LOCK: broadcast_group = SESSION.query(CatBroadcast).get( (keywoard, str(group_id))) return bool(broadcast_group)
def del_keyword_broadcastlist(keywoard): with CATBROADCAST_INSERTION_LOCK: broadcast_group = (SESSION.query(CatBroadcast.keywoard).filter( CatBroadcast.keywoard == keywoard).delete()) BROADCAST_SQL_.BROADCAST_CHANNELS.pop(keywoard) SESSION.commit()
def num_broadcastlist_chat(keywoard): try: return (SESSION.query(CatBroadcast.keywoard).filter( CatBroadcast.keywoard == keywoard).count()) finally: SESSION.close()
def num_broadcastlist_chats(): try: return SESSION.query(func.count(distinct( CatBroadcast.keywoard))).scalar() finally: SESSION.close()
def disapprove(chat_id): rem = SESSION.query(NOLogPMs).get(chat_id) if rem: SESSION.delete(rem) SESSION.commit()
def rm_all_notes(chat_id): notes = SESSION.query(Notes).filter(Notes.chat_id == str(chat_id)) if notes: notes.delete() SESSION.commit()
def rm_note(chat_id, keyword): note = SESSION.query(Notes).filter(Notes.chat_id == str(chat_id), Notes.keyword == keyword) if note: note.delete() SESSION.commit()
def ungmute(sender): rem = SESSION.query(GMute).get((str(sender))) if rem: SESSION.delete(rem) SESSION.commit()
def get_broadcastlist_chats(): try: chats = SESSION.query(CatBroadcast.keywoard).distinct().all() return [i[0] for i in chats] finally: SESSION.close()
def remove_s(user_id, chat_id): note = SESSION.query(LydiaAI).get((user_id, chat_id)) if note: SESSION.delete(note) SESSION.commit()
def num_broadcastlist(): try: return SESSION.query(CatBroadcast).count() finally: SESSION.close()
def disapprove(chat_id): rem = SESSION.query(PMPermit).get(str(chat_id)) if rem: SESSION.delete(rem) SESSION.commit()
def num_warns(): try: return SESSION.query(func.sum(Warns.num_warns)).scalar() or 0 finally: SESSION.close()
def delgvar(variable): rem = SESSION.query(Globals).filter(Globals.variable == str(variable))\ .delete(synchronize_session="fetch") if rem: SESSION.commit()
def num_warn_chats(): try: return SESSION.query(func.count(distinct(Warns.chat_id))).scalar() finally: SESSION.close()
def nightungban(chat_id): rem = SESSION.query(GBan).get(str(chat_id)) if rem: SESSION.delete(rem) SESSION.commit()
def get_all_muted(): rem = SESSION.query(Mute).all() SESSION.close() return rem
def remove_filter(chat_id, keyword): saved_filter = SESSION.query(Filters).get((str(chat_id), keyword)) if saved_filter: SESSION.delete(saved_filter) SESSION.commit()
def gparent_id(folder_id): adder = SESSION.query(Gdrive).get(folder_id) if not adder: adder = Gdrive(folder_id) SESSION.add(adder) SESSION.commit()
def is_muted(sender, chat_id): user = SESSION.query(Mute).get((str(sender), str(chat_id))) if user: return True else: return False
def rmparent_id(folder_id): note = SESSION.query(Gdrive).filter(Gdrive.marcus == folder_id) if note: note.delete() SESSION.commit()
def get_locks(chat_id): try: return SESSION.query(Locks).get(str(chat_id)) finally: SESSION.close()
def get_all_channels(): rem = SESSION.query(ghdb).all() SESSION.close() return rem