Re: [sqlalchemy] Working with an existing database, reflection and usage of ORM Declarative Mapping

2023-03-21 Thread Mike Bayer
ill clarify that para in the reflection part On Tue, Mar 21, 2023, at 11:15 AM, Pierre Massé wrote: > Thanks for this quick answer Mike! > > Obivously, I wasted way to much energy in trying to make everything work with > table reflection... :( Let's say I gained experience from it. > >

Re: [sqlalchemy] Working with an existing database, reflection and usage of ORM Declarative Mapping

2023-03-21 Thread Pierre Massé
Thanks for this quick answer Mike! Obivously, I wasted way to much energy in trying to make everything work with table reflection... :( Let's say I gained experience from it. Regarding the origin of the impression I might have gotten, I'd say I tried to read a big chunk of the docs (unified

Re: [sqlalchemy] Working with an existing database, reflection and usage of ORM Declarative Mapping

2023-03-21 Thread Mike Bayer
hi - I think things would be easier if you defined your ORM mappings/ tables without relying upon reflection. There is no such requirement that reflection is used for an existing database, you just want to have ORM table metadata that matches the schema. the ORM/table metadata does not

[sqlalchemy] Working with an existing database, reflection and usage of ORM Declarative Mapping

2023-03-21 Thread Pierre Massé
Dear all, I am quite new to ORMs and SQLAlchemy, and I have a maybe somewhat naive question set regarding how to build an application around a database. Just a few words of context (may not yield importance, but who knows): I am building a mobile app, for which the server side will be an AWS