[limb-svn] r7033 - 3.x/trunk/limb/dbal/src/query

[svn at limb-project.com]

Author: korchasa
Date: 2008-05-21 13:25:17 +0400 (Wed, 21 May 2008)
New Revision: 7033
URL: http://fisheye.limb-project.com/changelog/limb/?cs=7033

Modified:
   3.x/trunk/limb/dbal/src/query/lmbSelectRawQuery.class.php
Log:
-- add method setFields to selectRawQuery

Modified: 3.x/trunk/limb/dbal/src/query/lmbSelectRawQuery.class.php
===================================================================
--- 3.x/trunk/limb/dbal/src/query/lmbSelectRawQuery.class.php	2008-05-21 05:15:19 UTC (rev 7032)
+++ 3.x/trunk/limb/dbal/src/query/lmbSelectRawQuery.class.php	2008-05-21 09:25:17 UTC (rev 7033)
@@ -52,6 +52,14 @@
     return array_keys($this->_fields);
   }
 
+  function setFields($fields)
+  {
+    $this->_fields = array();
+    foreach($fields as $alias => $field);
+    $this->_fields[$field] = $alias;
+    return $this;
+  }
+
   function addRawField($field, $alias = null)
   {
     $this->_raw_fields[$field] = $alias;
@@ -86,14 +94,14 @@
     }
     else
       $this->_order[] = $this->_conn->quoteIdentifier($field) . " $type";
-      
+
     return $this;
   }
 
   function addRawOrder($field)
   {
     $this->_order[] = $field;
-      
+
     return $this;
   }
 
@@ -145,7 +153,7 @@
       $connect_by = array($table . '.' . $field => $connect_table . '.' . $connect_field);
     else
       $connect_by = array($table_alias . '.' . $field => $connect_table . '.' . $connect_field);
-    
+
     $this->_left_join_constraints[] = array('table' => $table,
                                             'connect_by' => $connect_by,
                                             'alias' => $table_alias);
@@ -183,7 +191,7 @@
         $fields .= $field . ',';
         continue;
       }
-      
+
       $fields .= $this->_conn->quoteIdentifier($field) .
                  ($alias ? ' as ' . $this->_conn->quoteIdentifier($alias) : '') . ',';
     }
@@ -197,7 +205,7 @@
         $fields .= $field . ',';
         continue;
       }
-      
+
       $fields .= $field .  ($alias ? ' as ' . $alias : '') . ',';
     }
     $fields = rtrim($fields, ',');