<?php
/**
* Zend Framework (http://framework.zend.com/)
*
* @link http://github.com/zendframework/zf2 for the canonical source repository
* @copyright Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
* @license http://framework.zend.com/license/new-bsd New BSD License
*/
namespace Zend\Db\Sql;
class Expression implements ExpressionInterface
{
/**
* @const
*/
const PLACEHOLDER = '?';
/**
* @var string
*/
protected $expression = '';
/**
* @var array
*/
protected $parameters = array();
/**
* @var array
*/
protected $types = array();
/**
* @param string $expression
* @param string|array $parameters
* @param array $types
*/
public function __construct($expression = '', $parameters = null, array $types = array())
{
if ($expression) {
$this->setExpression($expression);
}
if ($parameters) {
$this->setParameters($parameters);
}
if ($types) {
$this->setTypes($types);
}
}
/**
* @param $expression
* @return Expression
* @throws Exception\InvalidArgumentException
*/
public function setExpression($expression)
{
if (!is_string($expression) || $expression == '') {
throw new Exception\InvalidArgumentException('Supplied expression must be a string.');
}
$this->expression = $expression;
return $this;
}
/**
* @return string
*/
public function getExpression()
{
return $this->expression;
}
/**
* @param $parameters
* @return Expression
* @throws Exception\InvalidArgumentException
*/
public function setParameters($parameters)
{
if (!is_scalar($parameters) && !is_array($parameters)) {
throw new Exception\InvalidArgumentException('Expression parameters must be a scalar or array.');
}
$this->parameters = $parameters;
return $this;
}
/**
* @return array
*/
public function getParameters()
{
return $this->parameters;
}
/**
* @param array $types
* @return Expression
*/
public function setTypes(array $types)
{
$this->types = $types;
return $this;
}
/**
* @return array
*/
public function getTypes()
{
return $this->types;
}
/**
* @return array
* @throws Exception\RuntimeException
*/
public function getExpressionData()
{
$parameters = (is_scalar($this->parameters)) ? array($this->parameters) : $this->parameters;
$types = array();
$parametersCount = count($parameters);
if ($parametersCount == 0 && strpos($this->expression, self::PLACEHOLDER) !== false) {
// if there are no parameters, but there is a placeholder
$parametersCount = substr_count($this->expression, self::PLACEHOLDER);
$parameters = array_fill(0, $parametersCount, null);
}
for ($i = 0; $i < $parametersCount; $i++) {
$types[$i] = (isset($this->types[$i]) && ($this->types[$i] == self::TYPE_IDENTIFIER || $this->types[$i] == self::TYPE_LITERAL))
? $this->types[$i] : self::TYPE_VALUE;
}
// assign locally, escaping % signs
$expression = str_replace('%', '%%', $this->expression);
if ($parametersCount > 0) {
$count = 0;
$expression = str_replace(self::PLACEHOLDER, '%s', $expression, $count);
if ($count !== $parametersCount) {
throw new Exception\RuntimeException('The number of replacements in the expression does not match the number of parameters');
}
}
return array(array(
$expression,
$parameters,
$types
));
}
}
# |
Change |
User |
Description |
Committed |
|
#1
|
18334 |
Liz Lam |
initial add of jambox |
|
|