adumitru68 / QueryBuilder

src/Traits/Limit.php

Indentation +30 added lines, -30 removed lines

@@ -15,48 +15,48 @@
 trait Limit
 {
 
-    use Objects;
+	use Objects;
 
 
-    /**
-     * @param int $limit
-     * @param null $offset
-     * @return $this
-     * @throws QueryException
-     */
-    public function limit($limit = 0, $offset = null)
-    {
-        $limit = trim($limit);
+	/**
+	 * @param int $limit
+	 * @param null $offset
+	 * @return $this
+	 * @throws QueryException
+	 */
+	public function limit($limit = 0, $offset = null)
+	{
+		$limit = trim($limit);
 
-        if (!QueryHelper::isInteger($limit))
-            throw new QueryException('Invalid Limit value', QueryException::QUERY_ERROR_INVALID_LIMIT);
+		if (!QueryHelper::isInteger($limit))
+			throw new QueryException('Invalid Limit value', QueryException::QUERY_ERROR_INVALID_LIMIT);
 
-        if ($limit == 0)
-            throw new QueryException('Invalid Limit zero', QueryException::QUERY_ERROR_INVALID_LIMIT_ZERO);
+		if ($limit == 0)
+			throw new QueryException('Invalid Limit zero', QueryException::QUERY_ERROR_INVALID_LIMIT_ZERO);
 
-        if (is_null($offset)) {
-            $this->queryStructure->setElement(QueryStructure::LIMIT, $limit);
+		if (is_null($offset)) {
+			$this->queryStructure->setElement(QueryStructure::LIMIT, $limit);
 
-            return $this;
-        }
+			return $this;
+		}
 
-        $offset = trim($offset);
+		$offset = trim($offset);
 
-        if (!QueryHelper::isInteger($offset))
-            throw new QueryException('Invalid Limit offset', QueryException::QUERY_ERROR_INVALID_LIMIT_OFFSET);
+		if (!QueryHelper::isInteger($offset))
+			throw new QueryException('Invalid Limit offset', QueryException::QUERY_ERROR_INVALID_LIMIT_OFFSET);
 
-        $this->queryStructure->setElement(QueryStructure::LIMIT, $offset . ',' . $limit);
+		$this->queryStructure->setElement(QueryStructure::LIMIT, $offset . ',' . $limit);
 
-        return $this;
-    }
+		return $this;
+	}
 
-    private function getLimitSyntax()
-    {
-        if (!$this->queryStructure->getElement(QueryStructure::LIMIT))
-            return '';
+	private function getLimitSyntax()
+	{
+		if (!$this->queryStructure->getElement(QueryStructure::LIMIT))
+			return '';
 
-        return 'LIMIT ' . $this->queryStructure->getElement(QueryStructure::LIMIT);
-    }
+		return 'LIMIT ' . $this->queryStructure->getElement(QueryStructure::LIMIT);
+	}
 
 }
 

src/Traits/ColumnValidation.php

Indentation +9 added lines, -9 removed lines

@@ -12,18 +12,18 @@
 trait ColumnValidation
 {
 
-    use Objects;
+	use Objects;
 
-    protected function validateColumn($columnName, array $allowed)
-    {
-        if (is_integer($columnName))
-            return true;
+	protected function validateColumn($columnName, array $allowed)
+	{
+		if (is_integer($columnName))
+			return true;
 
-        if (!count($allowed))
-            return true;
+		if (!count($allowed))
+			return true;
 
-        return false;
-    }
+		return false;
+	}
 
 
 }
\ No newline at end of file

src/Traits/Ignore.php

Indentation +9 added lines, -9 removed lines

@@ -14,17 +14,17 @@
 trait Ignore
 {
 
-    use Objects;
+	use Objects;
 
-    /**
-     * @return $this
-     */
-    public function ignore()
-    {
-        $this->queryStructure->setElement(QueryStructure::IGNORE, 1);
+	/**
+	 * @return $this
+	 */
+	public function ignore()
+	{
+		$this->queryStructure->setElement(QueryStructure::IGNORE, 1);
 
-        return $this;
-    }
+		return $this;
+	}
 
 
 }
\ No newline at end of file

src/Traits/HighPriority.php

Indentation +9 added lines, -9 removed lines

