[sqlalchemy] Rationale for why 1.4 Core `select` argument as list is deprecated?

2021-05-12 Thread mkmo...@gmail.com
Hello, I am on Sqlalchemy 1.2 and looking to upgrade to 1.4. I have a lot of Core code that looks like this: # returns an array of columns select_fields = make_select_fields(...) sel = select(select_fields) Passing an array to select is now deprecated, so I'm planning on changing a

Re: [sqlalchemy] Re: Unique Partial Indexes throwing UniqueViolation

2021-05-12 Thread Mike Bayer
not silly at all, it's kind of an unfortunate situation w/ postgresql's naming, the name 'postgres' might be worth hardcoding somehwere as a universal "warn" kind of thing just so it doesn't skip silently On Wed, May 12, 2021, at 11:45 AM, Michael Bukachi wrote: > Typo alert. It's supposed to

[sqlalchemy] Re: Unique Partial Indexes throwing UniqueViolation

2021-05-12 Thread Michael Bukachi
Typo alert. It's supposed to be `postgresql_where`. How silly of me. On Wednesday, May 12, 2021 at 3:25:35 AM UTC+3 Michael Bukachi wrote: > > Hi > > I'm trying to setup unique partial indexes so that constraint violation is > only thrown when a a certain column is true. This is the index I'm us

Re: [sqlalchemy] MX Linux Python3 sqlalchemy hangs on ROLLBACK

2021-05-12 Thread Rob Marshall
Hi Mike, I'll see if I can separate the specific DataFrame that was causing the problem. Thanks, Rob On Tuesday, May 11, 2021 at 7:42:28 PM UTC-4 Mike Bayer wrote: > this does mean there's a bug in the mariadb driver, if you can provide a > reproducing test case > > > On Tue, May 11, 2021, a