include_columns is a list of strings indicating the names of those columns
which you'd like reflected. If you want to reflect all columns from the table,
leave that argument out.
On Feb 8, 2011, at 4:36 PM, Paul Rigor wrote:
> Hello,
>
> I have a table with the following schema:
>
> +-------------+---------------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +-------------+---------------+------+-----+---------+----------------+
> | acc | varchar(1024) | YES | | NULL | |
> | is_obsolete | int(11) | YES | | NULL | |
> | is_root | int(11) | YES | | NULL | |
> | term_type | varchar(1024) | YES | | NULL | |
> | id | int(11) | YES | | NULL | |
> | cid | int(11) | NO | PRI | NULL | auto_increment |
> | name | varchar(1024) | YES | | NULL | |
> +-------------+---------------+------+-----+---------+----------------+
>
>
> When attempting to run the following code to obtain column information
> programmatically...
>
> from sqlalchemy import create_engine, MetaData, Table
> from sqlalchemy.engine import reflection
> dburi = "mysql://..."
> engine = create_engine(dburi)
> meta = MetaData(dburi)
> user_table = Table('term', meta,useexisting=True)
> engine.reflecttable(user_table,include_columns=True) # More verbose error
> trace
> insp = reflection.Inspector.from_engine(engine)
> insp.reflecttable(user_table, include_columns=True)
>
>
> I get the following problem:
> python2.6/site-packages/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/reflection.pyc
> in reflecttable(self, table, include_columns)
> 383 found_table = True
> 384 name = col_d['name']
> --> 385 if include_columns and name not in include_columns:
> 386 continue
> 387
>
> TypeError: argument of type 'bool' is not iterable
>
> Is there a better way of obtaining table schemas?
>
> Thanks,
> Paul
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
