Python SESSION.close示例

示例#1

文件： gban_sql_helper.py 项目： LgPWNd/my-userbot

def is_gban(chat_id):
    try:
        return SESSION.query(GBan).filter(GBan.chat_id == int(chat_id)).one()
    except:
        return None
    finally:
        SESSION.close()

示例#2

文件： fban_sql_helper.py 项目： blake90/blake

def is_fban(chat_id):
    try:
        return SESSION.query(FBan).filter(FBan.chat_id == str(chat_id)).one()
    except:
        return None
    finally:
        SESSION.close()

示例#3

def is_globelmuted(sender_id):
    try:
        return SESSION.query(GLOBELMute).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#4

def gmutelist():
    try:
        return SESSION.query(GMute).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#5

文件： gmute_sql.py 项目： MhdRezza/genkkapak

def is_gmuted(_sender_id):
    try:
        return SESSION.query(GMute).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#6

def is_muted(chat_id):
    try:
        return SESSION.query(Mute).filter(Mute.chat_id == str(chat_id)).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#7

文件： snips_sql.py 项目： IlhamMansiez/-PETERCORD-

def get_all_snips():
    try:
        return SESSION.query(Snips).all()
    except:
        return None
    finally:
        SESSION.close()

示例#8

文件： lydia_sql.py 项目： apisuserbot/King-Userbot

def get_s(user_id, chat_id):
    try:
        return SESSION.query(LydiaAI).get((user_id, chat_id))
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#9

def get_current_oqwelcome_settings(chat_id):
    try:
        return SESSION.query(oqwelcome).filter(oqwelcome.chat_id == chat_id).one()
    except:
        return None
    finally:
        SESSION.close()

示例#10

文件： snips_sql.py 项目： IlhamMansiez/-PETERCORD-

def get_snips(keyword):
    try:
        return SESSION.query(Snips).get(keyword)
    except:
        return None
    finally:
        SESSION.close()

示例#11

文件： pm_permit_sql.py 项目： risawitama/WeebProject

def get_approved():
    try:
        return SESSION.query(PMPermit).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#12

def get_collectionlist_items():
    try:
        chats = SESSION.query(
            Petercord_GlobalCollection.keywoard).distinct().all()
        return [i[0] for i in chats]
    finally:
        SESSION.close()

示例#13

def num_collectionlist_items():
    try:
        return SESSION.query(
            func.count(distinct(
                Petercord_GlobalCollection.keywoard))).scalar()
    finally:
        SESSION.close()

示例#14

def is_gmuted(sender_id):
    try:
        return SESSION.query(GMute).filter(GMute.sender == str(sender_id)).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#15

def get_current_welcome_settings(chat_id):
    try:
        return SESSION.query(Welcome).filter(Welcome.chat_id == str(chat_id)).one()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#16

文件： keep_read_sql.py 项目： cemaldnzz/telegrambot

def is_kread():
    try:
        return SESSION.query(KRead).all()
    except:
        return None
    finally:
        SESSION.close()

示例#17

文件： gban_sql.py 项目： yusufusta/AsenaUserBot

def gbanlist():
    try:
        return SESSION.query(GBan).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#18

文件： lydia_sql.py 项目： apisuserbot/King-Userbot

def get_all_s():
    try:
        return SESSION.query(LydiaAI).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#19

文件： blacklist_sql.py 项目： thewhiteharlot/PurpleBot

def get_blacklist():
    try:
        return SESSION.query(Blacklist).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#20

文件： filter_sql.py 项目： IlhamMansiez/-PETERCORD-

def get_filter(chat_id, keyword):
    try:
        return SESSION.query(Filters).get((str(chat_id), keyword))
    except:
        return None
    finally:
        SESSION.close()

示例#21

文件： oqfilter_sql.py 项目： obsq/kyne3301

def get_all_oqfilters(chat_id):
    try:
        return SESSION.query(oqfilters).filter(oqfilters.chat_id == str(chat_id)).all()
    except:
        return None
    finally:
        SESSION.close()

示例#22

文件： gban_sql_helper.py 项目： Srinidhi0986/ProjectFizilion-1

def is_gbanned(chat_id):
    try:
        return SESSION.query(GBan).filter(GBan.chat_id == str(chat_id)).one()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#23

文件： bot_blacklists.py 项目： mrismanaziz/Man-Userbot

def get_all_bl_users():
    try:
        return SESSION.query(Bot_BlackList).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#24

文件： pmpermit_sql.py 项目： king-cobra-user/deviluserbot

def is_approved(chat_id):
    try:
        return SESSION.query(PMPermit).filter(PMPermit.chat_id == str(chat_id)).one()
    except:
        return None
    finally:
        SESSION.close()

示例#25

文件： echo_sql.py 项目： LUCKYRAJPUTOP/BrothersUserbot

def get_all_echos():
    try:
        return SESSION.query(ECHOSQL).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#26

文件： echo_sql.py 项目： LUCKYRAJPUTOP/BrothersUserbot

def is_echo(user_id, chat_id):
    try:
        return SESSION.query(ECHOSQL).get((str(user_id), str(chat_id)))
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#27

def get_all_starters():
    try:
        return SESSION.query(Bot_Starters).all()
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#28

def gvarstatus(variable):
    try:
        return SESSION.query(Globals).filter(
            Globals.variable == str(variable)).first().value
    except BaseException:
        return None
    finally:
        SESSION.close()

示例#29

文件： antiflood_sql.py 项目： Sadikahmed92/oubremix

def __load_flood_settings():
    global CHAT_FLOOD
    try:
        all_chats = SESSION.query(FloodControl).all()
        CHAT_FLOOD = {chat.chat_id: (None, DEF_COUNT, chat.limit) for chat in all_chats}
    finally:
        SESSION.close()
    return CHAT_FLOOD

示例#30

def get_starter_details(user_id):
    try:
        _result = SESSION.query(Bot_Starters).get(str(user_id))
        if _result:
            return _result
        return None
    finally:
        SESSION.close()