Hi Mike,
I think I'm more perplexed than before. My search_path was correctly set. I
put a breakpoint in my code after all of my classes and relationships are
defined and after a call to configure_mappers(). I also turned "echo" on.
The output is below. There are two confusing things. "metadata.tables" is
empty, which is confusing since the code *does* insert things into the
database, so it's not completely broken. When I execute the SQL command
below by hand that generated the "sqlalchemy.exc.NoSuchTableError: server"
error below, I get zero rows if the search path is set to "public", but the
table is found if the search path includes the schema the table is in
("trillian"). I'm not sure how to proceed.
Thanks,
Demitri
ipdb> dbc.metadata.reflect()
2016-08-10 19:55:42,491 INFO sqlalchemy.engine.base.Engine SELECT relname
FROM pg_class c WHERE relkind = 'r' AND 'trillian' = (select nspname from
pg_namespace n where n.oid = c.relnamespace)
2016-08-10 19:55:42,491 INFO sqlalchemy.engine.base.Engine {}
2016-08-10 19:55:42,494 INFO sqlalchemy.engine.base.Engine
SELECT c.oid
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE (pg_catalog.pg_table_is_visible(c.oid))
AND c.relname = %(table_name)s AND c.relkind in ('r', 'v', 'm',
'f')
2016-08-10 19:55:42,494 INFO sqlalchemy.engine.base.Engine {'table_name':
'server'}
*** sqlalchemy.exc.NoSuchTableError: server
ipdb> dbc.metadata.tables
immutabledict({})
ipdb> dbc.metadata
MetaData(bind=Engine(postgresql://trillian_admin:***@localhost:5432/trilliandb))
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
