Changeset 431

Timestamp:

11/09/07 06:43:32 (1 year ago)

Author:

kaste

Message:

implemented renameColumn in AkDbAdapter?.
(Note: not tested)
(Note: needs update of AkInstaller?!)

Files:

• branches/kaste/framework/lib/AkActiveRecord/AkDbAdapter.php (modified) (1 diff)
• branches/kaste/framework/lib/AkActiveRecord/AkDbAdapter_mysql.php (modified) (1 diff)
• branches/kaste/framework/lib/AkActiveRecord/AkDbAdapter_pgsql.php (modified) (1 diff)

branches/kaste/framework/lib/AkActiveRecord/AkDbAdapter.php

@@ -238 +238 @@
-    }
-    
+    /* SCHEMA */
+    
+    function renameColumn($table_name,$column_name,$new_name)
+    {
+        trigger_error(Ak::t('renameColumn is not available for your DbAdapter. Using %db_type.',array('%db_type'=>$this->type())));
+    }
+    
-}
-

branches/kaste/framework/lib/AkActiveRecord/AkDbAdapter_mysql.php

@@ -55 +55 @@
-    }
-    
+    /* SCHEMA */
+    
+    function renameColumn($table_name,$column_name,$new_name)
+    {
+        $column_details = $this->selectOne("SHOW COLUMNS FROM $table_name = '$column_name'");
+        $column_type_definition = $column_details['type'];
+        $this->sqlexecute("ALTER TABLE $table_name CHANGE COLUMN $column_name $new_name $column_type_definition");
+    }
+    
-}
-?>

branches/kaste/framework/lib/AkActiveRecord/AkDbAdapter_pgsql.php

@@ -29 +29 @@
-        return 'postgre';
-    }
+    
+    function renameColumn($table_name,$column_name,$new_name)
+    {
+        $this->sqlexecute("ALTER TABLE $table_name RENAME COLUMN $column_name TO $new_name");
+    }
+    
-}
-?>