Changeset 5462 for temp/trunk/html

Timestamp:

2006/09/23 16:28:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/system/bkup.php (modified) (2 diffs)

temp/trunk/html/admin/system/bkup.php

@@ -83 +83 @@
     $arrTableList = lfGetTableList();
     
-    sfprintr($arrTableList);
-    
-    // ¥Æ¡¼¥Ö¥ë¾ðÊó¤ò
+    // ³Æ¥Æ¡¼¥Ö¥ë¾ðÊó¤ò¼èÆÀ¤¹¤ë
+    foreach($arrTableList as $key => $val){
+        
+        // ¥Æ¡¼¥Ö¥ë¹½À®¤ò¼èÆÀ
+        $arrColumnList = lfGetColumnList($val);
+        
+        
+        sfprintr($arrColumnList);
+        
+        
+        
+        // Á´¥Ç¡¼¥¿¤ò¼èÆÀ
+        
+        
+    }
     
     
@@ -109 +121 @@
 }
 
-
+// ¥Æ¡¼¥Ö¥ë¹½À®¤ò¼èÆÀ¤¹¤ë
+function lfGetColumnList($table_name){
+    $objQuery = new SC_Query();
+
+    if(DB_TYPE == "pgsql"){
+        $sql = "SELECT 
+                    a.attname, t.typname, a.attnotnull, d.adsrc as defval, a.atttypmod, a.attnum as fldnum, e.description 
+                FROM 
+                    pg_class c,
+                    pg_type t,
+                    pg_attribute a left join pg_attrdef d on (a.attrelid=d.adrelid and a.attnum=d.adnum)
+                                   left join pg_description e on (a.attrelid=e.objoid and a.attnum=e.objsubid)
+                WHERE (c.relname=?) AND (c.oid=a.attrelid) AND (a.atttypid=t.oid) AND a.attnum > 0
+                ORDER BY fldnum";
+        $arrRet = $objQuery->getAll($sql, array($table_name));
+    }
+
+}