On Mar 12, 2010, at 10:14 AM, YAD wrote:
> Hello
>
from sqlalchemy import *
engine = create_engine('mysql://root:r...@localhost/sqlalchemy')
meta = MetaData(engine)
tb = Table('account', meta, autoload = True)
tb.append_column(Column('c',String(50)))
>
> this code does not work properly, it adds a column in the table but in
> fact the table remains intact. Where mistake?
SQLA doesn't have automatic support for ALTER TABLE. append_column() would
normally be called before a create() is issued.
To work with ALTER, use a recipe like that described in
http://www.sqlalchemy.org/docs/reference/ext/compiler.html#dialect-specific-compilation-rules
or look into using sqlalchemy-migrate.
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.