I have tried column_reflect event and couldn't skip column. Like you said. I'll have to go a bit dipper and see how do events actually work.
I tried at first to use exclude_columns but they're not acquired from kwargs in Table._init. The _autoload is called without exclude_columns argument which takes empty tuple as default https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalchemy/sql/schema.py#L484 On Thursday, December 10, 2015 at 10:57:03 AM UTC+1, mdob wrote: > > metadata = MetaData() > metadata.reflect(engine) > > Base = automap_base(metadata=metadata) > Base.prepare() > > > That did a real nice job but I wanted to skip some columns from being > mapped (binary types actually at the moment) > I see metadata.tables['TableName'].columns to be ImmutableColumnCollection > so there's probably no way to exclude column after reflect > > Is there a way to skip some columns from being reflected? > > Other option I can think of is > > insp = reflection.Inspector.from_engine(engine) > and do the mapping to declarative manually. > > Any thoughts on that? > > > > > -- 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 http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
