Re: [sqlalchemy] is this intentional or a bug with subquery join

2018-04-03 Thread Jonathan Vanasco
On Tuesday, April 3, 2018 at 10:34:03 PM UTC-4, Mike Bayer wrote: > > "does not work" ? wow, i am an awful person. sorry. that is the least helpful description of what happens i can think of. second try: if the subquery is the 1st element, the select compiles correctly and gives me the cor

Re: [sqlalchemy] is this intentional or a bug with subquery join

2018-04-03 Thread Mike Bayer
"does not work" ? On Tue, Apr 3, 2018 at 6:43 PM, Jonathan Vanasco wrote: > I couldn't find docs on this behavior, so wanted to ask before filing a > ticket with a test-case. If this isn't the expected behavior, I'll generate > a SSCCE. I think it might be expected though. > > I have a form of

[sqlalchemy] is this intentional or a bug with subquery join

2018-04-03 Thread Jonathan Vanasco
I couldn't find docs on this behavior, so wanted to ask before filing a ticket with a test-case. If this isn't the expected behavior, I'll generate a SSCCE. I think it might be expected though. I have a form of a query that uses an ORM object joined against a subquery It works when the subque

Re: [sqlalchemy] How to create multiple TABLES and INSERTS programatically ?

2018-04-03 Thread Peter Lai
I wonder if one can also do this with Declarative Base classes using `type` construction? Like, to dynamically create a Declarative Class from some pre-defined namespace dicts: Base = declarative_base() metas = [{'__tablename__': 'footable'}, ...] columns = [{ 'key': 'field1', 'type': Text}, .

Re: [sqlalchemy] dispose/close question

2018-04-03 Thread Jonathan Vanasco
On Tuesday, April 3, 2018 at 11:41:43 AM UTC-4, Mike Bayer wrote: > > right, the dispose() will emit "close connection" commands on the > socket which will leak into the parent process. > But only if `close()` has been called -- right? > they're not ! :) that's one of the "features" of Qu

[sqlalchemy] SQLAlchemy Dialect for Caché Monitor Database

2018-04-03 Thread Maki
Hi There, Are there any developer out here that could maybe develope a dialect for the Caché Monitor (https://www.cachemonitor.de/)? I wanted to start to do it but my python skills arent there yet, I just started to learn python and i think this is a lil bit too much to start as my first projec

Re: [sqlalchemy] dispose/close question

2018-04-03 Thread Mike Bayer
On Mon, Apr 2, 2018 at 10:19 PM, Jonathan Vanasco wrote: > looking at the current `engine.dispose()` (which I should have done sooner), > that's pretty much what it's doing -- right? > > https://bitbucket.org/zzzeek/sqlalchemy/src/55371f4cffa730f65f1b687e9f6287d2ac189227/lib/sqlalchemy/engine/base

Re: [sqlalchemy] joined load inheritance with extra joins.. possible?

2018-04-03 Thread Mike Bayer
the polymoprhic_load=inline is mostly a typing saver in 1.2, you can get that same effect by putting a with_polymorphic on the base mapper in previous versions. On Tue, Apr 3, 2018 at 10:17 AM, Julien Cigar wrote: > On Tue, Apr 03, 2018 at 10:05:22AM -0400, Mike Bayer wrote: >> On Tue, Apr 3, 201

Re: [sqlalchemy] joined load inheritance with extra joins.. possible?

2018-04-03 Thread Julien Cigar
On Tue, Apr 03, 2018 at 10:05:22AM -0400, Mike Bayer wrote: > On Tue, Apr 3, 2018 at 9:59 AM, Julien Cigar wrote: > > On Tue, Apr 03, 2018 at 12:20:53PM +0200, Julien Cigar wrote: > >> On Thu, Mar 22, 2018 at 10:58:56AM +0100, Julien Cigar wrote: > >> > On Tue, Mar 20, 2018 at 08:32:14PM -0400, Mi

Re: [sqlalchemy] joined load inheritance with extra joins.. possible?

2018-04-03 Thread Mike Bayer
On Tue, Apr 3, 2018 at 9:59 AM, Julien Cigar wrote: > On Tue, Apr 03, 2018 at 12:20:53PM +0200, Julien Cigar wrote: >> On Thu, Mar 22, 2018 at 10:58:56AM +0100, Julien Cigar wrote: >> > On Tue, Mar 20, 2018 at 08:32:14PM -0400, Mike Bayer wrote: >> > > I think it would be a lot easier to have the

Re: [sqlalchemy] joined load inheritance with extra joins.. possible?

2018-04-03 Thread Julien Cigar
On Tue, Apr 03, 2018 at 12:20:53PM +0200, Julien Cigar wrote: > On Thu, Mar 22, 2018 at 10:58:56AM +0100, Julien Cigar wrote: > > On Tue, Mar 20, 2018 at 08:32:14PM -0400, Mike Bayer wrote: > > > I think it would be a lot easier to have the corresponding translation > > > linked off using relations

Re: [sqlalchemy] joined load inheritance with extra joins.. possible?

2018-04-03 Thread Mike Bayer
On Tue, Apr 3, 2018 at 6:20 AM, Julien Cigar wrote: > On Thu, Mar 22, 2018 at 10:58:56AM +0100, Julien Cigar wrote: >> On Tue, Mar 20, 2018 at 08:32:14PM -0400, Mike Bayer wrote: >> > I think it would be a lot easier to have the corresponding translation >> > linked off using relationship(). can

Re: [sqlalchemy] joined load inheritance with extra joins.. possible?

2018-04-03 Thread Julien Cigar
On Thu, Mar 22, 2018 at 10:58:56AM +0100, Julien Cigar wrote: > On Tue, Mar 20, 2018 at 08:32:14PM -0400, Mike Bayer wrote: > > I think it would be a lot easier to have the corresponding translation > > linked off using relationship(). can you work with that? > Hello Mike, I tried with relatio