Re: [sqlalchemy] How to use load_only or with_entities with relationships

2019-01-08 Thread Mike Bayer
every case is now listed out for improved error reporting in: https://github.com/sqlalchemy/sqlalchemy/issues/4433 On Wed, Jan 9, 2019 at 12:21 AM Mike Bayer wrote: > > On Tue, Jan 8, 2019 at 4:16 PM Gmoney wrote: > > > > Unable to limit the columns returned from a query using .load_only or

Re: [sqlalchemy] How to use load_only or with_entities with relationships

2019-01-08 Thread Mike Bayer
On Tue, Jan 8, 2019 at 4:16 PM Gmoney wrote: > > Unable to limit the columns returned from a query using .load_only or > .with_entities. I feel like I'm missing a key concept here, and could use > some guidance. > > One column of interest is a relationship - which I'm guessing is my problem. >

Re: [sqlalchemy] Can't add unnamed column to column collection when defining UniqueConstraint

2019-01-08 Thread Riccardo Magliocchetti
Hello Mike, Il 08/01/19 19:00, Mike Bayer ha scritto: On Tue, Jan 8, 2019 at 12:40 PM Riccardo Magliocchetti wrote: Hello, I'd like to implement soft delete so I have to take into account when creating constraints the softdelete boolean column. The trick i want to implement is to get null

[sqlalchemy] How to use load_only or with_entities with relationships

2019-01-08 Thread Gmoney
Unable to limit the columns returned from a query using .load_only or .with_entities. I feel like I'm missing a key concept here, and could use some guidance. One column of interest is a relationship - which I'm guessing is my problem. class Task(Base): __tablename__ = 'TASK' id =

Re: [sqlalchemy] Can't add unnamed column to column collection when defining UniqueConstraint

2019-01-08 Thread Mike Bayer
On Tue, Jan 8, 2019 at 12:40 PM Riccardo Magliocchetti wrote: > > Hello, > > I'd like to implement soft delete so I have to take into account when > creating constraints > the softdelete boolean column. The trick i want to implement is to get null > for the column > when the row is supposed to

Re: [sqlalchemy] Re: Announcing SQLAlchemy Dialect for Apache Drill

2019-01-08 Thread Charles Givre
Lol. Thanks! Mike sent me an email saying the same thing. I’ll submit the PR later this afternoon. > On Jan 8, 2019, at 12:46, Jonathan Vanasco wrote: > > > The best way to handle this would be issuing a PR which lists your dialect > against this file: > > >

[sqlalchemy] Re: Announcing SQLAlchemy Dialect for Apache Drill

2019-01-08 Thread Jonathan Vanasco
The best way to handle this would be issuing a PR which lists your dialect against this file: https://github.com/sqlalchemy/sqlalchemy/blob/master/doc/build/dialects/index.rst That is used to build the online documentation for the .org; also Mike is more likely to approve a simple PR

Re: [sqlalchemy] Announcing SQLAlchemy Dialect for Apache Drill

2019-01-08 Thread Mike Bayer
On Tue, Jan 8, 2019 at 9:50 AM Charles Givre wrote: > > All, > John Omernik and I (mainly John) have been working on an SQLAlchemy dialect > for Apache Drill. Our main goal is to get Drill to work with Apache > Superset, but I'm sure it will have other uses. Anyway, I'd like to ask if > the

[sqlalchemy] Can't add unnamed column to column collection when defining UniqueConstraint

2019-01-08 Thread Riccardo Magliocchetti
Hello, I'd like to implement soft delete so I have to take into account when creating constraints the softdelete boolean column. The trick i want to implement is to get null for the column when the row is supposed to be deleted. When creating the index by hand in SQL it works just nice but in

[sqlalchemy] Announcing SQLAlchemy Dialect for Apache Drill

2019-01-08 Thread Charles Givre
All, John Omernik and I (mainly John) have been working on an SQLAlchemy dialect for Apache Drill. Our main goal is to get Drill to work with Apache Superset, but I'm sure it will have other uses. Anyway, I'd like to ask if the dialect could be included in the SQLAlchemy Docs in the list of