just as a reminder, current approach is:
t = Table('t', metadata, ....)
DDL("COMMENT ON COLUMN t.bar IS 'this is bar'", t)
the 0.6 series of SQLA, which is already underway, has an emphasis on
dialect/type/schema operation, and is likely the best place for a
complete Comment() construct. Lots of new constructs, like
CreateTable, DropTable, etc. are being added, as the generation of DDL
constructs has been placed into the same compilation system as SQL
expressions.
On Dec 31, 2008, at 12:08 PM, Jim Jones wrote:
>
> Just wanted to give this a bump as it would be a very welcome feature
> for us, too. Postgres also supports this and the comments are
> generally
> very helpful when browsing the schema with CLI- or GUI-tools.
>
> Any volunteers?
>
> regards + happy new year
> -jj
>
> Michael Bayer wrote:
>>
>> columns support an .info collection which is generic, but this is
>> not linked to DDL in any way.
>>
>> You can create comments inline with a Table using the DDL()
>> construct.
>>
>> A built in SQLA feature would likely look like a Comment() schema
>> object but there haven't been any plans for this. It is of course
>> a straightforward feature add.
>>
>> On Oct 27, 2008, at 1:43 PM, Michael Schlenker wrote:
>>
>>>
>>> Hi,
>>>
>>> i looked at the API doc but found no obvious way to specify a
>>> COMMENT clause
>>> for a schema object.
>>>
>>> Is there any support for this in SA or anything planned?
>>>
>>> Basically you can add comments to schema objects in e.g. Oracle,
>>> via a COMMENT command.
>>> (for Oracle
>>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4009.htm#i2119719
>>> ,
>>> SQL Server supports something similar,
>>> and Postgresql too
>>> http://www.postgresql.org/docs/8.3/interactive/sql-comment.html)
>>>
>>> Would be nice to be able to reflect a docstring into the database
>>> schema
>>> that way.
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
