All pastes #568714 Raw Edit

Unnamed

public python v1 · immutable
·published 2007-06-15 17:43 UTC
rendered paste body
def auth_step3(user, now, called):    session = sa.create_session()    assert user.enabled and not user.deleted    query = session.query(DESTINY).select(        sa.and_(            UserDestiny.c.id_user == user.id,            UserDestiny.c.id_node == DESTINY.c.id,                        DESTINY.c.enabled == True,            DESTINY.c.deleted == False            )        )        query2 = session.query(DESTINY).select(        sa.and_(                Group.c.id_user == user.id,                Group.c.id_node == DESTINY.c.id,                Group.c.enabled == True,                Group.c.deleted == False                )        )       all_nodes = sorted(list(set(query).union(set(query2))),                lambda x, y: y.priority - x.priority)    print "@" * 15    assert len(all_nodes) > 0    node = all_nodes[0]            query = session.query(RwDestiny).select(        sa.and_(            RwDestiny.c.id_node = node.id,            RwDestiny.c.enabled = True,            RwDestiny.c.deleted = False,        ), order_by=[sa.desc(sa.fun.length(RwDestiny.c.matching))]    )    assert len(query) > 0    rewrites = query        query = session.query(DESTINY_RULE_PRICE).select(          sa.and_(            DestinyRulePrice.c.id_node == node.id,            DestinyRulePrice.c.id_nrp == DESTINY_RULE_PRICE.c.id,            DESTINY_RULE_PRICE.c.begin <= now,            DESTINY_RULE_PRICE.c.end >= now,            DESTINY_RULE_PRICE.c.enabled == True,            DESTINY_RULE_PRICE.c.deleted == False        ), order_by=[sa.desc(DESTINY_RULE_PRICE.c.priority)])    assert len(query) > 0            rule = query[0]                query = session.query(DESTINY_ROUTE).select(        sa.and_(            DestinyRoute.c.id_nrp == rule.id,            DestinyRoute.c.id_route == DESTINY_ROUTE.c.id,            DESTINY_ROUTE.c.enabled == True,            DESTINY_ROUTE.c.deleted == False,            ), order_br=[sa.desc(sa.func.length(DESTINY_ROUTE.c.destiny_prefix))])    assert len(query) > 0    route = query[0]        return node, rule, route, rewrites