1 files changed, 130 insertions, 0 deletions
diff --git a/buildscripts/phing/classes/phing/tasks/ext/pdo/PlainPDOResultFormatter.php b/buildscripts/phing/classes/phing/tasks/ext/pdo/PlainPDOResultFormatter.php
new file mode 100644
index 00000000..3aad8ec8
--- /dev/null
+++ b/buildscripts/phing/classes/phing/tasks/ext/pdo/PlainPDOResultFormatter.php
@@ -0,0 +1,130 @@
+<?php
+/**
+ * $Id: 0b899576769e68651a8847db8db8941aa4d784a2 $
+ *
+ * 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');
+    }
+    
+}