Subversion-Projekte lars-tiefland.php_share

<?php
/**
 * $Id: FormatterElement.php 148 2007-02-13 11:15:53Z mrook $
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the LGPL. For more information please see
 * <http://phing.info>.
 */

require_once 'phing/system/io/PhingFile.php';
require_once 'phing/tasks/ext/pdo/PDOResultFormatter.php';

/**
 * XML formatter for PDO results.
 * 
 * This class reprsents the output of a query using a simple XML schema.
 * 
 * <results>
 *      <row>
 *       <col name="id">value</col>
 *       <col name="name">value2</col>
 *  </row>
 *  <row>
 *   <col name="id">value</col>
 *       <col name="name">value2</col>
 *  </row>
 * </results>
 *
 * The actual names of the colums will depend on the fetchmode that was used
 * with PDO.
 * 
 * @author Hans Lellelid <hans@xmpl.org>
 * @package phing.tasks.ext.pdo
 * @since 2.3.0
 */
class XMLPDOResultFormatter extends PDOResultFormatter {

        /**
         * The XML document being created.
         * @var DOMDocument
         */
        private $doc;

        /**
         * @var DOMElement
         */
        private $rootNode;

        /**
         * XML document encoding
         *
         * @var string
         */
        private $encoding;

        /**
         * @var boolean
         */
        private $formatOutput = true;
        
        /**
         * Set the DOM document encoding.
         * @param string $v
         */
        public function setEncoding($v) {
                $this->encoding = $v;
        }
        
        /**
         * @param boolean $v
         */
        public function setFormatOutput($v) {
                $this->formatOutput = (boolean) $v;
        }

        public function initialize() {
                $this->doc = new DOMDocument("1.0", $this->encoding);
                $this->rootNode = $this->doc->createElement('results');
                $this->doc->appendChild($this->rootNode);
                $this->doc->formatOutput = $this->formatOutput;
        }
        
        /**
         * Processes a specific row from PDO result set.
         *
         * @param array $row Row of PDO result set.
         */
        public function processRow($row) {
                
                $rowNode = $this->doc->createElement('row');
                $this->rootNode->appendChild($rowNode);

                foreach($row as $columnName => $columnValue) {
                        
                        $colNode = $this->doc->createElement('column');
                        $colNode->setAttribute('name', $columnName);
                        
                        if ($columnValue != null) {
                                $columnValue = trim($columnValue);
                                $colNode->nodeValue = $columnValue;
                        }
                        $rowNode->appendChild($colNode);
                }
                
        }
        
        /**
         * Gets a preferred filename for an output file.
         * 
         * If no filename is specified, this is where the results will be placed
         * (unless usefile=false).
         * 
         * @return string
         */
        public function getPreferredOutfile()
        {
                return new PhingFile('results.xml');
        }
        
        /**
         * Write XML to file and free the DOM objects.
         */
        public function close() {
                $this->out->write($this->doc->saveXML());
                $this->rootNode = null;
                $this->doc = null;
                parent::close();
        }
}