def get_welc_buttons(chat_id):
try:
return SESSION.query(WelcomeButtons).filter(
WelcomeButtons.chat_id == str(chat_id)).order_by(
WelcomeButtons.id).all()
finally:
SESSION.close()
def get_gdbye_buttons(chat_id):
try:
return SESSION.query(GoodbyeButtons).filter(
GoodbyeButtons.chat_id == str(chat_id)).order_by(
GoodbyeButtons.id).all()
finally:
SESSION.close()
def __load_dynasties_subscriber():
global DYNASTY_SUBSCRIBER
global MYDYNASTY_SUBSCRIBER
try:
dynasties = SESSION.query(DynastySubs.dynasty_id).distinct().all()
for (dynasty_id, ) in dynasties: # remove tuple by ( ,)
DYNASTY_SUBSCRIBER[dynasty_id] = []
MYDYNASTY_SUBSCRIBER[dynasty_id] = []
all_dynastiesubs = SESSION.query(DynastySubs).all()
for x in all_dynastiesubs:
DYNASTY_SUBSCRIBER[x.dynasty_id] += [x.dynasty_subs]
try:
MYDYNASTY_SUBSCRIBER[x.dynasty_subs] += [x.dynasty_id]
except KeyError:
getsubs = SESSION.query(DynastySubs).get(
(x.dynasty_id, x.dynasty_subs))
if getsubs:
SESSION.delete(getsubs)
SESSION.commit()
DYNASTY_SUBSCRIBER = {x: set(y) for x, y in DYNASTY_SUBSCRIBER.items()}
MYDYNASTY_SUBSCRIBER = {
x: set(y)
for x, y in MYDYNASTY_SUBSCRIBER.items()
}
finally:
SESSION.close()
def get_user_com_chats(user_id):
try:
chat_members = SESSION.query(ChatMembers).filter(
ChatMembers.user == int(user_id)).all()
return [i.chat for i in chat_members]
finally:
SESSION.close()
def get_note(chat_id, note_name):
try:
return SESSION.query(Notes).filter(
func.lower(Notes.name) == note_name,
Notes.chat_id == str(chat_id)).first()
finally:
SESSION.close()
def get_buttons(chat_id, note_name):
try:
return SESSION.query(Buttons).filter(
Buttons.chat_id == str(chat_id),
Buttons.note_name == note_name).order_by(Buttons.id).all()
finally:
SESSION.close()
def clean_service(chat_id: Union[str, int]) -> bool:
try:
chat_setting = SESSION.query(CleanServiceSetting).get(str(chat_id))
if chat_setting:
return chat_setting.clean_service
return False
finally:
SESSION.close()
def get_custom_gdbye(chat_id):
welcome_settings = SESSION.query(Welcome).get(str(chat_id))
ret = DEFAULT_GOODBYE
if welcome_settings and welcome_settings.custom_leave:
ret = welcome_settings.custom_leave
SESSION.close()
return ret
def chat_should_report(chat_id: Union[str, int]) -> bool:
try:
chat_setting = SESSION.query(ReportingChatSettings).get(str(chat_id))
if chat_setting:
return chat_setting.should_report
return False
finally:
SESSION.close()
def get_clean_pref(chat_id):
welc = SESSION.query(Welcome).get(str(chat_id))
SESSION.close()
if welc:
return welc.clean_welcome
return False
def get_gdbye_pref(chat_id):
welc = SESSION.query(Welcome).get(str(chat_id))
SESSION.close()
if welc:
return welc.should_goodbye, welc.custom_leave, welc.leave_type
else:
# Welcome by default.
return True, DEFAULT_GOODBYE, Types.TEXT
def get_welc_mutes_pref(chat_id):
welcomemutes = SESSION.query(WelcomeMute).get(str(chat_id))
SESSION.close()
if welcomemutes:
return welcomemutes.welcomemutes
return False
def welcome_mutes(chat_id):
try:
welcomemutes = SESSION.query(WelcomeMute).get(str(chat_id))
if welcomemutes:
return welcomemutes.welcomemutes
return False
finally:
SESSION.close()
def user_should_report(user_id: int) -> bool:
try:
user_setting = SESSION.query(ReportingUserSettings).get(user_id)
if user_setting:
return user_setting.should_report
return True
finally:
SESSION.close()
def get_rules(chat_id):
rules = SESSION.query(Rules).get(str(chat_id))
ret = ""
if rules:
ret = rules.rules
SESSION.close()
return ret
def get_custom_welcome(chat_id):
welcome_settings = SESSION.query(Welcome).get(str(chat_id))
ret = DEFAULT_WELCOME
if welcome_settings and welcome_settings.custom_welcome:
ret = welcome_settings.custom_welcome
SESSION.close()
return ret
def __load_gban_stat_list():
global GBANSTAT_LIST
try:
GBANSTAT_LIST = {
x.chat_id for x in SESSION.query(GbanSettings).all() if not x.setting
}
finally:
SESSION.close()
def rem_chat(chat_id):
with INSERTION_LOCK:
chat = SESSION.query(Chats).get(str(chat_id))
if chat:
SESSION.delete(chat)
SESSION.commit()
else:
SESSION.close()
def __load_all_dynasties_settings():
global DYNASTY_NOTIFICATION
try:
getuser = SESSION.query(DynastyUserSettings).all()
for x in getuser:
DYNASTY_NOTIFICATION[str(x.user_id)] = x.should_report
finally:
SESSION.close()
def is_chat(chat_id):
try:
chat = SESSION.query(ChatbotChats).get(str(chat_id))
if chat:
return True
else:
return False
finally:
SESSION.close()
def get_welc_pref(chat_id):
welc = SESSION.query(Welcome).get(str(chat_id))
SESSION.close()
if welc:
return welc.should_welcome, welc.custom_welcome, welc.custom_content, welc.welcome_type
else:
# Welcome by default.
return True, DEFAULT_WELCOME, None, Types.TEXT
def get_warn_setting(chat_id):
try:
setting = SESSION.query(WarnSettings).get(str(chat_id))
if setting:
return setting.warn_limit, setting.soft_warn
else:
return 3, False
finally:
SESSION.close()
