diff options
Diffstat (limited to 'buildscripts/phing/classes/phing/tasks/ext/dbdeploy')
8 files changed, 0 insertions, 721 deletions
diff --git a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbDeployTask.php b/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbDeployTask.php deleted file mode 100755 index a5cc23ff..00000000 --- a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbDeployTask.php +++ /dev/null @@ -1,436 +0,0 @@ -<?php -/* - * $Id: 035d43c0c50ca9567e9c8a016fef6a3053164acb $ - * - * 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/Task.php'; -require_once 'phing/tasks/ext/dbdeploy/DbmsSyntaxFactory.php'; - - -/** - * Generate SQL script for db using dbdeploy schema version table - * and delta scripts - * - * <dbdeploy url="mysql:host=localhost;dbname=test" - * userid="dbdeploy" password="dbdeploy" dir="db" outputfile=""> - * - * @author Luke Crouch at SourceForge (http://sourceforge.net) - * @version $Id$ - * @package phing.tasks.ext.dbdeploy - */ -class DbDeployTask extends Task -{ - /** - * The tablename to use from the database for storing all changes - * This cannot be changed - * - * @var string - */ - public static $TABLE_NAME = 'changelog'; - - /** - * Connection string for the database connection - * - * @var string - */ - protected $url; - - /** - * The userid for the database connection - * - * @var string - */ - protected $userid; - - /** - * The password of the database user - * - * @var string - */ - protected $password; - - /** - * Path to the directory that holds the database patch files - * - * @var string - */ - protected $dir; - - /** - * Output file for performing all database patches of this deployment - * Contains all the SQL statements that need to be executed - * - * @var string - */ - protected $outputFile = 'dbdeploy_deploy.sql'; - - /** - * Outputfile for undoing the database patches of this deployment - * Contains all the SQL statements that need to be executed - * - * @var string - */ - protected $undoOutputFile = 'dbdeploy_undo.sql'; - - /** - * The deltaset that's being used - * - * @var string - */ - protected $deltaSet = 'Main'; - - /** - * The number of the last change to apply - * - * @var int - */ - protected $lastChangeToApply = 999; - - /** - * Contains the object for the DBMS that is used - * - * @var object - */ - protected $dbmsSyntax = null; - - /** - * Array with all change numbers that are applied already - * - * @var array - */ - protected $appliedChangeNumbers = array(); - - /** - * Checkall attribute - * False means dbdeploy will only apply patches that have a higher number - * than the last patchnumber that was applied - * True means dbdeploy will apply all changes that aren't applied - * already (in ascending order) - * - * @var int - */ - protected $checkall = false; - - /** - * The main function for the task - * - * @throws BuildException - * @return void - */ - public function main() - { - try { - // get correct DbmsSyntax object - $dbms = substr($this->url, 0, strpos($this->url, ':')); - $dbmsSyntaxFactory = new DbmsSyntaxFactory($dbms); - $this->dbmsSyntax = $dbmsSyntaxFactory->getDbmsSyntax(); - - // figure out which revisions are in the db already - $this->appliedChangeNumbers = $this->getAppliedChangeNumbers(); - $this->log('Current db revision: '.$this->getLastChangeAppliedInDb()); - $this->log('Checkall: ' . $this->checkall); - - $this->deploy(); - - } catch (Exception $e) { - throw new BuildException($e); - } - } - - /** - * Get the numbers of all the patches that are already applied according to - * the changelog table in the database - * - * @return array - */ - protected function getAppliedChangeNumbers() - { - if (count($this->appliedChangeNumbers) == 0) { - $this->log('Getting applied changed numbers from DB: ' . $this->url); - $appliedChangeNumbers = array(); - $dbh = new PDO($this->url, $this->userid, $this->password); - $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); - $sql = "SELECT * - FROM " . DbDeployTask::$TABLE_NAME . " - WHERE delta_set = '$this->deltaSet' - ORDER BY change_number"; - foreach ($dbh->query($sql) as $change) { - $appliedChangeNumbers[] = $change['change_number']; - } - $this->appliedChangeNumbers = $appliedChangeNumbers; - } - return $this->appliedChangeNumbers; - } - - /** - * Get the number of the last patch applied to the database - * - * @return int|mixed The highest patch number that is applied in the db - */ - protected function getLastChangeAppliedInDb() - { - return (count($this->appliedChangeNumbers) > 0) - ? max($this->appliedChangeNumbers) : 0; - } - - /** - * Create the deploy and undo deploy outputfiles - * - * @return void - */ - protected function deploy() - { - // create deploy outputfile - $this->createOutputFile($this->outputFile, false); - - // create undo deploy outputfile - $this->createOutputFile($this->undoOutputFile, true); - } - - /** - * Generate the sql for doing/undoing the deployment and write it to a file - * - * @param string $file - * @param bool $undo - * @return void - */ - protected function createOutputFile($file, $undo = false) - { - $fileHandle = fopen($file, "w+"); - $sql = $this->generateSql($undo); - fwrite($fileHandle, $sql); - } - - /** - * Generate the sql for doing/undoing this deployment - * - * @param bool $undo - * @return string The sql - */ - protected function generateSql($undo = false) - { - $sql = ''; - $lastChangeAppliedInDb = $this->getLastChangeAppliedInDb(); - $files = $this->getDeltasFilesArray(); - $this->sortFiles($files, $undo); - - foreach ($files as $fileChangeNumber => $fileName) { - if ($this->fileNeedsToBeRead($fileChangeNumber, $lastChangeAppliedInDb)) { - $sql .= '-- Fragment begins: ' . $fileChangeNumber . ' --' . "\n"; - - if (!$undo) { - $sql .= 'INSERT INTO ' . DbDeployTask::$TABLE_NAME . ' - (change_number, delta_set, start_dt, applied_by, description)' . - ' VALUES (' . $fileChangeNumber . ', \'' . $this->deltaSet . '\', ' . - $this->dbmsSyntax->generateTimestamp() . - ', \'dbdeploy\', \'' . $fileName . '\');' . "\n"; - } - - // read the file - $fullFileName = $this->dir . '/' . $fileName; - $fh = fopen($fullFileName, 'r'); - $contents = fread($fh, filesize($fullFileName)); - // allow construct with and without space added - $split = strpos($contents, '-- //@UNDO'); - if ($split === false) - $split = strpos($contents, '--//@UNDO'); - - if ($undo) { - $sql .= substr($contents, $split + 10) . "\n"; - $sql .= 'DELETE FROM ' . DbDeployTask::$TABLE_NAME . ' - WHERE change_number = ' . $fileChangeNumber . ' - AND delta_set = \'' . $this->deltaSet . '\';' . "\n"; - } else { - $sql .= substr($contents, 0, $split); - $sql .= 'UPDATE ' . DbDeployTask::$TABLE_NAME . ' - SET complete_dt = ' . $this->dbmsSyntax->generateTimestamp() . ' - WHERE change_number = ' . $fileChangeNumber . ' - AND delta_set = \'' . $this->deltaSet . '\';' . "\n"; - } - - $sql .= '-- Fragment ends: ' . $fileChangeNumber . ' --' . "\n"; - } - } - - return $sql; - } - - /** - * Get a list of all the patch files in the patch file directory - * - * @return array - */ - protected function getDeltasFilesArray() - { - $files = array(); - $baseDir = realpath($this->dir); - $dh = opendir($baseDir); - $fileChangeNumberPrefix = ''; - while (($file = readdir($dh)) !== false) { - if (preg_match('[\d+]', $file, $fileChangeNumberPrefix)) { - $files[intval($fileChangeNumberPrefix[0])] = $file; - } - } - return $files; - } - - /** - * Sort files in the patch files directory (ascending or descending depending on $undo boolean) - * - * @param array $files - * @param bool $undo - * @return void - */ - protected function sortFiles(&$files, $undo) - { - if ($undo) { - krsort($files); - } else { - ksort($files); - } - } - - /** - * Determine if this patch file need to be deployed - * (using fileChangeNumber, lastChangeAppliedInDb and $this->checkall) - * - * @param int $fileChangeNumber - * @param string $lastChangeAppliedInDb - * @return bool True or false if patch file needs to be deployed - */ - protected function fileNeedsToBeRead($fileChangeNumber, $lastChangeAppliedInDb) - { - if ($this->checkall) { - return (!in_array($fileChangeNumber, $this->appliedChangeNumbers)); - } else { - return ($fileChangeNumber > $lastChangeAppliedInDb && $fileChangeNumber <= $this->lastChangeToApply); - } - } - - /** - * Set the url for the database connection - * - * @param string $url - * @return void - */ - public function setUrl($url) - { - $this->url = $url; - } - - /** - * Set the userid for the database connection - * - * @param string $userid - * @return void - */ - public function setUserId($userid) - { - $this->userid = $userid; - } - - /** - * Set the password for the database connection - * - * @param string $password - * @return void - */ - public function setPassword($password) - { - $this->password = $password; - } - - /** - * Set the directory where to find the patchfiles - * - * @param string $dir - * @return void - */ - public function setDir($dir) - { - $this->dir = $dir; - } - - /** - * Set the outputfile which contains all patch sql statements for this deployment - * - * @param string $outputFile - * @return void - */ - public function setOutputFile($outputFile) - { - $this->outputFile = $outputFile; - } - - /** - * Set the undo outputfile which contains all undo statements for this deployment - * - * @param string $undoOutputFile - * @return void - */ - public function setUndoOutputFile($undoOutputFile) - { - $this->undoOutputFile = $undoOutputFile; - } - - /** - * Set the lastchangetoapply property - * - * @param int $lastChangeToApply - * @return void - */ - public function setLastChangeToApply($lastChangeToApply) - { - $this->lastChangeToApply = $lastChangeToApply; - } - - /** - * Set the deltaset property - * - * @param string $deltaSet - * @return void - */ - public function setDeltaSet($deltaSet) - { - $this->deltaSet = $deltaSet; - } - - /** - * Set the checkall property - * - * @param bool $checkall - * @return void - */ - public function setCheckAll($checkall) - { - $this->checkall = (int)$checkall; - } - - /** - * Add a new fileset. - * @return FileSet - */ - public function createFileSet() - { - $this->fileset = new FileSet(); - $this->filesets[] = $this->fileset; - return $this->fileset; - } -} - diff --git a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntax.php b/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntax.php deleted file mode 100755 index f20d2df4..00000000 --- a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntax.php +++ /dev/null @@ -1,34 +0,0 @@ -<?php -/* - * $Id: 40826765e423da7500094b84f0025f75c8fdde87 $ - * - * 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>. - */ - -/** - * Utility class for generating necessary server-specific SQL commands - * - * @author Luke Crouch at SourceForge (http://sourceforge.net) - * @version $Id$ - * @package phing.tasks.ext.dbdeploy - */ - -abstract class DbmsSyntax -{ - public abstract function generateTimestamp(); -} - diff --git a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxFactory.php b/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxFactory.php deleted file mode 100755 index 1cc163f5..00000000 --- a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxFactory.php +++ /dev/null @@ -1,67 +0,0 @@ -<?php -/* - * $Id: 0efe41b73233dd4396055518a125e4ff642693c5 $ - * - * 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/Task.php'; -require_once 'phing/tasks/ext/dbdeploy/DbmsSyntax.php'; - -/** - * Factory for generating dbms-specific syntax-generating objects - * - * @author Luke Crouch at SourceForge (http://sourceforge.net) - * @version $Id$ - * @package phing.tasks.ext.dbdeploy - */ - -class DbmsSyntaxFactory -{ - private $dbms; - - public function __construct($dbms) - { - $this->dbms = $dbms; - } - - public function getDbmsSyntax() - { - switch ($this->dbms){ - case('sqlite') : - require_once 'phing/tasks/ext/dbdeploy/DbmsSyntaxSQLite.php'; - return new DbmsSyntaxSQLite(); - case('mysql'): - require_once 'phing/tasks/ext/dbdeploy/DbmsSyntaxMysql.php'; - return new DbmsSyntaxMysql(); - case 'odbc': - case('mssql'): - case 'dblib': - require_once 'phing/tasks/ext/dbdeploy/DbmsSyntaxMsSql.php'; - return new DbmsSyntaxMsSql(); - case('pgsql'): - require_once 'phing/tasks/ext/dbdeploy/DbmsSyntaxPgSQL.php'; - return new DbmsSyntaxPgSQL(); - case 'oci': - require_once 'phing/tasks/ext/dbdeploy/DbmsSyntaxOracle.php'; - return new DbmsSyntaxOracle(); - default: - throw new Exception($this->dbms . ' is not supported by dbdeploy task.'); - } - } -} - diff --git a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxMsSql.php b/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxMsSql.php deleted file mode 100755 index 0b505d8e..00000000 --- a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxMsSql.php +++ /dev/null @@ -1,37 +0,0 @@ -<?php -/* - * $Id: 10012c2626ef9befc8c18efa5898704e269d6164 $ - * - * 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>. - */ - -/** - * Utility class for generating necessary server-specific SQL commands - * - * @author Luke Crouch at SourceForge (http://sourceforge.net) - * @version $Id$ - * @package phing.tasks.ext.dbdeploy - */ - -class DbmsSyntaxMsSql extends DbmsSyntax -{ - public function generateTimestamp() - { - return "DATEDIFF(s, '19700101', GETDATE())"; - } -} - diff --git a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxMysql.php b/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxMysql.php deleted file mode 100755 index 86bf8ae0..00000000 --- a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxMysql.php +++ /dev/null @@ -1,37 +0,0 @@ -<?php -/* - * $Id: 3a8bab5e99f20e29f5c7dfe7d02f7a91fb8ccecd $ - * - * 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>. - */ - -/** - * Utility class for generating necessary server-specific SQL commands - * - * @author Luke Crouch at SourceForge (http://sourceforge.net) - * @version $Id$ - * @package phing.tasks.ext.dbdeploy - */ - -class DbmsSyntaxMysql extends DbmsSyntax -{ - public function generateTimestamp() - { - return "NOW()"; - } -} - diff --git a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxOracle.php b/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxOracle.php deleted file mode 100755 index 15b0b0a0..00000000 --- a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxOracle.php +++ /dev/null @@ -1,37 +0,0 @@ -<?php -/* - * $Id: be6f99d787b94f7f2c1c8e359def3d465386bba9 $ - * - * 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>. - */ - -/** - * Utility class for generating necessary server-specific SQL commands - * - * @author Luke Crouch at SourceForge (http://sourceforge.net) - * @version $Id$ - * @package phing.tasks.ext.dbdeploy - */ - -class DbmsSyntaxOracle extends DbmsSyntax -{ - public function generateTimestamp() - { - return "(sysdate - to_date('01-JAN-1970','DD-MON-YYYY')) * (86400)"; - } -} - diff --git a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxPgSQL.php b/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxPgSQL.php deleted file mode 100755 index 6c07931c..00000000 --- a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxPgSQL.php +++ /dev/null @@ -1,36 +0,0 @@ -<?php -/* - * $Id: 17845f06b311dbe508e7cb1244cd849a1d3fcada $ - * - * 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>. - */ - -/** - * Utility class for generating necessary server-specific SQL commands - * - * @author R�my BREUILS - * @version $Id$ - * @package phing.tasks.ext.dbdeploy - */ -class DbmsSyntaxPgSQL extends DbmsSyntax -{ - public function generateTimestamp() - { - return "NOW()"; - } -} - diff --git a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxSQLite.php b/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxSQLite.php deleted file mode 100755 index 32aa023e..00000000 --- a/buildscripts/phing/classes/phing/tasks/ext/dbdeploy/DbmsSyntaxSQLite.php +++ /dev/null @@ -1,37 +0,0 @@ -<?php -/* - * $Id: a48723b4c3ef1e5c15417f5ea6e495960e5e018b $ - * - * 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>. - */ - -/** - * Utility class for generating necessary server-specific SQL commands - * - * @author Luke Crouch at SourceForge (http://sourceforge.net) - * @version $Id$ - * @package phing.tasks.ext.dbdeploy - */ - -class DbmsSyntaxSQLite extends DbmsSyntax -{ - public function generateTimestamp() - { - return "strftime('%s','now')"; - } -} - |