DbSqlLiteral

Complexity

Total Complexity

13

Size/Duplication

Total Lines	139
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

48.48%

Importance

Changes	4
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	sum()	0	3	1
A	__construct()	0	3	1
A	literal()	0	5	1
A	buildSingleArgument()	0	13	4
A	max()	0	3	1
A	count()	0	3	1
A	isNull()	0	15	3
A	__toString()	0	3	1

<?php

/**
 * Class DbSqlLiteral
 */
class DbSqlLiteral extends DbSqlAware {

  const SQL_LITERAL_ALIAS_NONE = null;
  const SQL_LITERAL_ALIAS_AUTO = '';

  /**
   * ALWAYS STRING!
   *
   * @var string $literal
   */
  public $literal = '';

  /**
   * DbSqlLiteral constructor.
   *
   * @param db_mysql|null $db
   * @param string        $literal
   */
  public function __construct($db = null, $literal = '') {

The parameter $literal is not used and could be removed.

    parent::__construct($db);
  }

  /**
   * @param mixed $value
   *
   * @return $this
   */
  public function literal($value) {
    $this->literal = (string)$value;

    return $this;
  }
//

56% of this comment could be valid code. Did you maybe forget this after debugging?

//  public static function __callStatic($name, $arguments) {
//    // method_exists(get_called_class(), $name)
//    return call_user_func_array(array(static::build(), '_' .$name), $arguments);
//  }

  /**
   * Renders single argument function
   * - supports autobuild alias
   * - supports direct alias
   * - supports dotted field names like 'table.field'
   * - supports all fields with '*' and 'table.*'
   *
   * @param string      $functionName
   * @param string      $field
   *  - '*' - all fields
   *  - string - quoted as field name
   * @param null|string $alias
   * - DbSqlLiteral::SQL_LITERAL_ALIAS_NONE: no alias
   * - DbSqlLiteral::SQL_LITERAL_ALIAS_AUTO: alias from $field
   * - other value: using supplied alias
   *
   * @return $this
   */
  public function buildSingleArgument($functionName, $field = '*', $alias = self::SQL_LITERAL_ALIAS_NONE) {
    if ($alias === self::SQL_LITERAL_ALIAS_AUTO) {
      $alias = $this->aliasFromField($functionName, $field);
    }

    $this->literal = strtoupper($functionName) . '(' . $this->quoteField($field) . ')';

    if (self::SQL_LITERAL_ALIAS_NONE !== $alias && !empty($alias)) {
      $this->literal .= ' AS `' . $alias . '`';
    }

    return $this;
  }

  /**
   * @param string      $field
   * @param null|string $alias
   *
   * @return static
   *
   * @see buildSingleArgument
   */
  public function max($field = '*', $alias = self::SQL_LITERAL_ALIAS_NONE) {
    return $this->buildSingleArgument('max', $field, $alias);
  }

  /**
   * @param string      $field
   * @param null|string $alias
   *
   * @return $this
   *
   * @see buildSingleArgument
   */
  public function count($field = '*', $alias = self::SQL_LITERAL_ALIAS_NONE) {
    return $this->buildSingleArgument('count', $field, $alias);
  }

  /**
   * @param string      $field
   * @param null|string $alias
   *
   * @return $this
   *
   * @see buildSingleArgument
   */
  public function sum($field = '*', $alias = self::SQL_LITERAL_ALIAS_NONE) {
    return $this->buildSingleArgument('sum', $field, $alias);
  }

  /**
   * @param string      $field
   * @param null|string $alias
   *
   * @return $this
   *
   * @see buildSingleArgument
   */
  public function isNull($field = '*', $alias = self::SQL_LITERAL_ALIAS_NONE) {
    $functionName = 'isNull';

    if ($alias === self::SQL_LITERAL_ALIAS_AUTO) {
      $alias = $this->aliasFromField($functionName, $field);
    }

    $this->literal = $this->quoteField($field) . ' IS NULL';

    if (!empty($alias)) {
      $this->literal .= ' AS `' . $alias . '`';
    }

    return $this;
  }


  /**
   * @return string
   */
  public function __toString() {
    return $this->literal;
  }

}