123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 |
- <?php
- /**
- * @link http://www.yiiframework.com/
- * @copyright Copyright (c) 2008 Yii Software LLC
- * @license http://www.yiiframework.com/license/
- */
- namespace yii\db\pgsql;
- use yii\db\ArrayExpression;
- use yii\db\ExpressionBuilderInterface;
- use yii\db\ExpressionBuilderTrait;
- use yii\db\ExpressionInterface;
- use yii\db\JsonExpression;
- use yii\db\Query;
- use yii\helpers\Json;
- /**
- * Class JsonExpressionBuilder builds [[JsonExpression]] for PostgreSQL DBMS.
- *
- * @author Dmytro Naumenko <d.naumenko.a@gmail.com>
- * @since 2.0.14
- */
- class JsonExpressionBuilder implements ExpressionBuilderInterface
- {
- use ExpressionBuilderTrait;
- /**
- * {@inheritdoc}
- * @param JsonExpression|ExpressionInterface $expression the expression to be built
- */
- public function build(ExpressionInterface $expression, array &$params = [])
- {
- $value = $expression->getValue();
- if ($value instanceof Query) {
- list ($sql, $params) = $this->queryBuilder->build($value, $params);
- return "($sql)" . $this->getTypecast($expression);
- }
- if ($value instanceof ArrayExpression) {
- $placeholder = 'array_to_json(' . $this->queryBuilder->buildExpression($value, $params) . ')';
- } else {
- $placeholder = $this->queryBuilder->bindParam(Json::encode($value), $params);
- }
- return $placeholder . $this->getTypecast($expression);
- }
- /**
- * @param JsonExpression $expression
- * @return string the typecast expression based on [[type]].
- */
- protected function getTypecast(JsonExpression $expression)
- {
- if ($expression->getType() === null) {
- return '';
- }
- return '::' . $expression->getType();
- }
- }
|