Reflecting Oracle Global Temp Tables Using Pythons SQLAlchemy -
i using sqlalchemy , want reflect table structure of global temp tables.
from sqlalchemy import metadata ... meta = metadata() meta.reflect(bind = engine, = ['tt_employees'], schema = schema)
i enable 'echo=true' when establishing connection:
db_engine = create_engine(engine.url.url(**params), echo=self._echo)
i can reflect tables except global temp tables. because of way sqlalchemy looks tables in reflect():
info sqlalchemy.engine.base.engine select table_name all_tables nvl(tablespace_name, 'no tablespace') not in ('system', 'sysaux') , owner = :owner , iot_name null , duration null
the duration of oracle global temp tables 'sys$session' why no global temp tables reflect.
version info
- sqlalchemy 1.0.4 py27_0
- oracle database 11g enterprise edition release 11.2.0.4.0 - 64bit
is there can this?
appending metadata via metadata.tables() appears work guessing there better solution:
test = [sqlalchemy.table(t, meta, autoload=true, autoload_with=_engine, schema=_schema) t in schedule.tables.values]
Comments
Post a Comment