EmmetBlue / Emmet-Blue

tests/Core/Database/Abstraction/InsertQueryBuilderTest.php

Indentation +37 added lines, -37 removed lines

@@ -12,54 +12,54 @@
 use EmmetBlue\Core\Database\Abstraction\InsertQueryBuilder;
 
 /**
-  * class QueryBuilderTest.
-  *
-  * @author Samuel Adeshina <samueladeshina73@gmail.com>
-  *
-  * @since v0.0.1 27/05/2016 14:27
-  */
+ * class QueryBuilderTest.
+ *
+ * @author Samuel Adeshina <samueladeshina73@gmail.com>
+ *
+ * @since v0.0.1 27/05/2016 14:27
+ */
  class InsertQueryBuilderTest extends \PHPUnit_Framework_TestCase
  {
-     public function testInsertBuilderWithOnlyConstructorParameter()
-     {
-         $queryBuilder = new InsertQueryBuilder('tbl_name');
+	 public function testInsertBuilderWithOnlyConstructorParameter()
+	 {
+		 $queryBuilder = new InsertQueryBuilder('tbl_name');
 
-         $builtQuery = (string) $queryBuilder;
-         $expectedQuery = 'INSERT INTO tbl_name';
+		 $builtQuery = (string) $queryBuilder;
+		 $expectedQuery = 'INSERT INTO tbl_name';
 
-         $this->assertEquals($expectedQuery, $builtQuery);
-     }
+		 $this->assertEquals($expectedQuery, $builtQuery);
+	 }
 
-     public function testInsertBuilderWithIntoMethod()
-     {
-         $queryBuilder = new InsertQueryBuilder();
-         $queryBuilder = $queryBuilder->into('tbl_name');
+	 public function testInsertBuilderWithIntoMethod()
+	 {
+		 $queryBuilder = new InsertQueryBuilder();
+		 $queryBuilder = $queryBuilder->into('tbl_name');
 
-         $builtQuery = (string) $queryBuilder;
-         $expectedQuery = 'INSERT INTO tbl_name';
+		 $builtQuery = (string) $queryBuilder;
+		 $expectedQuery = 'INSERT INTO tbl_name';
 
-         $this->assertEquals($expectedQuery, $builtQuery);
-     }
+		 $this->assertEquals($expectedQuery, $builtQuery);
+	 }
 
-     public function testInsertBuilderWithIntoAndTableColumnsMethod()
-     {
-         $queryBuilder = new InsertQueryBuilder();
-         $queryBuilder = $queryBuilder->into('tbl_name', ['tbl_col1', 'tbl_col2']);
+	 public function testInsertBuilderWithIntoAndTableColumnsMethod()
+	 {
+		 $queryBuilder = new InsertQueryBuilder();
+		 $queryBuilder = $queryBuilder->into('tbl_name', ['tbl_col1', 'tbl_col2']);
 
-         $builtQuery = (string) $queryBuilder;
-         $expectedQuery = 'INSERT INTO tbl_name(tbl_col1,tbl_col2)';
+		 $builtQuery = (string) $queryBuilder;
+		 $expectedQuery = 'INSERT INTO tbl_name(tbl_col1,tbl_col2)';
 
-         $this->assertEquals($expectedQuery, $builtQuery);
-     }
+		 $this->assertEquals($expectedQuery, $builtQuery);
+	 }
 
-     public function testInsertBuilderWithConstructorParameterAndValuesKeyword()
-     {
-         $queryBuilder = new InsertQueryBuilder('tbl_name');
-         $queryBuilder = $queryBuilder->values(['tbl_col_val1', 'tbl_col_val2']);
+	 public function testInsertBuilderWithConstructorParameterAndValuesKeyword()
+	 {
+		 $queryBuilder = new InsertQueryBuilder('tbl_name');
+		 $queryBuilder = $queryBuilder->values(['tbl_col_val1', 'tbl_col_val2']);
 
-         $expectedQuery = 'INSERT INTO tbl_name VALUES (tbl_col_val1,tbl_col_val2)';
-         $builtQuery = (string) $queryBuilder;
+		 $expectedQuery = 'INSERT INTO tbl_name VALUES (tbl_col_val1,tbl_col_val2)';
+		 $builtQuery = (string) $queryBuilder;
 
-         $this->assertEquals($expectedQuery, $builtQuery);
-     }
+		 $this->assertEquals($expectedQuery, $builtQuery);
+	 }
  }

