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 types, geoalchemy again might be the best source for that) , event hook: https://docs.sqlalchemy.org/en/14/core/events.html?highlight=column_reflect#sqlalchemy.events.DDLEvents.column_reflect (I just noticed an error in the docs - the specific-metadata association feature is working) On Mon, Aug 15, 2022, at 11:30 PM, Carl Brewer wrote: > > 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() > arinc_metadata = MetaData(arinc_engine) > arinc_metadata.reflect() > > > > > I see these warnings : > > Engine(postgresql://****:***@***.someserver.site/arinc) > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'navaid' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'dme' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'geometry' of column 'geom' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type 'spoly' > of column 'chartbounds' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'toppos' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'bottompos' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'arp' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'old_arp' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'new_arp' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'point' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'centre' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type 'spoly' > of column 'bounds' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type 'spoly' > of column 'region' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'location' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type 'sline' > of column 'route' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'spoint' of column 'waypoint' > arinc_metadata.reflect() > /apps/lib/./avsoft_data.py:53: SAWarning: Did not recognize type > 'geometry' of column 'wkb_geometry' > arinc_metadata.reflect() > > > > The extension is pgSphere - it does some nifty stuff with spherical > co-ordinates. Doesn't really matter for this task. > > If I don't care about what the data is that's been stored using this > extension, can I safely just ignore these warnings? Or, is it possible > to load the extension into SQLAlchemy somehow? > > I think I should be changing the base definition to > arinc_Base = automap_base() instead of the declarative base above, but I > don't think that makes any difference here? > > Thank you > > Carl > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy%2bunsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/97da392f-06d3-a816-3eaf-e45d678011ef%40bl.echidna.id.au. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/0638c729-3e76-4e9a-bb7e-2dc4d1720fcc%40www.fastmail.com.
