adumitru68 / QueryBuilder

src/Dependencies/QueryHelper.php

Spacing +43 added lines, -43 removed lines

@@ -15,10 +15,10 @@ 
 	 * @param string $string
 	 * @return mixed|string
 	 */
-	public static function clearMultipleSpaces( $string = '' )
+	public static function clearMultipleSpaces($string = '')
 	{
-		$string = preg_replace( '/\s+/', ' ', $string );
-		$string = trim( $string );
+		$string = preg_replace('/\s+/', ' ', $string);
+		$string = trim($string);
 
 		return $string;
 	}
@@ -27,11 +27,11 @@ 
 	 * @param $val
 	 * @return bool
 	 */
-	public static function isInteger( $val )
+	public static function isInteger($val)
 	{
-		$val = trim( $val );
+		$val = trim($val);
 
-		return is_numeric( $val ) && floor( $val ) == $val;
+		return is_numeric($val) && floor($val) == $val;
 	}
 
 	/**
@@ -39,34 +39,34 @@ 
 	 * @return bool
 	 * @i
 	 */
-	public static function isDecimal( $val )
+	public static function isDecimal($val)
 	{
-		$val = trim( $val );
+		$val = trim($val);
 
-		return is_numeric( $val ) && floor( $val ) != $val;
+		return is_numeric($val) && floor($val) != $val;
 	}
 
