Ok, I tried this:
from sqlalchemy.schema import DropConstraint
for table in metadata.tables.keys():
for con in metadata.tables[table].constraints:
if isinstance(con, PrimaryKeyConstraint):
engine.execute(DropConstraint(con))
but I'm getting an exception:
engine.execute(DropConstraint(con))
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1457, in execute
return connection.execute(statement, *multiparams, **params)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1035, in execute
return Connection.executors[c](self, object, multiparams, params)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1081, in _execute_ddl
compiled_ddl=ddl.compile(dialect=self.dialect),
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/
expression.py", line 1262, in compile
compiler.compile()
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 629, in compile
self.string = self.process(self.statement)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 632, in process
return obj._compiler_dispatch(self, **kwargs)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/visitors.py",
line 47, in _compiler_dispatch
return getter(visitor)(self, **kw)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/compiler.py",
line 1052, in visit_drop_constraint
self.preparer.format_constraint(drop.element),
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/compiler.py",
line 1393, in format_constraint
return self.quote(constraint.name, constraint.quote)
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/compiler.py",
line 1367, in quote
if self._requires_quotes(ident):
File "/usr/lib/python2.5/site-packages/sqlalchemy/sql/compiler.py",
line 1348, in _requires_quotes
lc_value = value.lower()
AttributeError: 'NoneType' object has no attribute 'lower'
What did I miss?
-Gerry
--
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.
