[sqlalchemy] An Attribute Error is occurring but I am not understanding why?

2023-05-14 Thread Shashank
I've created a flask application that makes use of SQLAlchemy to store and retrieve the data, but I am facing this error. Can anybody please specify why the error might be occurring and as to how to solve it. *File "/home/ubuntu/OCR/venv/lib/python3.7/site-packages/sqlalchemy/sql/sqltypes.py",

Re: [sqlalchemy] Migration issues - Column value None on select with joins

2023-05-14 Thread Mike Bayer
thanks! On Sun, May 14, 2023, at 6:59 PM, Shane Holcombe wrote: > I've tested all the ways I could previously trigger the issue and still, no > Nones seem to even be produced to be filtered out, that fix definitely seems > to have sorted the issue out > > On Sunday, May 14, 2023 at 7:42:54 AM U

Re: [sqlalchemy] Inconsistent SQL Generation in 2.0

2023-05-14 Thread Mike Bayer
On Sun, May 14, 2023, at 12:39 PM, Benjamin Taub wrote: > Hi, Mike! > I tried your code, and it worked after I set the dialect to mysql+pymysql. > > Given this, in my case, I believe the problem stems from the fact that I am > starting with a generic SELECT call that isn't moored to a dialect.

Re: [sqlalchemy] Migration issues - Column value None on select with joins

2023-05-14 Thread Shane Holcombe
I've tested all the ways I could previously trigger the issue and still, no Nones seem to even be produced to be filtered out, that fix definitely seems to have sorted the issue out On Sunday, May 14, 2023 at 7:42:54 AM UTC+10 Shane Holcombe wrote: > Yes so I'm testing the second solution with

Re: [sqlalchemy] Inconsistent SQL Generation in 2.0

2023-05-14 Thread Benjamin Taub
Hi, Mike! I tried your code, and it worked after I set the dialect to mysql+pymysql. Given this, in my case, I believe the problem stems from the fact that I am starting with a generic SELECT call that isn't moored to a dialect. I start with *sql = select()* Which I have now changed to