On Wed, Jun 4, 2008 at 12:09 PM, Christoph Zwerschke <[EMAIL PROTECTED]> wrote: > > 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"))
I think I prefer "info" dictionary rather then a string. Dict "info" which I use already have something like this: sqlalchemy.Column('DRIVE_TRAIN', sqlalchemy.Unicode(4) ,info={"description":"DRIVE TRAIN TYPE [AWD,4WD,FWD,RWD]"}), sqlalchemy.Column('FUEL_SYS', sqlalchemy.Unicode(4) ,info={"description":"FUEL SYSTEM CODE", "FI":"FUEL INJECTION", "TB":"TURBO"}), Would be nice if the whole dictionary was written to a database. I could use info[description], info[FI], info[TB] etc... when I display data. That would be really useful definition!!! Lucas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---