Class: Log_sql

Source Location: /Log-1.9.8/Log/sql.php

Class Overview

Log
   |
   --Log_sql

The Log_sql class is a concrete implementation of the Log:: abstract class which sends messages to an SQL server. Each entry occupies a separate row in the database.

Author(s):

Jon Parise <jon at php.net>

Methods

Inherited Variables

Inherited Methods

Class: Log

Log::alert(): A convenience function for logging an alert event. It will log a message at the PEAR_LOG_ALERT log level.
Log::attach(): Adds a Log_observer instance to the list of observers that are listening for messages emitted by this Log instance.
Log::close(): Abstract implementation of the close() method.
Log::crit(): A convenience function for logging a critical event. It will log a message at the PEAR_LOG_CRIT log level.
Log::debug(): A convenience function for logging a debug event. It will log a message at the PEAR_LOG_DEBUG log level.
Log::detach(): Removes a Log_observer instance from the list of observers.
Log::emerg(): A convenience function for logging a emergency event. It will log a message at the PEAR_LOG_EMERG log level.
Log::err(): A convenience function for logging a error event. It will log a message at the PEAR_LOG_ERR log level.
Log::factory(): Attempts to return a concrete Log instance of type $handler.
Log::flush(): Abstract implementation of the flush() method.
Log::getIdent(): Returns the current identification string.
Log::getMask(): Returns the current level mask.
Log::getPriority(): Returns the current default priority.
Log::info(): A convenience function for logging a information event. It will log a message at the PEAR_LOG_INFO log level.
Log::isComposite(): Indicates whether this is a composite class.
Log::log(): Abstract implementation of the log() method.
Log::MASK(): Calculate the log mask for the given priority.
Log::MAX(): Calculate the log mask for all priorities less than or equal to the given priority. In other words, $priority will be the highests priority matched by the resulting mask.
Log::MIN(): Calculate the log mask for all priorities greater than or equal to the given priority. In other words, $priority will be the lowest priority matched by the resulting mask.
Log::notice(): A convenience function for logging a notice event. It will log a message at the PEAR_LOG_NOTICE log level.
Log::open(): Abstract implementation of the open() method.
Log::priorityToString(): Returns the string representation of a PEAR_LOG_* integer constant.
Log::setIdent(): Sets this Log instance's identification string.
Log::setMask(): Set and return the level mask for the current Log instance.
Log::setPriority(): Sets the default priority to the specified value.
Log::singleton(): Attempts to return a reference to a concrete Log instance of type $handler, only creating a new instance if no log instance with the same parameters currently exists.
Log::stringToPriority(): Returns the the PEAR_LOG_* integer constant for the given string representation of a priority name. This function performs a case-insensitive search.
Log::UPTO(): Calculate the log mask for all priorities up to the given priority.
Log::warning(): A convenience function for logging a warning event. It will log a message at the PEAR_LOG_WARNING log level.

Class Details

[line 43]
The Log_sql class is a concrete implementation of the Log:: abstract class which sends messages to an SQL server. Each entry occupies a separate row in the database.

This implementation uses PHP's PEAR database abstraction layer.

CREATE TABLE log_table ( id INT NOT NULL, logtime TIMESTAMP NOT NULL, ident CHAR(16) NOT NULL, priority INT NOT NULL, message VARCHAR(200), PRIMARY KEY (id) );

Author: Jon Parise <jon@php.net>
Since: Horde 1.3
Since: Log 1.0
Example: example not found

[ Top ]

Method Detail

Log_sql (Constructor) [line 120]

Log_sql Log_sql(
string
$name, [string
$ident = ''], [array
$conf = array()], [int
$level = PEAR_LOG_DEBUG])

Constructs a new sql logging object.

Access: public

Parameters:

string	`$name`	—	The target SQL table.
string	`$ident`	—	The identification field.
array	`$conf`	—	The connection configuration array.
int	`$level`	—	Log messages up to and including this level.

[ Top ]

close [line 200]

boolean close(
)

Closes the connection to the database if it is still open and we were the ones that opened it. It is the caller's responsible to close an existing connection that was passed to us via $conf['db'].

Return: True on success, false on failure.
Access: public

Overrides Log::close() (Abstract implementation of the close() method.)

[ Top ]

log [line 239]

boolean log(
mixed
$message, [string
$priority = null])

Inserts $message to the currently open database. Calls open(), if necessary. Also passes the message along to any Log_observer instances that are observing this Log.

Return: True on success or false on failure.
Access: public

Overrides Log::log() (Abstract implementation of the log() method.)

Parameters:

mixed	`$message`	—	String or object containing the message to log.
string	`$priority`	—	The priority of the message. Valid values are: PEAR_LOG_EMERG, PEAR_LOG_ALERT, PEAR_LOG_CRIT, PEAR_LOG_ERR, PEAR_LOG_WARNING, PEAR_LOG_NOTICE, PEAR_LOG_INFO, and PEAR_LOG_DEBUG.

[ Top ]

open [line 171]

boolean open(
)

Opens a connection to the database, if it has not already been opened. This is implicitly called by log(), if necessary.

Return: True on success, false on failure.
Access: public

Overrides Log::open() (Abstract implementation of the open() method.)

[ Top ]

setIdent [line 221]

void setIdent(
string
$ident)

Sets this Log instance's identification string. Note that this SQL-specific implementation will limit the length of the $ident string to sixteen (16) characters.

Since: Log 1.8.5
Access: public

Overrides Log::setIdent() (Sets this Log instance's identification string.)

Parameters:

string $ident — The new identification string.

[ Top ]