andela-joyebanji / PotatoORM

src/Model.php

Indentation +50 added lines, -50 removed lines

@@ -10,21 +10,21 @@ 
 
     /**
      * Store instance of database connection used.
-    * @var [type]
-    */
+     * @var [type]
+     */
     protected  $databaseConnection;
 
     /**
      *  The id of the model.
      *  
      * @property string $id
-    */
+     */
      
     /**
      * Create a model instance.
      * 
      */
-     public function __construct()
+        public function __construct()
     {
         $this->databaseConnection = DatabaseConnection::getInstance()->databaseConnection;
        
@@ -32,19 +32,19 @@ 
     /**
      * Sets into $properties the $key => $value pairs
      * 
-    * @param string $key 
-    * @param string $val 
-    *
-    */
+     * @param string $key 
+     * @param string $val 
+     *
+     */
     public  function __set($key, $val)
     {
         $this->properties[$key] = $val;
     }
     /**
-    * @param string $key
-    * 
-    * @return array
-    */
+     * @param string $key
+     * 
+     * @return array
+     */
     public function __get($key)
     {
         return $this->properties[$key];
@@ -54,15 +54,15 @@ 
      *
      * @return array
      */
-     public function getProperties()
-     {
-         return $this->properties;
-     }
+        public function getProperties()
+        {
+            return $this->properties;
+        }
     /**
-    * Gets the name of the child class with a 's'.
-    *
-    * @return string
-    */
+     * Gets the name of the child class with a 's'.
+     *
+     * @return string
+     */
     public function getTableName()
     {
         $className = explode('\\', get_called_class());
@@ -70,12 +70,12 @@ 
         return $table;
     }
     /**
-    * Find the particular model with the passed id.
-    * 
-    * @param int $id
-    * 
-    * @return object
-    */
+     * Find the particular model with the passed id.
+     * 
+     * @param int $id
+     * 
+     * @return object
+     */
     public static function find($id)
     {
         $model = new static;
@@ -83,12 +83,12 @@ 
     }
 
     /**
-    * Get the particular model with the passed id.
-    * 
-    * @param int $id
-    * 
-    * @return object
-    */
+     * Get the particular model with the passed id.
+     * 
+     * @param int $id
+     * 
+     * @return object
+     */
     public function get($id)
     {
         $sql = "SELECT * FROM {$this->getTableName()} WHERE id={$id}";
@@ -102,10 +102,10 @@ 
     }
 
     /**
-    * Get all the models from the database.
-    * 
-    * @return array
-    */
+     * Get all the models from the database.
+     * 
+     * @return array
+     */
     public static function getAll()
     {
         $model = new static;
@@ -113,10 +113,10 @@ 
     }
 
     /**
-    * Returns all the models from the database.
-    * 
-    * @return array
-    */
+     * Returns all the models from the database.
+     * 
+     * @return array
+     */
     public function all()
     {
         $sql = "SELECT * FROM {$this->getTableName()}";
@@ -130,7 +130,7 @@ 
      * Update the model in the database.
      * 
      * @return int
-    */
+     */
     private function update()
     {
        
@@ -151,10 +151,10 @@ 
     }
 
     /**
-    * Insert the model values into the database.
-    *
-    * @return int
-    */
+     * Insert the model values into the database.
+     *
+     * @return int
+     */
     private function create()
     {
         
@@ -189,11 +189,11 @@ 
         return $this->id ? $this->update() : $this->create();
     }
 
-   /**
-    * Delete a model from the database. 
-    * @param  int $id 
-    * @return boolean
-    */
+    /**
+     * Delete a model from the database. 
+     * @param  int $id 
+     * @return boolean
+     */
     public static function destroy($id)
     {
         $model = new static;

Spacing +10 added lines, -10 removed lines

@@ -66,7 +66,7 @@ 
     public function getTableName()
     {
         $className = explode('\\', get_called_class());
-        $table = strtolower(end($className) .'s');
+        $table = strtolower(end($className) . 's');
         return $table;
     }
     /**
@@ -95,7 +95,7 @@ 
         $sqlStatement = $this->databaseConnection->prepare($sql);
         $sqlStatement->setFetchMode($this->databaseConnection::FETCH_CLASS, get_called_class());
         $sqlStatement->execute();
-        if($sqlStatement->rowCount() < 1){
+        if ($sqlStatement->rowCount() < 1) {
             throw new ModelNotFoundException($id);
         }
         return $sqlStatement->fetch();
@@ -135,15 +135,15 @@ 
     {
        
         $bindNameParameters = [];
-        $sqlUpdate = "UPDATE " . $this->getTableName() . " SET " ;
+        $sqlUpdate = "UPDATE " . $this->getTableName() . " SET ";
         foreach ($this->properties as $columnName => $columnValue) {
-            if($columnName == 'id') continue;
+            if ($columnName == 'id') continue;
             $bindColumnName = ':' . $columnName;
             $sqlUpdate .= "$columnName = $bindColumnName,";
             $bindNameParameters[$bindColumnName] = $columnValue;
         }
         //Remove the last comma in sql command then join it to the other query part.
-        $sqlUpdate = substr($sqlUpdate, 0, -1)." WHERE id = :id";
+        $sqlUpdate = substr($sqlUpdate, 0, -1) . " WHERE id = :id";
         $sqlStatement = $this->databaseConnection->prepare($sqlUpdate);
         $sqlStatement->bindValue(":id", $this->properties['id']);
         $sqlStatement->execute($bindNameParameters);
@@ -161,19 +161,19 @@ 
         $columnNames = "";
         $columnValues = "";
         $bindNameParameters = [];
-        $sqlCreate = "INSERT" . " INTO " . $this->getTableName()." (";
+        $sqlCreate = "INSERT" . " INTO " . $this->getTableName() . " (";
         foreach ($this->properties as $columnName => $columnValue) {
 
             $bindColumnName = ':' . $columnName;
-            $columnNames .= $columnName.",";
-            $columnValues .= $bindColumnName.",";
+            $columnNames .= $columnName . ",";
+            $columnValues .= $bindColumnName . ",";
             $bindNameParameters[$bindColumnName] = $columnValue;
         }
         // Remove ending comma and whitespace.
         $columnNames = substr($columnNames, 0, -1);
         $columnValues = substr($columnValues, 0, -1);
 
-        $sqlCreate .= $columnNames.') VALUES (' .$columnValues.')';
+        $sqlCreate .= $columnNames . ') VALUES (' . $columnValues . ')';
         $sqlStatement = $this->databaseConnection->prepare($sqlCreate);
         $sqlStatement->execute($bindNameParameters);
         return $sqlStatement->rowCount();
@@ -208,7 +208,7 @@ 
      */
     public function delete($id)
     {
-        $sql = "DELETE" . " FROM " . self::getTableName()." WHERE id = ". $id;
+        $sql = "DELETE" . " FROM " . self::getTableName() . " WHERE id = " . $id;
         $sqlStatment = $this->databaseConnection->prepare($sql);
         $sqlStatment->execute();
         return ($sqlStatment->rowCount() > 0) ? true : false;

Braces +3 added lines, -1 removed lines

@@ -137,7 +137,9 @@
         $bindNameParameters = [];
         $sqlUpdate = "UPDATE " . $this->getTableName() . " SET " ;
         foreach ($this->properties as $columnName => $columnValue) {
-            if($columnName == 'id') continue;
+            if($columnName == 'id') {
+                continue;
+            }
             $bindColumnName = ':' . $columnName;
             $sqlUpdate .= "$columnName = $bindColumnName,";
             $bindNameParameters[$bindColumnName] = $columnValue;