Re: [sqlalchemy] Getting a triple of related id fields

2023-06-21 Thread Mike Bayer
they are perfectly fine to use, nothing is going away with any of that, so take any amount of time to migrate them (or not). On Wed, Jun 21, 2023, at 1:58 PM, Dan Stromberg wrote: > On Tue, Jun 20, 2023 at 3:47 PM Mike Bayer > wrote: >> >> >> step 1 is stop using that silly Flask extension

Re: [sqlalchemy] Getting a triple of related id fields

2023-06-21 Thread Dan Stromberg
On Tue, Jun 20, 2023 at 3:47 PM Mike Bayer wrote: > > > step 1 is stop using that silly Flask extension that gives you > "Pipeline.query", I can't tell what it is you want to SELECT from either by > reading this query. Wow, that made things a lot easier. Is there any reason to avoid mixing

Re: [sqlalchemy] orm.column_property()

2023-06-21 Thread Mike Bayer
On Wed, Jun 21, 2023, at 5:12 AM, Julien Cigar wrote: > Hello, > > I'm trying to add a column_property to recursively load and merge some > json column. > > I have the following: > https://gist.github.com/silenius/1af1072abae5829f54584f1ea554e074 but I > cannot figure how can I replace the

[sqlalchemy] Error: Packet sequence number wrong for read replica

2023-06-21 Thread Ali Hopyar
0 We have an environment with the following libraries and versions; Python 3.8 Flask 1.0.2 Flask-SQLAlchemy 2.3.0 SQLAlchemy 1.2.10 PyMySQL 1.0.2 Normally, we run on a single RDS Mysql but because of the high load we needed to add a read

[sqlalchemy] orm.column_property()

2023-06-21 Thread Julien Cigar
Hello, I'm trying to add a column_property to recursively load and merge some json column. I have the following: https://gist.github.com/silenius/1af1072abae5829f54584f1ea554e074 but I cannot figure how can I replace the '5011' at line 11 (which is the object primary key) with the "current"