Python SESSION示例

示例#1

def filter_list(chat_id):
    try:
        return SESSION.query(Filters).filter(
            Filters.chat_id == str(chat_id)).order_by(
                Filters.name.asc()).all()
    finally:
        SESSION.close()

示例#2

文件： anti_ubot.py 项目： annihilatorrrr/Mayuri

def antiubot_list(chat_id):
    try:
        return SESSION.query(AntiUbot).filter(
            AntiUbot.chat_id == str(chat_id)).order_by(
                AntiUbot.command.asc()).all()
    finally:
        SESSION.close()

示例#3

文件： disableable.py 项目： annihilatorrrr/Mayuri

def add_to_disableable(chat_id, command):
    with DISABLEABLE_INSERTION_LOCK:

        disableable_filt = DisableAble(chat_id, command)

        SESSION.merge(disableable_filt)
        SESSION.commit()

示例#4

文件： disableable.py 项目： annihilatorrrr/Mayuri

def get_disabled(chat_id):
    try:
        return SESSION.query(DisableAble).filter(
            DisableAble.chat_id == str(chat_id)).order_by(
                DisableAble.command.asc()).all()
    finally:
        SESSION.close()

示例#5

def add_to_gmute(user_id,reason):
	with CHAT_INSERTION_LOCK:
		prev = SESSION.query(Gmute).get(user_id)
		if prev:
			SESSION.delete(prev)
			SESSION.commit()

		gban_filt = Gmute(user_id,reason)
		SESSION.merge(gban_filt)
		SESSION.commit()

示例#6

def add_to_sudo(user_id):
	with SUDO_INSERTION_LOCK:
		prev = SESSION.query(Sudo).get(user_id)
		if prev:
			SESSION.delete(prev)
			SESSION.commit()

		gban_filt = Sudo(user_id)
		SESSION.merge(gban_filt)
		SESSION.commit()

示例#7

文件： blacklist.py 项目： annihilatorrrr/Mayuri

def add_to_blacklist(chat_id,trigger,mode,time):
	with BLACKLIST_INSERTION_LOCK:
		prev = SESSION.query(Blacklist).get((str(chat_id), trigger))
		if prev:
			SESSION.delete(prev)
			SESSION.commit()

		blacklist_filt = Blacklist(chat_id,trigger,mode,time)

		SESSION.merge(blacklist_filt)
		SESSION.commit()

示例#8

文件： anti_ubot.py 项目： annihilatorrrr/Mayuri

def add_to_antiubot(chat_id, command, mode, time):
    with ANTIUBOT_INSERTION_LOCK:
        prev = SESSION.query(AntiUbot).get((str(chat_id), command))
        if prev:
            SESSION.delete(prev)
            SESSION.commit()

        antiubot_filt = AntiUbot(chat_id, command, mode, time)

        SESSION.merge(antiubot_filt)
        SESSION.commit()

示例#9

def add_to_filter(chat_id, name, value, document, filter_type, document_type):
    with FILTERS_INSERTION_LOCK:
        prev = SESSION.query(Filters).get((str(chat_id), name))
        if prev:
            SESSION.delete(prev)
            SESSION.commit()

        filter_filt = Filters(chat_id, name, value, document, filter_type,
                              document_type)

        SESSION.merge(filter_filt)
        SESSION.commit()

示例#10

def rm_from_sudo(user_id):
	with SUDO_INSERTION_LOCK:
		curr = SESSION.query(Sudo).get(user_id)
		if curr:
			SESSION.delete(curr)
			SESSION.commit()
			return True

		else:
			SESSION.close()
			return False

示例#11

def rm_from_filter(chat_id, name):
    with FILTERS_INSERTION_LOCK:
        curr = SESSION.query(Filters).get((str(chat_id), name))
        if curr:
            SESSION.delete(curr)
            SESSION.commit()
            return True

        else:
            SESSION.close()
            return False

示例#12

文件： anti_ubot.py 项目： annihilatorrrr/Mayuri

def rm_from_antiubot(chat_id, command):
    with ANTIUBOT_INSERTION_LOCK:
        curr = SESSION.query(AntiUbot).get((str(chat_id), command))
        if curr:
            SESSION.delete(curr)
            SESSION.commit()
            return True

        else:
            SESSION.close()
            return False

示例#13

文件： blacklist.py 项目： annihilatorrrr/Mayuri

def rm_from_blacklist(chat_id,trigger):
	with BLACKLIST_INSERTION_LOCK:
		curr = SESSION.query(Blacklist).get((str(chat_id), trigger))
		if curr:
			SESSION.delete(curr)
			SESSION.commit()
			return True

		else:
			SESSION.close()
			return False

示例#14

文件： disableable.py 项目： annihilatorrrr/Mayuri

def rm_from_disableable(chat_id, command):
    with DISABLEABLE_INSERTION_LOCK:
        curr = SESSION.query(DisableAble).get((str(chat_id), command))
        if curr:
            SESSION.delete(curr)
            SESSION.commit()
            return True

        else:
            SESSION.close()
            return False

示例#15

def rm_from_gban(user_id):
	with CHAT_INSERTION_LOCK:
		curr = SESSION.query(Gmute).get(user_id)
		if curr:
			SESSION.delete(curr)
			SESSION.commit()
			return True

		else:
			SESSION.close()
			return False

示例#16

def check_gban(user_id):
	try:
		return SESSION.query(Gban).get(user_id)
	finally:
		SESSION.close()

示例#17

def get_chatlist():
	try:
		return SESSION.query(Chat).all()
	finally:
		SESSION.close()

示例#18

def check_chatlist(chat_id):
	try:
		return SESSION.query(Chat).get(str(chat_id))
	finally:
		SESSION.close()

示例#19

def add_to_chatlist(chat_id):
	with CHAT_INSERTION_LOCK:
		chat_filt = Chat(chat_id)
		SESSION.merge(chat_filt)
		SESSION.commit()

示例#20

def check_gmute(user_id):
	try:
		return SESSION.query(Gmute).get(user_id)
	finally:
		SESSION.close()

示例#21

文件： disableable.py 项目： annihilatorrrr/Mayuri

def check_disableable(chat_id, command):
    try:
        return SESSION.query(DisableAble).get((str(chat_id), command))
    finally:
        SESSION.close()

示例#22

文件： blacklist.py 项目： annihilatorrrr/Mayuri

def blacklist_list(chat_id):
	try:
		return SESSION.query(Blacklist).filter(Blacklist.chat_id == str(chat_id)).order_by(Blacklist.trigger.asc()).all()
	finally:
		SESSION.close()

示例#23

文件： anti_ubot.py 项目： annihilatorrrr/Mayuri

def check_antiubot(chat_id, command):
    try:
        return SESSION.query(AntiUbot).get((str(chat_id), command))
    finally:
        SESSION.close()

示例#24

def sudo_list():
	try:
		return SESSION.query(Sudo).all()
	finally:
		SESSION.close()