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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/97da392f-06d3-a816-3eaf-e45d678011ef%40bl.echidna.id.au.
