コード例 #1
0
 /**
  * Expression constructor.
  * @param PixelDb $db
  * @param string $column Column to order.
  * @param string $direction The direction of the order.
  * @param bool $first True if its the first order by expression.
  */
 public function __construct(PixelDb $db, $column, $direction = self::ORDER_DIRECTION_ASCENDING, $first = true)
 {
     parent::__construct($db);
     if ($first) {
         $db->getSqlBuffer()->append(' ORDER BY ');
     } else {
         $db->getSqlBuffer()->append(', ');
     }
     $db->getSqlBuffer()->append($column . ' ' . $direction);
 }
コード例 #2
0
 /**
  * SelectExpression constructor.
  * @param PixelDb $db
  * @param string[] $fields List of fields to select.
  * @param string $prefix Prefix for the fields. Useful for full field name.
  * @param bool $first True to include SELECT FROM.
  */
 public function __construct(PixelDb $db, $fields, $prefix = '', $first = true)
 {
     parent::__construct($db);
     if ($first) {
         $db->getSqlBuffer()->append('SELECT ');
     } else {
         $db->getSqlBuffer()->append(', ');
     }
     if ($prefix != '') {
         $prefixedFields = [];
         foreach ($fields as $field) {
             array_push($prefixedFields, $prefix . $field);
         }
         $db->getSqlBuffer()->append(join(', ', $prefixedFields));
     } else {
         $db->getSqlBuffer()->append(join(', ', $fields));
     }
 }
コード例 #3
0
ファイル: SetExpression.php プロジェクト: adityapurwa/pixeldb
 /**
  * Expression constructor.
  * @param PixelDb $db
  * @param string[] $mappings Mapping of the fields and its values. e.g. ['user_id'=>$userId]
  * @param string $function Function for the mappings.
  * @param string $mappingPrefix Prefix for the mapping to prevent conflicts.
  * @param bool $first
  */
 public function __construct(PixelDb $db, $mappings, $function = null, $mappingPrefix = 'p_', $first = true)
 {
     parent::__construct($db);
     if ($first) {
         $db->getSqlBuffer()->append(' SET ');
     } else {
         $db->getSqlBuffer()->append(', ');
     }
     $parameterString = '';
     if ($function != null) {
         foreach ($mappings as $map => $value) {
             $parameterString .= $map . ' = ' . $function . '(:' . $mappingPrefix . $map . '), ';
         }
     } else {
         foreach ($mappings as $map => $value) {
             $parameterString .= $map . ' = :' . $mappingPrefix . $map . ', ';
         }
     }
     $parameterString = rtrim($parameterString, ', ');
     $db->getSqlBuffer()->append($parameterString);
     $db->addParameter($mappings, $mappingPrefix);
 }
コード例 #4
0
 /**
  * Expression constructor.
  * @param PixelDb $db
  * @param string $column The column to compare.
  * @param string $value The value expected.
  * @param string $function Function that should be applied to the value.
  * @param string $operator Operator for the comparison, use WhereExpression::OPERATOR_
  * @param string $prefix Prefix for parameter.
  * @param string $join The join used to combine multiple where expression.
  */
 public function __construct(PixelDb $db, $column, $value, $function = null, $operator = WhereExpression::OPERATOR_EQ, $prefix = 'p_', $join = ' WHERE ')
 {
     parent::__construct($db);
     $db->getSqlBuffer()->append($join);
     if ($function == null) {
         switch ($operator) {
             case WhereExpression::OPERATOR_LIKE_STARTS:
                 $db->getSqlBuffer()->append($column . ' LIKE %:' . $prefix . $column);
                 break;
             case WhereExpression::OPERATOR_LIKE_ENDS:
                 $db->getSqlBuffer()->append($column . ' LIKE :' . $prefix . $column . '%');
                 break;
             case WhereExpression::OPERATOR_LIKE:
                 $db->getSqlBuffer()->append($column . ' LIKE %:' . $prefix . $column . '%');
                 break;
             default:
                 $db->getSqlBuffer()->append($column . ' ' . $operator . ' :' . $prefix . $column);
                 break;
         }
     } else {
         switch ($operator) {
             case WhereExpression::OPERATOR_LIKE_STARTS:
                 $db->getSqlBuffer()->append($column . ' LIKE %' . $function . '(:' . $prefix . $column . ')');
                 break;
             case WhereExpression::OPERATOR_LIKE_ENDS:
                 $db->getSqlBuffer()->append($column . ' LIKE ' . $function . '(:' . $prefix . $column . ')%');
                 break;
             case WhereExpression::OPERATOR_LIKE:
                 $db->getSqlBuffer()->append($column . ' LIKE %' . $function . '(:' . $prefix . $column . ')%');
                 break;
             default:
                 $db->getSqlBuffer()->append($column . ' ' . $operator . ' ' . $function . '(:' . $prefix . $column . ')');
                 break;
         }
     }
     $db->addParameter([$column => $value], $prefix);
 }
コード例 #5
0
 /**
  * FromExpression constructor.
  * @param \Myriatek\PixelDb\PixelDb $db
  * @param string[] $tables Name of the table.
  * @param bool $first True if the first from statement.
  */
 public function __construct(PixelDb $db, $tables, $first = true)
 {
     parent::__construct($db);
     $db->getSqlBuffer()->append(' FROM ' . join(', ', $tables));
 }
コード例 #6
0
 /**
  * Expression constructor.
  * @param PixelDb $db
  * @param string $tables Table to update.
  */
 public function __construct(PixelDb $db, $tables)
 {
     parent::__construct($db);
     $db->getSqlBuffer()->append('UPDATE ' . $tables);
 }
コード例 #7
0
 /**
  * Expression constructor.
  * @param PixelDb $db
  * @param int $start Limit start.
  * @param int $end Limit length.
  */
 public function __construct(PixelDb $db, $start, $end = 1)
 {
     parent::__construct($db);
     $db->getSqlBuffer()->append(' LIMIT ' . $start . ', ' . $end);
 }