- # res = uow.session.execute(\r
- # """\r
- # SELECT "resourceId", "parentId", "resourceTypeId",\r
- # "resourcePoolId", "oCloudId"\r
- # FROM resource\r
- # WHERE "resourceId" = :resourceId\r
- # """,\r
- # # AND "resourcePoolId" = :resourcePoolId\r
- # # dict(resourcePoolId=resourcePoolId,\r
- # dict(resourceId=resourceId),\r
- # )\r
+ # topq = uow.session.query(resource).filter(\r
+ # resource.c.resourceId == resourceId).cte('cte', recursive=True)\r
+ # bootomq = uow.session.query(resource).join(\r
+ # topq, resource.c.parentId == topq.c.resourceId)\r
+ # res = uow.session.query(topq.union(bootomq))\r
+ # print(res)\r