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

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -