Open Stack

On Tue, Dec 01, 2015 at 10:22:41AM EST, Venkata Anil wrote:
> Thanks Sean. I will check that.
> 
> Meanwhile I tried this and it is working
> 
>         port1 = orm.aliased(models_v2.Port, name="port1")
>         port2 = orm.aliased(models_v2.Port, name="port2")
>         router_intf_qry =
> context.session.query(RouterPort.router_id).join((port1,
> port1.id==RouterPort.port_id), (port2,
> port2.device_id==RouterPort.router_id)).filter(port1.network_id==int_net_id,
> port2.network_id==ext_net_id).distinct()
> 
>        for router in router_intf_qry:
>             router_id =router.router_id
> 

That looks pretty close. My only suggestion would be to try and see if
you can just alias it once, instead of twice. Basically see if it is
possible to replace all the port1 references with "models_v2.Port"

-- 
Sean M. Collins