andela-tolotin / Potato-ORM

src/Exceptions/NoRecordDeletionException.php

Indentation +4 added lines, -4 removed lines

@@ -12,8 +12,8 @@
 
 class NoRecordDeletionException extends  Exception
 {
-    public static function checkNoRecordUpdateException($message)
-    {
-        return new static($message);
-    }
+	public static function checkNoRecordUpdateException($message)
+	{
+		return new static($message);
+	}
 }

src/Database/DatabaseConnection.php

Indentation +13 added lines, -13 removed lines

@@ -21,22 +21,22 @@ 
 
 	public  function  __construct() 
 	{
-	    $this->loadEnv(); // load the environment variables
-	    $this->databaseName     =  getenv('databaseName');
-	    $this->databaseHost     =  getenv('databaseHost');
-	    $this->databaseDriver   =  getenv('databaseDriver');
-	    $this->databaseUsername =  getenv('databaseUsername');
-	    $this->databasePassword =  getenv('databasePassword');
+		$this->loadEnv(); // load the environment variables
+		$this->databaseName     =  getenv('databaseName');
+		$this->databaseHost     =  getenv('databaseHost');
+		$this->databaseDriver   =  getenv('databaseDriver');
+		$this->databaseUsername =  getenv('databaseUsername');
+		$this->databasePassword =  getenv('databasePassword');
 	    
-	    try {
-	    	$options = [
-	    		PDO::ATTR_PERSISTENT    => true,
+		try {
+			$options = [
+				PDO::ATTR_PERSISTENT    => true,
 			PDO::ATTR_ERRMODE       => PDO::ERRMODE_EXCEPTION
 			];
 			parent::__construct($this->getDatabaseDriver(), $this->databaseUsername, $this->databasePassword, $options);
-	    } catch(PDOException $e) {
-	    	return $e->getMessage();
-	    }
+		} catch(PDOException $e) {
+			return $e->getMessage();
+		}
 	}
 
 	/**
@@ -76,7 +76,7 @@ 
 	{
 		if (!getenv("APP_ENV")) {
 			$dotenv = new Dotenv(__DIR__.'/../../');
-		    $dotenv->load();
+			$dotenv->load();
 		}
 
 	}

src/Database/DatabaseHandler.php

Indentation +149 added lines, -149 removed lines

@@ -14,217 +14,217 @@
 use Laztopaz\potatoORM\EmptyArrayException;
 
 class DatabaseHandler {
-    private $tableFields;
-    private $dbHelperInstance;
-    private $dbConnection;
-    private $model;
+	private $tableFields;
+	private $dbHelperInstance;
+	private $dbConnection;
+	private $model;
     
-    /**
-     * This is a constructor; a default method  that will be called automatically during class instantiation
-     */
-     public function __construct($modelClassName, $dbConn = Null)
-     {
-     	if (is_null($dbConn)) {
-     		$this->dbConnection = new DatabaseConnection();
-     	} else {
-     	    $this->dbConnection = $dbConn;
-     	}
-     	$this->model = $modelClassName;
-     }
+	/**
+	 * This is a constructor; a default method  that will be called automatically during class instantiation
+	 */
+	 public function __construct($modelClassName, $dbConn = Null)
+	 {
+	 	if (is_null($dbConn)) {
+	 		$this->dbConnection = new DatabaseConnection();
+	 	} else {
+	 		$this->dbConnection = $dbConn;
+	 	}
+	 	$this->model = $modelClassName;
+	 }
      
-    /**
-      * This method create a record and store it in a table row
-      * @params associative array, string tablename
-      * @return boolean true or false
-      */
-    public function create($associative1DArray, $tableName, $dbConn = Null)
-    {
-    	$tableFields = $this->getColumnNames($this->model, $this->dbConnection);
+	/**
+	 * This method create a record and store it in a table row
+	 * @params associative array, string tablename
+	 * @return boolean true or false
+	 */
+	public function create($associative1DArray, $tableName, $dbConn = Null)
+	{
+		$tableFields = $this->getColumnNames($this->model, $this->dbConnection);
     	
-    	$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($tableFields,$associative1DArray);
-    	if (count($unexpectedFields) > 0) {
-    	    throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields,"needs to be created as table field");
-    	}
-    	unset($tableFields[0]);
-    	if (is_null($dbConn)) {
-    	    $dbConn = $this->dbConnection;
-    	}
-    	$this->insertRecord($dbConn, $tableName, $associative1DArray);
-    }
+		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($tableFields,$associative1DArray);
+		if (count($unexpectedFields) > 0) {
+			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields,"needs to be created as table field");
+		}
+		unset($tableFields[0]);
+		if (is_null($dbConn)) {
+			$dbConn = $this->dbConnection;
+		}
+		$this->insertRecord($dbConn, $tableName, $associative1DArray);
+	}
     
