Changeset 5087

Timestamp:

01/20/08 04:35:36 (10 months ago)

Author:

inureyes

Message:

#711

• DBQuery 클래스에 버전 및 데이터베이스 종류를 리턴하는 루틴 추가
  

Files:

• trunk/components/Needlworks.DBMS.MySQL.php (modified) (8 diffs)

trunk/components/Needlworks.DBMS.MySQL.php

@@ -21 +21 @@
         mysql_select_db($database['database']);
 
-        if (POD::query('SET CHARACTER SET utf8'))
+        if (DBQuery::query('SET CHARACTER SET utf8'))
             $__dbProperties['charset'] = 'utf8';
         else
             $__dbProperties['charset'] = 'default';
-        @POD::query('SET SESSION collation_connection = \'utf8_general_ci\'');
+        @DBQuery::query('SET SESSION collation_connection = \'utf8_general_ci\'');
     }
     
@@ -37 +37 @@
         if (array_key_exists('charset', $__dbProperties)) return $__dbProperties['charset'];
         else return null;
+    }
+    function dbms() {
+        return 'MySQL';
+    }
+
+    function version() {
+        global $__dbProperties;
+        if (array_key_exists('version', $__dbProperties)) return $__dbProperties['version'];
+        else {
+            $__dbProperties['version'] = DBQuery::queryCell("SHOW VARIABLES LIKE 'version'");
+            return $__dbProperties['version'];
+        }
     }
 
@@ -98 +110 @@
     function queryRow($query, $type = MYSQL_BOTH, $useCache=true) {
         if( $useCache ) {
-            $result = POD::queryAllWithCache($query, $type, 1);
-        } else {
-            $result = POD::queryAllWithoutCache($query, $type, 1);
+            $result = DBQuery::queryAllWithCache($query, $type, 1);
+        } else {
+            $result = DBQuery::queryAllWithoutCache($query, $type, 1);
         }
         if( empty($result) ) {
@@ -122 +134 @@
 
         $column = null;
-        if ($result = POD::query($query)) {
+        if ($result = DBQuery::query($query)) {
             $column = array();
             while ($row = mysql_fetch_row($result))
@@ -143 +155 @@
     function queryAllWithoutCache($query, $type = MYSQL_BOTH, $count = -1) {
         $all = array();
-        if ($result = POD::query($query)) {
+        if ($result = DBQuery::query($query)) {
             while ( ($count-- !=0) && $row = mysql_fetch_array($result, $type))
                 array_push($all, $row);
@@ -163 +175 @@
             return $cachedResult[$cacheKey][1];
         }
-        $all = POD::queryAllWithoutCache($query,$type,$count);
+        $all = DBQuery::queryAllWithoutCache($query,$type,$count);
         $cachedResult[$cacheKey] = array( 1, $all );
         return $all;
@@ -170 +182 @@
     /*@static@*/
     function execute($query) {
-        return POD::query($query) ? true : false;
+        return DBQuery::query($query) ? true : false;
     }
 
@@ -179 +191 @@
             if (is_array($query)) {
                 foreach ($query as $subquery)
-                    if (($result = POD::query($subquery)) === false)
+                    if (($result = DBQuery::query($subquery)) === false)
                         return false;
-            } else if (($result = POD::query($query)) === false)
+            } else if (($result = DBQuery::query($query)) === false)
                 return false;
         }