def num_chats():
try:
return SESSION.query(func.count(distinct(Rules.chat_id))).scalar()
finally:
SESSION.close()
def get_all_chat_notes(chat_id):
try:
return (SESSION.query(Notes).filter(
Notes.chat_id == str(chat_id)).order_by(Notes.name.asc()).all())
finally:
SESSION.close()
def num_warn_filter_chats():
try:
return SESSION.query(func.count(distinct(
WarnFilters.chat_id))).scalar()
finally:
SESSION.close()
def get_all_chat_id():
stark = SESSION.query(Nightmode).all()
SESSION.close()
return stark
def num_warn_chat_filters(chat_id):
try:
return (SESSION.query(WarnFilters.chat_id).filter(
WarnFilters.chat_id == str(chat_id)).count())
finally:
SESSION.close()
def num_warn_filters():
try:
return SESSION.query(WarnFilters).count()
finally:
SESSION.close()
def num_warns():
try:
return SESSION.query(func.sum(Warns.num_warns)).scalar() or 0
finally:
SESSION.close()
def get_warn_filter(chat_id, keyword):
try:
return SESSION.query(WarnFilters).get((str(chat_id), keyword))
finally:
SESSION.close()
def get_chat_warn_filters(chat_id):
try:
return (SESSION.query(WarnFilters).filter(
WarnFilters.chat_id == str(chat_id)).all())
finally:
SESSION.close()
