Re: [sqlalchemy] SQLAlchemy array aggregate of objects

2020-11-05 Thread Mike Bayer
I think what's important here is to come up with the exact SQL string you'd like to create first, then if you can share that here we can show you how SQLAlchemy can render it from the expression language.As far as working with the PG functions someone else here might know or you can try

Re: Example of inline autogenerated use?

2020-11-05 Thread Mike Bayer
Not quite given in an example, I guess I could add as a recipe but then people will be using it which as you've noted isn't reliable in the general sense, let's put together how to get the MigrationScript, which it looks like you have, with then how to make the Operations object

[sqlalchemy] SQLAlchemy array aggregate of objects

2020-11-05 Thread Wojtek K
Hi All, I'm trying to find the solution but with no success I have 2 tables related through assoc table table a id |name| -|| 1|example | assoc id |a_id | b_id | -|-|--| 1|1|1 | 2|1|2 | table b id |name | -|-| 1

[sqlalchemy] SALAlchemy array aggregation of objects

2020-11-05 Thread Wojtek K
Hi All, I'm trying to find the solution but with no success I have 2 tables related table a id |name| -|| 1|example | assoc id |a_id | b_id | -|-|--| 1|1|1 | 2|1|2 | table b id |name | -|-| 1|example1 | 2

[sqlalchemy] SQLAlchemy object aggregation

2020-11-05 Thread Wojtek K
Hi All, I'm trying to find the solution but with no success I have 2 tables related table a id |name| -|| 1|example | assoc id |a_id | b_id | -|-|--| 1|1|1 | 2|1|2 | table b id |name | -|-| 1|example1 | 2