method of iterating over sqlalchemy model’s defined columns?

by

You could use the following function:

def __unicode__(self):
    return "[%s(%s)]" % (self.__class__.__name__, ', '.join('%s=%s' % (k, self.__dict__[k]) for k in sorted(self.__dict__) if '_sa_' != k[:4]))

It will exclude SA magic attributes, but will not exclude the relations. So basically it might load the dependencies, parents, children etc, which is definitely not desirable.

But it is actually much easier because if you inherit from Base, you have a __table__ attribute, so that you can do:

for c in JobStatus.__table__.columns:
    print c

for c in JobStatus.__table__.foreign_keys:
    print c

See How to discover table properties from SQLAlchemy mapped object – similar question.

Edit by Mike: Please see functions such as Mapper.c and Mapper.mapped_table. If using 0.8 and higher also see Mapper.attrs and related functions.

Example for Mapper.attrs:

from sqlalchemy import inspect
mapper = inspect(JobStatus)
for column in mapper.attrs:
    print column.key

More Related Contents:

  1. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  2. SQLAlchemy IN clause
  3. Flask SQLAlchemy query, specify column names
  4. How can I bind a list to a parameter in a custom query in SQLAlchemy?
  5. How to disable SQLAlchemy caching?
  6. AttributeError: can’t set attribute when connecting to sqlite database with flask-sqlalchemy
  7. Case Insensitive Flask-SQLAlchemy Query
  8. sqlalchemy unique across multiple columns
  9. How to build a flask application around an already existing database?
  10. How to create a new database using SQLAlchemy?
  11. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  12. Python, SQLAlchemy pass parameters in connection.execute
  13. Multi-threaded use of SQLAlchemy
  14. How to get column names from SQLAlchemy result (declarative syntax)
  15. How to discover table properties from SQLAlchemy mapped object
  16. IntegrityError when inserting data in an association table using SQLAlchemy
  17. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  18. Dynamic Class Creation in SQLAlchemy
  19. SQLAlchemy equivalent to SQL “LIKE” statement
  20. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  21. Best way to do enum in Sqlalchemy?
  22. How do I INSERT INTO t1 (SELECT * FROM t2) in SQLAlchemy?
  23. Creating partial unique index with sqlalchemy on Postgres
  24. SQLAlchemy Joinedload filter column
  25. SQLAlchemy func.count on boolean column
  26. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  27. pandas to_sql all columns as nvarchar
  28. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  29. Can’t change system default SQLite binary
  30. add column to SQLAlchemy Table

Leave a Comment