Пример #1
0
def addgvar(variable, value):
    if SESSION.query(Globals).filter(
            Globals.variable == str(variable)).one_or_none():
        delgvar(variable)
    adder = Globals(str(variable), value)
    SESSION.add(adder)
    SESSION.commit()
Пример #2
0
def is_gmuted(sender_id):
    try:
        return SESSION.query(GMute).all()
    except BaseException:
        return None
    finally:
        SESSION.close()
Пример #3
0
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()
Пример #4
0
def is_kread():
    try:
        return SESSION.query(KRead).all()
    except BaseException:
        return None
    finally:
        SESSION.close()
Пример #5
0
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()
Пример #6
0
def gvarstatus(variable):
    try:
        return SESSION.query(Globals).filter(
            Globals.variable == str(variable)).first().value
    except BaseException:
        return None
    finally:
        SESSION.close()
Пример #7
0
def is_approved(chat_id):
    try:
        return SESSION.query(PMPermit).filter(
            PMPermit.chat_id == str(chat_id)).one()
    except BaseException:
        return None
    finally:
        SESSION.close()
Пример #8
0
def remove_snip(keyword):
    to_check = get_snip(keyword)
    if not to_check:
        return False
    else:
        rem = SESSION.query(Snips).filter(Snips.snip == keyword)
        rem.delete()
        SESSION.commit()
        return True
Пример #9
0
def rm_welcome_setting(chat_id):
    try:
        rem = SESSION.query(Welcome).get(str(chat_id))
        if rem:
            SESSION.delete(rem)
            SESSION.commit()
            return True
    except BaseException:
        return False
Пример #10
0
def rm_note(chat_id, keyword):
    to_check = get_note(chat_id, keyword)
    if not to_check:
        return False
    else:
        rem = SESSION.query(Notes).get((str(chat_id), keyword))
        SESSION.delete(rem)
        SESSION.commit()
        return True
Пример #11
0
def remove_filter(chat_id, keyword):
    to_check = get_filter(chat_id, keyword)
    if not to_check:
        return False
    else:
        rem = SESSION.query(Filters).get((str(chat_id), keyword))
        SESSION.delete(rem)
        SESSION.commit()
        return True
Пример #12
0
def add_filter(chat_id, keyword, reply, f_mesg_id):
    to_check = get_filter(chat_id, keyword)
    if not to_check:
        adder = Filters(str(chat_id), keyword, reply, f_mesg_id)
        SESSION.add(adder)
        SESSION.commit()
        return True
    else:
        rem = SESSION.query(Filters).get((str(chat_id), keyword))
        SESSION.delete(rem)
        SESSION.commit()
        adder = Filters(str(chat_id), keyword, reply, f_mesg_id)
        SESSION.add(adder)
        SESSION.commit()
        return False
Пример #13
0
def get_filters(chat_id):
    try:
        return SESSION.query(Filters).filter(
            Filters.chat_id == str(chat_id)).all()
    finally:
        SESSION.close()
Пример #14
0
def get_filter(chat_id, keyword):
    try:
        return SESSION.query(Filters).get((str(chat_id), keyword))
    finally:
        SESSION.close()
Пример #15
0
def dissprove(chat_id):
    rem = SESSION.query(PMPermit).get(str(chat_id))
    if rem:
        SESSION.delete(rem)
        SESSION.commit()
Пример #16
0
def approve(chat_id):
    adder = PMPermit(str(chat_id))
    SESSION.add(adder)
    SESSION.commit()
Пример #17
0
def get_note(chat_id, keyword):
    try:
        return SESSION.query(Notes).get((str(chat_id), keyword))
    finally:
        SESSION.close()
Пример #18
0
def get_snips():
    try:
        return SESSION.query(Snips).all()
    finally:
        SESSION.close()
Пример #19
0
def add_phrase(resp, phrase):
    adder = QuickPhrase(str(resp), phrase)
    SESSION.add(adder)
    SESSION.commit()
Пример #20
0
def ungmute(sender):
    rem = SESSION.query(GMute).get((str(sender)))
    if rem:
        SESSION.delete(rem)
        SESSION.commit()
Пример #21
0
def gmute(sender):
    adder = GMute(str(sender))
    SESSION.add(adder)
    SESSION.commit()
Пример #22
0
def get_notes(chat_id):
    try:
        return SESSION.query(Notes).filter(Notes.chat_id == str(chat_id)).all()
    finally:
        SESSION.close()
Пример #23
0
def get_snip(keyword):
    try:
        return SESSION.query(Snips).get(keyword)
    finally:
        SESSION.close()
Пример #24
0
def add_welcome_setting(chat_id, previous_welcome, reply, f_mesg_id):
    to_check = get_welcome(chat_id)
    if not to_check:
        adder = Welcome(chat_id, previous_welcome, reply, f_mesg_id)
        SESSION.add(adder)
        SESSION.commit()
        return True
    else:
        rem = SESSION.query(Welcome).get(str(chat_id))
        SESSION.delete(rem)
        SESSION.commit()
        adder = Welcome(chat_id, previous_welcome, reply, f_mesg_id)
        SESSION.commit()
        return False
Пример #25
0
def add_snip(keyword, reply, f_mesg_id):
    to_check = get_snip(keyword)
    if not to_check:
        adder = Snips(keyword, reply, f_mesg_id)
        SESSION.add(adder)
        SESSION.commit()
        return True
    else:
        rem = SESSION.query(Snips).filter(Snips.snip == keyword)
        SESSION.delete(rem)
        SESSION.commit()
        adder = Snips(keyword, reply, f_mesg_id)
        SESSION.add(adder)
        SESSION.commit()
        return False
Пример #26
0
def update_previous_welcome(chat_id, previous_welcome):
    row = SESSION.query(Welcome).get(str(chat_id))
    row.previous_welcome = previous_welcome
    SESSION.commit()
Пример #27
0
def get_phrases(resp):
    try:
        return SESSION.query(QuickPhrase).filter(
            QuickPhrase.resp == str(resp)).all()
    finally:
        SESSION.close()
Пример #28
0
def kread(chat):
    adder = KRead(str(chat))
    SESSION.add(adder)
    SESSION.commit()
Пример #29
0
def remove_phrase(resp, phrase):
    rem = SESSION.query(QuickPhrase).get((str(resp), str(phrase)))
    if rem:
        SESSION.delete(rem)
        SESSION.commit()
Пример #30
0
def unkread(chat):
    rem = SESSION.query(KRead).get((str(chat)))
    if rem:
        SESSION.delete(rem)
        SESSION.commit()