andela-tolotin / Potato-ORM

src/Helper/InflectorClass.php

Indentation +1 added lines, -1 removed lines

@@ -10,5 +10,5 @@
 
 class Inflector {
 	
-    use Inflector;
+	use Inflector;
 }

src/Exceptions/WrongArgumentException.php

Indentation +4 added lines, -4 removed lines

@@ -10,8 +10,8 @@
 
 class WrongArgumentException extends Exception
 {
-    public function create($message)
-    {
-        return new static ($message);
-    }
+	public function create($message)
+	{
+		return new static ($message);
+	}
 }

src/Exceptions/TableFieldUndefinedException.php

Indentation +5 added lines, -5 removed lines

@@ -10,10 +10,10 @@
 
 class TableFieldUndefinedException extends Exception
 {
-    public static function create($unExpectedFields, $message)
-    {
-        $fields = implode(', ', $unExpectedFields);
+	public static function create($unExpectedFields, $message)
+	{
+		$fields = implode(', ', $unExpectedFields);
 
-        return new static($fields.' '.$message);
-    }
+		return new static($fields.' '.$message);
+	}
 }

src/Exceptions/NullArgumentPassedToFunctionException.php

Indentation +4 added lines, -4 removed lines

@@ -10,8 +10,8 @@
 
 class NullArgumentPassedToFunctionException extends Exception
 {
-    public static function create($message)
-    {
-        return new static ($message);
-    }
+	public static function create($message)
+	{
+		return new static ($message);
+	}
 }

src/Exceptions/NoRecordDeletionException.php

Indentation +4 added lines, -4 removed lines

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

src/Exceptions/NoRecordInsertionException.php

Indentation +4 added lines, -4 removed lines

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

src/Database/DatabaseHandler.php

Indentation +177 added lines, -177 removed lines

@@ -9,129 +9,129 @@ 
 use PDO;
 class DatabaseHandler
 {
-    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 method create a record and store it in a table row.
-     *
-     * @params associative array, string tablename
-     *
-     * @return bool true or false
-     */
-    public function create($associative1DArray, $tableName, $dbConn = null)
-    {
-        $tableFields = $this->getColumnNames($this->model, $this->dbConnection);
-
-        $unexpectedFields = self::filterClassAttributes($tableFields, $associative1DArray);
-
-        if (count($unexpectedFields) > 0) {
-            throw TableFieldUndefinedException::create($unexpectedFields, 'needs to be created as a table field');
-        }
-
-        unset($associative1DArray[0]);
-
-        if (is_null($dbConn)) {
-            $dbConn = $this->dbConnection;
-        }
-
-        return $this->insertRecord($dbConn, $tableName, $associative1DArray);
-    }
-
-    /**
-     * This method runs the insertion query.
-     *
-     * @param  $dbConn
-     * @param  $tableName
-     * @param  $associative1DArray
-     *
-     * @return bool true
-     */
-    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);
-
-        if ($executeQuery) {
-            return true;
-        }
-
-        return false;
-    }
-
-    /**
-     * This method updates any table by supplying 3 parameter.
-     *
-     * @params: $updateParams, $tableName, $associative1DArray
-     *
-     * @return bool 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::filterClassAttributes($this->getColumnNames($this->model, $this->dbConnection), $associative1DArray);
-
-        if (count($unexpectedFields) > 0) {
-            throw TableFieldUndefinedException::create($unexpectedFields, 'needs to be created as a table field');
-        }
+	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 method create a record and store it in a table row.
+	 *
+	 * @params associative array, string tablename
+	 *
+	 * @return bool true or false
+	 */
+	public function create($associative1DArray, $tableName, $dbConn = null)
+	{
+		$tableFields = $this->getColumnNames($this->model, $this->dbConnection);
+
+		$unexpectedFields = self::filterClassAttributes($tableFields, $associative1DArray);
+
+		if (count($unexpectedFields) > 0) {
+			throw TableFieldUndefinedException::create($unexpectedFields, 'needs to be created as a table field');
+		}
+
+		unset($associative1DArray[0]);
+
+		if (is_null($dbConn)) {
+			$dbConn = $this->dbConnection;
+		}
+
+		return $this->insertRecord($dbConn, $tableName, $associative1DArray);
+	}
+
+	/**
+	 * This method runs the insertion query.
+	 *
+	 * @param  $dbConn
+	 * @param  $tableName
+	 * @param  $associative1DArray
+	 *
+	 * @return bool true
+	 */
+	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);
+
+		if ($executeQuery) {
+			return true;
+		}
+
+		return false;
+	}
+
+	/**
+	 * This method updates any table by supplying 3 parameter.
+	 *
+	 * @params: $updateParams, $tableName, $associative1DArray
+	 *
+	 * @return bool 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::filterClassAttributes($this->getColumnNames($this->model, $this->dbConnection), $associative1DArray);
+
+		if (count($unexpectedFields) > 0) {
+			throw TableFieldUndefinedException::create($unexpectedFields, 'needs to be created as a table field');
+		}
 
-        foreach ($associative1DArray as $field => $value) {
-            $sql .= "`$field` = '$value'".',';
-        }
+		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";
-        }
+		foreach ($updateParams as $key => $val) {
+			$updateSql .= " WHERE $key = $val";
+		}
 
-        $stmt = $dbConn->prepare($updateSql);
+		$stmt = $dbConn->prepare($updateSql);
 
-        $boolResponse = $stmt->execute();
+		$boolResponse = $stmt->execute();
 
-        if ($boolResponse) {
-            return true;
-        }
+		if ($boolResponse) {
+			return true;
+		}
 
-        return false;
-    }
+		return false;
+	}
 
    /**
     * This method retrieves record from a table.
@@ -142,26 +142,26 @@ 
     */
    public static function read($id, $tableName, $dbConn = null)
    {
-       $tableData = [];
+	   $tableData = [];
 
-       if (is_null($dbConn)) {
-           $dbConn = new DatabaseConnection();
-       }
+	   if (is_null($dbConn)) {
+		   $dbConn = new DatabaseConnection();
+	   }
 
-       $sql = $id ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
+	   $sql = $id ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
 
-       $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();
 
-       $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
+	   $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
 
-       foreach ($results as $result) {
-           array_push($tableData, $result);
-       }
+	   foreach ($results as $result) {
+		   array_push($tableData, $result);
+	   }
 
-       return $tableData;
+	   return $tableData;
    }
 
   /**
@@ -173,19 +173,19 @@ 
    */
   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;