@@ -14,16 +14,16 @@
 trait HighPriority
 {
 
-    use Objects;
+	use Objects;
 
-    /**
-     * @return $this
-     */
-    public function highPriority()
-    {
-        $this->queryStructure->setElement(QueryStructure::PRIORITY, 'HIGH_PRIORITY');
+	/**
+	 * @return $this
+	 */
+	public function highPriority()
+	{
+		$this->queryStructure->setElement(QueryStructure::PRIORITY, 'HIGH_PRIORITY');
 
-        return $this;
-    }
+		return $this;
+	}
 
 }
\ No newline at end of file

src/Traits/DefaultPriority.php

Indentation +9 added lines, -9 removed lines

@@ -14,17 +14,17 @@
 trait DefaultPriority
 {
 
-    use Objects;
+	use Objects;
 
 
-    /**
-     * @return $this
-     */
-    public function defaultPriority()
-    {
-        $this->queryStructure->setElement(QueryStructure::PRIORITY, '');
+	/**
+	 * @return $this
+	 */
+	public function defaultPriority()
+	{
+		$this->queryStructure->setElement(QueryStructure::PRIORITY, '');
 
-        return $this;
-    }
+		return $this;
+	}
 
 }
\ No newline at end of file

src/Dependencies/QueryException.php

Indentation +17 added lines, -17 removed lines

@@ -11,23 +11,23 @@
 class QueryException extends \Exception
 {
 
-    const QUERY_ERROR_ELEMENT_NOT_FOUND = 10;
-    const QUERY_ERROR_ELEMENT_TYPE = 11;
-    const QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY = 20;
-    const QUERY_ERROR_WHERE_INVALID_OPERATOR = 30;
-    const QUERY_ERROR_INVALID_LIMIT = 40;
-    const QUERY_ERROR_INVALID_LIMIT_ZERO = 50;
-    const QUERY_ERROR_INVALID_LIMIT_OFFSET = 60;
-    const QUERY_ERROR_DELETE_NOT_FILTER = 70;
+	const QUERY_ERROR_ELEMENT_NOT_FOUND = 10;
+	const QUERY_ERROR_ELEMENT_TYPE = 11;
+	const QUERY_ERROR_WHERE_INVALID_PARAM_ARRAY = 20;
+	const QUERY_ERROR_WHERE_INVALID_OPERATOR = 30;
+	const QUERY_ERROR_INVALID_LIMIT = 40;
+	const QUERY_ERROR_INVALID_LIMIT_ZERO = 50;
+	const QUERY_ERROR_INVALID_LIMIT_OFFSET = 60;
+	const QUERY_ERROR_DELETE_NOT_FILTER = 70;
 
-    const QUERY_ERROR_INVALID_FIELDS_COUNT = 91;
-    const QUERY_ERROR_INVALID_DISTINCT = 92;
-    const QUERY_ERROR_HAVING_INVALID_PARAM_ARRAY = 93;
-    const QUERY_ERROR_HAVING_INVALID_OPERATOR = 94;
-    const QUERY_ERROR_SELECT_INVALID_FIELD = 95;
-    const QUERY_ERROR_SELECT_INVALID_PARAM = 96;
-    const QUERY_ERROR_INVALID_TABLE_STATEMENT = 97;
-    const QUERY_ERROR_INVALID_COLUMN_NAME = 98;
-    const QUERY_ERROR_INVALID_CONDITION_TYPE = 99;
+	const QUERY_ERROR_INVALID_FIELDS_COUNT = 91;
+	const QUERY_ERROR_INVALID_DISTINCT = 92;
+	const QUERY_ERROR_HAVING_INVALID_PARAM_ARRAY = 93;
+	const QUERY_ERROR_HAVING_INVALID_OPERATOR = 94;
+	const QUERY_ERROR_SELECT_INVALID_FIELD = 95;
+	const QUERY_ERROR_SELECT_INVALID_PARAM = 96;
+	const QUERY_ERROR_INVALID_TABLE_STATEMENT = 97;
+	const QUERY_ERROR_INVALID_COLUMN_NAME = 98;
+	const QUERY_ERROR_INVALID_CONDITION_TYPE = 99;
 
 }
\ No newline at end of file

src/Dependencies/QueryTimer.php

Indentation +28 added lines, -28 removed lines

