def in_channels(chat_id):
try:
return SESSION.query(fban).filter(fban.chat_id == str(chat_id)).one()
except BaseException:
return None
finally:
SESSION.close()
def is_id_added(chat_id):
try:
return SESSION.query(Blockedid).filter(
Blockedid.chat_id == str(chat_id)).one()
except:
return None
finally:
SESSION.close()
def get_all_channels():
rem = SESSION.query(fban).all()
SESSION.close()
return rem
def rm_channel(chat_id):
rem = SESSION.query(fban).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def add_channel(chat_id):
adder = fban(str(chat_id))
SESSION.add(adder)
SESSION.commit()
def removeid(chat_id):
safai = SESSION.query(Blockedid).get(str(chat_id))
if safai:
SESSION.delete(safai)
SESSION.commit()
def get_all_nibba():
eberyone = SESSION.query(Blockedid).all()
SESSION.close()
return eberyone
def add_in_db(chat_id: int):
lodu = Blockedid(str(chat_id))
SESSION.add(lodu)
SESSION.commit()