oxDebugDb Class Reference

Collaboration diagram for oxDebugDb:

[legend]

List of all members.

---

Detailed Description

class for parsing and retrieving warnings from adodb saved sql table

Definition at line 6 of file oxdebugdb.php.

Public Member Functions
	getWarnings ()
Protected Member Functions
	_generateWarningsResult ($aInput)
	_checkMissingKeys ($sSql)
	_checkMess ($s1, $s2)
	_logToFile ($aWarnings)
Static Protected Member Functions
static	_skipWhiteSpace ($sStr)
static	_isSkipped ($sSql)
static	_getSqlTemplate ($sSql)
Private Member Functions
	_missingKeysChecker ($aExplain)
Static Private Attributes
static	$_aSkipSqls = array()

---

Member Function Documentation

static oxDebugDb._skipWhiteSpace

(

$

sStr

)

[static, protected]

Removes special chars (' ', "\t", "\r", "\n") from passed string

Parameters:

string

$sStr string to cleanup

Returns:

string

Definition at line 22 of file oxdebugdb.php.

static oxDebugDb._isSkipped

(

$

sSql

)

[static, protected]

Checks if query is allready in log file

Parameters:

string

$sSql sql query to check

Returns:

bool

Definition at line 34 of file oxdebugdb.php.

oxDebugDb.getWarnings

(

)

warning list generator

Returns:

array

Definition at line 55 of file oxdebugdb.php.

oxDebugDb._generateWarningsResult

(

$

aInput

)

[protected]

returns nice formatted array

Parameters:

array

$aInput messages array

Returns:

array

Definition at line 111 of file oxdebugdb.php.

oxDebugDb._checkMissingKeys

(

$

sSql

)

[protected]

check missing keys - use explain return true on warning

Parameters:

string

$sSql query string

Returns:

bool

Definition at line 141 of file oxdebugdb.php.

oxDebugDb._missingKeysChecker

(

$

aExplain

)

[private]

check if remark of explain is not using keys true if not using

Parameters:

array

$aExplain db explain response array

Returns:

bool

Definition at line 167 of file oxdebugdb.php.

oxDebugDb._checkMess	(	$	s1,
		$	s2
	)			[protected]

return true if statements are similar

Parameters:

	string	$s1 statement one
	string	$s2 statement two

Returns:

boolean

Definition at line 210 of file oxdebugdb.php.

static oxDebugDb._getSqlTemplate

(

$

sSql

)

[static, protected]

strips sql down of its values

Parameters:

string

$sSql sql to process

Returns:

string

Definition at line 238 of file oxdebugdb.php.

oxDebugDb._logToFile

(

$

aWarnings

)

[protected]

logs warnings to file

Parameters:

array

$aWarnings warnings

Returns:

null

Definition at line 254 of file oxdebugdb.php.

---

Member Data Documentation

oxDebugDb.$_aSkipSqls = array() [static, private]

Definition at line 13 of file oxdebugdb.php.

---

The documentation for this class was generated from the following file:

• core/oxdebugdb.php