12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 |
- <?php
- namespace yii\db\mysql;
- 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 implements ExpressionBuilderInterface
- {
- use ExpressionBuilderTrait;
- const PARAM_PREFIX = ':qp';
-
- public function build(ExpressionInterface $expression, array &$params = [])
- {
- $value = $expression->getValue();
- if ($value instanceof Query) {
- list ($sql, $params) = $this->queryBuilder->build($value, $params);
- return "($sql)";
- }
- $placeholder = static::PARAM_PREFIX . count($params);
- $params[$placeholder] = Json::encode($value);
- return "CAST($placeholder AS JSON)";
- }
- }
|