| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 | <?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();    }}
 |