|
From: <al...@us...> - 2008-08-24 19:45:56
|
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.
|