Viewing file: PlainPDOResultFormatter.php (3.36 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php /** * $Id: PlainPDOResultFormatter.php 552 2009-08-29 12:18:13Z 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';
/** * Plain text formatter for PDO results. * * @author Hans Lellelid <hans@xmpl.org> * @package phing.tasks.ext.pdo * @since 2.3.0 */ class PlainPDOResultFormatter extends PDOResultFormatter { /** * Have column headers been printed? * @var boolean */ private $colsprinted = false;
/** * Whether to show headers. * @var boolean */ private $showheaders = true;
/** * Column delimiter. * Defaults to ',' * @var string */ private $coldelimiter = ",";
/** * Row delimiter. * Defaults to PHP_EOL. * @var string */ private $rowdelimiter = PHP_EOL;
/** * Set the showheaders attribute. * @param boolean $v */ public function setShowheaders($v) { $this->showheaders = StringHelper::booleanValue($v); }
/** * Sets the column delimiter. * @param string $v */ public function setColdelim($v) { $this->coldelimiter = $v; }
/** * Sets the row delimiter. * @param string $v */ public function setRowdelim($v) { $this->rowdelimiter = $v; }
/** * Processes a specific row from PDO result set. * * @param array $row Row of PDO result set. */ public function processRow($row) {
if (!$this->colsprinted && $this->showheaders) { $first = true; foreach($row as $fieldName => $ignore) { if ($first) $first = false; else $line .= ","; $line .= $fieldName; }
$this->out->write($line); $this->out->write(PHP_EOL);
$line = ""; $colsprinted = true; } // if show headers
$first = true; foreach($row as $columnValue) {
if ($columnValue != null) { $columnValue = trim($columnValue); }
if ($first) { $first = false; } else { $line .= $this->coldelimiter; } $line .= $columnValue; } $this->out->write($line); $this->out->write($this->rowdelimiter);
}
public function getPreferredOutfile() { return new PhingFile('results.txt'); } }
|