On Jun 6, 2012, at 7:47 PM, Benjamin Hitz wrote:
> This seems (to me) like an obvious question but a brief googling and looking
> at the docs didn't seem to find the answer.
>
> I have an existing database (lets say mysql)
> I can easily create object like:
>
> class BroadPeaks(Base):
> __table__ = Table('broad_peaks', Base.metadata, autoload=True)
>
> def __repr__(self):
> return '<Peak %r>' % (self.peak_name)
>
> Once I am connected, yay. And I think this has already all the relationships
> I need.
>
> But let's say I am SOOOO lazy that I just want to auto generate the lines:
>
> class ClassName(Base)
> __table__ = Table('table_name', Base.metadata, autoload=True)
>
> For each table. Should I just introspect the metadata object? I thought of
> this but not all the tables were loaded...
if you're incredibly lazy to that degree you might want to check out / help out
with SQLSoup, which has been with SQLAlchemy since the beginning but is now
it's own project:
http://readthedocs.org/docs/sqlsoup/en/latest/tutorial.html
basically you give it a name, it reflects that name and maps it. All kinds of
caveats apply.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
