/branches/1.0/src/class.LoggerAppenderScalr.php

<?php



require_once(LOG4PHP_DIR . '/LoggerAppenderSkeleton.php');

require_once(LOG4PHP_DIR . '/helpers/LoggerOptionConverter.php');

require_once(LOG4PHP_DIR . '/LoggerLog.php');



class LoggerAppenderScalr extends LoggerAppenderSkeleton {



    /**

     * Create the log table if it does not exists (optional).

     * @var boolean

     */

    var $createTable = true;

    

    /**

     * The type of database to connect to

     * @var string

     */

    var $type;

    

    /**

     * Database user name

     * @var string

     */

    var $user;

    

    /**

     * Database password

     * @var string

     */

    var $password;

    

    /**

     * Database host to connect to

     * @var string

     */

    var $host;

    

    /**

     * Name of the database to connect to

     * @var string

     */

    var $database;

    

    /**

     * A {@link LoggerPatternLayout} string used to format a valid insert query (mandatory).

     * @var string

     */

    var $sql;

    

    /**

     * Table name to write events. Used only if {@link $createTable} is true.

     * @var string

     */    

    var $table;

    

    /**

     * @var object Adodb instance

     * @access private

     */

    var $db = null;

    

    /**

     * @var boolean used to check if all conditions to append are true

     * @access private

     */

    var $canAppend = true;

    

    /**    

     * @access private

     */

    var $requiresLayout = false;

    

    /**

     * Constructor.

     *

     * @param string $name appender name

     */

    function LoggerAppenderDb($name)

    {

        $this->LoggerAppenderSkeleton($name);

    }



    /**

     * Setup db connection.

     * Based on defined options, this method connects to db defined in {@link $dsn}

     * and creates a {@link $table} table if {@link $createTable} is true.

     * @return boolean true if all ok.

     */

    function activateOptions()

    {        

        $this->db = &ADONewConnection($this->type);

        if (! $this->db->NConnect($this->host, $this->user, $this->password, $this->database)) {

          LoggerLog::debug("LoggerAppenderAdodb::activateOptions() DB Connect Error [".$this->db->ErrorMsg()."]");            

          $this->db = null;

          $this->closed = true;

          $this->canAppend = false;

          return;

        }

        

        $this->layout = LoggerLayout::factory('LoggerPatternLayoutScalr');

        $this->layout->setConversionPattern($this->getSql());

    

        $this->canAppend = true;

    }

    

    function append($event)

    {    	

    	if ($this->canAppend) 

        {

        	try

            {

	        	// Reopen new mysql connection (need for php threads)

	        	$this->activateOptions();

	        	

	        	if ($event->message instanceOf FarmLogMessage)

	        	{

	        		$severity = $this->SeverityToInt($event->getLevel()->toString());

	        		$message = $this->db->qstr($event->message->Message);

	        		

	        		$query = "INSERT DELAYED INTO logentries SET 

	        			serverid	= '', 

	        			message		= {$message},

	        			severity	= '{$severity}',

	        			time		= '".time()."',

	        			source 		= '".$event->getLoggerName()."',

	        			farmid 		= '{$event->message->FarmID}' 

	        		";

	        			

	        		$this->db->Execute($query);

	        		

	        		$event->message = $this->db->qstr("[FarmID: {$event->message->FarmID}] {$event->message->Message}");

	        	}

	        	elseif ($event->message instanceof ScriptingLogMessage)

	        	{

	        		$message = $this->db->qstr($event->message->Message);

	        		

	        		$query = "INSERT DELAYED INTO scripting_log SET 

	        			farmid 		= '{$event->message->FarmID}',

	        			event		= '{$event->message->EventName}',

	        			instance	= '{$event->message->InstanceID}',

	        			dtadded		= NOW(),

	        			message		= {$message}

	        		";

	        			

	        		$this->db->Execute($query);

	        		

	        		$event->message = $this->db->qstr("[Farm: {$event->message->FarmID}] {$event->message->Message}");

	        	}

	        	else

	        		$event->message = $this->db->qstr($event->message);

	        	

	        	// Redeclare threadName

	            $event->threadName = TRANSACTION_ID; 

	

	            $event->subThreadName = defined("SUB_TRANSACTIONID") ? SUB_TRANSACTIONID : TRANSACTION_ID;

	            

	            $event->farmID = defined("LOGGER_FARMID") ? LOGGER_FARMID : null;

	            

	        	$level = $event->getLevel()->toString();

	        	if ($level == "FATAL" || $level == "ERROR")

	        	{

	        		$event->backtrace = $this->db->qstr(Debug::Backtrace());

	        		

	        		// Set meta information

	        		$this->db->Execute("INSERT DELAYED INTO syslog_metadata SET transactionid=?, errors='1', warnings='0'

	        			ON DUPLICATE KEY UPDATE errors=errors+1

	        		",

	        			array(TRANSACTION_ID)

	        		);

	        	}

	        	else

	        	{

	        		if ($level == "WARN")

	        		{

	        			// Set meta information

		        		$this->db->Execute("INSERT DELAYED INTO syslog_metadata SET transactionid=?, errors='0', warnings='1'

		        			ON DUPLICATE KEY UPDATE warnings=warnings+1

		        		",

		        			array(TRANSACTION_ID)

		        		);	

	        		}

	        		

	        		$event->backtrace = "''";

	        	}

	        	

	            $query = $this->layout->format($event);

            

            	$this->db->Execute($query);

            }

            catch(Exception $e)

            {



            }

            

            // close connection

            if ($this->db !== null)

            	$this->db->Close();

        }

    }

    

    function SeverityToInt($severity)

    {

    	$severities = array("DEBUG" => 0, "INFO" => 2, "WARN" => 3, "ERROR" => 4, "FATAL" => 5);

    	

    	return $severities[$severity];

    }

    

    function close()

    {

        if ($this->db !== null)

            $this->db->Close();

        $this->closed = true;

    }

    

    /**

     * @return boolean

     */

    function getCreateTable()

    {

        return $this->createTable;

    }

    

    /**

     * @return string the sql pattern string

     */

    function getSql()

    {

        return $this->sql;

    }

    

    /**

     * @return string the table name to create

     */

    function getTable()

    {

        return $this->table;

    }

    

    /**

     * @return string the database to connect to

     */

    function getDatabase() {

        return $this->database;

    }

    

    /**

     * @return string the database to connect to

     */

    function getHost() {

        return $this->host;

    }

    

    /**

     * @return string the user to connect with

     */

    function getUser() {

        return $this->user;

    }

    

    /**

     * @return string the password to connect with

     */

    function getPassword() {

        return $this->password;

    }

    

    /**

     * @return string the type of database to connect to

     */

    function getType() {

        return $this->type;

    }

    

    function setCreateTable($flag)

    {

        $this->createTable = LoggerOptionConverter::toBoolean($flag, true);

    }

    

    function setType($newType)

    {

        $this->type = $newType;

    }

    

    function setDatabase($newDatabase)

    {

        $this->database = $newDatabase;

    }

    

    function setHost($newHost)

    {

        $this->host = $newHost;

    }

    

    function setUser($newUser)

    {

        $this->user = $newUser;

    }

    

    function setPassword($newPassword)

    {

        $this->password = $newPassword;

    }

    

    function setSql($sql)

    {

        $this->sql = $sql;    

    }

    

    function setTable($table)

    {

        $this->table = $table;

    }

    

}

?>