本文整理汇总了PHP中Doctrine\ORM\Query\SqlWalker类的典型用法代码示例。如果您正苦于以下问题:PHP SqlWalker类的具体用法?PHP SqlWalker怎么用?PHP SqlWalker使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了SqlWalker类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: getSql
public function getSql(SqlWalker $sqlWalker)
{
$args = array_map(function ($value) use($sqlWalker) {
return $sqlWalker->walkArithmeticPrimary($value);
}, $this->values);
return 'GREATEST(' . implode(', ', $args) . ')';
}
开发者ID:v3labs,项目名称:doctrine-extensions,代码行数:7,代码来源:LeastFunction.php
示例2: getSql
/**
* @param \Doctrine\ORM\Query\SqlWalker $sqlWalker
*
* @return string
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
// use second parameter if parsed
if (null !== $this->fmt) {
return sprintf('TRUNC(%s, %s)', $sqlWalker->walkArithmeticPrimary($this->date), $sqlWalker->walkArithmeticPrimary($this->fmt));
}
return sprintf('TRUNC(%s)', $sqlWalker->walkArithmeticPrimary($this->date));
}
开发者ID:AlboVieira,项目名称:aplicacaozend,代码行数:13,代码来源:Trunc.php
示例3: getSql
/**
* @override
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
$platform = $sqlWalker->getConnection()->getDatabasePlatform();
if (!method_exists($platform, 'getStringAgg')) {
return $sqlWalker->walkStringPrimary($this->firstStringPrimary);
}
return $platform->getStringAgg($sqlWalker->walkStringPrimary($this->firstStringPrimary), $sqlWalker->walkStringPrimary($this->secondStringPrimary));
}
开发者ID:sgdoc,项目名称:sgdoce-codigo,代码行数:11,代码来源:StringAggFunction.php
示例4: getSql
/**
* {@inheritdoc}
*/
public function getSql(SqlWalker $sqlWalker)
{
$stringPrimary = $sqlWalker->walkStringPrimary($this->stringPrimary);
$platform = $sqlWalker->getConnection()->getDatabasePlatform();
$trimMode = $this->getTrimMode();
$trimChar = $this->trimChar !== false ? $sqlWalker->getConnection()->quote($this->trimChar) : false;
return $platform->getTrimExpression($stringPrimary, $trimMode, $trimChar);
}
开发者ID:Dren-x,项目名称:mobit,代码行数:11,代码来源:TrimFunction.php
示例5: getSql
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
$secondArgument = '';
if ($this->optionalSecondExpression) {
$secondArgument = $sqlWalker->walkSimpleArithmeticExpression($this->optionalSecondExpression);
}
return 'ATAN(' . $sqlWalker->walkSimpleArithmeticExpression($this->arithmeticExpression) . ($secondArgument ? ', ' . $secondArgument : '') . ')';
}
开发者ID:uppaljs,项目名称:pakistan-vlmis-v2,代码行数:8,代码来源:Atan.php
示例6: getSql
public function getSql(SqlWalker $sqlWalker)
{
$args = array_map(function ($value) use($sqlWalker) {
$nodeSql = $sqlWalker->walkArithmeticPrimary($value);
return $this->notEmpty ? sprintf("NULLIF(%s, '')", $nodeSql) : $nodeSql;
}, $this->values);
return 'CONCAT_WS(' . implode(', ', $args) . ')';
}
开发者ID:v3labs,项目名称:doctrine-extensions,代码行数:8,代码来源:ConcatWs.php
示例7: getSql
/**
* @param SqlWalker $sqlWalker
* @return string
*/
public function getSql(SqlWalker $sqlWalker)
{
$args = array();
foreach ($this->concatExpressions as $expression) {
$args[] = $sqlWalker->walkStringPrimary($expression);
}
return 'CONCAT_WS(' . join(', ', (array) $args) . ')';
}
开发者ID:glauberkyves,项目名称:mysql-functions-doctrine2,代码行数:12,代码来源:MysqlConcatWs.php
示例8: getSql
/**
* @param SqlWalker $sqlWalker
*
* @return string
*/
public function getSql(SqlWalker $sqlWalker)
{
$this->validatePlatform($sqlWalker->getConnection()->getDatabasePlatform());
if ($this->optionalExpression) {
return sprintf('%s(%s, %s, %s)', $this->functionName, $this->firstGeomExpression->dispatch($sqlWalker), $this->secondGeomExpression->dispatch($sqlWalker), $this->optionalExpression->dispatch($sqlWalker));
}
return sprintf('%s(%s, %s)', $this->functionName, $this->firstGeomExpression->dispatch($sqlWalker), $this->secondGeomExpression->dispatch($sqlWalker));
}
开发者ID:raketman,项目名称:doctrine2-spatial,代码行数:13,代码来源:AbstractDualGeometryOptionalParameterDQLFunction.php
示例9: getSql
/**
* @override
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
$platform = $sqlWalker->getConnection()->getDatabasePlatform();
$strings = array_map(function ($v) use($sqlWalker) {
return $sqlWalker->walkStringPrimary($v);
}, $this->strings);
return call_user_func_array(array($platform, 'getConcatExpression'), $strings);
}
开发者ID:saberyounis,项目名称:Sonata-Project,代码行数:11,代码来源:MultiConcatFunction.php
示例10: getSql
/**
* @param \Doctrine\ORM\Query\SqlWalker $sqlWalker
* @return string
*/
public function getSql(SqlWalker $sqlWalker)
{
$platform = $sqlWalker->getConnection()->getDatabasePlatform();
if ($platform instanceof PostgreSqlPlatform) {
return $this->getPostgreSql($sqlWalker);
}
throw new NotImplementedException();
}
开发者ID:carrooi,项目名称:doctrine,代码行数:12,代码来源:Field.php
示例11: getSql
/**
* @override
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
$optionalSecondSimpleArithmeticExpression = null;
if ($this->secondSimpleArithmeticExpression !== null) {
$optionalSecondSimpleArithmeticExpression = $sqlWalker->walkSimpleArithmeticExpression($this->secondSimpleArithmeticExpression);
}
return $sqlWalker->getConnection()->getDatabasePlatform()->getSubstringExpression($sqlWalker->walkStringPrimary($this->stringPrimary), $sqlWalker->walkSimpleArithmeticExpression($this->firstSimpleArithmeticExpression), $optionalSecondSimpleArithmeticExpression);
}
开发者ID:yamildiego,项目名称:JY,代码行数:11,代码来源:SubstringFunction.php
示例12: getSql
/**
* {@inheritdoc}
*/
public function getSql(SqlWalker $sqlWalker)
{
$strings = array();
$stringExpressions = $this->parameters[Base::STRINGS_KEY];
foreach ($stringExpressions as $stringExp) {
$strings[] = $sqlWalker->walkStringPrimary($stringExp);
}
return sprintf('CONCAT_WS(%s, %s)', $sqlWalker->walkStringPrimary($this->parameters[Base::SEPARATOR_KEY]), implode(', ', $strings));
}
开发者ID:Hikariii,项目名称:doctrine-extensions,代码行数:12,代码来源:ConcatWs.php
示例13: getSql
/**
* {@inheritdoc}
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
$strings = array();
$stringExpressions = $this->parameters['strings'];
foreach ($stringExpressions as $stringExp) {
$strings[] = $sqlWalker->walkStringPrimary($stringExp);
}
return sprintf('CONCAT_WS(%s, %s)', $sqlWalker->walkStringPrimary($this->parameters['separator']), implode(', ', $strings));
}
开发者ID:m3uzz,项目名称:onionfw,代码行数:12,代码来源:ConcatWs.php
示例14: getSql
/**
* @override
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
//TODO: Use platform to get SQL
$sql = 'LOCATE(' . $sqlWalker->walkStringPrimary($this->_firstStringPrimary) . ', ' . $sqlWalker->walkStringPrimary($this->_secondStringPrimary);
if ($this->_simpleArithmeticExpression) {
$sql .= ', ' . $sqlWalker->walkSimpleArithmeticExpression($this->_simpleArithmeticExpression);
}
return $sql . ')';
}
开发者ID:jackbravo,项目名称:doctrine,代码行数:12,代码来源:LocateFunction.php
示例15: getSql
/**
* @override
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
$sql = "WEEK(" . $sqlWalker->walkArithmeticPrimary($this->date);
if ($this->mode != null) {
$sql .= ", " . $sqlWalker->walkLiteral($this->mode);
}
$sql .= ")";
return $sql;
}
开发者ID:uppaljs,项目名称:pakistan-vlmis-v2,代码行数:12,代码来源:Week.php
示例16: getSql
/**
* @override
*/
public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
{
$platform = $sqlWalker->getConnection()->getDatabasePlatform();
$args = array();
foreach ($this->concatExpressions as $expression) {
$args[] = $sqlWalker->walkStringPrimary($expression);
}
return call_user_func_array(array($platform, 'getConcatExpression'), $args);
}
开发者ID:alfredocoj,项目名称:blogzf2tutorial,代码行数:12,代码来源:ConcatFunction.php
示例17: getSql
public function getSql(SqlWalker $sqlWalker)
{
$driver = $sqlWalker->getConnection()->getDriver()->getName();
if ($driver == 'pdo_sqlite') {
return sprintf("CAST(STRFTIME('%s', %s) AS INTEGER)", $this->formats[$this->field], $this->source->dispatch($sqlWalker));
} else {
return sprintf('EXTRACT(%s FROM %s %s)', $this->field, (string) $this->type, $this->source->dispatch($sqlWalker));
}
}
开发者ID:ec-cube,项目名称:ec-cube,代码行数:9,代码来源:Extract.php
示例18: getSql
/**
* @param SqlWalker $sqlWalker
*
* @return string
*/
public function getSql(SqlWalker $sqlWalker)
{
$this->validatePlatform($sqlWalker->getConnection()->getDatabasePlatform());
$result = sprintf('%s(%s', $this->functionName, $this->geomExpr[0]->dispatch($sqlWalker));
for ($i = 1, $size = count($this->geomExpr); $i < $size; $i++) {
$result .= ', ' . $this->geomExpr[$i]->dispatch($sqlWalker);
}
$result .= ')';
return $result;
}
开发者ID:peuh,项目名称:doctrine2-spatial,代码行数:15,代码来源:AbstractSpatialDQLFunction.php
示例19: __construct
/**
* @param \Doctrine\ORM\Query\AST\Node $AST
* @param \Doctrine\ORM\Query\SqlWalker $sqlWalker
*/
public function __construct(AST\Node $AST, $sqlWalker)
{
if ($AST instanceof AST\UpdateStatement) {
$this->_sqlStatements = $sqlWalker->walkUpdateStatement($AST);
} else {
if ($AST instanceof AST\DeleteStatement) {
$this->_sqlStatements = $sqlWalker->walkDeleteStatement($AST);
}
}
}
开发者ID:neteasy-work,项目名称:hkgbf_crm,代码行数:14,代码来源:SingleTableDeleteUpdateExecutor.php
示例20: getSql
/**
* {@inheritdoc}
*/
public function getSql(SqlWalker $sqlWalker)
{
// This type is defined by ANSI SQL
$targetType = 'VARCHAR';
// MySQL needs a CHAR type for string conversion (http://dev.mysql.com/doc/refman/5.7/en/type-conversion.html)
if ($sqlWalker->getConnection()->getDatabasePlatform()->getName() === 'mysql') {
$targetType = 'CHAR';
}
return 'CAST(' . $sqlWalker->walkSimpleArithmeticExpression($this->stringPrimary) . ' AS ' . $targetType . ')';
}
开发者ID:robertlemke,项目名称:neos-development-collection,代码行数:13,代码来源:ToStringFunction.php
注:本文中的Doctrine\ORM\Query\SqlWalker类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论