-    private function  insertRecord($dbConn, $tableName, $associative1DArray) 
-    {
-    	$insertQuery = 'INSERT INTO '.$tableName;
-    	$TableValues = implode(',',array_keys($associative1DArray));
-    	foreach ($associative1DArray as $field => $value) {
-    	    $FormValues[] = "'".trim(addslashes($value))."'";
-    	}
-    	$splittedTableValues = implode(',', $FormValues);
-    	$insertQuery.= ' ('.$TableValues.')';
-    	$insertQuery.= ' VALUES ('.$splittedTableValues.')';
-    	$executeQuery = $dbConn->exec($insertQuery);
-    	return $executeQuery ? : false;
+	private function  insertRecord($dbConn, $tableName, $associative1DArray) 
+	{
+		$insertQuery = 'INSERT INTO '.$tableName;
+		$TableValues = implode(',',array_keys($associative1DArray));
+		foreach ($associative1DArray as $field => $value) {
+			$FormValues[] = "'".trim(addslashes($value))."'";
+		}
+		$splittedTableValues = implode(',', $FormValues);
+		$insertQuery.= ' ('.$TableValues.')';
+		$insertQuery.= ' VALUES ('.$splittedTableValues.')';
+		$executeQuery = $dbConn->exec($insertQuery);
+		return $executeQuery ? : false;
     	
 	}
 
-    /*
+	/*
      * This method updates any table by supplying 3 parameter
      * @params: $updateParams, $tableName, $associative1DArray
      * @return boolean true or false
      */
-    public function update(array $updateParams, $tableName, $associative1DArray, $dbConn = Null)
-    {
-    	$sql = "";
-    	if (is_null($dbConn)) {
-    	    $dbConn = $this->dbConnection;
-    	}
-    	$updateSql = "UPDATE `$tableName` SET ";
-    	unset($associative1DArray['id']);
-    	$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->getColumnNames($this->model, $this->dbConnection),$associative1DArray);
+	public function update(array $updateParams, $tableName, $associative1DArray, $dbConn = Null)
+	{
+		$sql = "";
+		if (is_null($dbConn)) {
+			$dbConn = $this->dbConnection;
+		}
+		$updateSql = "UPDATE `$tableName` SET ";
+		unset($associative1DArray['id']);
+		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->getColumnNames($this->model, $this->dbConnection),$associative1DArray);
     	
-    	if (count($unexpectedFields) > 0) {
-    		throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
-    	}
-    	foreach($associative1DArray as $field => $value) {
-    	    $sql .= "`$field` = '$value'".",";
-    	}
+		if (count($unexpectedFields) > 0) {
+			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
+		}
+		foreach($associative1DArray as $field => $value) {
+			$sql .= "`$field` = '$value'".",";
+		}
     	
-    	$updateSql .= $this->prepareUpdateQuery($sql);
+		$updateSql .= $this->prepareUpdateQuery($sql);
     	
-    	foreach ($updateParams as $key => $val) {
-    	    $updateSql .= " WHERE $key = $val";
-    	}
-    	$stmt = $dbConn->prepare($updateSql);
-    	$boolResponse = $stmt->execute();
-    	return $boolResponse ?  : false;
-    }
+		foreach ($updateParams as $key => $val) {
+			$updateSql .= " WHERE $key = $val";
+		}
+		$stmt = $dbConn->prepare($updateSql);
+		$boolResponse = $stmt->execute();
+		return $boolResponse ?  : false;
+	}
     
   /**
-    * This method retrieves record from a table
-    * @params int id, string tableName
-    * @return array
-    */
+   * This method retrieves record from a table
+   * @params int id, string tableName
+   * @return array
+   */
    public static function read($id, $tableName, $dbConn = Null)
    {
    	$tableData = [];
    	
    	if (is_null($dbConn)) {
-   	    $dbConn = new DatabaseConnection();
+   		$dbConn = new DatabaseConnection();
    	}
    	$sql = $id  ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
    	
    	try {
-   	    $stmt = $dbConn->prepare($sql);
-   	    $stmt->bindValue(':table', $tableName);
-   	    $stmt->bindValue(':id', $id);
-   	    $stmt->execute();
+   		$stmt = $dbConn->prepare($sql);
+   		$stmt->bindValue(':table', $tableName);
+   		$stmt->bindValue(':id', $id);
+   		$stmt->execute();
    	} catch (PDOException $e) {
-   	    return  $e->getMessage();
+   		return  $e->getMessage();
    	}
    	$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
    	
    	foreach($results as $result) {
-   	    array_push($tableData, $result);
+   		array_push($tableData, $result);
    	}
    	return $tableData;
    }
    
    /**
-     * This method deletes a record  from a table row
-     * @params int id, string tableName
-     * @return boolean true or false
-     */
+    * This method deletes a record  from a table row
+    * @params int id, string tableName
+    * @return boolean true or false
+    */
   public static function delete($id, $tableName, $dbConn = Null)
   {
-      if (is_null($dbConn)) {
-          $dbConn = new DatabaseConnection();
-      }
+	  if (is_null($dbConn)) {
+		  $dbConn = new DatabaseConnection();
+	  }
       
-      $sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
-      $boolResponse = $dbConn->exec($sql);
-      return $boolResponse ? : false;
+	  $sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
+	  $boolResponse = $dbConn->exec($sql);
+	  return $boolResponse ? : false;
   }
   
   /**
-    * This method checks if the magic setters array is the same as the table columns
-    * @param array $tableColumn
-    * @param array $userSetterArray
-    * @return array $unexpectedFields
-    */
+   * This method checks if the magic setters array is the same as the table columns
+   * @param array $tableColumn
+   * @param array $userSetterArray
+   * @return array $unexpectedFields
+   */
   public static function checkIfMagicSetterContainsIsSameAsClassModel(array $tableColumn, array $userSetterArray)
   {
-      $unexpectedFields = [];
-      foreach ($userSetterArray as $key => $val) {
-          if (!in_array($key,$tableColumn)) {
-              $unexpectedFields[] = $key;
-          }
-      }
-      return $unexpectedFields;
+	  $unexpectedFields = [];
+	  foreach ($userSetterArray as $key => $val) {
+		  if (!in_array($key,$tableColumn)) {
+			  $unexpectedFields[] = $key;
+		  }
+	  }
+	  return $unexpectedFields;
   }
   
   /**
-    * This method returns sql query
-    * @param $sql
-    * @return string
-    */
+   * This method returns sql query
+   * @param $sql
+   * @return string
+   */
   public function prepareUpdateQuery($sql)
   {
-      $splittedQuery = explode(",",$sql);
-      array_pop($splittedQuery);
-      $mergeData = implode(",",$splittedQuery);
-      return $mergeData;
+	  $splittedQuery = explode(",",$sql);
+	  array_pop($splittedQuery);
+	  $mergeData = implode(",",$splittedQuery);
+	  return $mergeData;
   }
   
   /**
-    * @param array $params
-    * @param $tableName
-    * @param $dbConn
-    * @return bool
-    * @throws EmptyArrayException
-    */
+   * @param array $params
+   * @param $tableName
+   * @param $dbConn
+   * @return bool
+   * @throws EmptyArrayException
+   */
   public function findAndWhere($params, $tableName, $dbConn)
   {
-      if (is_null($dbConn)) {
-          $dbConn = $this->dbConnection;
-      }
-      if (is_array($params) && !empty($params)) {
-          $sql = "SELECT * FROM ".$tableName;
+	  if (is_null($dbConn)) {
+		  $dbConn = $this->dbConnection;
+	  }
+	  if (is_array($params) && !empty($params)) {
+		  $sql = "SELECT * FROM ".$tableName;
           
-          foreach ($params as $key => $val) {
-              $sql .= " WHERE `$key` = '$val'";
-          }
-          $statement = $dbConn->prepare($sql);
-          $statement->execute();
-          $returnedRowNumbers = $statement->rowCount();
+		  foreach ($params as $key => $val) {
+			  $sql .= " WHERE `$key` = '$val'";
+		  }
+		  $statement = $dbConn->prepare($sql);
+		  $statement->execute();
+		  $returnedRowNumbers = $statement->rowCount();
           
-          return $returnedRowNumbers  ? true : false;
-      }
-      throw EmptyArrayException::checkEmptyArrayException("Array Expected: parameter passed to this function is not an array");
+		  return $returnedRowNumbers  ? true : false;
+	  }
+	  throw EmptyArrayException::checkEmptyArrayException("Array Expected: parameter passed to this function is not an array");
   }
   
   /**
-    * This method returns column fields of a particular table
-    * @param $table
-    * @param $conn
-    * @return array
-    */
+   * This method returns column fields of a particular table
+   * @param $table
+   * @param $conn
+   * @return array
+   */
  public function getColumnNames($table, $dbConn = Null) {
-     $tableFields = [];
+	 $tableFields = [];
      
-     if (is_null($dbConn)) {
-         $dbConn = $this->dbConnection;
-     }
-     $sql = "SHOW COLUMNS FROM ".$table;
+	 if (is_null($dbConn)) {
+		 $dbConn = $this->dbConnection;
+	 }
+	 $sql = "SHOW COLUMNS FROM ".$table;
      
-     $stmt = $dbConn->prepare($sql);
-     $stmt->bindValue(':table', $table, PDO::PARAM_STR);
-     $stmt->execute();
-     $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
+	 $stmt = $dbConn->prepare($sql);
+	 $stmt->bindValue(':table', $table, PDO::PARAM_STR);
+	 $stmt->execute();
+	 $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
      
-     foreach($results as $result) {
-         array_push($tableFields, $result['Field']);
-     }
-     return $tableFields;
+	 foreach($results as $result) {
+		 array_push($tableFields, $result['Field']);
+	 }
+	 return $tableFields;
  }
 
 

