def add_snip(
keyword, reply, snip_type, media_id, media_access_hash, media_file_reference
):
adder = SESSION.query(Snips).get(keyword)
if adder:
adder.reply = reply
adder.snip_type = snip_type
adder.media_id = media_id
adder.media_access_hash = media_access_hash
adder.media_file_reference = media_file_reference
else:
adder = Snips(
keyword, reply, snip_type, media_id, media_access_hash, media_file_reference
)
SESSION.add(adder)
SESSION.commit()
def add_usersid_in_db(chat_id: int):
id_user = Moidata(str(chat_id))
SESSION.add(id_user)
SESSION.commit()
def add_id_in_db(message_id: int, chat_id: int, um_id: int):
""" add the message to the table """
__user = Users(message_id, str(chat_id), um_id)
SESSION.add(__user)
SESSION.commit()
def removeid(chat_id):
safai = SESSION.query(Blockedid).get(str(chat_id))
if safai:
SESSION.delete(safai)
SESSION.commit()
def add_in_db(chat_id: int):
lodu = Blockedid(str(chat_id))
SESSION.add(lodu)
SESSION.commit()
def remove_snip(keyword):
note = SESSION.query(Snips).filter(Snips.snip == keyword)
if note:
note.delete()
SESSION.commit()
def rm_channel(chat_id):
rem = SESSION.query(fban).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def add_channel(chat_id):
adder = fban(str(chat_id))
SESSION.add(adder)
SESSION.commit()