Re: [sqlalchemy] Using CTEs inside union()

2017-02-22 Thread mike bayer
On 02/22/2017 11:25 AM, Michael Williamson wrote: On Wed, 22 Feb 2017 11:15:05 -0500 mike bayer wrote: On 02/22/2017 10:17 AM, Michael Williamson wrote: Using CTEs directly inside union() (or similar functions such as intersect()) causes an error: query_1

Re: [sqlalchemy] Using CTEs inside union()

2017-02-22 Thread Michael Williamson
On Wed, 22 Feb 2017 11:15:05 -0500 mike bayer wrote: > > > On 02/22/2017 10:17 AM, Michael Williamson wrote: > > Using CTEs directly inside union() (or similar functions such as > > intersect()) causes an error: > > > > > > query_1 = s.query(Record.id).cte() > >

Re: [sqlalchemy] Using CTEs inside union()

2017-02-22 Thread mike bayer
On 02/22/2017 10:17 AM, Michael Williamson wrote: Using CTEs directly inside union() (or similar functions such as intersect()) causes an error: query_1 = s.query(Record.id).cte() query_2 = s.query(Record.id).cte() select_from = union(query_1, query_2) what does the above

[sqlalchemy] Using CTEs inside union()

2017-02-22 Thread Michael Williamson
Using CTEs directly inside union() (or similar functions such as intersect()) causes an error: import os from sqlalchemy.event import listens_for from sqlalchemy import * from sqlalchemy.orm import * from sqlalchemy.ext.declarative import declarative_base Base =