rendered paste bodydef 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