def addgvar(variable, value):
if SESSION.query(Globals).filter(
Globals.variable == str(variable)).one_or_none():
delgvar(variable)
adder = Globals(str(variable), value)
SESSION.add(adder)
SESSION.commit()
def remove_snip(keyword):
to_check = get_snip(keyword)
if not to_check:
return False
else:
rem = SESSION.query(Snips).filter(Snips.snip == keyword)
rem.delete()
SESSION.commit()
return True
def remove_filter(chat_id, keyword):
to_check = get_filter(chat_id, keyword)
if not to_check:
return False
else:
rem = SESSION.query(Filters).get((str(chat_id), keyword))
SESSION.delete(rem)
SESSION.commit()
return True
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 rm_welcome_setting(chat_id):
try:
rem = SESSION.query(Welcome).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
return True
except BaseException:
return False
def add_welcome_setting(chat_id, previous_welcome, reply, f_mesg_id):
to_check = get_welcome(chat_id)
if not to_check:
adder = Welcome(chat_id, previous_welcome, reply, f_mesg_id)
SESSION.add(adder)
SESSION.commit()
return True
else:
rem = SESSION.query(Welcome).get(str(chat_id))
SESSION.delete(rem)
SESSION.commit()
adder = Welcome(chat_id, previous_welcome, reply, f_mesg_id)
SESSION.commit()
return False
def add_snip(keyword, reply, f_mesg_id):
to_check = get_snip(keyword)
if not to_check:
adder = Snips(keyword, reply, f_mesg_id)
SESSION.add(adder)
SESSION.commit()
return True
else:
rem = SESSION.query(Snips).filter(Snips.snip == keyword)
SESSION.delete(rem)
SESSION.commit()
adder = Snips(keyword, reply, f_mesg_id)
SESSION.add(adder)
SESSION.commit()
return False
def add_filter(chat_id, keyword, reply, f_mesg_id):
to_check = get_filter(chat_id, keyword)
if not to_check:
adder = Filters(str(chat_id), keyword, reply, f_mesg_id)
SESSION.add(adder)
SESSION.commit()
return True
else:
rem = SESSION.query(Filters).get((str(chat_id), keyword))
SESSION.delete(rem)
SESSION.commit()
adder = Filters(str(chat_id), keyword, reply, f_mesg_id)
SESSION.add(adder)
SESSION.commit()
return False
def ungmute(sender):
rem = SESSION.query(GMute).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 approve(chat_id):
adder = PMPermit(str(chat_id))
SESSION.add(adder)
SESSION.commit()
def unkread(chat):
rem = SESSION.query(KRead).get((str(chat)))
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 add_phrase(resp, phrase):
adder = QuickPhrase(str(resp), phrase)
SESSION.add(adder)
SESSION.commit()
def gmute(sender):
adder = GMute(str(sender))
SESSION.add(adder)
SESSION.commit()
def update_previous_welcome(chat_id, previous_welcome):
row = SESSION.query(Welcome).get(str(chat_id))
row.previous_welcome = previous_welcome
SESSION.commit()
def unmute(chat_id, sender):
rem = SESSION.query(Mute).get(((str(chat_id)), (str(sender))))
if rem:
SESSION.delete(rem)
SESSION.commit()
def mute(chat_id, sender):
adder = Mute(str(chat_id), str(sender))
SESSION.add(adder)
SESSION.commit()
def remove_phrase(resp, phrase):
rem = SESSION.query(QuickPhrase).get((str(resp), str(phrase)))
if rem:
SESSION.delete(rem)
SESSION.commit()
def kread(chat):
adder = KRead(str(chat))
SESSION.add(adder)
SESSION.commit()