def add_note_to_db(chat_id, note_name, note_message_id):
with NOTES_INSERTION_LOCK:
prev = SESSION.query(Notes).get((str(chat_id), note_name))
if prev:
SESSION.delete(prev)
note = Notes(str(chat_id), note_name, note_message_id)
SESSION.add(note)
SESSION.commit()
def rm_note(chat_id, note_name):
with NOTES_INSERTION_LOCK:
note = SESSION.query(Notes).get((str(chat_id), note_name))
if note:
SESSION.delete(note)
SESSION.commit()
return True
else:
SESSION.close()
return False
def clear_credential(chat_id):
with INSERTION_LOCK:
saved_cred = SESSION.query(gDriveCreds).get(chat_id)
if saved_cred:
SESSION.delete(saved_cred)
SESSION.commit()
def rm_welcome_setting(chat_id):
rem = SESSION.query(Welcome).get(chat_id)
if rem:
SESSION.delete(rem)
SESSION.commit()