def get_notes(chat_id):
try:
return SESSION.query(Notes).filter(Notes.chat_id == str(chat_id)).all()
finally:
SESSION.close()
def remove_all_filters(chat_id):
saved_filter = SESSION.query(Filters).filter(
Filters.chat_id == str(chat_id))
if saved_filter:
saved_filter.delete()
SESSION.commit()
def unmute(sender, chat_id):
rem = SESSION.query(Mute).get((str(sender), str(chat_id)))
if rem:
SESSION.delete(rem)
SESSION.commit()
def get_gbanuser(chat_id):
try:
return SESSION.query(GBan).get(str(chat_id))
finally:
SESSION.close()
def get_all_gbanned():
rem = SESSION.query(GBan).all()
SESSION.close()
return rem
def delCommand(command):
rem = SESSION.query(CMD).get(str(command))
if rem:
SESSION.delete(rem)
SESSION.commit()
def get_all_approved():
rem = SESSION.query(PMPermit).all()
SESSION.close()
return rem
def is_in_broadcastlist(keywoard, group_id):
with CATBROADCAST_INSERTION_LOCK:
broadcast_group = SESSION.query(CatBroadcast).get(
(keywoard, str(group_id)))
return bool(broadcast_group)
def del_keyword_broadcastlist(keywoard):
with CATBROADCAST_INSERTION_LOCK:
broadcast_group = (SESSION.query(CatBroadcast.keywoard).filter(
CatBroadcast.keywoard == keywoard).delete())
BROADCAST_SQL_.BROADCAST_CHANNELS.pop(keywoard)
SESSION.commit()
def num_broadcastlist_chat(keywoard):
try:
return (SESSION.query(CatBroadcast.keywoard).filter(
CatBroadcast.keywoard == keywoard).count())
finally:
SESSION.close()
def num_broadcastlist_chats():
try:
return SESSION.query(func.count(distinct(
CatBroadcast.keywoard))).scalar()
finally:
SESSION.close()
def disapprove(chat_id):
rem = SESSION.query(NOLogPMs).get(chat_id)
if rem:
SESSION.delete(rem)
SESSION.commit()
def rm_all_notes(chat_id):
notes = SESSION.query(Notes).filter(Notes.chat_id == str(chat_id))
if notes:
notes.delete()
SESSION.commit()
def rm_note(chat_id, keyword):
note = SESSION.query(Notes).filter(Notes.chat_id == str(chat_id),
Notes.keyword == keyword)
if note:
note.delete()
SESSION.commit()
def ungmute(sender):
rem = SESSION.query(GMute).get((str(sender)))
if rem:
SESSION.delete(rem)
SESSION.commit()
def get_broadcastlist_chats():
try:
chats = SESSION.query(CatBroadcast.keywoard).distinct().all()
return [i[0] for i in chats]
finally:
SESSION.close()
def remove_s(user_id, chat_id):
note = SESSION.query(LydiaAI).get((user_id, chat_id))
if note:
SESSION.delete(note)
SESSION.commit()
def num_broadcastlist():
try:
return SESSION.query(CatBroadcast).count()
finally:
SESSION.close()
def disapprove(chat_id):
rem = SESSION.query(PMPermit).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def num_warns():
try:
return SESSION.query(func.sum(Warns.num_warns)).scalar() or 0
finally:
SESSION.close()
def delgvar(variable):
rem = SESSION.query(Globals).filter(Globals.variable == str(variable))\
.delete(synchronize_session="fetch")
if rem:
SESSION.commit()
def num_warn_chats():
try:
return SESSION.query(func.count(distinct(Warns.chat_id))).scalar()
finally:
SESSION.close()
def nightungban(chat_id):
rem = SESSION.query(GBan).get(str(chat_id))
if rem:
SESSION.delete(rem)
SESSION.commit()
def get_all_muted():
rem = SESSION.query(Mute).all()
SESSION.close()
return rem
def remove_filter(chat_id, keyword):
saved_filter = SESSION.query(Filters).get((str(chat_id), keyword))
if saved_filter:
SESSION.delete(saved_filter)
SESSION.commit()
def gparent_id(folder_id):
adder = SESSION.query(Gdrive).get(folder_id)
if not adder:
adder = Gdrive(folder_id)
SESSION.add(adder)
SESSION.commit()
def is_muted(sender, chat_id):
user = SESSION.query(Mute).get((str(sender), str(chat_id)))
if user:
return True
else:
return False
def rmparent_id(folder_id):
note = SESSION.query(Gdrive).filter(Gdrive.marcus == folder_id)
if note:
note.delete()
SESSION.commit()
def get_locks(chat_id):
try:
return SESSION.query(Locks).get(str(chat_id))
finally:
SESSION.close()
def get_all_channels():
rem = SESSION.query(ghdb).all()
SESSION.close()
return rem
