Changeset 166 for trunk/trax/vendor/trax/active_record.php

Timestamp:

03/09/06 17:22:35 (6 years ago)

Author:

john

Message:

added sql logging in debug mode into AR

Files:

• trunk/trax/vendor/trax/active_record.php (modified) (4 diffs)

trunk/trax/vendor/trax/active_record.php

@@ -712 +712 @@
         ($parameters[0]) ? $field = $parameters[0] : $field = "*";
         $sql = "SELECT $aggregrate_type($field) AS agg_result FROM $this->table_name ";
-
+        
         # Use any passed-in parameters
         if (!is_null($parameters)) {
@@ -782 +782 @@
         if($this->column_attribute_exists($column)) {
             # Run the query to grab a specific columns value.
-            $result = self::$db->getOne("SELECT $column FROM $this->table_name WHERE id='$this->id'");
+            $sql = "SELECT $column FROM $this->table_name WHERE id='$this->id'";
+            $this->log_query($sql);
+            $result = self::$db->getOne($sql);
             if($this->is_error($result)) {
                 $this->raise($result->getMessage());
@@ -834 +836 @@
     function query($sql) {
         # Run the query
+        $this->log_query($sql);
         $rs = self::$db->query($sql);
         if ($this->is_error($rs)) {
@@ -2193 +2196 @@
     function after_delete() {}
 
+    function log_query($sql) {
+        if(TRAX_MODE == "development" && $sql) {
+            $GLOBALS['ACTIVE_RECORD_SQL_LOG'][] = $sql;       
+        }    
+    }
+
     /**
      *  @todo Document this API