Python SESSION.query Examples

Example #1

File: users_sql.py Project: farihyuta/Kaga

def get_name_by_userid(user_id):
    try:
        return SESSION.query(Users).get(Users.user_id == int(user_id)).first()
    finally:
        SESSION.close()

Example #2

def get_connected_chat(user_id):
    try:
        return SESSION.query(Connection).get((int(user_id)))
    finally:
        SESSION.close()

Example #3

File: users_sql.py Project: farihyuta/Kaga

def get_userid_by_name(username):
    try:
        return SESSION.query(Users).filter(
            func.lower(Users.username) == username.lower()).all()
    finally:
        SESSION.close()

Example #4

def get_locks(chat_id):
    try:
        return SESSION.query(Permissions).get(str(chat_id))
    finally:
        SESSION.close()

Example #5

def curr_connection(chat_id):
    try:
        return SESSION.query(Connection).get((str(chat_id)))
    finally:
        SESSION.close()

Example #6

File: users_sql.py Project: farihyuta/Kaga

def get_all_users():
    try:
        return SESSION.query(Users).all()
    finally:
        SESSION.close()

Example #7

File: users_sql.py Project: farihyuta/Kaga

def num_chats():
    try:
        return SESSION.query(Chats).count()
    finally:
        SESSION.close()

Example #8

File: cust_filters_sql.py Project: sandidias/KagaRobot

def num_filters():
    try:
        return SESSION.query(CustomFilters).count()
    finally:
        SESSION.close()

Example #9

File: warns_sql.py Project: farihyuta/Kaga

def get_warn_filter(chat_id, keyword):
    try:
        return SESSION.query(WarnFilters).get((str(chat_id), keyword))
    finally:
        SESSION.close()

Example #10

File: cust_filters_sql.py Project: farihyuta/Kaga

def num_chats():
    try:
        return SESSION.query(func.count(distinct(
            CustomFilters.chat_id))).scalar()
    finally:
        SESSION.close()

Example #11

File: cust_filters_sql.py Project: sandidias/KagaRobot

def get_all_filters():
    try:
        return SESSION.query(CustomFilters).all()
    finally:
        SESSION.close()

Example #12

File: log_channel_sql.py Project: farihyuta/Kaga

def num_logchannels():
    try:
        return SESSION.query(func.count(distinct(GroupLogs.chat_id))).scalar()
    finally:
        SESSION.close()

Example #13

def num_notes():
    try:
        return SESSION.query(Notes).count()
    finally:
        SESSION.close()

Example #14

def get_restr(chat_id):
    try:
        return SESSION.query(Restrictions).get(str(chat_id))
    finally:
        SESSION.close()

Example #15

File: users_sql.py Project: farihyuta/Kaga

def get_chat_members(chat_id):
    try:
        return SESSION.query(ChatMembers).filter(
            ChatMembers.chat == str(chat_id)).all()
    finally:
        SESSION.close()

Example #16

File: warns_sql.py Project: farihyuta/Kaga

def num_warns():
    try:
        return SESSION.query(func.sum(Warns.num_warns)).scalar() or 0
    finally:
        SESSION.close()

Example #17

File: users_sql.py Project: farihyuta/Kaga

def get_all_chats():
    try:
        return SESSION.query(Chats).all()
    finally:
        SESSION.close()

Example #18

File: warns_sql.py Project: farihyuta/Kaga

def num_warn_chats():
    try:
        return SESSION.query(func.count(distinct(Warns.chat_id))).scalar()
    finally:
        SESSION.close()

Example #19

File: users_sql.py Project: farihyuta/Kaga

def get_user_num_chats(user_id):
    try:
        return SESSION.query(ChatMembers).filter(
            ChatMembers.user == int(user_id)).count()
    finally:
        SESSION.close()

Example #20

File: warns_sql.py Project: farihyuta/Kaga

def num_warn_filters():
    try:
        return SESSION.query(WarnFilters).count()
    finally:
        SESSION.close()

Example #21

File: users_sql.py Project: farihyuta/Kaga

def num_users():
    try:
        return SESSION.query(Users).count()
    finally:
        SESSION.close()

Example #22

def num_disabled():
    try:
        return SESSION.query(Disable).count()
    finally:
        SESSION.close()