X-Git-Url: https://git.mdrn.pl/wolnelektury.git/blobdiff_plain/21f878e8112cf1f9b732a6dbb77e70efa68a01aa..9baaf0aa657110f7481ea24dc6bc68bf4fc64cd1:/apps/south/db/mysql.py diff --git a/apps/south/db/mysql.py b/apps/south/db/mysql.py index c3659fc48..a05c0714d 100644 --- a/apps/south/db/mysql.py +++ b/apps/south/db/mysql.py @@ -1,5 +1,6 @@ from django.db import connection +from django.conf import settings from south.db import generic class DatabaseOperations(generic.DatabaseOperations): @@ -11,9 +12,20 @@ class DatabaseOperations(generic.DatabaseOperations): alter_string_set_type = '' alter_string_set_null = 'MODIFY %(column)s %(type)s NULL;' alter_string_drop_null = 'MODIFY %(column)s %(type)s NOT NULL;' + drop_index_string = 'DROP INDEX %(index_name)s ON %(table_name)s' + allows_combined_alters = False + has_ddl_transactions = False + + def execute(self, sql, params=[]): + if hasattr(settings, "DATABASE_STORAGE_ENGINE") and \ + settings.DATABASE_STORAGE_ENGINE: + generic.DatabaseOperations.execute(self, "SET storage_engine=%s;" % + settings.DATABASE_STORAGE_ENGINE) + return generic.DatabaseOperations.execute(self, sql, params) + execute.__doc__ = generic.DatabaseOperations.execute.__doc__ def rename_column(self, table_name, old, new): - if old == new: + if old == new or self.dry_run: return [] qn = connection.ops.quote_name @@ -27,17 +39,22 @@ class DatabaseOperations(generic.DatabaseOperations): qn(table_name), qn(old), qn(new), - "%s %s %s %s %s" % ( - rows[0][1], - rows[0][2] == "YES" and "NULL" or "NOT NULL", - rows[0][3] == "PRI" and "PRIMARY KEY" or "", - rows[0][4] and "DEFAULT %s" % rows[0][4] or "", - rows[0][5] or "", - ), + rows[0][1], + rows[0][2] == "YES" and "NULL" or "NOT NULL", + rows[0][3] == "PRI" and "PRIMARY KEY" or "", + rows[0][4] and "DEFAULT " or "", + rows[0][4] and "%s" or "", + rows[0][5] or "", ) - self.execute('ALTER TABLE %s CHANGE COLUMN %s %s %s;' % params) - - + + sql = 'ALTER TABLE %s CHANGE COLUMN %s %s %s %s %s %s %s %s;' % params + + if rows[0][4]: + self.execute(sql, (rows[0][4],)) + else: + self.execute(sql) + + def rename_table(self, old_table_name, table_name): """ Renames the table 'old_table_name' to 'table_name'. @@ -47,4 +64,4 @@ class DatabaseOperations(generic.DatabaseOperations): return qn = connection.ops.quote_name params = (qn(old_table_name), qn(table_name)) - self.execute('RENAME TABLE %s TO %s;' % params) \ No newline at end of file + self.execute('RENAME TABLE %s TO %s;' % params)