tests/Core/Database/Abstraction/QueryBuilderTest.php

Indentation +18 added lines, -18 removed lines

@@ -11,27 +11,27 @@
 use EmmetBlue\Core\Database\Abstraction\QueryBuilder;
 
 /**
-  * class QueryBuilderTest.
-  *
-  * @author Samuel Adeshina <samueladeshina73@gmail.com>
-  *
-  * @since v0.0.1 27/05/2016 14:27
-  */
+ * class QueryBuilderTest.
+ *
+ * @author Samuel Adeshina <samueladeshina73@gmail.com>
+ *
+ * @since v0.0.1 27/05/2016 14:27
+ */
  class QueryBuilderTest extends \PHPUnit_Framework_TestCase
  {
-     public function testBuilderActuallyBuilding()
-     {
-         $queryBuilder = new QueryBuilder('INSERT INTO tbl_name');
-         $queryBuilder = $queryBuilder->build("VALUES ('tbl_col1', 'tbl_col2')");
+	 public function testBuilderActuallyBuilding()
+	 {
+		 $queryBuilder = new QueryBuilder('INSERT INTO tbl_name');
+		 $queryBuilder = $queryBuilder->build("VALUES ('tbl_col1', 'tbl_col2')");
 
-         $builtQuery = (string) $queryBuilder;
-         $expectedQuery = "INSERT INTO tbl_name VALUES ('tbl_col1', 'tbl_col2')";
+		 $builtQuery = (string) $queryBuilder;
+		 $expectedQuery = "INSERT INTO tbl_name VALUES ('tbl_col1', 'tbl_col2')";
 
-         $this->assertEquals($expectedQuery, $builtQuery);
-     }
+		 $this->assertEquals($expectedQuery, $builtQuery);
+	 }
 
-     public function testWrapStringFunctionBehavesStatically()
-     {
-         $built = QueryBuilder::wrapString('Name', "'");
-     }
+	 public function testWrapStringFunctionBehavesStatically()
+	 {
+		 $built = QueryBuilder::wrapString('Name', "'");
+	 }
  }

src/Core/Connection/ConnectableInterface.php

Indentation +26 added lines, -26 removed lines

@@ -18,33 +18,33 @@
  */
 interface ConnectableInterface
 {
-    /**
-     * Setter for the DSN string {@see $dsn}
-     *
-     * @param array $dsnArray
-     * @return void
-     */
-    public function setDsn(array $dsnArray);
+	/**
+	 * Setter for the DSN string {@see $dsn}
+	 *
+	 * @param array $dsnArray
+	 * @return void
+	 */
+	public function setDsn(array $dsnArray);
 
-    /**
-     * Establishes connection
-     *
-     * @param string $username optional
-     * @param string $password optional
-     * @throws [@todo get exceptions]
-     * @return void
-     */
-    public function connect(string $username, string $password="");
+	/**
+	 * Establishes connection
+	 *
+	 * @param string $username optional
+	 * @param string $password optional
+	 * @throws [@todo get exceptions]
+	 * @return void
+	 */
+	public function connect(string $username, string $password="");
 
-    /**
-     * Returns an instance a pdo intance of the connection object
-     *
-     * @return \PDO
-     */
-    public function getConnection() : \PDO;
+	/**
+	 * Returns an instance a pdo intance of the connection object
+	 *
+	 * @return \PDO
+	 */
+	public function getConnection() : \PDO;
 
-    /**
-     * Closes connection
-     */
-    public function disableConnection();
+	/**
+	 * Closes connection
+	 */
+	public function disableConnection();
 }

src/Core/Connection/ConnectionAdapter.php

Indentation +15 added lines, -15 removed lines