+	  $sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
 
-      $boolResponse = $dbConn->exec($sql);
+	  $boolResponse = $dbConn->exec($sql);
 
-      if ($boolResponse) {
-          return true;
-      }
+	  if ($boolResponse) {
+		  return true;
+	  }
 
-      throw NoRecordDeletionException::create('Record deletion unsuccessful because id does not match any record');
+	  throw NoRecordDeletionException::create('Record deletion unsuccessful because id does not match any record');
   }
 
   /**
@@ -198,15 +198,15 @@ 
    */
   public static function filterClassAttributes(array $tableColumn, array $userSetterArray)
   {
-      $unexpectedFields = [];
+	  $unexpectedFields = [];
 
-      foreach ($userSetterArray as $key => $val) {
-          if (!in_array($key, $tableColumn)) {
-              $unexpectedFields[] = $key;
-          }
-      }
+	  foreach ($userSetterArray as $key => $val) {
+		  if (!in_array($key, $tableColumn)) {
+			  $unexpectedFields[] = $key;
+		  }
+	  }
 
-      return $unexpectedFields;
+	  return $unexpectedFields;
   }
 
   /**
@@ -218,13 +218,13 @@ 
    */
   public function prepareUpdateQuery($sql)
   {
-      $splittedQuery = explode(',', $sql);
+	  $splittedQuery = explode(',', $sql);
 
-      array_pop($splittedQuery);
+	  array_pop($splittedQuery);
 
-      $mergeData = implode(',', $splittedQuery);
+	  $mergeData = implode(',', $splittedQuery);
 
-      return $mergeData;
+	  return $mergeData;
   }
 
   /**
@@ -238,26 +238,26 @@ 
    */
   public function findAndWhere($params, $tableName, $dbConn = null)
   {
-      if (is_null($dbConn)) {
-          $dbConn = $this->dbConnection;
-      }
+	  if (is_null($dbConn)) {
+		  $dbConn = $this->dbConnection;
+	  }
 
-      if (is_array($params) && !empty($params)) {
-          $sql = 'SELECT * FROM '.$tableName;
+	  if (is_array($params) && !empty($params)) {
+		  $sql = 'SELECT * FROM '.$tableName;
 
-          foreach ($params as $key => $val) {
-              $sql .= " WHERE `$key` = '$val'";
-          }
+		  foreach ($params as $key => $val) {
+			  $sql .= " WHERE `$key` = '$val'";
+		  }
 
-          $statement = $dbConn->prepare($sql);
-          $statement->execute();
+		  $statement = $dbConn->prepare($sql);
+		  $statement->execute();
 
-          $returnedRowNumbers = $statement->rowCount();
+		  $returnedRowNumbers = $statement->rowCount();
 
-          return $returnedRowNumbers ? true : false;
-      }
+		  return $returnedRowNumbers ? true : false;
+	  }
 
-      throw EmptyArrayException::create('Array Expected: parameter passed to this function is not an array');
+	  throw EmptyArrayException::create('Array Expected: parameter passed to this function is not an array');
   }
 
   /**
@@ -270,24 +270,24 @@ 
    */
   public function getColumnNames($table, $dbConn = null)
   {
-      $tableFields = [];
+	  $tableFields = [];
 
-      if (is_null($dbConn)) {
-          $dbConn = $this->dbConnection;
-      }
+	  if (is_null($dbConn)) {
+		  $dbConn = $this->dbConnection;
+	  }
 
-      $sql = 'SHOW COLUMNS FROM '.$table;
+	  $sql = 'SHOW COLUMNS FROM '.$table;
 
-      $stmt = $dbConn->prepare($sql);
-      $stmt->bindValue(':table', $table, PDO::PARAM_STR);
-      $stmt->execute();
+	  $stmt = $dbConn->prepare($sql);
+	  $stmt->bindValue(':table', $table, PDO::PARAM_STR);
+	  $stmt->execute();
 
-      $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
+	  $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
 
-      foreach ($results as $result) {
-          array_push($tableFields, $result['Field']);
-      }
+	  foreach ($results as $result) {
+		  array_push($tableFields, $result['Field']);
+	  }
 
-      return $tableFields;
+	  return $tableFields;
   }
 }

