same answer: sqlalchemy has no built in facility for generating relationship() structures automatically. there's a library called sqlautocode that does this but I don't know its status.
On Apr 12, 2013, at 11:03 AM, ken <cmor...@reddeer.gb.com> wrote: > This has also been posted here: > http://stackoverflow.com/questions/15950375/sqlalchemy-introspection-of-relationships, > shoulda asked here first. > > I have a use case for modelling data in a SQL schema rather than through > defining SQLAlchemy objects. However, i require a way to construct the > corresponding SQLAlchemy objects automatically from the SQL schema. > > Currently i have: > > from sqlalchemy import MetaData > > > from sqlalchemy.ext.declarative import declarative_base > > > > meta = MetaData(bind=your_engine) > > > meta.reflect() > > > > # get the table which we would like to represent as a Python object > > > table = meta.tables['your_table_name'] > > > > # define the object which we will use as the base class > > > base = declarative_base() > > > # create db object > > > MyObject = type(str(table.fullname), (base,), {'__table__': table}) > > however, the relationships between objects are not created. Any ideas how to > go about doing this? > > Thanks! > > -- > 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 sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.