Completed
Push — test ( 5bf343...41c779 )
by Temitope
03:44
created
src/Database/DatabaseHandler.php 2 patches
Unused Use Statements   -3 removed lines patch added patch discarded remove patch
@@ -9,12 +9,9 @@
 block discarded – undo
9 9
 namespace Laztopaz\PotatoORM;
10 10
 
11 11
 use PDO;
12
-use Laztopaz\PotatoORM\DatabaseHelper;
13 12
 use Laztopaz\PotatoORM\TableFieldUndefinedException;
14 13
 use Laztopaz\PotatoORM\EmptyArrayException;
15 14
 use Laztopaz\PotatoORM\NoRecordDeletionException;
16
-use Laztopaz\PotatoORM\NoRecordInsertionException;
17
-use Laztopaz\PotatoORM\NoRecordUpdateException;
18 15
 
19 16
 class DatabaseHandler {
20 17
 
Please login to merge, or discard this patch.
Indentation   +152 added lines, -152 removed lines patch added patch discarded remove patch
@@ -18,131 +18,131 @@  discard block
 block discarded – undo
18 18
 
19 19
 class DatabaseHandler {
20 20
 
21
-    private $tableFields;
22
-    private $dbHelperInstance;
23
-    private $dbConnection;
24
-    private $model;
21
+	private $tableFields;
22
+	private $dbHelperInstance;
23
+	private $dbConnection;
24
+	private $model;
25 25
     
26
-    /**
27
-     * This is a constructor; a default method  that will be called automatically during class instantiation
28
-     */
29
-    public function __construct($modelClassName, $dbConn = Null) 
30
-    {
31
-        if (is_null($dbConn)) {
32
-            $this->dbConnection = new DatabaseConnection();
33
-
34
-        } else {
35
-            $this->dbConnection = $dbConn;
36
-
37
-        }
26
+	/**
27
+	 * This is a constructor; a default method  that will be called automatically during class instantiation
28
+	 */
29
+	public function __construct($modelClassName, $dbConn = Null) 
30
+	{
31
+		if (is_null($dbConn)) {
32
+			$this->dbConnection = new DatabaseConnection();
33
+
34
+		} else {
35
+			$this->dbConnection = $dbConn;
36
+
37
+		}
38 38
         
39
-        $this->model = $modelClassName;
40
-     }
39
+		$this->model = $modelClassName;
40
+	 }
41 41
      
42
-    /**
43
-     * This method create a record and store it in a table row
44
-     * @params associative array, string tablename
45
-     * @return boolean true or false
46
-     */
47
-    public function create($associative1DArray, $tableName, $dbConn = Null) 
48
-    {
49
-        $tableFields = $this->getColumnNames($this->model, $this->dbConnection);
50
-
51
-        $unexpectedFields = self::filterClassAttributes($tableFields, $associative1DArray);
42
+	/**
43
+	 * This method create a record and store it in a table row
44
+	 * @params associative array, string tablename
45
+	 * @return boolean true or false
46
+	 */
47
+	public function create($associative1DArray, $tableName, $dbConn = Null) 
48
+	{
49
+		$tableFields = $this->getColumnNames($this->model, $this->dbConnection);
50
+
51
+		$unexpectedFields = self::filterClassAttributes($tableFields, $associative1DArray);
52 52
       
53
-        if (count($unexpectedFields) > 0) {
54
-            throw TableFieldUndefinedException::create($unexpectedFields,"needs to be created as a table field");
55
-        }
53
+		if (count($unexpectedFields) > 0) {
54
+			throw TableFieldUndefinedException::create($unexpectedFields,"needs to be created as a table field");
55
+		}
56 56
 
57
-        unset($associative1DArray[0]);
57
+		unset($associative1DArray[0]);
58 58
 
59
-        if (is_null($dbConn)) {
60
-            $dbConn = $this->dbConnection;
59
+		if (is_null($dbConn)) {
60
+			$dbConn = $this->dbConnection;
61 61
 
62
-        }
62
+		}
63 63
 
64
-        return $this->insertRecord($dbConn, $tableName, $associative1DArray);
64
+		return $this->insertRecord($dbConn, $tableName, $associative1DArray);
65 65
 
66
-    }
66
+	}
67 67
     
68
-    /**
69
-     * This method runs the insertion query
70
-     * @param  $dbConn           
71
-     * @param  $tableName          
72
-     * @param  $associative1DArray 
73
-     * @return boolean true         
74
-     */
75
-    private function  insertRecord($dbConn, $tableName, $associative1DArray) 
76
-    {
77
-        $insertQuery = 'INSERT INTO '.$tableName;
68
+	/**
69
+	 * This method runs the insertion query
70
+	 * @param  $dbConn           
71
+	 * @param  $tableName          
72
+	 * @param  $associative1DArray 
73
+	 * @return boolean true         
74
+	 */
75
+	private function  insertRecord($dbConn, $tableName, $associative1DArray) 
76
+	{
77
+		$insertQuery = 'INSERT INTO '.$tableName;
78 78
 
79
-        $TableValues = implode(',',array_keys($associative1DArray));
79
+		$TableValues = implode(',',array_keys($associative1DArray));
80 80
 
81
-        foreach ($associative1DArray as $field => $value) {
82
-            $FormValues[] = "'".trim(addslashes($value))."'";
83
-        }
81
+		foreach ($associative1DArray as $field => $value) {
82
+			$FormValues[] = "'".trim(addslashes($value))."'";
83
+		}
84 84
 
85
-        $splittedTableValues = implode(',', $FormValues);
85
+		$splittedTableValues = implode(',', $FormValues);
86 86
 
87
-        $insertQuery.= ' ('.$TableValues.')';
88
-        $insertQuery.= ' VALUES ('.$splittedTableValues.')';
87
+		$insertQuery.= ' ('.$TableValues.')';
88
+		$insertQuery.= ' VALUES ('.$splittedTableValues.')';
89 89
 
90
-        $executeQuery = $dbConn->exec($insertQuery);
90
+		$executeQuery = $dbConn->exec($insertQuery);
91 91
 
92
-        if ($executeQuery) {
93
-            return true;
94
-        }
92
+		if ($executeQuery) {
93
+			return true;
94
+		}
95 95
 
96
-        return false;
96
+		return false;
97 97
 
98
-      }
98
+	  }
99 99
 
100
-    /**
101
-     * This method updates any table by supplying 3 parameter
102
-     * @params: $updateParams, $tableName, $associative1DArray
103
-     * @return boolean true or false
104
-     */
105
-    public function update(array $updateParams, $tableName, $associative1DArray, $dbConn = null)
106
-    {
107
-        $sql = "";
100
+	/**
101
+	 * This method updates any table by supplying 3 parameter
102
+	 * @params: $updateParams, $tableName, $associative1DArray
103
+	 * @return boolean true or false
104
+	 */
105
+	public function update(array $updateParams, $tableName, $associative1DArray, $dbConn = null)
106
+	{
107
+		$sql = "";
108 108
 
109
-        if (is_null($dbConn)) {
110
-            $dbConn = $this->dbConnection;
109
+		if (is_null($dbConn)) {
110
+			$dbConn = $this->dbConnection;
111 111
 
112
-        }
112
+		}
113 113
 
114
-        $updateSql = "UPDATE `$tableName` SET ";
114
+		$updateSql = "UPDATE `$tableName` SET ";
115 115
 
116
-        unset($associative1DArray['id']);
116
+		unset($associative1DArray['id']);
117 117
 
118
-        $unexpectedFields = self::filterClassAttributes($this->getColumnNames($this->model, $this->dbConnection), $associative1DArray);
118
+		$unexpectedFields = self::filterClassAttributes($this->getColumnNames($this->model, $this->dbConnection), $associative1DArray);
119 119
 
120
-        if (count($unexpectedFields) > 0) {
121
-            throw TableFieldUndefinedException::create($unexpectedFields, "needs to be created as a table field");
122
-        }
120
+		if (count($unexpectedFields) > 0) {
121
+			throw TableFieldUndefinedException::create($unexpectedFields, "needs to be created as a table field");
122
+		}
123 123
 
124
-        foreach ($associative1DArray as $field => $value) {
125
-            $sql .= "`$field` = '$value'".",";
126
-        }
124
+		foreach ($associative1DArray as $field => $value) {
125
+			$sql .= "`$field` = '$value'".",";
126
+		}
127 127
 
128
-        $updateSql .= $this->prepareUpdateQuery($sql);
128
+		$updateSql .= $this->prepareUpdateQuery($sql);
129 129
 
130
-        foreach ($updateParams as $key => $val) {
131
-            $updateSql .= " WHERE $key = $val";
132
-        }
130
+		foreach ($updateParams as $key => $val) {
131
+			$updateSql .= " WHERE $key = $val";
132
+		}
133 133
 
134
-        $stmt = $dbConn->prepare($updateSql);
134
+		$stmt = $dbConn->prepare($updateSql);
135 135
 
136
-        $boolResponse = $stmt->execute();
136
+		$boolResponse = $stmt->execute();
137 137
 
138
-        if ($boolResponse) {
139
-            return true;
138
+		if ($boolResponse) {
139
+			return true;
140 140
 
141
-        }
141
+		}
142 142
 
143
-        return false;
143
+		return false;
144 144
 
145
-    }
145
+	}
146 146
     
147 147
   /**
148 148
    * This method retrieves record from a table
@@ -151,26 +151,26 @@  discard block
 block discarded – undo
151 151
    */
152 152
    public static function read($id, $tableName, $dbConn = null)
153 153
    {
154
-       $tableData = [];
154
+	   $tableData = [];
155 155
 
156
-       if (is_null($dbConn)) {
157
-           $dbConn = new DatabaseConnection();
158
-       }
156
+	   if (is_null($dbConn)) {
157
+		   $dbConn = new DatabaseConnection();
158
+	   }
159 159
 
160
-       $sql = $id ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
160
+	   $sql = $id ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
161 161
 
162
-       $stmt = $dbConn->prepare($sql);
163
-       $stmt->bindValue(':table', $tableName);
164
-       $stmt->bindValue(':id', $id);
165
-       $stmt->execute();
162
+	   $stmt = $dbConn->prepare($sql);
163
+	   $stmt->bindValue(':table', $tableName);
164
+	   $stmt->bindValue(':id', $id);
165
+	   $stmt->execute();
166 166
 
167
-       $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
167
+	   $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
168 168
 
169
-       foreach ($results as $result) {
170
-           array_push($tableData, $result);
171
-       }
169
+	   foreach ($results as $result) {
170
+		   array_push($tableData, $result);
171
+	   }
172 172
 
173
-       return $tableData;
173
+	   return $tableData;
174 174
 
175 175
    }
176 176
    
@@ -181,20 +181,20 @@  discard block
 block discarded – undo
181 181
    */
182 182
   public static function delete($id, $tableName, $dbConn = null)
183 183
   {
184
-      if (is_null($dbConn)) {
185
-          $dbConn = new DatabaseConnection();
186
-      }
184
+	  if (is_null($dbConn)) {
185
+		  $dbConn = new DatabaseConnection();
186
+	  }
187 187
 
188
-      $sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
188
+	  $sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
189 189
 
190
-      $boolResponse = $dbConn->exec($sql);
190
+	  $boolResponse = $dbConn->exec($sql);
191 191
 
192
-      if ($boolResponse) {
193
-          return true;
192
+	  if ($boolResponse) {
193
+		  return true;
194 194
 
195
-      }
195
+	  }
196 196
 
197
-      throw NoRecordDeletionException::create("Record deletion unsuccessful because id does not match any record");
197
+	  throw NoRecordDeletionException::create("Record deletion unsuccessful because id does not match any record");
198 198
   }
199 199
   
200 200
   /**
@@ -205,15 +205,15 @@  discard block
 block discarded – undo
205 205
    */
206 206
   public static function filterClassAttributes(array $tableColumn, array $userSetterArray)
207 207
   {
208
-      $unexpectedFields = [];
208
+	  $unexpectedFields = [];
209 209
 
210
-      foreach ($userSetterArray as $key => $val) {
211
-          if (! in_array($key, $tableColumn)) {
212
-              $unexpectedFields[] = $key;
213
-          }
214
-      }
210
+	  foreach ($userSetterArray as $key => $val) {
211
+		  if (! in_array($key, $tableColumn)) {
212
+			  $unexpectedFields[] = $key;
213
+		  }
214
+	  }
215 215
 
216
-      return $unexpectedFields;
216
+	  return $unexpectedFields;
217 217
 
218 218
   }
219 219
   
@@ -224,13 +224,13 @@  discard block
 block discarded – undo
224 224
    */
225 225
   public function prepareUpdateQuery($sql)
226 226
   {
227
-      $splittedQuery = explode(",",$sql);
227
+	  $splittedQuery = explode(",",$sql);
228 228
 
229
-      array_pop($splittedQuery);
229
+	  array_pop($splittedQuery);
230 230
 
231
-      $mergeData = implode(",",$splittedQuery);
231
+	  $mergeData = implode(",",$splittedQuery);
232 232
 
233
-      return $mergeData;
233
+	  return $mergeData;
234 234
 
235 235
   }
236 236
   
@@ -243,27 +243,27 @@  discard block
 block discarded – undo
243 243
    */
244 244
   public function findAndWhere($params, $tableName, $dbConn = null)
245 245
   {
246
-      if (is_null($dbConn)) {
247
-          $dbConn = $this->dbConnection;
248
-      }
246
+	  if (is_null($dbConn)) {
247
+		  $dbConn = $this->dbConnection;
248
+	  }
249 249
 
250
-      if (is_array($params) && !empty($params)) {
251
-          $sql = "SELECT * FROM ".$tableName;
250
+	  if (is_array($params) && !empty($params)) {
251
+		  $sql = "SELECT * FROM ".$tableName;
252 252
 
253
-          foreach ($params as $key => $val) {
254
-              $sql .= " WHERE `$key` = '$val'";
255
-          }
253
+		  foreach ($params as $key => $val) {
254
+			  $sql .= " WHERE `$key` = '$val'";
255
+		  }
256 256
 
257
-          $statement = $dbConn->prepare($sql);
258
-          $statement->execute();
257
+		  $statement = $dbConn->prepare($sql);
258
+		  $statement->execute();
259 259
 
260
-          $returnedRowNumbers = $statement->rowCount();
260
+		  $returnedRowNumbers = $statement->rowCount();
261 261
           
262
-          return $returnedRowNumbers ? true : false;
262
+		  return $returnedRowNumbers ? true : false;
263 263
 
264
-      }
264
+	  }
265 265
 
266
-      throw EmptyArrayException::create("Array Expected: parameter passed to this function is not an array");
266
+	  throw EmptyArrayException::create("Array Expected: parameter passed to this function is not an array");
267 267
   }
268 268
   
269 269
   /**
@@ -274,25 +274,25 @@  discard block
 block discarded – undo
274 274
    */
275 275
   public function getColumnNames($table, $dbConn = null) 
276 276
   {
277
-      $tableFields = [];
277
+	  $tableFields = [];
278 278
      
279
-      if (is_null($dbConn)) {
280
-         $dbConn = $this->dbConnection;
281
-      }
279
+	  if (is_null($dbConn)) {
280
+		 $dbConn = $this->dbConnection;
281
+	  }
282 282
 
283
-      $sql = "SHOW COLUMNS FROM ".$table;
283
+	  $sql = "SHOW COLUMNS FROM ".$table;
284 284
      
285
-      $stmt = $dbConn->prepare($sql);
286
-      $stmt->bindValue(':table', $table, PDO::PARAM_STR);
287
-      $stmt->execute();
285
+	  $stmt = $dbConn->prepare($sql);
286
+	  $stmt->bindValue(':table', $table, PDO::PARAM_STR);
287
+	  $stmt->execute();
288 288
 
289
-      $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
289
+	  $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
290 290
      
291
-      foreach ($results as $result) {
292
-          array_push($tableFields, $result['Field']);
293
-      }
291
+	  foreach ($results as $result) {
292
+		  array_push($tableFields, $result['Field']);
293
+	  }
294 294
 
295
-      return $tableFields;
295
+	  return $tableFields;
296 296
      
297 297
   }
298 298
 
Please login to merge, or discard this patch.
src/Model/BaseModel.php 2 patches
Unused Use Statements   -1 removed lines patch added patch discarded remove patch
@@ -14,7 +14,6 @@
 block discarded – undo
14 14
 use Laztopaz\PotatoORM\NoRecordFoundException;
15 15
 use Laztopaz\PotatoORM\NoRecordInsertionException;
16 16
 use Laztopaz\PotatoORM\NullArgumentPassedToFunction;
17
-use Laztopaz\PotatoORM\WrongArgumentException;
18 17
 use Laztopaz\PotatoORM\NoArgumentPassedToFunctionException;
19 18
 use Laztopaz\PotatoORM\EmptyArrayException;
20 19
 
Please login to merge, or discard this patch.
Indentation   +135 added lines, -135 removed lines patch added patch discarded remove patch
@@ -20,155 +20,155 @@  discard block
 block discarded – undo
20 20
 
21 21
 class BaseModel implements BaseModelInterface
22 22
 {
23
-    // Inject the inflector trait
24
-    use Inflector; 
23
+	// Inject the inflector trait
24
+	use Inflector; 
25 25
     
26
-    // Private variable that contains instance of database
27
-    protected $databaseModel; 
26
+	// Private variable that contains instance of database
27
+	protected $databaseModel; 
28 28
 
29
-    // Class variable holding class name pluralized
30
-    protected $tableName; 
29
+	// Class variable holding class name pluralized
30
+	protected $tableName; 
31 31
 
32
-    // Properties will later contain key, value pairs from the magic setter, getter methods
33
-    protected $properties = []; 
32
+	// Properties will later contain key, value pairs from the magic setter, getter methods
33
+	protected $properties = []; 
34 34
 
35
-    public function  __construct()
36
-    {
37
-        $this->tableName = $this->getClassName();
35
+	public function  __construct()
36
+	{
37
+		$this->tableName = $this->getClassName();
38 38
 
39
-        $this->databaseModel = new DatabaseHandler($this->tableName);
39
+		$this->databaseModel = new DatabaseHandler($this->tableName);
40 40
 
41
-        $this->properties['id'] = 0;
42
-    }
41
+		$this->properties['id'] = 0;
42
+	}
43 43
     
44
-    /**
45
-     * The magic getter method
46
-     * @params key
47
-     * @return array key
48
-     */
49
-    public function __get($key)
50
-    {
51
-        $this->properties[$key];
52
-
53
-    }
44
+	/**
45
+	 * The magic getter method
46
+	 * @params key
47
+	 * @return array key
48
+	 */
49
+	public function __get($key)
50
+	{
51
+		$this->properties[$key];
52
+
53
+	}
54 54
     
55
-    /**
56
-     * The magic setter method
57
-     * @params property, key
58
-     * @return array associative array properties
59
-     */
60
-    public function  __set($property, $value)
61
-    {
62
-        $this->properties[$property] = $value;
63
-
64
-    }
55
+	/**
56
+	 * The magic setter method
57
+	 * @params property, key
58
+	 * @return array associative array properties
59
+	 */
60
+	public function  __set($property, $value)
61
+	{
62
+		$this->properties[$property] = $value;
63
+
64
+	}
65 65
     
66
-    /**
67
-     * This method gets all the record from a particular table
68
-     * @params void
69
-     * @return associative array
70
-     * @throws NoRecordFoundException
71
-     */
72
-    public static function getAll()
73
-    {
74
-        $allData = DatabaseHandler::read($id = false, self::getClassName());
66
+	/**
67
+	 * This method gets all the record from a particular table
68
+	 * @params void
69
+	 * @return associative array
70
+	 * @throws NoRecordFoundException
71
+	 */
72
+	public static function getAll()
73
+	{
74
+		$allData = DatabaseHandler::read($id = false, self::getClassName());
75 75
 
76
-        if (count($allData) > 0) {
77
-            return $allData;
76
+		if (count($allData) > 0) {
77
+			return $allData;
78 78
 
79
-        }
79
+		}
80 80
 
81
-        throw NoRecordFoundException::create("There is no record to display");
81
+		throw NoRecordFoundException::create("There is no record to display");
82 82
 
83
-    }
83
+	}
84 84
     
85
-    /**
86
-     * This method create or update record in a database table
87
-     * @params void
88
-     * @return bool true or false;
89
-     * @throws EmptyArrayException
90
-     * @throws NoRecordInsertionException
91
-     * @throws NoRecordUpdateException
92
-     */
93
-    public function save()
94
-    {
95
-        $boolCommit = false;
96
-
97
-        if ($this->properties['id']) {
98
-            $allData = DatabaseHandler::read($id = $this->properties['id'], self::getClassName());
99
-
100
-            if ($this->checkIfRecordIsEmpty($allData)) {
101
-                $boolCommit = $this->databaseModel->update(['id' => $this->properties['id']], $this->tableName, $this->properties);
102
-
103
-                if ($boolCommit) {
104
-                    return true;
105
-
106
-                }
107
-
108
-                throw NoRecordUpdateException::create("Record not updated successfully");
109
-            }
110
-
111
-            throw EmptyArrayException::create("Value passed didn't match any record");
112
-        }
113
-
114
-        $boolCommit = $this->databaseModel->create($this->properties, $this->tableName);
115
-
116
-        if ($boolCommit) {
117
-            return true;
118
-        }
119
-
120
-        throw NoRecordInsertionException::create("Record not created successfully");
121
-    }
122
-
123
-    /**
124
-     * This method find a record by id
125
-     * @params int id
126
-     * @return Object
127
-     * @throws NoArgumentPassedToFunctionException
128
-     */
129
-    public static function find($id)
130
-    {
131
-        $num_args = (int) func_num_args(); // get number of arguments passed to this function 
132
-        if ($num_args == 0 || $num_args > 1) {
133
-            throw NoArgumentPassedToFunctionException::create("Argument missing: only one argument is allowed");
134
-        }
85
+	/**
86
+	 * This method create or update record in a database table
87
+	 * @params void
88
+	 * @return bool true or false;
89
+	 * @throws EmptyArrayException
90
+	 * @throws NoRecordInsertionException
91
+	 * @throws NoRecordUpdateException
92
+	 */
93
+	public function save()
94
+	{
95
+		$boolCommit = false;
96
+
97
+		if ($this->properties['id']) {
98
+			$allData = DatabaseHandler::read($id = $this->properties['id'], self::getClassName());
99
+
100
+			if ($this->checkIfRecordIsEmpty($allData)) {
101
+				$boolCommit = $this->databaseModel->update(['id' => $this->properties['id']], $this->tableName, $this->properties);
102
+
103
+				if ($boolCommit) {
104
+					return true;
105
+
106
+				}
107
+
108
+				throw NoRecordUpdateException::create("Record not updated successfully");
109
+			}
110
+
111
+			throw EmptyArrayException::create("Value passed didn't match any record");
112
+		}
113
+
114
+		$boolCommit = $this->databaseModel->create($this->properties, $this->tableName);
115
+
116
+		if ($boolCommit) {
117
+			return true;
118
+		}
119
+
120
+		throw NoRecordInsertionException::create("Record not created successfully");
121
+	}
122
+
123
+	/**
124
+	 * This method find a record by id
125
+	 * @params int id
126
+	 * @return Object
127
+	 * @throws NoArgumentPassedToFunctionException
128
+	 */
129
+	public static function find($id)
130
+	{
131
+		$num_args = (int) func_num_args(); // get number of arguments passed to this function 
132
+		if ($num_args == 0 || $num_args > 1) {
133
+			throw NoArgumentPassedToFunctionException::create("Argument missing: only one argument is allowed");
134
+		}
135 135
         
136
-        if ($id == "") {
137
-            throw NullArgumentPassedToFunction::create("This function expect a value");
138
-        }
136
+		if ($id == "") {
137
+			throw NullArgumentPassedToFunction::create("This function expect a value");
138
+		}
139 139
 
140
-        $staticFindInstance = new static();
141
-        $staticFindInstance->id = $id == "" ? false : $id;
140
+		$staticFindInstance = new static();
141
+		$staticFindInstance->id = $id == "" ? false : $id;
142 142
 
143
-        return $staticFindInstance;
143
+		return $staticFindInstance;
144 144
         
145
-    }
145
+	}
146 146
     
147
-    /**
148
-     * This method delete a row from the table by the row id
149
-     * @params int id
150
-     * @return boolean true or false
151
-     * @throws NoRecordDeletionException;
152
-     */
153
-    public static function destroy($id)
154
-    {
155
-        $boolDeleted = false;
156
-
157
-        $num_args = (int) func_num_args(); // get number of arguments passed to this function 
147
+	/**
148
+	 * This method delete a row from the table by the row id
149
+	 * @params int id
150
+	 * @return boolean true or false
151
+	 * @throws NoRecordDeletionException;
152
+	 */
153
+	public static function destroy($id)
154
+	{
155
+		$boolDeleted = false;
156
+
157
+		$num_args = (int) func_num_args(); // get number of arguments passed to this function 
158 158
         
159
-        if ($num_args == 0 || $num_args > 1) {
160
-            throw NoArgumentPassedToFunctionException::create("Argument missing: only one argument is allowed");
161
-        }
159
+		if ($num_args == 0 || $num_args > 1) {
160
+			throw NoArgumentPassedToFunctionException::create("Argument missing: only one argument is allowed");
161
+		}
162 162
 
163
-        $boolDeleted = DatabaseHandler::delete($id, self::getClassName());
163
+		$boolDeleted = DatabaseHandler::delete($id, self::getClassName());
164 164
 
165
-        if ($boolDeleted) {
166
-            return true;
165
+		if ($boolDeleted) {
166
+			return true;
167 167
 
168
-        }
168
+		}
169 169
 
170
-        throw NoRecordDeletionException::create("Record deletion unsuccessful because id does not match any record");
171
-    }
170
+		throw NoRecordDeletionException::create("Record deletion unsuccessful because id does not match any record");
171
+	}
172 172
 
173 173
    /**
174 174
     * This method return the current class name
@@ -177,11 +177,11 @@  discard block
 block discarded – undo
177 177
     */
178 178
    public static function getClassName()
179 179
    {
180
-       $tableName = preg_split('/(?=[A-Z])/', get_called_class());
180
+	   $tableName = preg_split('/(?=[A-Z])/', get_called_class());
181 181
        
182
-       $className = end($tableName);
182
+	   $className = end($tableName);
183 183
 
184
-       return self::pluralize(strtolower($className));
184
+	   return self::pluralize(strtolower($className));
185 185
 
186 186
    }
187 187
    
@@ -190,14 +190,14 @@  discard block
 block discarded – undo
190 190
     * @param $arrayOfRecord
191 191
     * @return bool
192 192
     */
193
-    public function checkIfRecordIsEmpty($arrayOfRecord)
194
-    {
195
-        if (count($arrayOfRecord) > 0) {
196
-            return true;
193
+	public function checkIfRecordIsEmpty($arrayOfRecord)
194
+	{
195
+		if (count($arrayOfRecord) > 0) {
196
+			return true;
197 197
 
198
-        }
198
+		}
199 199
         
200
-        return false;
201
-    }
200
+		return false;
201
+	}
202 202
 
203 203
 }
Please login to merge, or discard this patch.
src/Database/DatabaseHelper.php 1 patch
Indentation   +22 added lines, -22 removed lines patch added patch discarded remove patch
@@ -12,34 +12,34 @@
 block discarded – undo
12 12
 
13 13
 class DatabaseHelper {
14 14
   
15
-    public $dbConn;
15
+	public $dbConn;
16 16
     
17
-    /**
18
-     * This is a constructor; a default method  that will be called automatically during class instantiation
19
-     */
20
-    public function __construct($dbConnect)
21
-    {
22
-        $this->dbConn = $dbConnect;
17
+	/**
18
+	 * This is a constructor; a default method  that will be called automatically during class instantiation
19
+	 */
20
+	public function __construct($dbConnect)
21
+	{
22
+		$this->dbConn = $dbConnect;
23 23
         
24
-    }
24
+	}
25 25
     
26
-    /**
27
-     * This method creates a particular table
28
-     * @param tableName
29
-     * $return boolean true or false
30
-     */
31
-    public function createTable($tableName, $conn = NULL)
32
-    {
33
-        if (is_null($conn)) {
34
-            $conn = $this->dbConn;
35
-        }
26
+	/**
27
+	 * This method creates a particular table
28
+	 * @param tableName
29
+	 * $return boolean true or false
30
+	 */
31
+	public function createTable($tableName, $conn = NULL)
32
+	{
33
+		if (is_null($conn)) {
34
+			$conn = $this->dbConn;
35
+		}
36 36
 
37
-        $sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'(';
38
-        $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 ) )';
37
+		$sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'(';
38
+		$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 ) )';
39 39
 
40
-        return $conn->exec($sql);
40
+		return $conn->exec($sql);
41 41
 
42
-        throw TableNotCreatedException::create("Check your database connection");
42
+		throw TableNotCreatedException::create("Check your database connection");
43 43
    }
