Re: [sqlalchemy] Re: Translating sql query to sqlalchemy

2019-08-25 Thread Peter Schutt
Good to hear and you're welcome:) On Monday, 26 August 2019 13:00:02 UTC+10, Ira Fuchs wrote: > > That's it. (postal_code). The ORM query now works from the iPad! Now I > need to sort things out with Python on the Mac and with MySQL server. > Having a working example like this helps as I go

Re: [sqlalchemy] Re: Translating sql query to sqlalchemy

2019-08-25 Thread Ira Fuchs
That's it. (postal_code). The ORM query now works from the iPad! Now I need to sort things out with Python on the Mac and with MySQL server. Having a working example like this helps as I go through the documentation. Thanks very much much for your patient assistance. On Sunday, August 25,

Re: [sqlalchemy] Re: Translating sql query to sqlalchemy

2019-08-25 Thread Peter Schutt
HI Ira, Again, that is an error that originates from inside the database layer and its telling you that one of the columns that you've queried on doesn't exist, which could mean a few things that will be hard for anyone to debug without access to the schema that you are trying to abstract

Re: [sqlalchemy] Re: Translating sql query to sqlalchemy

2019-08-25 Thread Ira Fuchs
Until I can get a new version of the server installed, I decided to try running this scipt on my iPad using Pythonista. The script now looks like this: from sqlalchemy import * from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import relationship from sqlalchemy.orm