-	public static function isValidOrderBy( $order_by_parameter )
+	public static function isValidOrderBy($order_by_parameter)
 	{
 
-		$columns = array( 'first_name', 'last_name', 'zip', 'created_at' );
+		$columns = array('first_name', 'last_name', 'zip', 'created_at');
 
-		$parts = preg_split( "/[\s,]+/", $order_by_parameter );
+		$parts = preg_split("/[\s,]+/", $order_by_parameter);
 
-		foreach ( $parts as $part ) {
-			$subparts = preg_split( "/\s+/", $part );
+		foreach ($parts as $part) {
+			$subparts = preg_split("/\s+/", $part);
 
-			if ( count( $subparts ) < 0 || count( $subparts ) > 2 ) {
+			if (count($subparts) < 0 || count($subparts) > 2) {
 				// Too many or too few parts.
 				return false;
 			}
 
-			if ( !in_array( $subparts[0], $columns ) ) {
+			if (!in_array($subparts[0], $columns)) {
 				// Column name is invalid.
 				return false;
 			}
 
-			if ( count( $subparts ) == 2 && !in_array( strtoupper( $subparts[1] ), array( 'ASC', 'DESC' ) ) ) {
+			if (count($subparts) == 2 && !in_array(strtoupper($subparts[1]), array('ASC', 'DESC'))) {
 				// ASC or DESC is invalid
 				return false;
 			}
@@ -81,23 +81,23 @@ 
 	 * @param string $delimiter
 	 * @return array
 	 */
-	public static function explode( $string, $delimiter = ',' )
+	public static function explode($string, $delimiter = ',')
 	{
-		$brutArray = explode( $delimiter, $string );
+		$brutArray = explode($delimiter, $string);
 		$newArray = array();
-		foreach ( $brutArray as $value ) {
-			$value = trim( $value );
-			if ( '' !== $value ) $newArray[] = $value;
+		foreach ($brutArray as $value) {
+			$value = trim($value);
+			if ('' !== $value) $newArray[] = $value;
 		}
 
 		return $newArray;
 	}
 
-	public static function alphaNum( $string )
+	public static function alphaNum($string)
 	{
-		$string = preg_replace( "/[^a-zA-Z0-9 _,]+/", "", $string );
+		$string = preg_replace("/[^a-zA-Z0-9 _,]+/", "", $string);
 
-		return self::clearMultipleSpaces( $string );
+		return self::clearMultipleSpaces($string);
 	}
 
 	/**
@@ -105,12 +105,12 @@ 
 	 * @param string $delimiter
 	 * @return string
 	 */
-	public static function implode( array $array, $delimiter = ',' )
+	public static function implode(array $array, $delimiter = ',')
 	{
-		$string = implode( $delimiter, $array );
-		$string = trim( $string );
-		$string = trim( $string, trim( $delimiter ) );
-		$string = trim( $string );
+		$string = implode($delimiter, $array);
+		$string = trim($string);
+		$string = trim($string, trim($delimiter));
+		$string = trim($string);
 
 		return $string;
 	}
@@ -119,36 +119,36 @@ 
 	 * @param $string
 	 * @return mixed|string
 	 */
-	public static function clearQuotes( $string )
+	public static function clearQuotes($string)
 	{
-		$search = array( '"', "'" );
+		$search = array('"', "'");
 		$replace = '';
-		$string = str_replace( $search, $replace, $string );
+		$string = str_replace($search, $replace, $string);
 
-		return self::clearMultipleSpaces( $string );
+		return self::clearMultipleSpaces($string);
 	}
 
 	/**
 	 * @param int $length
 	 * @return string
 	 */
-	public static function random( $length = 5 )
+	public static function random($length = 5)
 	{
 		$characters = 'abcdefghijklmnopqrstuvwxyz';
-		$charactersLength = strlen( $characters );
+		$charactersLength = strlen($characters);
 		$randomString = '';
-		for ( $i = 0; $i < $length; $i++ )
-			$randomString .= $characters[ rand( 0, $charactersLength - 1 ) ];
+		for ($i = 0; $i < $length; $i++)
+			$randomString .= $characters[rand(0, $charactersLength - 1)];
 
-		return str_shuffle( $randomString );
+		return str_shuffle($randomString);
 	}
 
-	public static function limitString( $rowCount, $offset = null )
+	public static function limitString($rowCount, $offset = null)
 	{
-		$rowCount = intval( $rowCount );
-		if ( is_null( $offset ) )
+		$rowCount = intval($rowCount);
+		if (is_null($offset))
 			return $rowCount;
-		$offset = intval( $offset );
+		$offset = intval($offset);
 
 		return "$offset, $rowCount";
 	}

src/Dependencies/QueryStructure.php

Spacing +34 added lines, -34 removed lines

@@ -85,8 +85,8 @@ 
 	{
 		$this->syntaxEL = $this->init();
 
-		foreach ( $this->syntaxEL as $name => $value )
-			$this->typeEL[ $name ] = gettype( $value );
+		foreach ($this->syntaxEL as $name => $value)
+			$this->typeEL[$name] = gettype($value);
 
 	}
 
@@ -128,9 +128,9 @@ 
 
 	private function makeStatementInstance()
 	{
-		$instance = QueryHelper::random( 5 );
-		while ( in_array( $instance, self::$usedInstanceIds ) ) {
-			$instance = QueryHelper::random( 7 );
+		$instance = QueryHelper::random(5);
+		while (in_array($instance, self::$usedInstanceIds)) {
+			$instance = QueryHelper::random(7);
 		}
 		self::$usedInstanceIds[] = $instance;
 
@@ -158,7 +158,7 @@ 
 	/**
 	 * @param $elements
 	 */
-	public function setAllElements( $elements )
+	public function setAllElements($elements)
 	{
 		$this->syntaxEL = $elements;
 	}
@@ -170,18 +170,18 @@ 
 	 * @return bool
 	 * @throws QueryException
 	 */
-	public function setElement( $name, $value )
+	public function setElement($name, $value)
 	{
-		if ( !array_key_exists( $name, $this->syntaxEL ) )
-			throw new QueryException( 'Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND );
+		if (!array_key_exists($name, $this->syntaxEL))
+			throw new QueryException('Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND);
 
-		if ( $name == self::TABLE && is_a( $value, QueryStatement::class ) )
+		if ($name == self::TABLE && is_a($value, QueryStatement::class))
 			return true;
 
-		if ( $this->typeEL[ $name ] === self::ELEMENT_TYPE_ARRAY )
-			$this->syntaxEL[ $name ][] = $value;
+		if ($this->typeEL[$name] === self::ELEMENT_TYPE_ARRAY)
+			$this->syntaxEL[$name][] = $value;
 		else
-			$this->syntaxEL[ $name ] = $value;
+			$this->syntaxEL[$name] = $value;
 
 		return true;
 	}
@@ -192,12 +192,12 @@ 
 	 * @param $elementValue
 	 * @throws QueryException
 	 */
-	public function replaceElement( $elementName, $elementValue )
+	public function replaceElement($elementName, $elementValue)
 	{
-		if ( !array_key_exists( $elementName, $this->syntaxEL ) )
-			throw new QueryException( 'Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND );
+		if (!array_key_exists($elementName, $this->syntaxEL))
+			throw new QueryException('Invalid Query property', QueryException::QUERY_ERROR_ELEMENT_NOT_FOUND);
 
-		$this->syntaxEL[ $elementName ] = $elementValue;
+		$this->syntaxEL[$elementName] = $elementValue;
 	}
 
 
@@ -205,9 +205,9 @@ 
 	 * @param string $name
 	 * @return mixed
 	 */
-	public function getElement( $name )
+	public function getElement($name)
 	{
-		return $this->syntaxEL[ $name ];
+		return $this->syntaxEL[$name];
 	}
 
 
@@ -215,9 +215,9 @@ 
 	 * @param $name
 	 * @param $value
 	 */
-	public function setParams( $name, $value )
+	public function setParams($name, $value)
 	{
-		$this->syntaxEL[ QueryStructure::BIND_PARAMS ][ $name ] = $value;
+		$this->syntaxEL[QueryStructure::BIND_PARAMS][$name] = $value;
 	}
 
 
@@ -226,10 +226,10 @@ 
 	 * @param $value
 	 * @return string
 	 */
-	public function bindParam( $name, $value )
+	public function bindParam($name, $value)
 	{
-		$pdoName = $this->index( $name );
-		$this->syntaxEL[ QueryStructure::BIND_PARAMS ][ $pdoName ] = $value;
+		$pdoName = $this->index($name);
+		$this->syntaxEL[QueryStructure::BIND_PARAMS][$pdoName] = $value;
 
 		return ':' . $pdoName;
 	}
@@ -241,27 +241,27 @@ 
 	 * @param string $search
 	 * @return string
 	 */
-	public function bindParamsExpression( $expression, array $params = [], $search = '?' )
+	public function bindParamsExpression($expression, array $params = [], $search = '?')
 	{
-		if ( !count( $params ) )
+		if (!count($params))
 			return $expression;
 
-		if ( strpos( $expression, $search ) === false )
+		if (strpos($expression, $search) === false)
 			return $expression;
 
-		$params = array_slice( $params, 0, substr_count( $expression, $search ) );
+		$params = array_slice($params, 0, substr_count($expression, $search));
 
 		$i = 0;
 		$arrayReturn = [];
-		$expressionToArray = explode( $search, $expression );
+		$expressionToArray = explode($search, $expression);
 
-		foreach ( $expressionToArray as $sub ) {
+		foreach ($expressionToArray as $sub) {
 			$arrayReturn[] = $sub;
-			$arrayReturn[] = array_key_exists( $i, $params ) ? $this->bindParam( 'exp', $params[ $i ] ) : '';
+			$arrayReturn[] = array_key_exists($i, $params) ? $this->bindParam('exp', $params[$i]) : '';
 			$i++;
 		}
 
-		return implode( '', $arrayReturn );
+		return implode('', $arrayReturn);
 	}
 
 
@@ -269,9 +269,9 @@ 
 	 * @param string $fieldName
 	 * @return string
 	 */
-	public function index( $fieldName = '' )
+	public function index($fieldName = '')
 	{
-		return trim( $fieldName ) . '_' . $this->syntaxEL[ self::INSTANCE ] . '_' . ++$this->counter . 'i';
+		return trim($fieldName) . '_' . $this->syntaxEL[self::INSTANCE] . '_' . ++$this->counter . 'i';
 	}
 
 }
\ No newline at end of file

src/Dependencies/QueryTimer.php

Spacing +2 added lines, -2 removed lines

@@ -23,7 +23,7 @@ 
 
 	public function __construct()
 	{
-		$this->queryStart = microtime( true );
+		$this->queryStart = microtime(true);
 	}
 
 	/**
@@ -31,7 +31,7 @@ 
 	 */
 	public function getDuration()
 	{
-		$this->queryEnd = microtime( true );
+		$this->queryEnd = microtime(true);
 
 		return $this->queryEnd - $this->queryStart;
 	}

src/QueryBuild.php

Spacing +11 added lines, -11 removed lines

@@ -26,7 +26,7 @@ 
 	 * QueryBuild constructor.
 	 * @param $queryType
 	 */
-	protected function __construct( $queryType )
+	protected function __construct($queryType)
 	{
 		$this->queryType = $queryType;
 	}
@@ -35,45 +35,45 @@ 
 	 * @param $table
 	 * @return QuerySelect
 	 */
-	public static function select( $table )
+	public static function select($table)
 	{
-		return new QuerySelect( new QueryBuild( 0 ), $table );
+		return new QuerySelect(new QueryBuild(0), $table);
 	}
 
 	/**
 	 * @param $table
 	 * @return QueryUpdate
 	 */
-	public static function update( $table )
+	public static function update($table)
 	{
-		return new QueryUpdate( new QueryBuild( 0 ), $table );
+		return new QueryUpdate(new QueryBuild(0), $table);
 	}
 
 	/**
 	 * @param $table
 	 * @return QueryInsert
 	 */
-	public static function insert( $table )
+	public static function insert($table)
 	{
-		return new QueryInsert( new QueryBuild( 0 ), $table );
+		return new QueryInsert(new QueryBuild(0), $table);
 	}
 
 	/**
 	 * @param $table
 	 * @return QueryDelete
 	 */
-	public static function delete( $table )
+	public static function delete($table)
 	{
-		return new QueryDelete( new QueryBuild( 0 ), $table );
+		return new QueryDelete(new QueryBuild(0), $table);
 	}
 
 	/**
 	 * @param $query
 	 * @return QueryCustom
 	 */
-	public static function query( $query )
+	public static function query($query)
 	{
-		return new QueryCustom( new QueryBuild( 1 ), $query );
+		return new QueryCustom(new QueryBuild(1), $query);
 	}
 
 	/**

src/Statements/QueryUpdate.php

Spacing +12 added lines, -12 removed lines

@@ -39,12 +39,12 @@ 
 	 * @param QueryBuild $queryBuild
 	 * @param null $table
 	 */
-	public function __construct( QueryBuild $queryBuild, $table = null )
+	public function __construct(QueryBuild $queryBuild, $table = null)
 	{
-		parent::__construct( $queryBuild, $table );
+		parent::__construct($queryBuild, $table);
 	}
 
-	public function getSyntax( $replacement = self::REPLACEMENT_NONE )
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
 	{
 
 		$syntax = array();
@@ -62,17 +62,17 @@ 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
 
 		/**
 		 * IGNORE clause
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
 
 		/**
 		 * TABLE update
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::TABLE);
 
 		/**
 		 * FIELDS update
@@ -94,9 +94,9 @@ 
 		 */
 		$syntax[] = $this->getLimitSyntax();
 
-		$syntax = implode( ' ', $syntax );
+		$syntax = implode(' ', $syntax);
 
-		return $this->getSyntaxReplace( $syntax, $replacement );
+		return $this->getSyntaxReplace($syntax, $replacement);
 
 	}
 
@@ -108,14 +108,14 @@ 
 	{
 
 		if (
-			$this->queryStructure->getElement( ( QueryStructure::WHERE_TRIGGER ) ) &&
-			!count( $this->queryStructure->getElement( QueryStructure::WHERE ) )
+			$this->queryStructure->getElement((QueryStructure::WHERE_TRIGGER)) &&
+			!count($this->queryStructure->getElement(QueryStructure::WHERE))
 		)
-			throw new QueryException( 'Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER );
+			throw new QueryException('Where clause is required for this statement!', QueryException::QUERY_ERROR_DELETE_NOT_FILTER);
 
 		return DbService::getInstance()->query(
 			$this->getSyntax(),
-			$this->queryStructure->getElement( QueryStructure::BIND_PARAMS )
+			$this->queryStructure->getElement(QueryStructure::BIND_PARAMS)
 		);
 	}
 }
\ No newline at end of file

src/Statements/QueryCustom.php

Spacing +11 added lines, -11 removed lines

@@ -43,22 +43,22 @@ 
 	protected $tablePrefix;
 
 
-	public function __construct( QueryBuild $queryBuild, $query = '' )
+	public function __construct(QueryBuild $queryBuild, $query = '')
 	{
 		$this->queryBuild = $queryBuild;
 		$this->queryStructure = new QueryStructure();
-		$this->queryStructure->setElement( QueryStructure::STATEMENT, $this->statement );
-		$this->queryStructure->setElement( QueryStructure::QUERY_TYPE, $this->queryBuild->getType() );
-		$this->queryStructure->setElement( QueryStructure::QUERY_STRING, $query );
+		$this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
+		$this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
+		$this->queryStructure->setElement(QueryStructure::QUERY_STRING, $query);
 	}
 
 	/**
 	 * @param array $params
 	 * @return $this
 	 */
-	public function withBindParams( array $params = [] )
+	public function withBindParams(array $params = [])
 	{
-		$this->queryStructure->replaceElement( QueryStructure::BIND_PARAMS, $params );
+		$this->queryStructure->replaceElement(QueryStructure::BIND_PARAMS, $params);
 
 		return $this;
 	}
@@ -67,9 +67,9 @@ 
 	 * @param bool|int $replacement
 	 * @return mixed
 	 */
-	public function getSyntax( $replacement = self::REPLACEMENT_NONE )
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
 	{
-		return $this->queryStructure->getElement( QueryStructure::QUERY_STRING );
+		return $this->queryStructure->getElement(QueryStructure::QUERY_STRING);
 	}
 
 	/**
@@ -77,7 +77,7 @@ 
 	 */
 	public function getBindParams()
 	{
-		return $this->queryStructure->getElement( QueryStructure::BIND_PARAMS );
+		return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
 	}
 
 	/**
@@ -86,8 +86,8 @@ 
 	public function execute()
 	{
 		return DbService::getInstance()->query(
-			$this->queryStructure->getElement( QueryStructure::QUERY_STRING ),
-			$this->queryStructure->getElement( QueryStructure::BIND_PARAMS )
+			$this->queryStructure->getElement(QueryStructure::QUERY_STRING),
+			$this->queryStructure->getElement(QueryStructure::BIND_PARAMS)
 		);
 	}
 

src/Statements/QueryStatementInterface.php

Spacing +1 added lines, -1 removed lines

@@ -18,7 +18,7 @@
 	 * @param bool $replacement
 	 * @return string
 	 */
-	public function getSyntax( $replacement = self::REPLACEMENT_NONE );
+	public function getSyntax($replacement = self::REPLACEMENT_NONE);
 
 	public function execute();
 

src/Statements/QueryStatement.php

Spacing +6 added lines, -6 removed lines

@@ -63,16 +63,16 @@ 
 	 * @param string $table
 	 * @throws QueryException
 	 */
-	public function __construct( QueryBuild $queryBuild, $table = '' )
+	public function __construct(QueryBuild $queryBuild, $table = '')
 	{
 
-		$table = $this->validateTable( $table );
+		$table = $this->validateTable($table);
 
 		$this->queryBuild = $queryBuild;
 		$this->queryStructure = new QueryStructure();
-		$this->queryStructure->setElement( QueryStructure::TABLE, $table );
-		$this->queryStructure->setElement( QueryStructure::STATEMENT, $this->statement );
-		$this->queryStructure->setElement( QueryStructure::QUERY_TYPE, $this->queryBuild->getType() );
+		$this->queryStructure->setElement(QueryStructure::TABLE, $table);
+		$this->queryStructure->setElement(QueryStructure::STATEMENT, $this->statement);
+		$this->queryStructure->setElement(QueryStructure::QUERY_TYPE, $this->queryBuild->getType());
 
 	}
 
@@ -81,7 +81,7 @@ 
 	 */
 	public function getBindParams()
 	{
-		return $this->queryStructure->getElement( QueryStructure::BIND_PARAMS );
+		return $this->queryStructure->getElement(QueryStructure::BIND_PARAMS);
 	}
 
 

src/Statements/QueryInsertMultiple.php

Spacing +10 added lines, -10 removed lines

@@ -36,13 +36,13 @@ 
 	 * @param QueryBuild $queryBuild
 	 * @param null $table
 	 */
-	public function __construct( QueryBuild $queryBuild, $table = null )
+	public function __construct(QueryBuild $queryBuild, $table = null)
 	{
-		parent::__construct( $queryBuild, $table );
-		$this->queryStructure->setElement( QueryStructure::FIELDS, array() );
+		parent::__construct($queryBuild, $table);
+		$this->queryStructure->setElement(QueryStructure::FIELDS, array());
 	}
 
-	public function getSyntax( $replacement = self::REPLACEMENT_NONE )
+	public function getSyntax($replacement = self::REPLACEMENT_NONE)
 	{
 		$syntax = array();
 
@@ -59,26 +59,26 @@ 
 		/**
 		 * PRIORITY
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::PRIORITY );
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::PRIORITY);
 
 		/**
 		 * IGNORE clause
 		 */
-		$syntax[] = $this->queryStructure->getElement( QueryStructure::IGNORE ) ? 'IGNORE' : '';
+		$syntax[] = $this->queryStructure->getElement(QueryStructure::IGNORE) ? 'IGNORE' : '';
 
 		/**
 		 * INTO table
 		 */
-		$syntax[] = 'INTO ' . $this->queryStructure->getElement( QueryStructure::TABLE );
+		$syntax[] = 'INTO ' . $this->queryStructure->getElement(QueryStructure::TABLE);
 
 		/**
 		 * FIELDS update
 		 */
 		$syntax[] = $this->getInsertMultipleRowsSyntax();
 
-		$syntax = implode( ' ', $syntax );
+		$syntax = implode(' ', $syntax);
 
-		return $this->getSyntaxReplace( $syntax, $replacement );
+		return $this->getSyntaxReplace($syntax, $replacement);
 
 	}
 
@@ -86,7 +86,7 @@ 
 	{
 		return DbService::getInstance()->query(
 			$this->getSyntax(),
-			$this->queryStructure->getElement( QueryStructure::BIND_PARAMS )
+			$this->queryStructure->getElement(QueryStructure::BIND_PARAMS)
 		);
 	}
 }
\ No newline at end of file