44 44
   
45 45
 }
Please login to merge, or discard this patch.
src/Exceptions/NoRecordInsertionException.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -6,7 +6,7 @@
 block discarded – undo
6 6
  * @license  <https://opensource.org/license/MIT> MIT
7 7
  */
8 8
 
9
-namespace Laztopaz\PotatoORM    ;
9
+namespace Laztopaz\PotatoORM;
10 10
 
11 11
 use Exception;
12 12
 
Please login to merge, or discard this patch.
src/Interface/InterfaceBaseClass.php 1 patch
Indentation   +24 added lines, -24 removed lines patch added patch discarded remove patch
@@ -10,31 +10,31 @@
 block discarded – undo
10 10
 
11 11
 interface BaseModelInterface {
12 12
 
13
-    /**
14
-     * This method gets all the record from a particular table
15
-     * @params void
16
-     * @return associative array
17
-     */
18
-    public static function getAll();
13
+	/**
14
+	 * This method gets all the record from a particular table
15
+	 * @params void
16
+	 * @return associative array
17
+	 */
18
+	public static function getAll();
19 19
    
20
-    /**
21
-     * This method create or update record in a database table
22
-     * @params void
23
-     * @return boolean true or false;
24
-     */
25
-    public function save();
20
+	/**
21
+	 * This method create or update record in a database table
22
+	 * @params void
23
+	 * @return boolean true or false;
24
+	 */
25
+	public function save();
26 26
    
27
-    /**
28
-     * This method delete a row from the table by the row id
29
-     * @params int $id
30
-     * @return boolean true or false
31
-     */
32
-    public static function destroy($id);
27
+	/**
28
+	 * This method delete a row from the table by the row id
29
+	 * @params int $id
30
+	 * @return boolean true or false
31
+	 */
32
+	public static function destroy($id);
33 33
      
34
-    /**
35
-     * This method find a record by id
36
-     * @params int $id
37
-     * @return object find
38
-     */
39
-    public static function find($id);
34
+	/**
35
+	 * This method find a record by id
36
+	 * @params int $id
37
+	 * @return object find
38
+	 */
39
+	public static function find($id);
40 40
 }
Please login to merge, or discard this patch.