On Jun 26, 2008, at 11:12 AM, bukzor wrote:

the mapper has a method called "iterate_properties" which returns all   MapperProperty objects it contains.  Each PropertyLoader subclass   represents a relation() to another mapper.

so you can walk among relations as follows:

recursive = set() def walk (cls):      print "cls:", cls      if cls in recursive:          return      recursive.add(cls)

     mapper = class_mapper(cls)      for prop in mapper.iterate_properties:          if isinstance(prop, PropertyLoader):              print "key", prop.key              walk(prop.mapper.class_)

it depends on what information you're interested in.   the use case   here seems to be joining among configured relation()s so the ORM level   would be better.

heres the docs for every API mentioned above:

http://www.sqlalchemy.org/docs/05/sqlalchemy_orm.html#docstrings_sqla...http://www.sqlalchemy.org/docs/05/sqlalchemy_orm_mapper.html#docstrin...http://www.sqlalchemy.org/docs/05/sqlalchemy_orm_interfaces.html#docs...http://www.sqlalchemy.org/docs/05/sqlalchemy_orm_properties.html#docs...

The same documentation can be had by using "pydoc <modulename>", i.e.   pydoc sqlalchemy.orm.mapperlib

I also think you should consider carefully if you truly need   automatic, implicit joining across arbitrarily long paths.  Its a   feature we explicitly removed for its non-pythonicness and   unpredictable behavior.