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 add_s(user_id, chat_id, session_id, session_expires):
adder = SESSION.query(LydiaAI).get((user_id, chat_id))
if adder:
adder.session_id = session_id
adder.session_expires = session_expires
else:
adder = LydiaAI(user_id, chat_id, session_id, session_expires)
SESSION.add(adder)
SESSION.commit()
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_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 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_phrase(resp, phrase):
adder = QuickPhrase(str(resp), phrase)
SESSION.add(adder)
SESSION.commit()
def mute(chat_id, sender):
adder = Mute(str(chat_id), str(sender))
SESSION.add(adder)
SESSION.commit()
def kread(chat):
adder = KRead(str(chat))
SESSION.add(adder)
SESSION.commit()
def approve(chat_id):
adder = PMPermit(str(chat_id))
SESSION.add(adder)
SESSION.commit()
def gmute(sender):
adder = GMute(str(sender))
SESSION.add(adder)
SESSION.commit()