Re: [sqlalchemy] Reflecting a postgreSQL database with extensions?

2022-08-17 Thread Carl Brewer
On 16/08/2022 11:16 pm, Mike Bayer wrote: they are safe to ignore. Thank you Mike. I'll ignore them for now. I don't need to deal with them in this bit of software, just know that they exist. Carl -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

Re: [sqlalchemy] Reflecting a postgreSQL database with extensions?

2022-08-16 Thread Mike Bayer
they are safe to ignore. they might work if you install https://geoalchemy-2.readthedocs.io/en/latest/ if they include reflection support. you can also implement an event hook where you can provide for your own logic to supply a type object (but you'd need to have stub classes for those

[sqlalchemy] Reflecting a postgreSQL database with extensions?

2022-08-15 Thread Carl Brewer
G'day, I'm trying to reflect a PostgreSQL database into the ORM that has an extension in it. Code snippet : arinc_engine = create_engine("postgresql://"+pgReadOnlyUser.name+":"+pgReadOnlyUser.passwd+"@"+PostgresServer+"/"+ARINCDB) print(arinc_engine) arinc_Base = declarative_base()