Python SESSION.commit Examples

Example #1

def unmute(chat_id, sender):
    rem = (SESSION.query(Mute).filter(Mute.chat_id == str(chat_id),
                                      Mute.sender == str(sender)).all())
    if len(rem):
        for item in rem:
            SESSION.delete(item)
            SESSION.commit()

Example #2

File: blacklist_sql.py Project: lucifeermorningstar/skemarmy

def add_to_blacklist(chat_id, trigger):
    with BLACKLIST_FILTER_INSERTION_LOCK:
        blacklist_filt = BlackListFilters(str(chat_id), trigger)

        SESSION.merge(blacklist_filt)  # merge to avoid duplicate key issues
        SESSION.commit()
        CHAT_BLACKLISTS.setdefault(str(chat_id), set()).add(trigger)

Example #3

File: keep_read_sql.py Project: lucifeermorningstar/skemarmy

def unkread(chat):
    rem = SESSION.query(KRead).get((str(chat)))
    if rem:
        SESSION.delete(rem)
        SESSION.commit()
        return True
    return False

Example #4

File: keep_read_sql.py Project: lucifeermorningstar/skemarmy

def kread(chat):
    if SESSION.query(KRead).get((str(chat))):
        return False
    adder = KRead(str(chat))
    SESSION.add(adder)
    SESSION.commit()
    return True

Example #5

def rm_note(chat_id, keyword):
    to_check = get_note(chat_id, keyword)
    if not to_check:
        return False
    else:
        SESSION.delete(to_check)
        SESSION.commit()
        return True

Example #6

File: snips_sql.py Project: lucifeermorningstar/skemarmy

def remove_snip(keyword):
    to_check = get_snip(keyword)
    if not to_check:
        return False
    else:
        SESSION.delete(to_check)
        SESSION.commit()
        return True

Example #7

File: blacklist_sql.py Project: lucifeermorningstar/skemarmy

def rm_from_blacklist(chat_id, trigger):
    with BLACKLIST_FILTER_INSERTION_LOCK:
        blacklist_filt = SESSION.query(BlackListFilters).get(
            (str(chat_id), trigger))
        if blacklist_filt:
            # sanity check
            if trigger in CHAT_BLACKLISTS.get(str(chat_id), set()):
                CHAT_BLACKLISTS.get(str(chat_id), set()).remove(trigger)

            SESSION.delete(blacklist_filt)
            SESSION.commit()
            return True

        SESSION.close()
        return False

Example #8

def add_note(chat_id, keyword, reply, f_mesg_id):
    to_check = get_note(chat_id, keyword)
    if not to_check:
        adder = Notes(str(chat_id), keyword, reply, f_mesg_id)
        SESSION.add(adder)
        SESSION.commit()
        return True
    else:
        rem = SESSION.query(Notes).get((str(chat_id), keyword))
        SESSION.delete(rem)
        SESSION.commit()
        adder = Notes(str(chat_id), keyword, reply, f_mesg_id)
        SESSION.add(adder)
        SESSION.commit()
        return False

Example #9

File: snips_sql.py Project: lucifeermorningstar/skemarmy

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)
        rem.delete()
        SESSION.commit()
        adder = Snips(keyword, reply, f_mesg_id)
        SESSION.add(adder)
        SESSION.commit()
        return False

Example #10

File: pm_permit_sql.py Project: lucifeermorningstar/skemarmy

def dissprove(chat_id):
    rem = SESSION.query(PMPermit).get(str(chat_id))
    if rem:
        SESSION.delete(rem)
        SESSION.commit()

Example #11

File: pm_permit_sql.py Project: lucifeermorningstar/skemarmy

def approve(chat_id):
    adder = PMPermit(str(chat_id))
    SESSION.add(adder)
    SESSION.commit()

Example #12

def mute(chat_id, sender):
    adder = Mute(str(chat_id), str(sender))
    SESSION.add(adder)
    SESSION.commit()

Example #13

File: gmute_sql.py Project: lucifeermorningstar/skemarmy

def ungmute(sender):
    rem = SESSION.query(GMute).get((str(sender)))
    if rem:
        SESSION.delete(rem)
        SESSION.commit()

Example #14

File: gmute_sql.py Project: lucifeermorningstar/skemarmy

def gmute(sender):
    adder = GMute(str(sender))
    SESSION.add(adder)
    SESSION.commit()

Example #15

File: gban_sql.py Project: lucifeermorningstar/skemarmy

def ungban(sender):
    rem = SESSION.query(GBan).get((str(sender)))
    if rem:
        SESSION.delete(rem)
        SESSION.commit()

Example #16

File: gban_sql.py Project: lucifeermorningstar/skemarmy

def gban(sender):
    adder = GBan(str(sender))
    SESSION.add(adder)
    SESSION.commit()