andela-joyebanji / PotatoORM

src/Model.php

Indentation +40 added lines, -40 removed lines

@@ -10,28 +10,28 @@ 
 
     /**
      * Store instance of database connection used.
-    * @var [type]
-    */
+     * @var [type]
+     */
     protected  $databaseConnection;
 
-     public function __construct()
+        public function __construct()
     {
         $this->databaseConnection = DatabaseConnection::getInstance()->databaseConnection;
         //$databaseConnection->databaseConnection->connect();
     }
     /**
-    * @param string $key rep column name
-    * @param string $val rep column value
-    * sets into $propertie the $key => $value pairs
-    */
+     * @param string $key rep column name
+     * @param string $val rep column value
+     * sets into $propertie the $key => $value pairs
+     */
     public  function __set($key, $val)
     {
         $this->properties[$key] = $val;
     }
     /**
-    * @param string $key reps the column name
-    * @return $key and $value
-    */
+     * @param string $key reps the column name
+     * @return $key and $value
+     */
     public function __get($key)
     {
         return $this->properties[$key];
@@ -41,17 +41,17 @@ 
      *
      * @return array
      */
-     public function getProperties()
-     {
-         return $this->properties;
-     }
+        public function getProperties()
+        {
+            return $this->properties;
+        }
     /**
-    * Gets the name of the child class only
-    * without the namespace
-    * @var $className
-    * @var $table
-    * @return $table
-    */
+     * Gets the name of the child class only
+     * without the namespace
+     * @var $className
+     * @var $table
+     * @return $table
+     */
     public function getTableName()
     {
         $className = explode('\\', get_called_class());
@@ -59,11 +59,11 @@ 
         return $table;
     }
     /**
-    * returns a particular record
-    * @param $id reps the record id
-    * @param $connection initialised to null
-    * @return object
-    */
+     * returns a particular record
+     * @param $id reps the record id
+     * @param $connection initialised to null
+     * @return object
+     */
     public static function find($id)
     {
         $model = new static;
@@ -71,11 +71,11 @@ 
     }
 
     /**
-    * returns a particular record
-    * @param $id reps the record id
-    * @param $connection initialised to null
-    * @return object
-    */
+     * returns a particular record
+     * @param $id reps the record id
+     * @param $connection initialised to null
+     * @return object
+     */
     public function get($id)
     {
         $sql = "SELECT * FROM {$this->getTableName()} WHERE id={$id}";
@@ -107,7 +107,7 @@ 
      * Update the model in the database.
      * 
      * @return int
-    */
+     */
     private function update()
     {
        
@@ -130,10 +130,10 @@ 
     }
 
     /**
-    * Insert the model values into the database.
-    *
-    * @return int
-    */
+     * Insert the model values into the database.
+     *
+     * @return int
+     */
     private function create()
     {
         
@@ -168,11 +168,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

@@ -55,7 +55,7 @@ 
     public function getTableName()
     {
         $className = explode('\\', get_called_class());
-        $table = strtolower(end($className) .'s');
+        $table = strtolower(end($className) . 's');
         return $table;
     }
     /**
@@ -82,7 +82,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();
@@ -114,15 +114,15 @@ 
         $columnNames = "";
         $columnValues = "";
         $bindNameParameters = [];
-        $sqlUpdate = "UPDATE " . $this->getTableName() . " SET " ;
+        $sqlUpdate = "UPDATE " . $this->getTableName() . " SET ";
         foreach ($this->properties as $columnName => $columnValue) {
-            if($key == 'id') continue;
+            if ($key == '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);
@@ -140,19 +140,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();
@@ -187,7 +187,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

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