@@ -20,22 +20,22 @@
 {
 	public $connection;
 
-    public function __construct(string $adapter, array $dsnArray, string $username=null, string $password=null)
-    {
-    	$class = __NAMESPACE__."\\Adapters\\$adapter";
-    	$adapterObject = new $class;
+	public function __construct(string $adapter, array $dsnArray, string $username=null, string $password=null)
+	{
+		$class = __NAMESPACE__."\\Adapters\\$adapter";
+		$adapterObject = new $class;
 
-    	if ($adapterObject instanceof ConnectableInterface)
-    	{
-    		$adapterObject->setDsn($dsnArray);
-	    	$adapterObject->connect($username, $password);
-    	}
+		if ($adapterObject instanceof ConnectableInterface)
+		{
+			$adapterObject->setDsn($dsnArray);
+			$adapterObject->connect($username, $password);
+		}
 
-    	$this->connection = $adapterObject->getConnection();
-    }
+		$this->connection = $adapterObject->getConnection();
+	}
 
-    public function getConnection() : \PDO
-    {
-    	return $this->connection;
-    }
+	public function getConnection() : \PDO
+	{
+		return $this->connection;
+	}
 }
\ No newline at end of file

src/Core/Factory/DatabaseConnectionFactory.php

Indentation +39 added lines, -39 removed lines

@@ -20,43 +20,43 @@
  */
 class DatabaseConnectionFactory
 {
-    /**
-     * @var \PDO $connectionObject
-     */
-    private static $connectionObject;
-
-    /**
-     * Gets the config values defined in the database-config.json file
-     * and uses the values to create a new connection object.
-     */
-    public static function bootstrap()
-    {
-        $databaseConfigJson = file_get_contents("bin/configs/database-config.json");
-
-        $databaseConfig = json_decode($databaseConfigJson);
-
-        $adapter = $databaseConfig->adapter;
-        $server = $databaseConfig->server;
-        $database = $databaseConfig->database;
-        $username = $databaseConfig->username;
-        $password = $databaseConfig->password;
-
-        self::$connectionObject = new Connection($adapter, [$server, $database], $username, $password);
-
-        if ($databaseConfig->showError)
-        {
-            self::$connectionObject->getConnection()->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
-        }
-    }
-
-    /**
-     * Returns a new connection object
-     * 
-     * @return \PDO
-     */
-    public static function getConnection() : \PDO
-    {
-        self::bootstrap();
-        return self::$connectionObject->getConnection();
-    }
+	/**
+	 * @var \PDO $connectionObject
+	 */
+	private static $connectionObject;
+
+	/**
+	 * Gets the config values defined in the database-config.json file
+	 * and uses the values to create a new connection object.
+	 */
+	public static function bootstrap()
+	{
+		$databaseConfigJson = file_get_contents("bin/configs/database-config.json");
+
+		$databaseConfig = json_decode($databaseConfigJson);
+
+		$adapter = $databaseConfig->adapter;
+		$server = $databaseConfig->server;
+		$database = $databaseConfig->database;
+		$username = $databaseConfig->username;
+		$password = $databaseConfig->password;
+
+		self::$connectionObject = new Connection($adapter, [$server, $database], $username, $password);
+
+		if ($databaseConfig->showError)
+		{
+			self::$connectionObject->getConnection()->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
+		}
+	}
+
+	/**
+	 * Returns a new connection object
+	 * 
+	 * @return \PDO
+	 */
+	public static function getConnection() : \PDO
+	{
+		self::bootstrap();
+		return self::$connectionObject->getConnection();
+	}
 }

src/Core/Builder/QueryBuilder/DeleteQueryBuilder.php

Indentation +24 added lines, -24 removed lines

