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 is_gmuted(sender_id):
try:
return SESSION.query(GMute).all()
except BaseException:
return None
finally:
SESSION.close()
def is_muted(chat_id):
try:
return SESSION.query(Mute).filter(Mute.chat_id == str(chat_id)).all()
except BaseException:
return None
finally:
SESSION.close()
def is_kread():
try:
return SESSION.query(KRead).all()
except BaseException:
return None
finally:
SESSION.close()
def get_current_welcome_settings(chat_id):
try:
return SESSION.query(Welcome).filter(
Welcome.chat_id == str(chat_id)).one()
except BaseException:
return None
finally:
SESSION.close()
def gvarstatus(variable):
try:
return SESSION.query(Globals).filter(
Globals.variable == str(variable)).first().value
except BaseException:
return None
finally:
SESSION.close()
def is_approved(chat_id):
try:
return SESSION.query(PMPermit).filter(
PMPermit.chat_id == str(chat_id)).one()
except BaseException:
return None
finally:
SESSION.close()
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 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 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 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 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 get_filters(chat_id):
try:
return SESSION.query(Filters).filter(
Filters.chat_id == str(chat_id)).all()
finally:
SESSION.close()
def get_filter(chat_id, keyword):
try:
return SESSION.query(Filters).get((str(chat_id), keyword))
finally:
SESSION.close()
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 get_note(chat_id, keyword):
try:
return SESSION.query(Notes).get((str(chat_id), keyword))
finally:
SESSION.close()
def get_snips():
try:
return SESSION.query(Snips).all()
finally:
SESSION.close()
def add_phrase(resp, phrase):
adder = QuickPhrase(str(resp), phrase)
SESSION.add(adder)
SESSION.commit()
def ungmute(sender):
rem = SESSION.query(GMute).get((str(sender)))
if rem:
SESSION.delete(rem)
SESSION.commit()
def gmute(sender):
adder = GMute(str(sender))
SESSION.add(adder)
SESSION.commit()
def get_notes(chat_id):
try:
return SESSION.query(Notes).filter(Notes.chat_id == str(chat_id)).all()
finally:
SESSION.close()
def get_snip(keyword):
try:
return SESSION.query(Snips).get(keyword)
finally:
SESSION.close()
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 update_previous_welcome(chat_id, previous_welcome):
row = SESSION.query(Welcome).get(str(chat_id))
row.previous_welcome = previous_welcome
SESSION.commit()
def get_phrases(resp):
try:
return SESSION.query(QuickPhrase).filter(
QuickPhrase.resp == str(resp)).all()
finally:
SESSION.close()
def kread(chat):
adder = KRead(str(chat))
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 unkread(chat):
rem = SESSION.query(KRead).get((str(chat)))
if rem:
SESSION.delete(rem)
SESSION.commit()