DbSqlLiteral

Complexity

Total Complexity

11

Size/Duplication

Total Lines	124
Duplicated Lines	22.58 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

54.84%

Importance

Changes	3
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	buildSingleArgument()	13	13	3
A	max()	0	3	1
A	count()	0	3	1
A	sum()	0	3	1
A	isNull()	15	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 = '';

  public $literal = '';

  /**
   * DbSqlLiteral constructor.
   *
   * @param db_mysql|null $db
   * @param string        $literal
   */
  public function __construct($db = null, $literal = '') {
    parent::__construct($db);
    $this->literal = $literal;
  }
//

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) {

This method seems to be duplicated in your project.

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

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

    if (!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) {

This method seems to be duplicated in your project.

    $functionName = 'isNull';

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

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

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

    return $this;
  }


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

}