diff options
author | christian.simms <unknown> | 2008-08-28 01:17:44 +0000 |
---|---|---|
committer | christian.simms <unknown> | 2008-08-28 01:17:44 +0000 |
commit | f687cd3fe04737ffe3ef7dd5aded1a8f781c93f9 (patch) | |
tree | 3f46249456ffce6b344fc51f394bfc2ed9804b05 /migrate/changeset/databases/oracle.py | |
parent | aba0f506811ba2a8ff0bee6a0995f8690ffaa48e (diff) | |
download | sqlalchemy-migrate-f687cd3fe04737ffe3ef7dd5aded1a8f781c93f9.tar.gz |
add support for SA 0.5
Diffstat (limited to 'migrate/changeset/databases/oracle.py')
-rw-r--r-- | migrate/changeset/databases/oracle.py | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/migrate/changeset/databases/oracle.py b/migrate/changeset/databases/oracle.py index c420593..1bb616d 100644 --- a/migrate/changeset/databases/oracle.py +++ b/migrate/changeset/databases/oracle.py @@ -22,7 +22,7 @@ class OracleSchemaChanger(OracleSchemaGenerator,ansisql.ANSISchemaChanger): def visit_column(self,delta): keys = delta.keys() - if 'type' in keys or 'nullable' in keys or 'default' in keys: + if 'type' in keys or 'nullable' in keys or 'default' in keys or 'server_default' in keys: self._run_subvisit(delta,self._visit_column_change) if 'name' in keys: self._run_subvisit(delta,self._visit_column_name) @@ -36,7 +36,7 @@ class OracleSchemaChanger(OracleSchemaGenerator,ansisql.ANSISchemaChanger): # Oracle cannot drop a default once created, but it can set it to null. # We'll do that if default=None # http://forums.oracle.com/forums/message.jspa?messageID=1273234#1273234 - dropdefault_hack = (column.default is None and 'default' in delta.keys()) + dropdefault_hack = (column.server_default is None and 'server_default' in delta.keys()) # Oracle apparently doesn't like it when we say "not null" if the # column's already not null. Fudge it, so we don't need a new function notnull_hack = ((not column.nullable) and ('nullable' not in delta.keys())) @@ -45,7 +45,7 @@ class OracleSchemaChanger(OracleSchemaGenerator,ansisql.ANSISchemaChanger): if dropdefault_hack: - column.default = sa.PassiveDefault(sa.sql.null()) + column.server_default = sa.PassiveDefault(sa.sql.null()) if notnull_hack: column.nullable = True colspec=self.get_column_specification(column,override_nullable=null_hack) @@ -54,7 +54,7 @@ class OracleSchemaChanger(OracleSchemaGenerator,ansisql.ANSISchemaChanger): if notnull_hack: column.nullable = False if dropdefault_hack: - column.default = None + column.server_default = None self.start_alter_table(table_name) self.append("MODIFY ") |