Re: [sqlalchemy] SQLAlchemy 1.0.12 use inner JOIN instead of LEFT OUTER JOIN

On 04/26/2016 12:22 PM, Alex Dev wrote: These two work. However I think that I cannot do that in my real query because it is a bit more complex. For the sake of simplifying my question, I reduced the query to the minimum but I realize it is now hard so see why I was using contains_eager or

Re: [sqlalchemy] SQLAlchemy 1.0.12 use inner JOIN instead of LEFT OUTER JOIN

Thank you for your quick answer Mike. Le mardi 26 avril 2016 00:28:10 UTC+2, Mike Bayer a écrit : > > > > well this usage above is wrong. You can't have contains_eager() and > joinedload() along the same paths at the same time like that. Also, > chaining joinedload() from contains_eager() is

Re: [sqlalchemy] Bug in BufferedColumnResultProxy class?

On Tue, Apr 26, 2016 at 12:18 AM, Mike Bayer wrote: > > On 04/25/2016 11:04 AM, Piotr Dobrogost wrote: >> >> Is caching using dogpile what you call "Query cache extension"? If so >> we don't use it. > > this extension: >

Re: [sqlalchemy] Declaring column NOT NULL only for specific dialect (Oracle)?

On 04/26/2016 11:19 AM, Piotr Dobrogost wrote: Questions I asked in my last post are concerned more with implementing IDENTITY for Oracle. Here the situation is not so simple and simply replacing text is not possible as "GENERATE AS IDENTITY" phrase must be placed in right order with regard to

Re: [sqlalchemy] Declaring column NOT NULL only for specific dialect (Oracle)?

On Tue, Apr 26, 2016 at 4:42 PM, Mike Bayer wrote: > > So first we'll take a breathbreathe...and we're back. The best thing > about air is that it's in most places we live and it's free. Breathing is very important indeed :) I highly recommend taking freediving

Re: [sqlalchemy] relationship joined to max() on a foreign table - help needed

On 04/26/2016 08:09 AM, Rob Fowler wrote: I have a complete example here: https://gist.github.com/mianos/42cf15928f27cc9dfde9996d2e593e78 Ideas? I am sure it's possible. At the moment I am just using a "orderby desc" on the relationship and using [0] to get the first. this example helps

[sqlalchemy] Re: relationship joined to max() on a foreign table - help needed

Michael helped me with a few similar threads recently. One of them is here: https://groups.google.com/forum/#!topic/sqlalchemy/Vw1iBXSLibI That uses a "last 5" correlated subquery, but you could modify that to be max-1 and uselist=false -- You received this message because you are subscribed

Re: [sqlalchemy] Declaring column NOT NULL only for specific dialect (Oracle)?

On 04/26/2016 06:27 AM, Piotr Dobrogost wrote: Do I see right, that using @compiles(schema.CreateColumn, 'oracle') is not good as it's being invoked too late to have access to colspec? It seems I have to override DDLCompiler.get_column_specification() and then I have to copy & paste code

Re: [sqlalchemy] Trying to create string array columns with Alembic gives "NameError: name 'String' is not defined"

On 04/26/2016 10:07 AM, Simon King wrote: Can you show us the contents of alembic/versions/dd9e391f807f_issues_is_behind.py ? just a heads up this user is likely hitting https://bitbucket.org/zzzeek/alembic/issues/85/using-postgresqlarray-unicode-breaks, where the "sa." prefix is missing

Re: Running Migrations Simulataneously

On 04/26/2016 01:22 AM, Amit Saha wrote: On Tue, Apr 26, 2016 at 12:33 PM, Mike Bayer wrote: On 04/25/2016 08:30 PM, Amit Saha wrote: Hi all, In my scenario, DB migrations (via alembic) will be run as part of the app deployment and multiple app deployments will

Re: [sqlalchemy] Trying to create string array columns with Alembic gives "NameError: name 'String' is not defined"

On Tue, Apr 26, 2016 at 1:28 PM, Duke Dougal wrote: > Hi folks, > > > Model is below plus error message below that. > > > I am trying to create some array columns using Alembic but getting errors. > > > Any help valued. > > > thanks! > > > > from sqlalchemy import Column,

[sqlalchemy] Trying to create string array columns with Alembic gives "NameError: name 'String' is not defined"

Hi folks, Model is below plus error message below that. I am trying to create some array columns using Alembic but getting errors. Any help valued. thanks! from sqlalchemy import Column, String, Integer, DateTime from serve_spec.db_global import db import datetime from time import

[sqlalchemy] relationship joined to max() on a foreign table - help needed

Can anyone help me with this interesting (to me) relationship definition in sqla. I have some already defined data, not by me, that has, for each user, a foreign table of contact numbers, where the highest contact number is the one to use. For example, users: Harry, 1081, and Bob 1082

Re: [sqlalchemy] Declaring column NOT NULL only for specific dialect (Oracle)?

On Fri, Apr 22, 2016 at 5:57 PM, Mike Bayer wrote: > > On 04/22/2016 11:51 AM, Piotr Dobrogost wrote: >> >> >Column('some_col', nullable=False, info={"oracle_not_null": False}) >> > >> >then in your @compiles recipe look for column.info >>