Changeset 7424 for temp/trunk/data/lib

Timestamp:

2006/11/06 09:54:45 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

File:

• temp/trunk/data/lib/slib.php (modified) (1 diff)

temp/trunk/data/lib/slib.php

@@ -69 +69 @@
                         relname";
             $arrRet = $objQuery->getAll($sql, array($table_name));
+            if(count($arrRet) > 0) {
+                return true;
+            }
+        }else if ($db_type == "mysql") {
+            $sql = "SHOW TABLE STATUS LIKE ?";
+            $arrRet = $objQuery->getAll($sql, array($table_name));
+            if(count($arrRet) > 0) {
+                return true;
+            }
+        }
+    }
+    return false;
+}
+
+// ¥«¥é¥à¤Î¸ºß¥Á¥§¥Ã¥¯
+function sfColumnExists($table_name, $col_name, $dsn = "") {
+    if($dsn == "") {
+        if(defined('DEFAULT_DSN')) {
+            $dsn = DEFAULT_DSN;
+        } else {
+            return;
+        }
+    }
+    
+    $objQuery = new SC_Query($dsn, true, true);
+    // Àµ¾ï¤ËÀܳ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç
+    if(!$objQuery->isError()) {
+        list($db_type) = split(":", $dsn);
+        // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
+        if ($db_type == "pgsql") {
+            $sql = "SELECT
+                        a.attname
+                    FROM
+                        pg_class c, pg_attribute a
+                    WHERE
+                        c.relname=? AND
+                        a.attname=? AND
+                        c.oid=a.attrelid AND
+                        a.attnum > 0
+                    ORDER BY
+                        a.attnum";
+            $arrRet = $objQuery->getAll($sql, array($table_name, $col_name));
             if(count($arrRet) > 0) {
                 return true;