Re: [sqlalchemy] How to refer to columns whose names begin with a number when autoloading?

2021-04-14 Thread r...@rosenfeld.to
, entries[prefix]) > break > > > class Student(Model): > __table__ = Table("Students", metadata, autoload=True, > autoload_with=engine) > > > > > On Tue, Apr 13, 2021, at 8:48 AM, r...@rosenfeld.to wrote: > > Thanks for

Re: [sqlalchemy] How to refer to columns whose names begin with a number when autoloading?

2021-04-13 Thread r...@rosenfeld.to
Thanks for the documentation. Sorry, but I'm not certain how to apply that in my case. Since I am mapping to an existing table, how could I reference the object attribute with an illegal name in Python? Do I combine getattr with the documentation as below? class Student(Model):

Re: [sqlalchemy] How to refer to columns whose names begin with a number when autoloading?

2021-04-12 Thread r...@rosenfeld.to
Yep. That seems fine. Thanks. SQLAlchemy doesn't escape or quote the name. I checked using inspection = inspect(Student) return [c_attr.key for c_attr in inspection.mapper.column_attrs] On Monday, April 12, 2021 at 5:55:07 AM UTC-5 Richard Damon wrote: > On 4/12/21 12:29 AM, Rob