/exchange/code/trunk/administrator/components/com_exchange/models/transforms/sql.php

<?php
/**
 * @version		$Id: sql.php 280 2010-09-18 02:14:15Z eddieajau $
 * @package		NewLifeInIT
 * @subpackage	com_exchange
 * @copyright	Copyright 2005 - 2010 New Life in IT Pty Ltd. All rights reserved.
 * @license		GNU General Public License version 2 or later.
 * @link		http://www.theartofjoomla.com
 */

// no direct access
defined('_JEXEC') or die;

/**
 * @package		NewLifeInIT
 * @subpackage	com_exchange
 */
class XMLTransformSQL extends XMLIterator
{
	/**
	 * Evaluates an expression
	 * @param	object	The tag node
	 * @param	mixed	The value of the field
	 */
	function iterate(&$node, &$value)
	{
		$query		= (string) $node;
		if (trim($query))
		{
			$model		= &$this->getModel();
			$logQueries	= $model->getOption('log_queries');

			$test	= $model->getOption('test_mode', XMLHelper::isBool((string) $node['test']));
			$db		= &$model->getDestDBO();
			$db->setQuery($query);
			if ($logQueries) {
				ExchangeLog::add(0, $db->getQuery());
			}
			if (!$test) {
				if (!$db->query()) {
					ExchangeLog::add(500, ' '.$db->getErrorMsg(), true);
				}
			}
		}
	}
}