@@ -17,31 +17,31 @@
  */
 class DeleteQueryBuilder extends QueryBuilder
 {
-    /**
-     * @var \EmmetBlue\Core\Builder\QueryBuilder
-     */
-    protected $queryBuilder;
+	/**
+	 * @var \EmmetBlue\Core\Builder\QueryBuilder
+	 */
+	protected $queryBuilder;
 
-    /**
-     * @param string|null $tableName
-     */
-    public function __construct()
-    {
-        $DeleteKeyword = "Delete";
-        $this->queryBuilder = $this->build($DeleteKeyword);
-    }
+	/**
+	 * @param string|null $tableName
+	 */
+	public function __construct()
+	{
+		$DeleteKeyword = "Delete";
+		$this->queryBuilder = $this->build($DeleteKeyword);
+	}
 
-     /**
-     * {@inheritdoc}
-     *
-     * @param string $tableName
-     *
-     * @return \EmmetBlue\Core\Builder\DeleteQueryBuilder
-     */
-    public function from(string $tableName)
-    {
-        $this->queryBuilder = $this->queryBuilder->build("FROM ".$tableName);
+	 /**
+	  * {@inheritdoc}
+	  *
+	  * @param string $tableName
+	  *
+	  * @return \EmmetBlue\Core\Builder\DeleteQueryBuilder
+	  */
+	public function from(string $tableName)
+	{
+		$this->queryBuilder = $this->queryBuilder->build("FROM ".$tableName);
 
-        return $this;
-    }
+		return $this;
+	}
 }

src/Core/Builder/QueryBuilder/UpdateQueryBuilder.php

Indentation +38 added lines, -38 removed lines

@@ -17,49 +17,49 @@
  */
 class UpdateQueryBuilder extends QueryBuilder
 {
-    /**
-     * @var \EmmetBlue\Core\Builder\QueryBuilder
-     */
-    protected $queryBuilder;
+	/**
+	 * @var \EmmetBlue\Core\Builder\QueryBuilder
+	 */
+	protected $queryBuilder;
 
-    /**
-     * @param string|null $tableName
-     */
-    public function __construct(string $tableName = null)
-    {
-        $updateKeyword = (is_null($tableName)) ? 'UPDATE' : 'UPDATE '.$tableName;
-        $this->queryBuilder = $this->build($updateKeyword);
-    }
+	/**
+	 * @param string|null $tableName
+	 */
+	public function __construct(string $tableName = null)
+	{
+		$updateKeyword = (is_null($tableName)) ? 'UPDATE' : 'UPDATE '.$tableName;
+		$this->queryBuilder = $this->build($updateKeyword);
+	}
 
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $tableName
-     *
-     * @return \EmmetBlue\Core\Builder\UpdateQueryBuilder
-     */
-    public function table(string $tableName)
-    {
-        $this->queryBuilder = $this->queryBuilder->build($tableName);
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $tableName
+	 *
+	 * @return \EmmetBlue\Core\Builder\UpdateQueryBuilder
+	 */
+	public function table(string $tableName)
+	{
+		$this->queryBuilder = $this->queryBuilder->build($tableName);
 
-        return $this;
-    }
+		return $this;
+	}
 
-    /**
-     * {@inheritdoc}
-     *
-     * @param string[] $inputValues
-     *
-     * @return \EmmetBlue\Core\Builder\UpdateQueryBuilder
-     */
-    public function set(array $inputValues)
-    {
-        $valuesKeyword = 'SET ';
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string[] $inputValues
+	 *
+	 * @return \EmmetBlue\Core\Builder\UpdateQueryBuilder
+	 */
+	public function set(array $inputValues)
+	{
+		$valuesKeyword = 'SET ';
 
-        $valuesKeyword .= self::getImplodedStringWithKeys($inputValues);
+		$valuesKeyword .= self::getImplodedStringWithKeys($inputValues);
 
-        $this->queryBuilder = $this->queryBuilder->build($valuesKeyword);
+		$this->queryBuilder = $this->queryBuilder->build($valuesKeyword);
 
-        return $this;
-    }
+		return $this;
+	}
 }

src/Core/Builder/QueryBuilder/InsertQueryBuilder.php

Indentation +54 added lines, -54 removed lines

