Re: [openstack-dev] [Neutron] need help in translating sql query to sqlalchemy query

[Venkata Anil]

On 12/01/2015 09:06 PM, Sean M. Collins wrote:

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"

Thanks Sean. Sure, I will try that suggestion.



__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev