def remove_s(
user_id,
chat_id
):
note = SESSION.query(LydiaAI).get((user_id, chat_id))
if note:
SESSION.delete(note)
SESSION.commit()
def rm_note(chat_id, keyword):
to_check = get_note(chat_id, keyword)
if not to_check:
return False
else:
rem = SESSION.query(Notes).get((str(chat_id), keyword))
SESSION.delete(rem)
SESSION.commit()
return True
def del_flist(chat_id):
rem = SESSION.query(Fban).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def rm_wafu_setting(chat_id):
try:
rem = SESSION.query(Joinwafu).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
return True
except BaseException:
return False
def init_locks(chat_id, reset=False):
curr_restr = SESSION.query(Locks).get(str(chat_id))
if reset:
SESSION.delete(curr_restr)
SESSION.flush()
restr = Locks(str(chat_id))
SESSION.add(restr)
SESSION.commit()
return restr
def remove_url(tg_chat_id, tg_feed_link):
with INSERTION_LOCK:
# this loops to delete any possible duplicates for the same TG User ID, TG Chat ID and link
for row in check_url_availability(tg_chat_id, tg_feed_link):
# add the action to the DB query
SESSION.delete(row)
SESSION.commit()
def addwafu_setting(chat_id, previous_wafu, reply, f_mesg_id):
to_check = getwafu(chat_id)
if not to_check:
adder = Joinwafu(chat_id, previous_wafu, reply, f_mesg_id)
SESSION.add(adder)
SESSION.commit()
return True
rem = SESSION.query(Joinwafu).get(str(chat_id))
SESSION.delete(rem)
SESSION.commit()
adder = Joinwafu(chat_id, previous_wafu, reply, f_mesg_id)
SESSION.commit()
return False
def rf_bl(chat_id, trigger):
with BLACKLIST_FILTER_INSERTION_LOCK:
blacklist_filt = SESSION.query(BLF2).get((str(chat_id), trigger))
if blacklist_filt:
if trigger in CHAT_BLACKLISTS.get(str(chat_id),
set()): # sanity check
CHAT_BLACKLISTS.get(str(chat_id), set()).remove(trigger)
SESSION.delete(blacklist_filt)
SESSION.commit()
return True
SESSION.close()
return False
def rm_from_blacklist(chat_id, trigger):
with BLACKLIST_FILTER_INSERTION_LOCK:
blacklist_filt = SESSION.query(BlackListFilters).get((str(chat_id), trigger))
if blacklist_filt:
if trigger in BLACKLIST_SQL_.CHAT_BLACKLISTS.get(
str(chat_id), set()
): # sanity check
BLACKLIST_SQL_.CHAT_BLACKLISTS.get(str(chat_id), set()).remove(trigger)
SESSION.delete(blacklist_filt)
SESSION.commit()
return True
SESSION.close()
return False
def add_note(chat_id, keyword, reply, f_mesg_id):
to_check = get_note(chat_id, keyword)
if not to_check:
adder = Notes(str(chat_id), keyword, reply, f_mesg_id)
SESSION.add(adder)
SESSION.commit()
return True
else:
rem = SESSION.query(Notes).get((str(chat_id), keyword))
SESSION.delete(rem)
SESSION.commit()
adder = Notes(str(chat_id), keyword, reply, f_mesg_id)
SESSION.add(adder)
SESSION.commit()
return False
def rm_from_broadcastlist(keywoard, group_id):
with USERBROADCAST_INSERTION_LOCK:
broadcast_group = SESSION.query(UserBroadcast).get(
(keywoard, str(group_id)))
if broadcast_group:
if str(group_id) in BROADCAST_SQL_.BROADCAST_CHANNELS.get(
keywoard, set()):
BROADCAST_SQL_.BROADCAST_CHANNELS.get(keywoard, set()).remove(
str(group_id))
SESSION.delete(broadcast_group)
SESSION.commit()
return True
SESSION.close()
return False
def removenibba(chat_id):
nibbanoob = SESSION.query(Blockedid).get(str(chat_id))
if nibbanoob:
SESSION.delete(nibbanoob)
SESSION.commit()
def disapprove(chat_id):
rem = SESSION.query(PMPermit).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def removegmex(chat_id):
note = SESSION.query(GMEX).get(str(chat_id))
if note:
SESSION.delete(note)
SESSION.commit()
def marcusungban(chat_id):
rem = SESSION.query(GBan).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def remove_chat_gban(chat_id):
rem = SESSION.query(GBan).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
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 remove(user_id):
rem = SESSION.query(PMPermits).get(str(user_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def clear_credentials(user):
saved_credentials = SESSION.query(GoogleDriveCreds).get(user)
if saved_credentials:
SESSION.delete(saved_credentials)
SESSION.commit()
return True
def delCommand(command):
rem = SESSION.query(CMD).get(str(command))
if rem:
SESSION.delete(rem)
SESSION.commit()
def rmfed(feds):
rmfeddy = SESSION.query(Fed).get(feds)
if rmfeddy:
SESSION.delete(rmfeddy)
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 del_chat(chat_id):
rem = SESSION.query(Chat).get((str(chat_id)))
if rem:
SESSION.delete(rem)
SESSION.commit()
def rm_channel(chat_id):
rem = SESSION.query(ghdb).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def disapprove(chat_id):
rem = SESSION.query(NOLogPMs).get(chat_id)
if rem:
SESSION.delete(rem)
SESSION.commit()
def disapprove(chat_id):
rem = SESSION.query(forceSubscribe).get(chat_id)
if rem:
SESSION.delete(rem)
SESSION.commit()
def rm_welcome_setting(chat_id):
rem = SESSION.query(Welcome).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def unglobelmute(sender):
rem = SESSION.query(GLOBELMute).get((str(sender)))
if rem:
SESSION.delete(rem)
SESSION.commit()
def remove_echo(user_id, chat_id):
note = SESSION.query(ECHOSQL).get((str(user_id), str(chat_id)))
if note:
SESSION.delete(note)
SESSION.commit()