@@ -17,68 +17,68 @@
  */
 class InsertQueryBuilder extends QueryBuilder
 {
-    /**
-     * @var \EmmetBlue\Core\Abstraction\QueryBuilder
-     */
-    protected $queryBuilder;
+	/**
+	 * @var \EmmetBlue\Core\Abstraction\QueryBuilder
+	 */
+	protected $queryBuilder;
 
-    /**
-     * @param string|null $tableName
-     */
-    public function __construct(string $tableName = null)
-    {
-        $insertKeyword = (is_null($tableName)) ? 'INSERT' : 'INSERT INTO '.$tableName;
-        $this->queryBuilder = $this->build($insertKeyword);
-    }
+	/**
+	 * @param string|null $tableName
+	 */
+	public function __construct(string $tableName = null)
+	{
+		$insertKeyword = (is_null($tableName)) ? 'INSERT' : 'INSERT INTO '.$tableName;
+		$this->queryBuilder = $this->build($insertKeyword);
+	}
 
-    /**
-     * {@inheritdoc}
-     *
-     * @param string   $tableName
-     * @param string[] $tableColumns Optional, provide this to specify the
-     *                               columns that should be acted on
-     *
-     * @return \EmmetBlue\Core\Abstraction\InsertQueryBuilder
-     */
-    public function into(string $tableName, array $tableColumns = [])
-    {
-        $intoKeyword = 'INTO '.$tableName;
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string   $tableName
+	 * @param string[] $tableColumns Optional, provide this to specify the
+	 *                               columns that should be acted on
+	 *
+	 * @return \EmmetBlue\Core\Abstraction\InsertQueryBuilder
+	 */
+	public function into(string $tableName, array $tableColumns = [])
+	{
+		$intoKeyword = 'INTO '.$tableName;
 
-        if (!empty($tableColumns)) {
-            $intoKeyword .= $this->wrapString(self::getImplodedString($tableColumns), '(', ')');
-        }
+		if (!empty($tableColumns)) {
+			$intoKeyword .= $this->wrapString(self::getImplodedString($tableColumns), '(', ')');
+		}
 
-        $this->queryBuilder = $this->queryBuilder->build($intoKeyword);
+		$this->queryBuilder = $this->queryBuilder->build($intoKeyword);
 
-        return $this;
-    }
+		return $this;
+	}
 
-    /**
-     * {@inheritdoc}
-     *
-     * @param string[] $inputValues
-     *
-     * @return \EmmetBlue\Core\Abstraction\InsertQueryBuilder
-     */
-    public function values(array $inputValues)
-    {
-        $valuesKeyword = 'VALUES ';
-        $isMultidimentional = is_array($inputValues[0]);
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string[] $inputValues
+	 *
+	 * @return \EmmetBlue\Core\Abstraction\InsertQueryBuilder
+	 */
+	public function values(array $inputValues)
+	{
+		$valuesKeyword = 'VALUES ';
+		$isMultidimentional = is_array($inputValues[0]);
 
-        if (!$isMultidimentional) {
-            $valuesKeyword .= $this->wrapString(self::getImplodedString($inputValues), '(', ')');
-        } else {
-            $tempValuesKeywords = [];
-            foreach ($inputValues as $inputValue) {
-                $tempValuesKeywords[] = $this->wrapString(self::getImplodedString($inputValue), '(', ')');
-            }
+		if (!$isMultidimentional) {
+			$valuesKeyword .= $this->wrapString(self::getImplodedString($inputValues), '(', ')');
+		} else {
+			$tempValuesKeywords = [];
+			foreach ($inputValues as $inputValue) {
+				$tempValuesKeywords[] = $this->wrapString(self::getImplodedString($inputValue), '(', ')');
+			}
 
-            $valuesKeyword .= self::getImplodedString($tempValuesKeywords);
-            unset($tempValuesKeywords);
-        }
+			$valuesKeyword .= self::getImplodedString($tempValuesKeywords);
+			unset($tempValuesKeywords);
+		}
 
-        $this->queryBuilder = $this->queryBuilder->build($valuesKeyword);
+		$this->queryBuilder = $this->queryBuilder->build($valuesKeyword);
 
-        return $this;
-    }
+		return $this;
+	}
 }

src/Core/Builder/QueryBuilder/QueryBuilder.php

Indentation +165 added lines, -165 removed lines

