[Sciret-svn] SF.net SVN: sciret:[628] trunk

[<al...@us...>]

Revision: 628
          http://sciret.svn.sourceforge.net/sciret/?rev=628&view=rev
Author:   alpeb
Date:     2008-08-24 19:45:53 +0000 (Sun, 24 Aug 2008)

Log Message:
-----------
added DB profiler, for the moment just used to log queries

Modified Paths:
--------------
    trunk/index.php

Added Paths:
-----------
    trunk/classes/DBProfiler.php

Added: trunk/classes/DBProfiler.php
===================================================================
--- trunk/classes/DBProfiler.php	                        (rev 0)
+++ trunk/classes/DBProfiler.php	2008-08-24 19:45:53 UTC (rev 628)
@@ -0,0 +1,14 @@
+<?php
+
+class DBProfiler extends Zend_Db_Profiler {
+    public function MonkeysDbProfiler() {
+        parent::__construct(true);
+    }
+
+    public function queryStart($queryText, $queryType = null) {
+        Zend_Registry::get('logger')->log("DB QUERY: $queryText", Zend_Log::DEBUG);
+        return parent::queryStart($queryText, $queryType);
+    }
+}
+
+?>


Property changes on: trunk/classes/DBProfiler.php
___________________________________________________________________
Added: svn:executable
   + *

Modified: trunk/index.php
===================================================================
--- trunk/index.php	2008-08-24 19:15:56 UTC (rev 627)
+++ trunk/index.php	2008-08-24 19:45:53 UTC (rev 628)
@@ -71,6 +71,10 @@
 /**************************/
 $config->database->params->driver_options = array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true);
 $db = Zend_Db::factory($config->database);
+if ($config->environment->loglevel == Zend_Log::DEBUG) {
+    $profiler = new DBProfiler();
+    $db->setProfiler($profiler);
+}
 $connectionFailed = false;
 try {
     $db->getConnection();


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.