From a61b62e592380fa3be7e4ff812f3e514afabd321 Mon Sep 17 00:00:00 2001
From: nickw <nickw@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Fri, 16 Oct 2009 22:53:22 +0000
Subject: Rewriting core debug messages to be more informative.

Introducing the concept of levels for Elgg debugging: notices, warnings and errors are displayed when the appropriate debugging level is enabled. An additional level of "debug" exists to differentiate from errors.


git-svn-id: http://code.elgg.org/elgg/trunk@3560 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/lib/database.php | 72 ++++++++++++-------------------------------------
 1 file changed, 17 insertions(+), 55 deletions(-)

(limited to 'engine/lib/database.php')

diff --git a/engine/lib/database.php b/engine/lib/database.php
index 0faa6f029..96dac3846 100644
--- a/engine/lib/database.php
+++ b/engine/lib/database.php
@@ -11,7 +11,6 @@
  * @link http://elgg.org/
  */
 
-$DB_PROFILE = array();
 $DB_QUERY_CACHE = array();
 $DB_DELAYED_QUERIES = array();
 
@@ -51,7 +50,7 @@ function establish_db_link($dblinkname = "readwrite") {
 	// Connect to database
 	if (!$dblink[$dblinkname] = mysql_connect($CONFIG->dbhost, $CONFIG->dbuser, $CONFIG->dbpass, true)) {
 		$msg = sprintf(elgg_echo('DatabaseException:WrongCredentials'),
-				$CONFIG->dbuser, $CONFIG->dbhost, $CONFIG->debug ? $CONFIG->dbpass : "****");
+				$CONFIG->dbuser, $CONFIG->dbhost, "****");
 		throw new DatabaseException($msg);
 	}
 	if (!mysql_select_db($CONFIG->dbname, $dblink[$dblinkname])) {
@@ -92,20 +91,9 @@ function setup_db_connections() {
  * Shutdown hook to display profiling information about db (debug mode)
  */
 function db_profiling_shutdown_hook() {
-	global $CONFIG, $DB_PROFILE, $dbcalls;
-
-	if (isset($CONFIG->debug) && $CONFIG->debug) {
-		error_log("***************** DB PROFILING ********************");
-
-		$DB_PROFILE = array_count_values($DB_PROFILE);
-
-		foreach ($DB_PROFILE as $k => $v) {
-			error_log("$v times: '$k' ");
-		}
-
-		error_log("DB Queries for this page: $dbcalls");
-		error_log("***************************************************");
-	}
+	global $dbcalls;
+	
+	elgg_log("DB Queries for this page: $dbcalls", 'DEBUG');
 }
 
 /**
@@ -123,7 +111,7 @@ function db_delayedexecution_shutdown_hook() {
 				$query_details['h']($result);
 			}
 		} catch (Exception $e) { // Suppress all errors since these can't be delt with here
-			if (isset($CONFIG->debug) && $CONFIG->debug) {
+			if (isset($CONFIG->debug)) {
 				error_log($e);
 			}
 		}
@@ -183,13 +171,10 @@ function explain_query($query, $link) {
  * @return Returns a the result of mysql_query
  */
 function execute_query($query, $dblink) {
-	global $CONFIG, $dbcalls, $DB_PROFILE, $DB_QUERY_CACHE;
+	global $CONFIG, $dbcalls, $DB_QUERY_CACHE;
 
 	$dbcalls++;
 
-	//if ((isset($CONFIG->debug)) && ($CONFIG->debug==true))
-			$DB_PROFILE[] = $query;
-
 	$result = mysql_query($query, $dblink);
 	if ($DB_QUERY_CACHE) {
 		$DB_QUERY_CACHE[$query] = -1; // Set initial cache to -1
@@ -265,9 +250,7 @@ function get_data($query, $callback = "") {
 	}
 
 	if ((isset($cached_query)) && ($cached_query)) {
-		if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-			error_log ("$query results returned from cache");
-		}
+		elgg_log("$query results returned from cache");
 
 		if ($cached_query === -1) {
 			// Last time this query returned nothing, so return an empty array
@@ -292,19 +275,14 @@ function get_data($query, $callback = "") {
 	}
 
 	if (empty($resultarray)) {
-		if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-			error_log("WARNING: DB query \"$query\" returned no results.");
-			return false;
-		}
-	}
-
-	if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-		error_log("$query results cached");
+		elgg_log("DB query \"$query\" returned no results.");
+		return false;
 	}
 
 	// Cache result
 	if ($DB_QUERY_CACHE) {
 		$DB_QUERY_CACHE[$query] = $resultarray;
+		elgg_log("$query results cached");
 	}
 
 	return $resultarray;
@@ -325,9 +303,7 @@ function get_data_row($query, $callback = "") {
 	}
 
 	if ((isset($cached_query)) && ($cached_query)) {
-		if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-			error_log ("$query results returned from cache");
-		}
+		elgg_log("$query results returned from cache");
 
 		if ($cached_query === -1) {
 			// Last time this query returned nothing, so return false
@@ -344,12 +320,9 @@ function get_data_row($query, $callback = "") {
 		$row = mysql_fetch_object($result);
 
 		// Cache result (even if query returned no data)
-		if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-			error_log("$query results cached");
-		}
-
 		if ($DB_QUERY_CACHE) {
 			$DB_QUERY_CACHE[$query] = $row;
+			elgg_log("$query results cached");
 		}
 
 		if (!empty($callback) && is_callable($callback)) {
@@ -361,11 +334,8 @@ function get_data_row($query, $callback = "") {
 		}
 	}
 
-	if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-		error_log("WARNING: DB query \"$query\" returned no results.");
-	}
-
-	return false;
+	elgg_log("$query returned no results.");
+	return FALSE;
 }
 
 /**
@@ -384,9 +354,7 @@ function insert_data($query) {
 		$DB_QUERY_CACHE->clear();
 	}
 
-	if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-		error_log("Query cache invalidated");
-	}
+	elgg_log("Query cache invalidated");
 
 	if (execute_query("$query", $dblink)) {
 		return mysql_insert_id($dblink);
@@ -409,10 +377,7 @@ function update_data($query) {
 	// Invalidate query cache
 	if ($DB_QUERY_CACHE) {
 		$DB_QUERY_CACHE->clear();
-	}
-
-	if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-		error_log("Query cache invalidated");
+		elgg_log("Query cache invalidated");
 	}
 
 	if (execute_query("$query", $dblink)) {
@@ -438,10 +403,7 @@ function delete_data($query) {
 	// Invalidate query cache
 	if ($DB_QUERY_CACHE) {
 		$DB_QUERY_CACHE->clear();
-	}
-
-	if ((isset($CONFIG->debug)) && ($CONFIG->debug==true)) {
-		error_log("Query cache invalidated");
+		elgg_log("Query cache invalidated");
 	}
 
 	if (execute_query("$query", $dblink)) {
-- 
cgit v1.2.3