src/Database/DatabaseHelper.php

Indentation +24 added lines, -24 removed lines

@@ -8,33 +8,33 @@
 
 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
-     */
-    public function createTable($tableName, $conn = null)
-    {
-        if (is_null($conn)) {
-            $conn = $this->dbConn;
-        }
+	/**
+	 * 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;
+		}
 
-        $sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'(';
-        $sql .= ' id INT( 11 ) AUTO_INCREMENT PRIMARY KEY, name VARCHAR( 100 ), gender VARCHAR( 10 ), alias VARCHAR( 150 ) NOT NULL, class VARCHAR( 150 ), stack VARCHAR( 50 ) )';
+		$sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'(';
+		$sql .= ' id INT( 11 ) AUTO_INCREMENT PRIMARY KEY, name VARCHAR( 100 ), gender VARCHAR( 10 ), alias VARCHAR( 150 ) NOT NULL, class VARCHAR( 150 ), stack VARCHAR( 50 ) )';
 
-        return $conn->exec($sql);
+		return $conn->exec($sql);
 
-        throw TableNotCreatedException::create('Check your database connection');
-    }
+		throw TableNotCreatedException::create('Check your database connection');
+	}
 }

src/Helper/Inflector.php

Indentation +57 added lines, -57 removed lines

@@ -37,62 +37,62 @@
 
 trait Inflector
 {
-    /**
-     * Pluralizes English nouns.
-     *
-     * @static
-     *
-     * @param string $word English noun to pluralize
-     *
-     * @return string Plural noun
-     */
-    public static function pluralize($word)
-    {
-        $plural = [
-            '/(quiz)$/i'                     => '$1zes',
-            '/^(ox)$/i'                      => '$1en',
-            '/([m|l])ouse$/i'                => '$1ice',
-            '/(matr|vert|ind)ix|ex$/i'       => '$1ices',
-            '/(x|ch|ss|sh)$/i'               => '$1es',
-            '/([^aeiouy]|qu)y$/i'            => '$1ies',
-            '/(hive)$/i'                     => '$1s',
-            '/(?:([^f])fe|([lr])f)$/i'       => '$1$2ves',
-            '/(shea|lea|loa|thie)f$/i'       => '$1ves',
-            '/sis$/i'                        => 'ses',
-            '/([ti])um$/i'                   => '$1a',
-            '/(tomat|potat|ech|her|vet)o$/i' => '$1oes',
-            '/(bu)s$/i'                      => '$1ses',
-            '/(alias)$/i'                    => '$1es',
-            '/(octop)us$/i'                  => '$1i',
-            '/(ax|test)is$/i'                => '$1es',
-            '/(us)$/i'                       => '$1es',
-            '/s$/i'                          => 's',
-            '/$/'                            => 's',
-        ];
-        $uncountable = ['equipment', 'information', 'rice', 'money', 'species', 'series', 'fish', 'sheep'];
-        $irregular = [
-            'person' => 'people',
-            'man'    => 'men',
-            'child'  => 'children',
-            'sex'    => 'sexes',
-            'move'   => 'moves', ];
-        $lowercased_word = strtolower($word);
-        foreach ($uncountable as $_uncountable) {
-            if (substr($lowercased_word, (-1 * strlen($_uncountable))) == $_uncountable) {
-                return $word;
-            }
-        }
-        foreach ($irregular as $_plural => $_singular) {
-            if (preg_match('/('.$_plural.')$/i', $word, $arr)) {
-                return preg_replace('/('.$_plural.')$/i', substr($arr[0], 0, 1).substr($_singular, 1), $word);
-            }
-        }
-        foreach ($plural as $rule => $replacement) {
-            if (preg_match($rule, $word)) {
-                return preg_replace($rule, $replacement, $word);
-            }
-        }
+	/**
+	 * Pluralizes English nouns.
+	 *
+	 * @static
+	 *
+	 * @param string $word English noun to pluralize
+	 *
+	 * @return string Plural noun
+	 */
+	public static function pluralize($word)
+	{
+		$plural = [
+			'/(quiz)$/i'                     => '$1zes',
+			'/^(ox)$/i'                      => '$1en',
+			'/([m|l])ouse$/i'                => '$1ice',
+			'/(matr|vert|ind)ix|ex$/i'       => '$1ices',
+			'/(x|ch|ss|sh)$/i'               => '$1es',
+			'/([^aeiouy]|qu)y$/i'            => '$1ies',
+			'/(hive)$/i'                     => '$1s',
+			'/(?:([^f])fe|([lr])f)$/i'       => '$1$2ves',
+			'/(shea|lea|loa|thie)f$/i'       => '$1ves',
+			'/sis$/i'                        => 'ses',
+			'/([ti])um$/i'                   => '$1a',
+			'/(tomat|potat|ech|her|vet)o$/i' => '$1oes',
+			'/(bu)s$/i'                      => '$1ses',
+			'/(alias)$/i'                    => '$1es',
+			'/(octop)us$/i'                  => '$1i',
+			'/(ax|test)is$/i'                => '$1es',
+			'/(us)$/i'                       => '$1es',
+			'/s$/i'                          => 's',
+			'/$/'                            => 's',
+		];
+		$uncountable = ['equipment', 'information', 'rice', 'money', 'species', 'series', 'fish', 'sheep'];
+		$irregular = [
+			'person' => 'people',
+			'man'    => 'men',
+			'child'  => 'children',
+			'sex'    => 'sexes',
+			'move'   => 'moves', ];
+		$lowercased_word = strtolower($word);
+		foreach ($uncountable as $_uncountable) {
+			if (substr($lowercased_word, (-1 * strlen($_uncountable))) == $_uncountable) {
+				return $word;
+			}
+		}
+		foreach ($irregular as $_plural => $_singular) {
+			if (preg_match('/('.$_plural.')$/i', $word, $arr)) {
+				return preg_replace('/('.$_plural.')$/i', substr($arr[0], 0, 1).substr($_singular, 1), $word);
+			}
+		}
+		foreach ($plural as $rule => $replacement) {
+			if (preg_match($rule, $word)) {
+				return preg_replace($rule, $replacement, $word);
+			}
+		}
 
-        return false;
-    }
+		return false;
+	}
 }