From 63d6e6dfc35e6d82c4a64f37c408794c163becd4 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Wed, 28 Sep 2011 15:16:41 -0400 Subject: [PATCH] Bump versions to 0.6 stable --- program/lib/MDB2/Driver/Function/Common.php | 52 ++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 48 insertions(+), 4 deletions(-) diff --git a/program/lib/MDB2/Driver/Function/Common.php b/program/lib/MDB2/Driver/Function/Common.php index 74971e2..7892255 100644 --- a/program/lib/MDB2/Driver/Function/Common.php +++ b/program/lib/MDB2/Driver/Function/Common.php @@ -42,7 +42,7 @@ // | Author: Lukas Smith <smith@pooteeweet.org> | // +----------------------------------------------------------------------+ // -// $Id: Common.php,v 1.19 2007/09/09 13:47:36 quipo Exp $ +// $Id: Common.php 292715 2009-12-28 14:06:34Z quipo $ // /** @@ -57,9 +57,9 @@ * To load this module in the MDB2 object: * $mdb->loadModule('Function'); * - * @package MDB2 + * @package MDB2 * @category Database - * @author Lukas Smith <smith@pooteeweet.org> + * @author Lukas Smith <smith@pooteeweet.org> */ class MDB2_Driver_Function_Common extends MDB2_Module_Common { @@ -74,6 +74,7 @@ * the result set * @param mixed $result_class string which specifies which result class to use * @param mixed $result_wrap_class string which specifies which class to wrap results in + * * @return mixed a result handle or MDB2_OK on success, a MDB2 error on failure * @access public */ @@ -113,6 +114,8 @@ * - CURRENT_DATE (date, DATE type) * - CURRENT_TIME (time, TIME type) * + * @param string $type 'timestamp' | 'time' | 'date' + * * @return string to call a variable with the current timestamp * @access public */ @@ -130,6 +133,29 @@ } // }}} + // {{{ unixtimestamp() + + /** + * return string to call a function to get the unix timestamp from a iso timestamp + * + * @param string $expression + * + * @return string to call a variable with the timestamp + * @access public + */ + function unixtimestamp($expression) + { + $db =& $this->getDBInstance(); + if (PEAR::isError($db)) { + return $db; + } + + $error =& $db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null, + 'method not implemented', __FUNCTION__); + return $error; + } + + // }}} // {{{ substring() /** @@ -140,10 +166,24 @@ */ function substring($value, $position = 1, $length = null) { - if (!is_null($length)) { + if (null !== $length) { return "SUBSTRING($value FROM $position FOR $length)"; } return "SUBSTRING($value FROM $position)"; + } + + // }}} + // {{{ replace() + + /** + * return string to call a function to get replace inside an SQL statement. + * + * @return string to call a function to get a replace + * @access public + */ + function replace($str, $from_str, $to_str) + { + return "REPLACE($str, $from_str , $to_str)"; } // }}} @@ -155,6 +195,7 @@ * @param string $value1 * @param string $value2 * @param string $values... + * * @return string to concatenate two strings * @access public */ @@ -185,6 +226,7 @@ * return string to call a function to lower the case of an expression * * @param string $expression + * * @return return string to lower case of an expression * @access public */ @@ -200,6 +242,7 @@ * return string to call a function to upper the case of an expression * * @param string $expression + * * @return return string to upper case of an expression * @access public */ @@ -215,6 +258,7 @@ * return string to call a function to get the length of a string expression * * @param string $expression + * * @return return string to get the string expression length * @access public */ -- Gitblit v1.9.1