@@ -11,33 +11,33 @@
 class QueryTimer
 {
 
-    /**
-     * @var mixed
-     */
-    private $queryStart;
-
-    /**
-     * @var mixed
-     */
-    private $queryEnd;
-
-
-    /**
-     * QueryTimer constructor.
-     */
-    public function __construct()
-    {
-        $this->queryStart = microtime(true);
-    }
-
-    /**
-     * @return float
-     */
-    public function getDuration()
-    {
-        $this->queryEnd = microtime(true);
-
-        return $this->queryEnd - $this->queryStart;
-    }
+	/**
+	 * @var mixed
+	 */
+	private $queryStart;
+
+	/**
+	 * @var mixed
+	 */
+	private $queryEnd;
+
+
+	/**
+	 * QueryTimer constructor.
+	 */
+	public function __construct()
+	{
+		$this->queryStart = microtime(true);
+	}
+
+	/**
+	 * @return float
+	 */
+	public function getDuration()
+	{
+		$this->queryEnd = microtime(true);
+
+		return $this->queryEnd - $this->queryStart;
+	}
 
 }
\ No newline at end of file

src/QueryBuild.php

Indentation +59 added lines, -59 removed lines

@@ -17,71 +17,71 @@
 class QueryBuild
 {
 
-    /**
-     * @var integer
-     */
-    private $queryType;
+	/**
+	 * @var integer
+	 */
+	private $queryType;
 
-    /**
-     * QueryBuild constructor.
-     * @param $queryType
-     */
-    protected function __construct($queryType)
-    {
-        $this->queryType = $queryType;
-    }
+	/**
+	 * QueryBuild constructor.
+	 * @param $queryType
+	 */
+	protected function __construct($queryType)
+	{
+		$this->queryType = $queryType;
+	}
 
-    /**
-     * @param $table
-     * @return QuerySelect
-     */
-    public static function select($table)
-    {
-        return new QuerySelect(new QueryBuild(0), $table);
-    }
+	/**
+	 * @param $table
+	 * @return QuerySelect
+	 */
+	public static function select($table)
+	{
+		return new QuerySelect(new QueryBuild(0), $table);
+	}
 
-    /**
-     * @param $table
-     * @return QueryUpdate
-     */
-    public static function update($table)
-    {
-        return new QueryUpdate(new QueryBuild(0), $table);
-    }
+	/**
+	 * @param $table
+	 * @return QueryUpdate
+	 */
+	public static function update($table)
+	{
+		return new QueryUpdate(new QueryBuild(0), $table);
+	}
 
-    /**
-     * @param $table
-     * @return QueryInsert
-     */
-    public static function insert($table)
-    {
-        return new QueryInsert(new QueryBuild(0), $table);
-    }
+	/**
+	 * @param $table
+	 * @return QueryInsert
+	 */
+	public static function insert($table)
+	{
+		return new QueryInsert(new QueryBuild(0), $table);
+	}
 
-    /**
-     * @param $table
-     * @return QueryDelete
-     */
-    public static function delete($table)
-    {
-        return new QueryDelete(new QueryBuild(0), $table);
-    }
+	/**
+	 * @param $table
+	 * @return QueryDelete
+	 */
+	public static function delete($table)
+	{
+		return new QueryDelete(new QueryBuild(0), $table);
+	}
 
-    /**
-     * @param $query
-     * @return QueryCustom
-     */
-    public static function query($query)
-    {
-        return new QueryCustom(new QueryBuild(1), $query);
-    }
+	/**
+	 * @param $query
+	 * @return QueryCustom
+	 */
+	public static function query($query)
+	{
+		return new QueryCustom(new QueryBuild(1), $query);
+	}
 
-    /**
-     * @return integer
-     */
-    public function getType()
-    {
-        return $this->queryType;
-    }
+	/**
+	 * @return integer
+	 */
+	public function getType()
+	{
+		return $this->queryType;
+	}
 
 }
\ No newline at end of file

src/Statements/QuerySelect.php

Indentation +174 added lines, -174 removed lines

