Akeneo\SalesForce\Query\QueryBuilder

Complexity

Total Complexity

13

Size/Duplication

Total Lines	150
Duplicated Lines	0 %

Coupling/Cohesion

Components	2
Dependencies	0

Importance

Changes

0

11 Methods

Rating	Name	Duplication	Size	Complexity
A	select()	0	6	1
A	addSelect()	0	6	1
A	from()	0	6	1
A	where()	0	6	1
A	getEqualCondition()	0	4	1
A	getNotEqualCondition()	0	4	1
A	getLikeCondition()	0	4	1
A	andWhere()	0	6	1
A	setParameter()	0	6	1
A	getQuery()	0	10	2
A	setOperator()	0	6	2

<?php

namespace Akeneo\SalesForce\Query;

/**
 * @author Anael Chardan <anael.chardan@akeneo.com>
 */
class QueryBuilder
{
    /**
     * @var array
     */
    protected $parameters = [];

    /**
     * @var string
     */
    protected $query = '';

    /**
     * @param string $field
     *
     * @return QueryBuilder
     */
    public function select(string $field): QueryBuilder
    {
        $this->query = sprintf('SELECT %s', $field);

        return $this;
    }

    /**
     * @param string $field
     *
     * @return QueryBuilder
     */
    public function addSelect(string $field): QueryBuilder
    {
        $this->query = sprintf('%s, %s', $this->query, $field);

        return $this;
    }

    /**
     * @param string $table
     *
     * @return QueryBuilder
     */
    public function from(string $table): QueryBuilder
    {
        $this->query = sprintf('%s FROM %s', $this->query, $table);

        return $this;
    }

    /**
     * @param string $condition
     *
     * @return QueryBuilder
     */
    public function where(string $condition): QueryBuilder
    {
        $this->query = sprintf('%s WHERE %s', $this->query, $condition);

        return $this;
    }

    /**
     * @param string $fieldName
     * @param string $value
     * @param bool   $quoted
     *
     * @return string
     */
    public function getEqualCondition(string $fieldName, string $value, bool $quoted = true): string
    {
        return $this->setOperator($fieldName, '=', $value, $quoted);
    }

    /**
     * @param string $fieldName
     * @param string $value
     * @param bool   $quoted
     *
     * @return string
     */
    public function getNotEqualCondition(string $fieldName, string $value, bool $quoted = true): string
    {
        return $this->setOperator($fieldName, '!=', $value, $quoted);
    }

    /**
     * @param string $fieldName
     * @param string $value
     * @param bool   $quoted
     *
     * @return string
     */
    public function getLikeCondition(string $fieldName, string $value, bool $quoted = true): string
    {
        return $this->setOperator($fieldName, 'LIKE', $value, $quoted);
    }

    /**
     * @param string $condition
     *
     * @return QueryBuilder
     */
    public function andWhere(string $condition): QueryBuilder
    {
        $this->query = sprintf('%s AND %s', $this->query, $condition);

        return $this;
    }

    /**
     * @param string $name
     * @param string $value
     *
     * @return QueryBuilder
     */
    public function setParameter(string $name, string $value): QueryBuilder
    {
        $this->parameters[$name] = $value;

        return $this;
    }

    /**
     * @return string
     */
    public function getQuery(): string
    {
        $result = $this->query;

        foreach ($this->parameters as $parameterKey => $parameterValue) {
            $result = str_replace(sprintf(':%s', $parameterKey), $parameterValue, $result);
        }

        return $result;
    }

    /**
     * @param string $fieldName
     * @param string $operator
     * @param string $value
     * @param bool   $quoted
     *
     * @return string
     */
    protected function setOperator(string $fieldName, string $operator, string $value, $quoted = true): string
    {
        $quoteText = $quoted ? '\'' : '';

        return sprintf('%s %s %s%s%s', $fieldName, $operator, $quoteText, $value, $quoteText);
    }
}