DbSqlLiteral

Complexity

Total Complexity

6

Size/Duplication

Total Lines	73
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

60%

Importance

Changes	2
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	buildSingleArgument()	0	13	3
A	max()	0	5	1
A	__toString()	0	3	1

<?php

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;
  }

  /**
   * 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
   */
  protected function buildSingleArgument($functionName, $field = '*', $alias = self::SQL_LITERAL_ALIAS_NONE) {
    if ($alias === self::SQL_LITERAL_ALIAS_AUTO) {
      $alias = $this->makeAliasFromField($functionName, $field);
    }

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

    if ($alias) {

The expression $alias of type null|string is loosely compared to true; this is ambiguous if the string can be empty. You might want to explicitly use !== null instead.

      $this->literal .= ' AS `' . $alias . '`';
    }

    return $this;
  }

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

    return $this;
  }


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

}