@@ -29,179 +29,179 @@
 class QuerySelect extends QueryStatement implements QueryStatementInterface
 {
 
-    use SelectFields, Limit, Distinct, Where, Having, WhereAndHavingBuilder, Replacement, OrderBy, GroupBy, Join, DefaultPriority, HighPriority, Utilities;
-
-    /**
-     * @var string
-     */
-    protected $statement = self::QUERY_STATEMENT_SELECT;
-
-
-    /**
-     * QuerySelect constructor.
-     * @param QueryBuild $queryBuild
-     * @param string|QueryStatement $table
-     */
-    public function __construct(QueryBuild $queryBuild, $table)
-    {
-        parent::__construct($queryBuild, $table);
-
-        if (is_a($table, QuerySelect::class)) {
-
-            /**
-             * @var QuerySelect $table
-             */
-            $tableName = '( ' . $table->getSyntax() . ' )';
-            $this->queryStructure->setElement(QueryStructure::TABLE, $tableName);
-
-            $tableSelectParams = $table->getBindParams();
-            foreach ($tableSelectParams as $key => $value)
-                $this->queryStructure->setParams($key, $value);
-
-        }
-    }
-
-    /**
-     * @return $this
-     */
-    public function first()
-    {
-        $this->queryStructure->setElement(QueryStructure::FIRST, 1);
-
-        return $this;
-    }
-
-    /**
-     * @return $this
-     */
-    public function count()
-    {
-        $this->queryStructure->setElement(QueryStructure::COUNT, 1);
-
-        return $this;
-    }
-
-    /**
-     * @param $column
-     * @return $this
-     */
-    public function column($column)
-    {
-        $column = QueryHelper::clearMultipleSpaces($column);
-        $this->queryStructure->setElement(QueryStructure::COLUMN, $column);
-
-        return $this;
-    }
-
-
-    /**
-     * @param bool|int $replacement
-     * @return mixed|string
-     */
-    public function getSyntax($replacement = self::REPLACEMENT_NONE)
-    {
-
-        if ($this->queryStructure->getElement(QueryStructure::COUNT)) {
-            $this->queryStructure->setElement(QueryStructure::FIELDS, 'COUNT(*)');
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
-            $this->queryStructure->setElement(QueryStructure::DISTINCT, 0); //???
-        }
-
-        if ($this->queryStructure->getElement(QueryStructure::FIRST))
-            $this->queryStructure->setElement(QueryStructure::LIMIT, 1);
-
-        $syntax = array();
-
-        /**
-         *  Explain
-         */
-        $syntax[] = $this->getExplainSyntax();
-
-        /**
-         * SELECT statement
-         */
-        $syntax[] = $this->statement;
-
-        /**
-         * PRIORITY
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
-
-        /**
-         * DISTINCT clause
-         */
-        $syntax[] = $this->getDistinctSyntax();
-
-        /**
-         * FIELDS
-         */
-        $syntax[] = $this->queryStructure->getElement(QueryStructure::FIELDS);
-
-        /**
-         * FROM table or queryStructure
-         */
-        $syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
-
-        /**
-         * JOIN CLAUSES
-         */
-        $syntax[] = $this->getJoinSyntax();
-
-        /**
-         * WHERE clause
-         */
-        $syntax[] = $this->getWhereSyntax();
-
-        /**
-         * GROUP BY clause
-         */
-        $syntax[] = $this->getGroupBySyntax();
-
-        /**
-         * HAVING clause
-         */
-        $syntax[] = $this->getHavingSyntax();
-
-        /**
-         * ORDER BY clause
-         */
-        $syntax[] = $this->getOrderBySyntax();
-
-        /**
-         * LIMIT clause
-         */
-        $syntax[] = $this->getLimitSyntax();
-
-        $syntax = implode(' ', $syntax);
-
-        return $this->getSyntaxReplace($syntax, $replacement);
-
-    }
-
-
-    /**
-     * @return array|int|mixed|null|string
-     */
-    public function execute()
-    {
-
-        switch (true) {
-            case $this->queryStructure->getElement(QueryStructure::COUNT):
-                return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-                break;
-            case $this->queryStructure->getElement(QueryStructure::FIRST):
-                if ($this->queryStructure->getElement(QueryStructure::COLUMN))
-                    return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-
-                return DbService::getInstance()->row($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-                break;
-            case $this->queryStructure->getElement(QueryStructure::COLUMN):
-                return DbService::getInstance()->column($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-                break;
-            default:
-                return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
-                break;
-        }
-    }
+	use SelectFields, Limit, Distinct, Where, Having, WhereAndHavingBuilder, Replacement, OrderBy, GroupBy, Join, DefaultPriority, HighPriority, Utilities;
+
+	/**
+	 * @var string
+	 */
+	protected $statement = self::QUERY_STATEMENT_SELECT;
+
+
+	/**
+	 * QuerySelect constructor.
+	 * @param QueryBuild $queryBuild
+	 * @param string|QueryStatement $table
+	 */
+	public function __construct(QueryBuild $queryBuild, $table)
+	{
+		parent::__construct($queryBuild, $table);
+
+		if (is_a($table, QuerySelect::class)) {
+
+			/**
+			 * @var QuerySelect $table
+			 */
+			$tableName = '( ' . $table->getSyntax() . ' )';
+			$this->queryStructure->setElement(QueryStructure::TABLE, $tableName);
+
+			$tableSelectParams = $table->getBindParams();
+			foreach ($tableSelectParams as $key => $value)
+				$this->queryStructure->setParams($key, $value);
+
+		}
+	}
+
+	/**
+	 * @return $this
+	 */
+	public function first()
+	{
+		$this->queryStructure->setElement(QueryStructure::FIRST, 1);
+
+		return $this;
+	}
+
+	/**
+	 * @return $this
+	 */
+	public function count()
+	{
+		$this->queryStructure->setElement(QueryStructure::COUNT, 1);
+
+		return $this;
+	}
+
+	/**
+	 * @param $column
+	 * @return $this
+	 */
+	public function column($column)
+	{
+		$column = QueryHelper::clearMultipleSpaces($column);
+		$this->queryStructure->setElement(QueryStructure::COLUMN, $column);
+
+		return $this;
+	}
+
+
+	/**
+	 * @param bool|int $replacement
+	 * @return mixed|string
+	 */
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
+	{
+
+		if ($this->queryStructure->getElement(QueryStructure::COUNT)) {
+			$this->queryStructure->setElement(QueryStructure::FIELDS, 'COUNT(*)');
+			$this->queryStructure->setElement(QueryStructure::LIMIT, 1);
+			$this->queryStructure->setElement(QueryStructure::DISTINCT, 0); //???
+		}
+
+		if ($this->queryStructure->getElement(QueryStructure::FIRST))
+			$this->queryStructure->setElement(QueryStructure::LIMIT, 1);
+
+		$syntax = array();
+
+		/**
+		 *  Explain
+		 */
+		$syntax[] = $this->getExplainSyntax();
+
+		/**
+		 * SELECT statement
+		 */
+		$syntax[] = $this->statement;
+
+		/**
+		 * PRIORITY
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
+
+		/**
+		 * DISTINCT clause
+		 */
+		$syntax[] = $this->getDistinctSyntax();
+
+		/**
+		 * FIELDS
+		 */
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::FIELDS);
+
+		/**
+		 * FROM table or queryStructure
+		 */
+		$syntax[] = 'FROM ' . $this->queryStructure->getElement(QueryStructure::TABLE);
+
+		/**
+		 * JOIN CLAUSES
+		 */
+		$syntax[] = $this->getJoinSyntax();
+
+		/**
+		 * WHERE clause
+		 */
+		$syntax[] = $this->getWhereSyntax();
+
+		/**
+		 * GROUP BY clause
+		 */
+		$syntax[] = $this->getGroupBySyntax();
+
+		/**
+		 * HAVING clause
+		 */
+		$syntax[] = $this->getHavingSyntax();
+
+		/**
+		 * ORDER BY clause
+		 */
+		$syntax[] = $this->getOrderBySyntax();
+
+		/**
+		 * LIMIT clause
+		 */
+		$syntax[] = $this->getLimitSyntax();
+
+		$syntax = implode(' ', $syntax);
+
+		return $this->getSyntaxReplace($syntax, $replacement);
+
+	}
+
+
+	/**
+	 * @return array|int|mixed|null|string
+	 */
+	public function execute()
+	{
+
+		switch (true) {
+			case $this->queryStructure->getElement(QueryStructure::COUNT):
+				return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+				break;
+			case $this->queryStructure->getElement(QueryStructure::FIRST):
+				if ($this->queryStructure->getElement(QueryStructure::COLUMN))
+					return DbService::getInstance()->single($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+
+				return DbService::getInstance()->row($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+				break;
+			case $this->queryStructure->getElement(QueryStructure::COLUMN):
+				return DbService::getInstance()->column($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+				break;
+			default:
+				return DbService::getInstance()->query($this->getSyntax(), $this->queryStructure->getElement(QueryStructure::BIND_PARAMS));
+				break;
+		}
+	}
 
 }
\ No newline at end of file