Lukasz Szybalski schrieb:
> I started using info dict on a column names in sa file definitions. It
> would be nice to save it to db if once could. What db supports
> comments and what table name is it?
Oracle and PostgreSQL have the "comment on" SQL statement. MySQL has a
comment clause for column definitions. SA could abstract away these
differences, the syntax would be something like this:
users = Table('users', metadata,
Column('id', Integer, primary_key=True),
Column('name', String(40), comment="The Unix user name"),
Column('fullname', String(100), comment="Full name with title"))
This way, the table definition in Python itself would be commented, and
at the same time, comments on the database would be created that help
you if you operate directly on the database with some admin tool.
-- Christoph
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
