[sqlalchemy] Updates with GROUP BY and subquery

I'm trying to recreate the following SQL in SQLAlchemy: update ignore abms_biog a join (select a.id, u.id as user_id from abms_biog a join 3md.users u on u.firstname = a.firstname and u.lastname = a.lastname and 3md.non_conflict_middlename(u.middlename, a.middlename)=1 and u.credentials in

[sqlalchemy] Stumped on bulk update with joins and GROUP BY. Any takers?

I'm trying to recreate the following SQL in SQLAlchemy: update ignore abms_biog_%s a join (select a.id, u.id as user_id from abms_biog_%s a join 3md.users u on u.firstname = a.firstname and u.lastname = a.lastname and 3md.non_conflict_middlename(u.middlename, a.middlename)=1 and u.credentials

Re: [sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

Thanks for your help, Mike! Douglas On Thu, 11 Aug 2016 at 17:14 Mike Bayer wrote: > > > On 08/11/2016 03:35 PM, Douglas Russell wrote: > > Of course! That makes sense. > > > > Does SQLAlchemy just discard the subqueryload chain parts that are on > > the wrong type?

Re: [sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

On 08/11/2016 03:35 PM, Douglas Russell wrote: Of course! That makes sense. Does SQLAlchemy just discard the subqueryload chain parts that are on the wrong type? It didn't seem to generate any SQL for those when they were wrong. it validates the path as far as classes / attributes, but I

Re: [sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

Of course! That makes sense. Does SQLAlchemy just discard the subqueryload chain parts that are on the wrong type? It didn't seem to generate any SQL for those when they were wrong. An example of this in the docs would be a great idea I think as I think it's pretty tough to explain this in

Re: [sqlalchemy] Joining tables across schema in PostgreSQL

On 08/11/2016 01:24 PM, Demitri Muna wrote: Hi Mike, It looks like my Base class was not exactly the same (although it was in my original code), but this is not the problem. I didn't think it was, but it's very difficult for me to be helpful when I only get various out of context lines of

Re: [sqlalchemy] Joining tables across schema in PostgreSQL

Hi Mike, It looks like my Base class was not exactly the same (although it was in my original code), but this is not the problem. I have a custom "DatabaseConnection" Python class that is a singleton and encapsulates the database connection. It's constructed like this: me.engine =

Re: [sqlalchemy] Tracking instance commit status

On 08/11/2016 03:30 AM, Wibowo Arindrarto wrote: Dear all, I have a little problem with getting object states that have been flushed but not committed. As far as I understand, SQLAlchemy does not have an official object state corresponding to this. The Session is intended to only be working

Re: [sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

On 08/11/2016 09:53 AM, Douglas Russell wrote: of_type was what I was searching for. Thanks. Unfortunately, it did not yield the desired results when I extended the hierarchy to 3 levels (C->C2 with a relation between B and C). I've updated the Gist. B+B2 is successfully queried, but C+C2

[sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

of_type was what I was searching for. Thanks. Unfortunately, it did not yield the desired results when I extended the hierarchy to 3 levels (C->C2 with a relation between B and C). I've updated the Gist. B+B2 is successfully queried, but C+C2 is not. This will then result in lazily generated

Re: [sqlalchemy] Tracking instance commit status

Hi Simon, The purpose was to flag those contained objects. These objects are created by the application's users (both container and contained). The user can either create the contained objects manually and let the application infer the container, or they can also create the containers manually.

Re: [sqlalchemy] Tracking instance commit status

On Thu, Aug 11, 2016 at 8:30 AM, Wibowo Arindrarto wrote: > Dear all, > > I have a little problem with getting object states that have been flushed > but not committed. As far as I understand, SQLAlchemy does not have an > official object state corresponding to this.

[sqlalchemy] Querying a dict collection by key/value pair

Hi, first of all, thanks for SQLAlchemy - it's the one project that actually made me enjoy working with large data collections in applications ;)! I have an SQLAlchemy model that associates tags (key/value pairs) with elements, like in attached mwe.py. Element.tags is a dictionary

[sqlalchemy] Tracking instance commit status

Dear all, I have a little problem with getting object states that have been flushed but not committed. As far as I understand, SQLAlchemy does not have an official object state corresponding to this. However, in my application I need to track such objects. My current approach is to listen to