[sqlalchemy] Re: control over metadata reflect

2015-12-10 Thread mdob
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

Re: [sqlalchemy] Re: control over metadata reflect

2015-12-10 Thread Mike Bayer
On 12/10/2015 08:06 AM, mdob wrote: > I think I got it. > > | > ||metadata =MetaData() > ||insp =reflection.Inspector.from_engine(engine) > fortable_name ininsp.get_table_names(self.db_schema): > columns =[col['name']forcol > ininsp.get_columns(table_name,self.db_schema)ifnotisinstance(col['

[sqlalchemy] Re: control over metadata reflect

2015-12-10 Thread mdob
I think I got it. metadata = MetaData() insp = reflection.Inspector.from_engine(engine) for table_name in insp.get_table_names(self.db_schema): columns = [col['name'] for col in insp.get_columns(table_name, self. db_schema) if not isinstance(col['type'], IMAGE)] Table(table_name, metadata,