src/Database/DatabaseHelper.php

Indentation +14 added lines, -14 removed lines

@@ -13,25 +13,25 @@
 
 class DatabaseHelper {
 	
-    public $dbConn;
+	public $dbConn;
     
-    /**
-      * This is a constructor; a default method  that will be called automatically during class instantiation
-      */
-    public function __construct($dbConnect)
-    {
-    	$this->dbConn = $dbConnect;
-    }
+	/**
+	 * This is a constructor; a default method  that will be called automatically during class instantiation
+	 */
+	public function __construct($dbConnect)
+	{
+		$this->dbConn = $dbConnect;
+	}
     
-    /**
-      * This method creates a particular table
-      * @param tableName
-      * $return boolean true or false
-      */
+	/**
+	 * This method creates a particular table
+	 * @param tableName
+	 * $return boolean true or false
+	 */
    public function createTable($tableName, $conn = NULL)
    {
    	if (is_null($conn)) {
-   	    $conn = $this->dbConn;
+   		$conn = $this->dbConn;
    	}
    	
    	$sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'(';

src/Exceptions/EmptyArrayException.php

Indentation +4 added lines, -4 removed lines

@@ -12,9 +12,9 @@
 
 class EmptyArrayException extends Exception {
 	
-    public static function checkEmptyArrayException($message)
-    {
-    	return new static($message);
-    }
+	public static function checkEmptyArrayException($message)
+	{
+		return new static($message);
+	}
 
 }

src/Exceptions/NoArgumentPassedToFunctionException.php

Indentation +4 added lines, -4 removed lines

@@ -12,9 +12,9 @@
 
 class NoArgumentPassedToFunctionException extends Exception {
 	
-    public static function checkNoArgumentPassedToFunction($message)
-    {
-    	return new static($message);
-    }
+	public static function checkNoArgumentPassedToFunction($message)
+	{
+		return new static($message);
+	}
 
 }

src/Exceptions/NoRecordInsertionException.php

Indentation +4 added lines, -4 removed lines

@@ -12,8 +12,8 @@
 
 class NoRecordInsertionException extends Exception {
 
-    public static function checkNoRecordAddedException($mesaage)
-    {
-    	return new static($mesaage);
-    }
+	public static function checkNoRecordAddedException($mesaage)
+	{
+		return new static($mesaage);
+	}
 }

src/Exceptions/NoRecordUpdateException.php

Indentation +4 added lines, -4 removed lines

@@ -12,9 +12,9 @@
 
 class NoRecordUpdateException extends  Exception {
 	
-    public static function checkNoRecordUpdateException($message)
-    {
-    	return new static($message);
-    }
+	public static function checkNoRecordUpdateException($message)
+	{
+		return new static($message);
+	}
 
 }

src/Exceptions/NullArgumentPassedToFunctionException.php

Indentation +4 added lines, -4 removed lines

@@ -12,9 +12,9 @@
 
 class NullArgumentPassedToFunction extends Exception {
 
-    public static function ckeckNullArgumentPassedToFunction($message)
-    {
-    	return new static ($message);
-    }
+	public static function ckeckNullArgumentPassedToFunction($message)
+	{
+		return new static ($message);
+	}
 
 }