EmmetBlue / Emmet-Blue

src/Core/Connection/Adapters/SQLite.php

Indentation +90 added lines, -90 removed lines

@@ -21,106 +21,106 @@
  */
 class SQLite implements ConnectableInterface
 {
-    /**
-     * @var string $dsn
-     */
-    protected $dsn;
+	/**
+	 * @var string $dsn
+	 */
+	protected $dsn;
 
-    /**
-     * @var \PDO $connectionObject
-     */
-    protected $connectionObject;
+	/**
+	 * @var \PDO $connectionObject
+	 */
+	protected $connectionObject;
 
-    /**
-     * @var array loginData
-     */
-    private $loginData = [];
+	/**
+	 * @var array loginData
+	 */
+	private $loginData = [];
 
-    /**
-     * Setter for the DSN string {@see $dsn}
-     *
-     * MSSQl Server DSN Structure: sqlsrv:Server={srv};Database={db}"
-     * `$dsnArray[0] = {srv}`
-     * `$dsnArray[1] = {db}`
-     * Attributes = [2 - infinity]
-     *
-     * @param array $dsnArray
-     * @return void
-     */
-    public function setDsn(array $dsnArray)
-    {
-        $this->dsn = $dsnArray;
-    }
+	/**
+	 * Setter for the DSN string {@see $dsn}
+	 *
+	 * MSSQl Server DSN Structure: sqlsrv:Server={srv};Database={db}"
+	 * `$dsnArray[0] = {srv}`
+	 * `$dsnArray[1] = {db}`
+	 * Attributes = [2 - infinity]
+	 *
+	 * @param array $dsnArray
+	 * @return void
+	 */
+	public function setDsn(array $dsnArray)
+	{
+		$this->dsn = $dsnArray;
+	}
 
-    /**
-     * Establishes connection
-     *
-     * @param string $username
-     * @param string $password optional
-     * @throws \EmmetBlue\Core\Exception\SQLException
-     * @return void
-     */
-    public function connect(string $username="", string $password="")
-    {
-        $dbLocation = $this->dsn[0];
+	/**
+	 * Establishes connection
+	 *
+	 * @param string $username
+	 * @param string $password optional
+	 * @throws \EmmetBlue\Core\Exception\SQLException
+	 * @return void
+	 */
+	public function connect(string $username="", string $password="")
+	{
+		$dbLocation = $this->dsn[0];
 
-        try
-        {
-            $this->connectionObject = new \PDO("sqlite:$dbLocation");
-        }
-        catch (\PDOException $e)
-        {
-            throw new SQLException("Unable to connect to database", 400, $e);  
-        }
+		try
+		{
+			$this->connectionObject = new \PDO("sqlite:$dbLocation");
+		}
+		catch (\PDOException $e)
+		{
+			throw new SQLException("Unable to connect to database", 400, $e);  
+		}
 
-        $dsn = $this->dsn;
-        unset($dsn[0]);
+		$dsn = $this->dsn;
+		unset($dsn[0]);
         
-        foreach ($dsn as $attribute)
-        {
-            foreach ($attribute as $key=>$value)
-            {
-                $this->connectionObject->setAttribute($key, $value);
-            }
-        }
-    }
+		foreach ($dsn as $attribute)
+		{
+			foreach ($attribute as $key=>$value)
+			{
+				$this->connectionObject->setAttribute($key, $value);
+			}
+		}
+	}
 
-    /**
-     * Returns an instance a pdo intance of the connection object
-     *
-     * @return \PDO
-     */
-    public function getConnection() : \PDO
-    {
-        if ($this->connectionObject instanceof \PDO)
-        {
-            return $this->connectionObject;
-        }
+	/**
+	 * Returns an instance a pdo intance of the connection object
+	 *
+	 * @return \PDO
+	 */
+	public function getConnection() : \PDO
+	{
+		if ($this->connectionObject instanceof \PDO)
+		{
+			return $this->connectionObject;
+		}
 
-        $this->connect(
-            $this->loginData['username'] ?? '',
-            $this->loginData['password'] ?? ''
-        );
+		$this->connect(
+			$this->loginData['username'] ?? '',
+			$this->loginData['password'] ?? ''
+		);
 
-        return $this->connectionObject;
-    }
+		return $this->connectionObject;
+	}
 
-    /**
-     * Closes connection
-     */
-    public function disableConnection()
-    {
-        $this->connectionObject = null;
-    }
+	/**
+	 * Closes connection
+	 */
+	public function disableConnection()
+	{
+		$this->connectionObject = null;
+	}
 
-    /**
-     * Sets attributes for the PDO object
-     *
-     * @param \PDO $attribute
-     * @param \PDO $value
-     */
-    public function setAttribute(\PDO $attribute, \PDO $value)
-    {
-         $this->connectionObject->setAttribute($attribute, $value);
-    }
+	/**
+	 * Sets attributes for the PDO object
+	 *
+	 * @param \PDO $attribute
+	 * @param \PDO $value
+	 */
+	public function setAttribute(\PDO $attribute, \PDO $value)
+	{
+		 $this->connectionObject->setAttribute($attribute, $value);
+	}
 }

src/Core/Logger/ErrorLog.php

Indentation +23 added lines, -23 removed lines

@@ -22,21 +22,21 @@ 
  */
 class ErrorLog implements LogInterface
 {
-    public static function log(int $databaseUserId, string $errorNumber, string $errorSeverity, string $errorMessage, string $errorObject=null)
-    {
-        /**
-         * For now I am not doing anything with $errorObject yet.
-         *
-         * As soon as it can be properly serialized for the MSSQL Server db
-         * it shall be saved in the database.
-         *
-         * FUNNY: I'M GONNA INTENTIONALLY LEAVE THIS COMMIT FOR MY AMUSEMENT
-         * $errorObject, wasn't the issue. My DB schema was.
-         */
-        $insertBuilder = (new Builder("QueryBuilder", "Insert"))->getBuilder();
+	public static function log(int $databaseUserId, string $errorNumber, string $errorSeverity, string $errorMessage, string $errorObject=null)
+	{
+		/**
+		 * For now I am not doing anything with $errorObject yet.
+		 *
+		 * As soon as it can be properly serialized for the MSSQL Server db
+		 * it shall be saved in the database.
+		 *
+		 * FUNNY: I'M GONNA INTENTIONALLY LEAVE THIS COMMIT FOR MY AMUSEMENT
+		 * $errorObject, wasn't the issue. My DB schema was.
+		 */
+		$insertBuilder = (new Builder("QueryBuilder", "Insert"))->getBuilder();
 
-        $insertBuilder
-            ->into('
+		$insertBuilder
+			->into('
                 [Logs].[ErrorLog]
                 (
                     ErrorTime,
@@ -46,14 +46,14 @@ 
                     ErrorMessage
                 )
             ')
-            ->values([
-                'GETDATE()',
-                $databaseUserId,
-                QB::wrapString($errorNumber, "'"),
-                QB::wrapString($errorSeverity, "'"),
-                QB::wrapString($errorMessage, "'")
-            ]);
+			->values([
+				'GETDATE()',
+				$databaseUserId,
+				QB::wrapString($errorNumber, "'"),
+				QB::wrapString($errorSeverity, "'"),
+				QB::wrapString($errorMessage, "'")
+			]);
             
-        DBConnectionFactory::getConnection()->query((string)$insertBuilder);
-    }
+		DBConnectionFactory::getConnection()->query((string)$insertBuilder);
+	}
 }

src/Core/Logger/DatabaseLog.php

Indentation +22 added lines, -22 removed lines

@@ -22,12 +22,12 @@ 
  */
 class DatabaseLog implements LogInterface
 {
-    public static function log(string $databaseUserId, string $event, string $objectSchema, string $object, string $tSql)
-    {
-        $insertBuilder = (new Builder("QueryBuilder", "Insert"))->getBuilder();
-        try {
-            $insertBuilder
-                ->into('
+	public static function log(string $databaseUserId, string $event, string $objectSchema, string $object, string $tSql)
+	{
+		$insertBuilder = (new Builder("QueryBuilder", "Insert"))->getBuilder();
+		try {
+			$insertBuilder
+				->into('
                     [Logs].[DatabaseLog]
                     (
                         PostTime,
@@ -38,21 +38,21 @@ 
                         TSQL
                     )
                 ')
-                ->values([
-                    'GETDATE()',
-                    QB::wrapString($databaseUserId, "'"),
-                    QB::wrapString((string)$event, "'"),
-                    QB::wrapString($objectSchema, "'"),
-                    QB::wrapString($object, "'"),
-                    QB::wrapString(str_replace("'", "\"", $tSql), "'")
-                ]);
+				->values([
+					'GETDATE()',
+					QB::wrapString($databaseUserId, "'"),
+					QB::wrapString((string)$event, "'"),
+					QB::wrapString($objectSchema, "'"),
+					QB::wrapString($object, "'"),
+					QB::wrapString(str_replace("'", "\"", $tSql), "'")
+				]);
 
-            DBConnectionFactory::getConnection()->query((string)$insertBuilder);
-        } catch (\PDOException $e) {
-            echo $e->getMessage();
-            throw new SQLException(sprintf(
-                    "Unable to store database log"
-                ), 1);
-        }
-    }
+			DBConnectionFactory::getConnection()->query((string)$insertBuilder);
+		} catch (\PDOException $e) {
+			echo $e->getMessage();
+			throw new SQLException(sprintf(
+					"Unable to store database log"
+				), 1);
+		}
+	}
 }

src/Core/Constant.php

Indentation +27 added lines, -27 removed lines

@@ -17,35 +17,35 @@
  */
 class Constant
 {
-    /**
-     * Events
-     */
-    const EVENT_INSERT = 'EVENT: INSERT DML EVENT';
-    const EVENT_SELECT = 'EVENT: SELECT DML EVENT';
-    const EVENT_UPDATE = 'EVENT: UPDATE DML EVENT';
+	/**
+	 * Events
+	 */
+	const EVENT_INSERT = 'EVENT: INSERT DML EVENT';
+	const EVENT_SELECT = 'EVENT: SELECT DML EVENT';
+	const EVENT_UPDATE = 'EVENT: UPDATE DML EVENT';
 
-    /**
-     * @author Lucky Bardeson
-     */
-    const EVENT_DELETE = 'EVENT: DELETE DML EVENT';
+	/**
+	 * @author Lucky Bardeson
+	 */
+	const EVENT_DELETE = 'EVENT: DELETE DML EVENT';
 
-    /**
-     * Error Numbers
-     */
-    const ERROR_401 = 'ERROR_401: Resource Inaccessible';
-    const ERROR_402 = 'ERROR_402: Resource Requirements Not Met';
-    const ERROR_403 = 'ERROR_403: Resource Not Writable';
-    const ERROR_404 = 'ERROR_404: Resource Not Found';
+	/**
+	 * Error Numbers
+	 */
+	const ERROR_401 = 'ERROR_401: Resource Inaccessible';
+	const ERROR_402 = 'ERROR_402: Resource Requirements Not Met';
+	const ERROR_403 = 'ERROR_403: Resource Not Writable';
+	const ERROR_404 = 'ERROR_404: Resource Not Found';
 
-    /**
-     * Error Severities
-     */
-    const ERROR_HIGH = 'ERROR_SEVERITY: HIGH';
-    const ERROR_LOW = 'ERROR_SEVERITY: LOW';
-    const ERROR_NORMAL = 'ERROR_SEVERITY: NORMAL';
+	/**
+	 * Error Severities
+	 */
+	const ERROR_HIGH = 'ERROR_SEVERITY: HIGH';
+	const ERROR_LOW = 'ERROR_SEVERITY: LOW';
+	const ERROR_NORMAL = 'ERROR_SEVERITY: NORMAL';
 
-    /**
-     * 
-     */
-    const UNDEFINED = 0;
+	/**
+	 * 
+	 */
+	const UNDEFINED = 0;
 }

src/Core/Builder/QueryBuilder/SelectQueryBuilder.php

Indentation +72 added lines, -72 removed lines

@@ -17,84 +17,84 @@
  */
 class SelectQueryBuilder extends QueryBuilder
 {
-    /**
-     * @var \EmmetBlue\Core\Builder\QueryBuilder
-     */
-    protected $queryBuilder;
+	/**
+	 * @var \EmmetBlue\Core\Builder\QueryBuilder
+	 */
+	protected $queryBuilder;
 
-    /**
-     * @param string|null $tableName
-     */
-    public function __construct()
-    {
-        $SelectKeyword = "SELECT";
-        $this->queryBuilder = $this->build($SelectKeyword);
-    }
+	/**
+	 * @param string|null $tableName
+	 */
+	public function __construct()
+	{
+		$SelectKeyword = "SELECT";
+		$this->queryBuilder = $this->build($SelectKeyword);
+	}
 
-    /**
-     * {@inheritdoc}
-     *
-     * @param int $topValue
-     *
-     * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
-     */
-    public function top(int $topValue)
-    {
-        $this->queryBuilder = $this->queryBuilder->build("TOP ".$topValue);
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param int $topValue
+	 *
+	 * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
+	 */
+	public function top(int $topValue)
+	{
+		$this->queryBuilder = $this->queryBuilder->build("TOP ".$topValue);
 
-        return $this;
-    }
-    /**
-    * This method handles situations that requires to
-    * select all from the table.
-    * @param *
-    */
-    public function all()
-    {
-        $this->queryBuilder = $this->queryBuilder->build("*");
-        return $this;
-    }
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $columns
-     *
-     * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
-     */
-    public function columns(string ...$columns)
-    {
-        $this->queryBuilder = $this->queryBuilder->build(self::getImplodedString($columns));
+		return $this;
+	}
+	/**
+	 * This method handles situations that requires to
+	 * select all from the table.
+	 * @param *
+	 */
+	public function all()
+	{
+		$this->queryBuilder = $this->queryBuilder->build("*");
+		return $this;
+	}
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $columns
+	 *
+	 * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
+	 */
+	public function columns(string ...$columns)
+	{
+		$this->queryBuilder = $this->queryBuilder->build(self::getImplodedString($columns));
 
-        return $this;
-    }
+		return $this;
+	}
 
-     /**
-     * {@inheritdoc}
-     *
-     * @param string $tableName
-     *
-     * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
-     */
-    public function from(string $tableName)
-    {
-        $this->queryBuilder = $this->queryBuilder->build("FROM ".$tableName);
+	 /**
+	  * {@inheritdoc}
+	  *
+	  * @param string $tableName
+	  *
+	  * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
+	  */
+	public function from(string $tableName)
+	{
+		$this->queryBuilder = $this->queryBuilder->build("FROM ".$tableName);
 
-        return $this;
-    }
+		return $this;
+	}
 
-    /**
-     * {@inheritdoc}
-     *
-     * @param string $tableName
-     * @param string $condition
-     *
-     * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
-     */
-    public function innerJoin(string $tableName, string $condition)
-    {
-        $string = "INNER JOIN ".$tableName." ON ".$condition;
-        $this->queryBuilder = $this->queryBuilder->build($string);
+	/**
+	 * {@inheritdoc}
+	 *
+	 * @param string $tableName
+	 * @param string $condition
+	 *
+	 * @return \EmmetBlue\Core\Builder\SelectQueryBuilder
+	 */
+	public function innerJoin(string $tableName, string $condition)
+	{
+		$string = "INNER JOIN ".$tableName." ON ".$condition;
+		$this->queryBuilder = $this->queryBuilder->build($string);
 
-        return $this;
-    }
+		return $this;
+	}
 }

src/Core/Validator/Validators/UserIDValidator.php

Indentation +13 added lines, -13 removed lines

@@ -21,18 +21,18 @@
  */
 class UserIDValidator implements ValidatorInterface
 {
-    public function isValidUserId(string $userId)
-    {
-        $selectQuery = (new Builder('QueryBuilder', 'Select'))->getBuilder();
+	public function isValidUserId(string $userId)
+	{
+		$selectQuery = (new Builder('QueryBuilder', 'Select'))->getBuilder();
 
-        $selectQuery
-            ->top(1)
-            ->columns('StaffID')
-            ->from('[Staffs].[Staff]')
-            ->where(
-                'StaffID',
-                '='.
-                $userId
-            );
-    }
+		$selectQuery
+			->top(1)
+			->columns('StaffID')
+			->from('[Staffs].[Staff]')
+			->where(
+				'StaffID',
+				'='.
+				$userId
+			);
+	}
 }

src/Core/Exception/UnexpectedErrorException.php

Indentation +5 added lines, -5 removed lines

@@ -20,10 +20,10 @@
  */
 class UnexpectedErrorException extends Exception
 {
-    public function __construct(string $message, int $databaseUser)
-    {
-        parent::__construct($message, 0, $previous);
+	public function __construct(string $message, int $databaseUser)
+	{
+		parent::__construct($message, 0, $previous);
 
-        $this->log($databaseUser, Constant::ERROR_401, Constant::ERROR_HIGH);
-    }
+		$this->log($databaseUser, Constant::ERROR_401, Constant::ERROR_HIGH);
+	}
 }

src/Core/Exception/SQLException.php

Indentation +5 added lines, -5 removed lines

@@ -20,10 +20,10 @@
  */
 class SQLException extends Exception
 {
-    public function __construct(string $message, int $databaseUser)
-    {
-        parent::__construct($message, 0, null);
+	public function __construct(string $message, int $databaseUser)
+	{
+		parent::__construct($message, 0, null);
         
-        $this->log($databaseUser, Constant::ERROR_401, Constant::ERROR_NORMAL);
-    }
+		$this->log($databaseUser, Constant::ERROR_401, Constant::ERROR_NORMAL);
+	}
 }

src/Core/Exception/UndefinedValueException.php

Indentation +5 added lines, -5 removed lines

@@ -20,10 +20,10 @@
  */
 class UndefinedValueException extends Exception
 {
-    public function __construct(string $message, int $databaseUser)
-    {
-        parent::__construct($message, 0, null);
+	public function __construct(string $message, int $databaseUser)
+	{
+		parent::__construct($message, 0, null);
         
-        $this->log($databaseUser, Constant::ERROR_404, Constant::ERROR_NORMAL);
-    }
+		$this->log($databaseUser, Constant::ERROR_404, Constant::ERROR_NORMAL);
+	}
 }