@@ -20,169 +20,169 @@
  */
 class QueryBuilder implements BuildableInterface
 {
-    /**
-     * @var string Global Sql Statement
-     */
-    private $sqlStatement;
-
-    /**
-     * @var string SPACE
-     */
-    const SPACE = ' ';
-
-    /**
-     * @param string | null $sqlStatement SQL Statement to be processed by the build method
-     *
-     * @throws {@todo Write exception class}
-     */
-    public function __construct(string $sqlStatement = null)
-    {
-        self::setSqlStatement($sqlStatement);
-    }
-
-    /**
-     * Returns the string value of the global sqlStatement variable.
-     *
-     * @return string
-     */
-    private function getSqlStatement()
-    {
-        return $this->sqlStatement;
-    }
-
-    /**
-     * Sets/Modifies the value of the global sqlStatement variable.
-     *
-     * @param string $sqlStatement to set/replace global equivalent to.
-     *
-     * @return null
-     */
-    private function setSqlStatement(string $sqlStatement = null)
-    {
-        $this->sqlStatement = $sqlStatement;
-    }
-
-    /**
-     * Builds a QueryBuilder object.
-     * {@see QueryBuildableInterface}.
-     *
-     * @param string | null $sqlStringToAppend
-     *
-     * @throws {@todo Create exceptions}
-     *
-     * @return QueryBuilder new instance of the QueryBuilder object.
-     */
-    public function build(string $sqlStringToAppend) : BuildableInterface
-    {
-        $separator = (empty(self::getSqlStatement())) ? '' : self::SPACE;
-        $newSqlString = self::getSqlStatement().$separator.$sqlStringToAppend;
-        self::setSqlStatement($newSqlString);
-
-        return $this;
-    }
-
-    /**
-     * returns a `built sql` when the QueryBuilder object is casted to a string.
-     *
-     * @return string
-     */
-    public function __toString()
-    {
-        return self::getSqlStatement();
-    }
-
-    /**
-     * Implodes an array into a string.
-     *
-     * @param array  $arrayToImplode
-     * @param string $delimiter      Optional.
-     *
-     * @return string
-     */
-    protected function getImplodedString(array $arrayToImplode, string $delimiter = ',') : string
-    {
-        return implode($delimiter, $arrayToImplode);
-    }
-
-    /**
-     * Implodes an array into a string while keeping track of the keys.
-     *
-     * @param array  $arrayToImplode
-     * @param string $delimiter Optional.
-     *
-     * @return string
-     */
-    protected function getImplodedStringWithKeys(array $arrayToImplode, string $keyDelimiter='=', string $delimiter = ',') : string
-    {
-        $implodedStrings = []; 
-
-        foreach ($arrayToImplode as $key=>$value)
-        {
-            $implodedStrings[] = $key.$keyDelimiter.$value;
-        }
-
-        return implode($delimiter, $implodedStrings);
-    }
-
-    /**
-     * Wraps a string with specified characters.
-     *
-     * @param string      $strBefore
-     * @param string|null $strAfter
-     * @param string      $strToWrap
-     *
-     * @return string
-     */
-    public static function wrapString(string $strToWrap, string $strBefore, string $strAfter = null) : string
-    {
-        return $strBefore.$strToWrap.(is_null($strAfter) ? $strBefore : $strAfter);
-    }
-
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $condition
-     *
-     * @return \EmmetBlue\Core\Builder\BuildableInterface
-     */
-    public function where(string $condition)
-    {
-        $whereString = "WHERE $condition";
-
-        $this->queryBuilder = $this->queryBuilder->build($whereString);
-
-        return $this;
-    }
-
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $condition
-     *
-     * @return \EmmetBlue\Core\Builder\BuildableInterface
-     */
-    public function andWhere(string $condition)
-    {
-         $whereString = "AND WHERE $condition";
-
-        $this->queryBuilder = $this->queryBuilder->build($whereString);
-
-        return $this;
-    }
-
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $condition
-     *
-     * @return \EmmetBlue\Core\Builder\BuildableInterface
-     */
-    public function orWhere(string $condition)
-    {
-         $whereString = "OR WHERE $condition";
-
-        $this->queryBuilder = $this->queryBuilder->build($whereString);
-
-        return $this;
-    }
+	/**
+	 * @var string Global Sql Statement
+	 */
+	private $sqlStatement;
+
+	/**
+	 * @var string SPACE
+	 */
+	const SPACE = ' ';
+
+	/**
+	 * @param string | null $sqlStatement SQL Statement to be processed by the build method
+	 *
+	 * @throws {@todo Write exception class}
+	 */
+	public function __construct(string $sqlStatement = null)
+	{
+		self::setSqlStatement($sqlStatement);
+	}
+
+	/**
+	 * Returns the string value of the global sqlStatement variable.
+	 *
+	 * @return string
+	 */
+	private function getSqlStatement()
+	{
+		return $this->sqlStatement;
+	}
+
+	/**
+	 * Sets/Modifies the value of the global sqlStatement variable.
+	 *
+	 * @param string $sqlStatement to set/replace global equivalent to.
+	 *
+	 * @return null
+	 */
+	private function setSqlStatement(string $sqlStatement = null)
+	{
+		$this->sqlStatement = $sqlStatement;
+	}
+
+	/**
+	 * Builds a QueryBuilder object.
+	 * {@see QueryBuildableInterface}.
+	 *
+	 * @param string | null $sqlStringToAppend
+	 *
+	 * @throws {@todo Create exceptions}
+	 *
+	 * @return QueryBuilder new instance of the QueryBuilder object.
+	 */
+	public function build(string $sqlStringToAppend) : BuildableInterface
+	{
+		$separator = (empty(self::getSqlStatement())) ? '' : self::SPACE;
+		$newSqlString = self::getSqlStatement().$separator.$sqlStringToAppend;
+		self::setSqlStatement($newSqlString);
+
+		return $this;
+	}
+
+	/**
+	 * returns a `built sql` when the QueryBuilder object is casted to a string.
+	 *
+	 * @return string
+	 */
+	public function __toString()
+	{
+		return self::getSqlStatement();
+	}
+
+	/**
+	 * Implodes an array into a string.
+	 *
+	 * @param array  $arrayToImplode
+	 * @param string $delimiter      Optional.
+	 *
+	 * @return string
+	 */
+	protected function getImplodedString(array $arrayToImplode, string $delimiter = ',') : string
+	{
+		return implode($delimiter, $arrayToImplode);
+	}
+
+	/**
+	 * Implodes an array into a string while keeping track of the keys.
+	 *
+	 * @param array  $arrayToImplode
+	 * @param string $delimiter Optional.
+	 *
+	 * @return string
+	 */
+	protected function getImplodedStringWithKeys(array $arrayToImplode, string $keyDelimiter='=', string $delimiter = ',') : string
+	{
+		$implodedStrings = []; 
+
+		foreach ($arrayToImplode as $key=>$value)
+		{
+			$implodedStrings[] = $key.$keyDelimiter.$value;
+		}
+
+		return implode($delimiter, $implodedStrings);
+	}
+
+	/**
+	 * Wraps a string with specified characters.
+	 *
+	 * @param string      $strBefore
+	 * @param string|null $strAfter
+	 * @param string      $strToWrap
+	 *
+	 * @return string
+	 */
+	public static function wrapString(string $strToWrap, string $strBefore, string $strAfter = null) : string
+	{
+		return $strBefore.$strToWrap.(is_null($strAfter) ? $strBefore : $strAfter);
+	}
+
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $condition
+	 *
+	 * @return \EmmetBlue\Core\Builder\BuildableInterface
+	 */
+	public function where(string $condition)
+	{
+		$whereString = "WHERE $condition";
+
+		$this->queryBuilder = $this->queryBuilder->build($whereString);
+
+		return $this;
+	}
+
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $condition
+	 *
+	 * @return \EmmetBlue\Core\Builder\BuildableInterface
+	 */
+	public function andWhere(string $condition)
+	{
+		 $whereString = "AND WHERE $condition";
+
+		$this->queryBuilder = $this->queryBuilder->build($whereString);
+
+		return $this;
+	}
+
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $condition
+	 *
+	 * @return \EmmetBlue\Core\Builder\BuildableInterface
+	 */
+	public function orWhere(string $condition)
+	{
+		 $whereString = "OR WHERE $condition";
+
+		$this->queryBuilder = $this->queryBuilder->build($whereString);
+
+		return $this;
+	}
 }