Changeset 2732

Timestamp:

04/23/06 16:45:36 (3 years ago)

Author:

adrian

Message:

magic-removal: Fixed #1373 -- Factored out database-specific 'DROP CONSTRAINT' syntax, to get sqlreset/sqlclear working with MySQL. Thanks, njharman

Files:

• django/branches/magic-removal/django/core/management.py (modified) (1 diff)
• django/branches/magic-removal/django/db/backends/ado_mssql/base.py (modified) (1 diff)
• django/branches/magic-removal/django/db/backends/dummy/base.py (modified) (1 diff)
• django/branches/magic-removal/django/db/backends/mysql/base.py (modified) (1 diff)
• django/branches/magic-removal/django/db/backends/postgresql/base.py (modified) (1 diff)
• django/branches/magic-removal/django/db/backends/sqlite3/base.py (modified) (1 diff)

django/branches/magic-removal/django/core/management.py

@@ -291 +291 @@
-                        (style.SQL_KEYWORD('ALTER TABLE'),
-                        style.SQL_TABLE(backend.quote_name(table)),
-'DROP CONSTRAINT'
+backend.get_drop_foreignkey_sql()
-                        style.SQL_FIELD(backend.quote_name("%s_referencing_%s_%s" % (col, r_table, r_col)))))
-                del references_to_delete[klass]

django/branches/magic-removal/django/db/backends/ado_mssql/base.py

@@ -122 +122 @@
-    return "RAND()"
-
+def get_drop_foreignkey_sql():
+    return "DROP CONSTRAINT"
+
-OPERATOR_MAPPING = {
-    'exact': '= %s',

django/branches/magic-removal/django/db/backends/dummy/base.py

@@ -34 +34 @@
-get_limit_offset_sql = complain
-get_random_function_sql = complain
+get_drop_foreignkey_sql = complain
-OPERATOR_MAPPING = {}

django/branches/magic-removal/django/db/backends/mysql/base.py

@@ -147 +147 @@
-    return "RAND()"
-
+def get_drop_foreignkey_sql():
+    return "DROP FOREIGN KEY"
+
-OPERATOR_MAPPING = {
-    'exact': '= %s',

django/branches/magic-removal/django/db/backends/postgresql/base.py

@@ -99 +99 @@
-    return "RANDOM()"
-
+def get_drop_foreignkey_sql():
+    return "DROP CONSTRAINT"
+
-# Register these custom typecasts, because Django expects dates/times to be
-# in Python's native (standard-library) datetime/time format, whereas psycopg

django/branches/magic-removal/django/db/backends/sqlite3/base.py

@@ -117 +117 @@
-    return "RANDOM()"
-
+def get_drop_foreignkey_sql():
+    return ""
+
-def _sqlite_date_trunc(lookup_type, dt):
-    try: