Changeset 5457

Timestamp:

2006/09/23 16:01:29 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin

Files:

• contents/csv_sql.php (modified) (1 diff)
• system/bkup.php (modified) (3 diffs)

temp/trunk/html/admin/contents/csv_sql.php

@@ -180 +180 @@
     $objQuery = new SC_Query();
     $arrRet = array();      // ·ë²Ì¼èÆÀÍÑ
-    /*
-    $sql = "";
-    $sql .= " SELECT";
-    $sql .= "     c.relname ,";
-    $sql .= "     c.relname || ':' ||obj_description(c.oid) as description";
-    $sql .= " FROM";
-    $sql .= "     pg_class c,";
-    $sql .= "     pg_user u";
-    $sql .= " WHERE";
-    $sql .= "     c.relowner = u.usesysid AND";
-    $sql .= "     relname IN (SELECT";
-    $sql .= "                     tablename";
-    $sql .= "                 FROM";
-    $sql .= "                     pg_tables";
-    $sql .= "                 WHERE";
-    $sql .= "                     tableowner=? ";
-    $sql .= "                 )";
-    $sql .= " ORDER BY c.relname ";
-    $arrRet = $objQuery->getAll($sql, array(DB_USER));
-    */
+
     $sql = "";
     $sql .= "SELECT table_name, description FROM dtb_table_comment WHERE column_name IS NULL ORDER BY table_name";

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

@@ -63 +63 @@
 $objPage->arrErr = $arrErr;
 
-sfprintr($arrErr);
-
 $objView->assignobj($objPage);      //ÊÑ¿ô¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¥¢¥µ¥¤¥ó¤¹¤ë
 $objView->display(MAIN_FRAME);      //¥Æ¥ó¥×¥ì¡¼¥È¤Î½ÐÎÏ
@@ -83 +81 @@
     
     // Á´¥Æ¡¼¥Ö¥ë¼èÆÀ
-    
+    $arrTableList = lfGetTableList();
+    
+    sfprintr($arrTableList);
     
     // ¥Æ¡¼¥Ö¥ë¾ðÊó¤ò
@@ -93 +93 @@
 }
 
+// Á´¥Æ¡¼¥Ö¥ë¥ê¥¹¥È¤ò¼èÆÀ¤¹¤ë
+function lfGetTableList(){
+    $objQuery = new SC_Query();
+    
+    if(DB_TYPE == "pgsql"){
+        $sql = "SELECT tablename FROM pg_tables where tableowner = ? ORDER BY tablename ; ";
+        $arrRet = $objQuery->getAll($sql, array(DB_USER));
+    }else if(DB_TYPE == "mysql"){
+        
+    }
+    
+    return $arrRet;
+}