def rm_all_notes(chat_id):
notes = SESSION.query(Notes).filter(Notes.chat_id == str(chat_id))
if notes:
notes.delete()
SESSION.commit()
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 unkread(chat):
rem = SESSION.query(KRead).get((str(chat)))
if rem:
SESSION.delete(rem)
SESSION.commit()
def get_all_gbanned():
rem = SESSION.query(GBan).all()
SESSION.close()
return rem
def remove_filter(chat_id, keyword):
rem = SESSION.query(Filters).get((str(chat_id), keyword))
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 get_gbanuser(chat_id):
try:
return SESSION.query(GBan).get(str(chat_id))
finally:
SESSION.close()
def get_flist():
try:
return SESSION.query(Fban).all()
finally:
SESSION.close()
def del_flist(chat_id):
rem = SESSION.query(Fban).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def is_gbanned(sid):
try:
sonuc = SESSION.query(GBan).filter(GBan.sender == sid).first()
return sonuc.sender
except:
return False
def ungban(sender):
rem = SESSION.query(GBan).get((str(sender)))
if rem:
SESSION.delete(rem)
SESSION.commit()
def dissprove(chat_id):
rem = SESSION.query(PMPermit).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def delgvar(variable):
rem = SESSION.query(Globals).filter(Globals.variable == str(variable))\
.delete(synchronize_session="fetch")
if rem:
SESSION.commit()
def getir_warn(userid):
try:
UYARI = SESSION.query(Warns).filter(Warns.user_id == userid).first()
return UYARI.num_warn
except:
return 0
def unmute(chat_id, sender):
rem = SESSION.query(Mute).get(((str(chat_id)), (str(sender))))
if rem:
SESSION.delete(rem)
SESSION.commit()
def get_note(keyword):
try:
return SESSION.query(Note).get(keyword)
finally:
SESSION.close()
def clear_credentials(user):
saved_credentials = SESSION.query(GoogleDriveCreds).get(user)
if saved_credentials:
SESSION.delete(saved_credentials)
SESSION.commit()
return True
def get_notes():
try:
return SESSION.query(Note).all()
finally:
SESSION.close()
def num_warn_chats():
try:
return SESSION.query(func.count(distinct(Warns.chat_id))).scalar()
finally:
SESSION.close()
def all_gmuted():
rem = SESSION.query(GMute).all()
SESSION.close()
return rem
def freakungban(chat_id):
rem = SESSION.query(GBan).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def rm_all_filters(chat_id):
filters = SESSION.query(Notes).filter(Notes.chat_id == str(chat_id))
if filters:
filters.delete()
SESSION.commit()
def get_filters(chat_id):
try:
return SESSION.query(Filters).filter(
Filters.chat_id == str(chat_id)).all()
finally:
SESSION.close()
def get_note(chat_id, keyword):
try:
return SESSION.query(Notes).get((str(chat_id), keyword))
finally:
SESSION.close()
def num_blacklist_filters():
try:
return SESSION.query(BlackListFilters).count()
finally:
SESSION.close()
def get_notes(chat_id):
try:
return SESSION.query(Notes).filter(Notes.chat_id == str(chat_id)).all()
finally:
SESSION.close()
def num_blacklist_filter_chats():
try:
return SESSION.query(func.count(distinct(
BlackListFilters.chat_id))).scalar()
finally:
SESSION.close()
def get_filter(chat_id, keyword):
try:
return SESSION.query(Filters).get((str(chat_id), keyword))
finally:
SESSION.close()
def ungmute(sender):
rem = SESSION.query(GMute).get((str(sender)))
if rem:
SESSION.delete(rem)
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()
