Completed
Push — test ( f14dee...63c20a )
by Temitope
05:37 queued 03:07
created
src/Model/BaseModel.php 2 patches
Doc Comments   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -119,7 +119,7 @@  discard block
 block discarded – undo
119 119
 	/**
120 120
 	 * This method find a record by id
121 121
 	 * @params int id
122
-	 * @return Object
122
+	 * @return BaseClass
123 123
 	 * @throws NoArgumentPassedToFunctionException
124 124
 	 */
125 125
 	public static function find($id)
@@ -171,7 +171,7 @@  discard block
 block discarded – undo
171 171
 	/**
172 172
 	 * This method return the current class name
173 173
 	 * $params void
174
-	 * @return classname
174
+	 * @return string|false
175 175
 	 */
176 176
 	public static function getClassName()
177 177
 	{
Please login to merge, or discard this patch.
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.
src/Helper/Inflector.php 1 patch
Spacing   +9 added lines, -9 removed lines patch added patch discarded remove patch
@@ -74,14 +74,14 @@  discard block
 block discarded – undo
74 74
 			'sex' => 'sexes',
75 75
 			'move' => 'moves');
76 76
 		$lowercased_word = strtolower($word);
77
-		foreach ($uncountable as $_uncountable){
78
-			if(substr($lowercased_word,(-1*strlen($_uncountable))) == $_uncountable){
77
+		foreach ($uncountable as $_uncountable) {
78
+			if (substr($lowercased_word, (-1*strlen($_uncountable))) == $_uncountable) {
79 79
 				return $word;
80 80
 			}
81 81
 		}
82
-		foreach ($irregular as $_plural=> $_singular){
82
+		foreach ($irregular as $_plural=> $_singular) {
83 83
 			if (preg_match('/('.$_plural.')$/i', $word, $arr)) {
84
-				return preg_replace('/('.$_plural.')$/i', substr($arr[0],0,1).substr($_singular,1), $word);
84
+				return preg_replace('/('.$_plural.')$/i', substr($arr[0], 0, 1).substr($_singular, 1), $word);
85 85
 			}
86 86
 		}
87 87
 		foreach ($plural as $rule => $replacement) {
@@ -101,7 +101,7 @@  discard block
 block discarded – undo
101 101
 	 */
102 102
 	public function singularize($word)
103 103
 	{
104
-		$singular = array (
104
+		$singular = array(
105 105
 			'/(quiz)zes$/i'             => "$1",
106 106
 			'/(matr)ices$/i'            => "$1ix",
107 107
 			'/(vert|ind)ices$/i'        => "$1ex",
@@ -139,14 +139,14 @@  discard block
 block discarded – undo
139 139
 			'sex' => 'sexes',
140 140
 			'move' => 'moves');
141 141
 		$lowercased_word = strtolower($word);
142
-		foreach ($uncountable as $_uncountable){
143
-			if(substr($lowercased_word,(-1*strlen($_uncountable))) == $_uncountable){
142
+		foreach ($uncountable as $_uncountable) {
143
+			if (substr($lowercased_word, (-1*strlen($_uncountable))) == $_uncountable) {
144 144
 				return $word;
145 145
 			}
146 146
 		}
147
-		foreach ($irregular as $_plural=> $_singular){
147
+		foreach ($irregular as $_plural=> $_singular) {
148 148
 			if (preg_match('/('.$_singular.')$/i', $word, $arr)) {
149
-				return preg_replace('/('.$_singular.')$/i', substr($arr[0],0,1).substr($_plural,1), $word);
149
+				return preg_replace('/('.$_singular.')$/i', substr($arr[0], 0, 1).substr($_plural, 1), $word);
150 150
 			}
151 151
 		}
152 152
 		foreach ($singular as $rule => $replacement) {
Please login to merge, or discard this patch.
src/Exceptions/NoRecordInsertionException.php 2 patches
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.
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -12,8 +12,8 @@
 block discarded – undo
12 12
 
13 13
 class NoRecordInsertionException extends Exception {
14 14
 
15
-    public static function checkNoRecordAddedException($mesaage)
16
-    {
17
-    	return new static($mesaage);
18
-    }
15
+	public static function checkNoRecordAddedException($mesaage)
16
+	{
17
+		return new static($mesaage);
18
+	}
19 19
 }
Please login to merge, or discard this patch.
src/Database/DatabaseHandler.php 4 patches
Unused Use Statements   -1 removed lines patch added patch discarded remove patch
@@ -9,7 +9,6 @@
 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
 
Please login to merge, or discard this patch.
Doc Comments   +11 added lines, -2 removed lines patch added patch discarded remove patch
@@ -21,6 +21,7 @@  discard block
 block discarded – undo
21 21
     
22 22
     /**
23 23
      * This is a constructor; a default method  that will be called automatically during class instantiation
24
+     * @param string|false $modelClassName
24 25
      */
25 26
      public function __construct($modelClassName, $dbConn = Null)
26 27
      {
@@ -35,7 +36,8 @@  discard block
 block discarded – undo
35 36
     /**
36 37
       * This method create a record and store it in a table row
37 38
       * @params associative array, string tablename
38
-      * @return boolean true or false
39
+      * @param string|false $tableName
40
+      * @return boolean|null true or false
39 41
       */
40 42
     public function create($associative1DArray, $tableName, $dbConn = Null)
41 43
     {
@@ -72,6 +74,10 @@  discard block
 block discarded – undo
72 74
      * @params: $updateParams, $tableName, $associative1DArray
73 75
      * @return boolean true or false
74 76
      */
77
+
78
+    /**
79
+     * @param string|false $tableName
80
+     */
75 81
     public function update(array $updateParams, $tableName, $associative1DArray, $dbConn = Null)
76 82
     {
77 83
     	$sql = "";
@@ -102,6 +108,7 @@  discard block
 block discarded – undo
102 108
   /**
103 109
     * This method retrieves record from a table
104 110
     * @params int id, string tableName
111
+    * @param string|false $tableName
105 112
     * @return array
106 113
     */
107 114
    public static function read($id, $tableName, $dbConn = Null)
@@ -132,6 +139,7 @@  discard block
 block discarded – undo
132 139
    /**
133 140
      * This method deletes a record  from a table row
134 141
      * @params int id, string tableName
142
+     * @param string|false $tableName
135 143
      * @return boolean true or false
136 144
      */
137 145
   public static function delete($id, $tableName, $dbConn = Null)
@@ -164,7 +172,7 @@  discard block
 block discarded – undo
164 172
   
165 173
   /**
166 174
     * This method returns sql query
167
-    * @param $sql
175
+    * @param string $sql
168 176
     * @return string
169 177
     */
170 178
   public function prepareUpdateQuery($sql)
@@ -206,6 +214,7 @@  discard block
 block discarded – undo
206 214
     * This method returns column fields of a particular table
207 215
     * @param $table
208 216
     * @param $conn
217
+    * @param DatabaseConnection $dbConn
209 218
     * @return array
210 219
     */
211 220
  public function getColumnNames($table, $dbConn = Null) {
Please login to merge, or discard this patch.
Indentation   +149 added lines, -149 removed lines patch added patch discarded remove patch
@@ -14,217 +14,217 @@
 block discarded – undo
14 14
 use Laztopaz\potatoORM\EmptyArrayException;
15 15
 
16 16
 class DatabaseHandler {
17
-    private $tableFields;
18
-    private $dbHelperInstance;
19
-    private $dbConnection;
20
-    private $model;
17
+	private $tableFields;
18
+	private $dbHelperInstance;
19
+	private $dbConnection;
20
+	private $model;
21 21
     
22
-    /**
23
-     * This is a constructor; a default method  that will be called automatically during class instantiation
24
-     */
25
-     public function __construct($modelClassName, $dbConn = Null)
26
-     {
27
-     	if (is_null($dbConn)) {
28
-     		$this->dbConnection = new DatabaseConnection();
29
-     	} else {
30
-     	    $this->dbConnection = $dbConn;
31
-     	}
32
-     	$this->model = $modelClassName;
33
-     }
22
+	/**
23
+	 * This is a constructor; a default method  that will be called automatically during class instantiation
24
+	 */
25
+	 public function __construct($modelClassName, $dbConn = Null)
26
+	 {
27
+	 	if (is_null($dbConn)) {
28
+	 		$this->dbConnection = new DatabaseConnection();
29
+	 	} else {
30
+	 		$this->dbConnection = $dbConn;
31
+	 	}
32
+	 	$this->model = $modelClassName;
33
+	 }
34 34
      
35
-    /**
36
-      * This method create a record and store it in a table row
37
-      * @params associative array, string tablename
38
-      * @return boolean true or false
39
-      */
40
-    public function create($associative1DArray, $tableName, $dbConn = Null)
41
-    {
42
-    	$tableFields = $this->getColumnNames($this->model, $this->dbConnection);
35
+	/**
36
+	 * This method create a record and store it in a table row
37
+	 * @params associative array, string tablename
38
+	 * @return boolean true or false
39
+	 */
40
+	public function create($associative1DArray, $tableName, $dbConn = Null)
41
+	{
42
+		$tableFields = $this->getColumnNames($this->model, $this->dbConnection);
43 43
     	
44
-    	$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($tableFields,$associative1DArray);
45
-    	if (count($unexpectedFields) > 0) {
46
-    	    throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields,"needs to be created as table field");
47
-    	}
48
-    	unset($tableFields[0]);
49
-    	if (is_null($dbConn)) {
50
-    	    $dbConn = $this->dbConnection;
51
-    	}
52
-    	$this->insertRecord($dbConn, $tableName, $associative1DArray);
53
-    }
44
+		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($tableFields,$associative1DArray);
45
+		if (count($unexpectedFields) > 0) {
46
+			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields,"needs to be created as table field");
47
+		}
48
+		unset($tableFields[0]);
49
+		if (is_null($dbConn)) {
50
+			$dbConn = $this->dbConnection;
51
+		}
52
+		$this->insertRecord($dbConn, $tableName, $associative1DArray);
53
+	}
54 54
     
55
-    private function  insertRecord($dbConn, $tableName, $associative1DArray) 
56
-    {
57
-    	$insertQuery = 'INSERT INTO '.$tableName;
58
-    	$TableValues = implode(',',array_keys($associative1DArray));
59
-    	foreach ($associative1DArray as $field => $value) {
60
-    	    $FormValues[] = "'".trim(addslashes($value))."'";
61
-    	}
62
-    	$splittedTableValues = implode(',', $FormValues);
63
-    	$insertQuery.= ' ('.$TableValues.')';
64
-    	$insertQuery.= ' VALUES ('.$splittedTableValues.')';
65
-    	$executeQuery = $dbConn->exec($insertQuery);
66
-    	return $executeQuery ? : false;
55
+	private function  insertRecord($dbConn, $tableName, $associative1DArray) 
56
+	{
57
+		$insertQuery = 'INSERT INTO '.$tableName;
58
+		$TableValues = implode(',',array_keys($associative1DArray));
59
+		foreach ($associative1DArray as $field => $value) {
60
+			$FormValues[] = "'".trim(addslashes($value))."'";
61
+		}
62
+		$splittedTableValues = implode(',', $FormValues);
63
+		$insertQuery.= ' ('.$TableValues.')';
64
+		$insertQuery.= ' VALUES ('.$splittedTableValues.')';
65
+		$executeQuery = $dbConn->exec($insertQuery);
66
+		return $executeQuery ? : false;
67 67
     	
68 68
 	}
69 69
 
70
-    /*
70
+	/*
71 71
      * This method updates any table by supplying 3 parameter
72 72
      * @params: $updateParams, $tableName, $associative1DArray
73 73
      * @return boolean true or false
74 74
      */
75
-    public function update(array $updateParams, $tableName, $associative1DArray, $dbConn = Null)
76
-    {
77
-    	$sql = "";
78
-    	if (is_null($dbConn)) {
79
-    	    $dbConn = $this->dbConnection;
80
-    	}
81
-    	$updateSql = "UPDATE `$tableName` SET ";
82
-    	unset($associative1DArray['id']);
83
-    	$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->getColumnNames($this->model, $this->dbConnection),$associative1DArray);
75
+	public function update(array $updateParams, $tableName, $associative1DArray, $dbConn = Null)
76
+	{
77
+		$sql = "";
78
+		if (is_null($dbConn)) {
79
+			$dbConn = $this->dbConnection;
80
+		}
81
+		$updateSql = "UPDATE `$tableName` SET ";
82
+		unset($associative1DArray['id']);
83
+		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->getColumnNames($this->model, $this->dbConnection),$associative1DArray);
84 84
     	
85
-    	if (count($unexpectedFields) > 0) {
86
-    		throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
87
-    	}
88
-    	foreach($associative1DArray as $field => $value) {
89
-    	    $sql .= "`$field` = '$value'".",";
90
-    	}
85
+		if (count($unexpectedFields) > 0) {
86
+			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
87
+		}
88
+		foreach($associative1DArray as $field => $value) {
89
+			$sql .= "`$field` = '$value'".",";
90
+		}
91 91
     	
92
-    	$updateSql .= $this->prepareUpdateQuery($sql);
92
+		$updateSql .= $this->prepareUpdateQuery($sql);
93 93
     	
94
-    	foreach ($updateParams as $key => $val) {
95
-    	    $updateSql .= " WHERE $key = $val";
96
-    	}
97
-    	$stmt = $dbConn->prepare($updateSql);
98
-    	$boolResponse = $stmt->execute();
99
-    	return $boolResponse ?  : false;
100
-    }
94
+		foreach ($updateParams as $key => $val) {
95
+			$updateSql .= " WHERE $key = $val";
96
+		}
97
+		$stmt = $dbConn->prepare($updateSql);
98
+		$boolResponse = $stmt->execute();
99
+		return $boolResponse ?  : false;
100
+	}
101 101
     
102 102
   /**
103
-    * This method retrieves record from a table
104
-    * @params int id, string tableName
105
-    * @return array
106
-    */
103
+   * This method retrieves record from a table
104
+   * @params int id, string tableName
105
+   * @return array
106
+   */
107 107
    public static function read($id, $tableName, $dbConn = Null)
108 108
    {
109 109
    	$tableData = [];
110 110
    	
111 111
    	if (is_null($dbConn)) {
112
-   	    $dbConn = new DatabaseConnection();
112
+   		$dbConn = new DatabaseConnection();
113 113
    	}
114 114
    	$sql = $id  ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
115 115
    	
116 116
    	try {
117
-   	    $stmt = $dbConn->prepare($sql);
118
-   	    $stmt->bindValue(':table', $tableName);
119
-   	    $stmt->bindValue(':id', $id);
120
-   	    $stmt->execute();
117
+   		$stmt = $dbConn->prepare($sql);
118
+   		$stmt->bindValue(':table', $tableName);
119
+   		$stmt->bindValue(':id', $id);
120
+   		$stmt->execute();
121 121
    	} catch (PDOException $e) {
122
-   	    return  $e->getMessage();
122
+   		return  $e->getMessage();
123 123
    	}
124 124
    	$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
125 125
    	
126 126
    	foreach($results as $result) {
127
-   	    array_push($tableData, $result);
127
+   		array_push($tableData, $result);
128 128
    	}
129 129
    	return $tableData;
130 130
    }
131 131
    
132 132
    /**
133
-     * This method deletes a record  from a table row
134
-     * @params int id, string tableName
135
-     * @return boolean true or false
136
-     */
133
+    * This method deletes a record  from a table row
134
+    * @params int id, string tableName
135
+    * @return boolean true or false
136
+    */
137 137
   public static function delete($id, $tableName, $dbConn = Null)
138 138
   {
139
-      if (is_null($dbConn)) {
140
-          $dbConn = new DatabaseConnection();
141
-      }
139
+	  if (is_null($dbConn)) {
140
+		  $dbConn = new DatabaseConnection();
141
+	  }
142 142
       
143
-      $sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
144
-      $boolResponse = $dbConn->exec($sql);
145
-      return $boolResponse ? : false;
143
+	  $sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
144
+	  $boolResponse = $dbConn->exec($sql);
145
+	  return $boolResponse ? : false;
146 146
   }
147 147
   
148 148
   /**
149
-    * This method checks if the magic setters array is the same as the table columns
150
-    * @param array $tableColumn
151
-    * @param array $userSetterArray
152
-    * @return array $unexpectedFields
153
-    */
149
+   * This method checks if the magic setters array is the same as the table columns
150
+   * @param array $tableColumn
151
+   * @param array $userSetterArray
152
+   * @return array $unexpectedFields
153
+   */
154 154
   public static function checkIfMagicSetterContainsIsSameAsClassModel(array $tableColumn, array $userSetterArray)
155 155
   {
156
-      $unexpectedFields = [];
157
-      foreach ($userSetterArray as $key => $val) {
158
-          if (!in_array($key,$tableColumn)) {
159
-              $unexpectedFields[] = $key;
160
-          }
161
-      }
162
-      return $unexpectedFields;
156
+	  $unexpectedFields = [];
157
+	  foreach ($userSetterArray as $key => $val) {
158
+		  if (!in_array($key,$tableColumn)) {
159
+			  $unexpectedFields[] = $key;
160
+		  }
161
+	  }
162
+	  return $unexpectedFields;
163 163
   }
164 164
   
165 165
   /**
166
-    * This method returns sql query
167
-    * @param $sql
168
-    * @return string
169
-    */
166
+   * This method returns sql query
167
+   * @param $sql
168
+   * @return string
169
+   */
170 170
   public function prepareUpdateQuery($sql)
171 171
   {
172
-      $splittedQuery = explode(",",$sql);
173
-      array_pop($splittedQuery);
174
-      $mergeData = implode(",",$splittedQuery);
175
-      return $mergeData;
172
+	  $splittedQuery = explode(",",$sql);
173
+	  array_pop($splittedQuery);
174
+	  $mergeData = implode(",",$splittedQuery);
175
+	  return $mergeData;
176 176
   }
177 177
   
178 178
   /**
179
-    * @param array $params
180
-    * @param $tableName
181
-    * @param $dbConn
182
-    * @return bool
183
-    * @throws EmptyArrayException
184
-    */
179
+   * @param array $params
180
+   * @param $tableName
181
+   * @param $dbConn
182
+   * @return bool
183
+   * @throws EmptyArrayException
184
+   */
185 185
   public function findAndWhere($params, $tableName, $dbConn)
186 186
   {
187
-      if (is_null($dbConn)) {
188
-          $dbConn = $this->dbConnection;
189
-      }
190
-      if (is_array($params) && !empty($params)) {
191
-          $sql = "SELECT * FROM ".$tableName;
187
+	  if (is_null($dbConn)) {
188
+		  $dbConn = $this->dbConnection;
189
+	  }
190
+	  if (is_array($params) && !empty($params)) {
191
+		  $sql = "SELECT * FROM ".$tableName;
192 192
           
193
-          foreach ($params as $key => $val) {
194
-              $sql .= " WHERE `$key` = '$val'";
195
-          }
196
-          $statement = $dbConn->prepare($sql);
197
-          $statement->execute();
198
-          $returnedRowNumbers = $statement->rowCount();
193
+		  foreach ($params as $key => $val) {
194
+			  $sql .= " WHERE `$key` = '$val'";
195
+		  }
196
+		  $statement = $dbConn->prepare($sql);
197
+		  $statement->execute();
198
+		  $returnedRowNumbers = $statement->rowCount();
199 199
           
200
-          return $returnedRowNumbers  ? true : false;
201
-      }
202
-      throw EmptyArrayException::checkEmptyArrayException("Array Expected: parameter passed to this function is not an array");
200
+		  return $returnedRowNumbers  ? true : false;
201
+	  }
202
+	  throw EmptyArrayException::checkEmptyArrayException("Array Expected: parameter passed to this function is not an array");
203 203
   }
204 204
   
205 205
   /**
206
-    * This method returns column fields of a particular table
207
-    * @param $table
208
-    * @param $conn
209
-    * @return array
210
-    */
206
+   * This method returns column fields of a particular table
207
+   * @param $table
208
+   * @param $conn
209
+   * @return array
210
+   */
211 211
  public function getColumnNames($table, $dbConn = Null) {
212
-     $tableFields = [];
212
+	 $tableFields = [];
213 213
      
214
-     if (is_null($dbConn)) {
215
-         $dbConn = $this->dbConnection;
216
-     }
217
-     $sql = "SHOW COLUMNS FROM ".$table;
214
+	 if (is_null($dbConn)) {
215
+		 $dbConn = $this->dbConnection;
216
+	 }
217
+	 $sql = "SHOW COLUMNS FROM ".$table;
218 218
      
219
-     $stmt = $dbConn->prepare($sql);
220
-     $stmt->bindValue(':table', $table, PDO::PARAM_STR);
221
-     $stmt->execute();
222
-     $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
219
+	 $stmt = $dbConn->prepare($sql);
220
+	 $stmt->bindValue(':table', $table, PDO::PARAM_STR);
221
+	 $stmt->execute();
222
+	 $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
223 223
      
224
-     foreach($results as $result) {
225
-         array_push($tableFields, $result['Field']);
226
-     }
227
-     return $tableFields;
224
+	 foreach($results as $result) {
225
+		 array_push($tableFields, $result['Field']);
226
+	 }
227
+	 return $tableFields;
228 228
  }
229 229
 
230 230
 
Please login to merge, or discard this patch.
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -41,9 +41,9 @@  discard block
 block discarded – undo
41 41
     {
42 42
     	$tableFields = $this->getColumnNames($this->model, $this->dbConnection);
43 43
     	
44
-    	$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($tableFields,$associative1DArray);
44
+    	$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($tableFields, $associative1DArray);
45 45
     	if (count($unexpectedFields) > 0) {
46
-    	    throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields,"needs to be created as table field");
46
+    	    throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
47 47
     	}
48 48
     	unset($tableFields[0]);
49 49
     	if (is_null($dbConn)) {
@@ -55,15 +55,15 @@  discard block
 block discarded – undo
55 55
     private function  insertRecord($dbConn, $tableName, $associative1DArray) 
56 56
     {
57 57
     	$insertQuery = 'INSERT INTO '.$tableName;
58
-    	$TableValues = implode(',',array_keys($associative1DArray));
58
+    	$TableValues = implode(',', array_keys($associative1DArray));
59 59
     	foreach ($associative1DArray as $field => $value) {
60 60
     	    $FormValues[] = "'".trim(addslashes($value))."'";
61 61
     	}
62 62
     	$splittedTableValues = implode(',', $FormValues);
63
-    	$insertQuery.= ' ('.$TableValues.')';
64
-    	$insertQuery.= ' VALUES ('.$splittedTableValues.')';
63
+    	$insertQuery .= ' ('.$TableValues.')';
64
+    	$insertQuery .= ' VALUES ('.$splittedTableValues.')';
65 65
     	$executeQuery = $dbConn->exec($insertQuery);
66
-    	return $executeQuery ? : false;
66
+    	return $executeQuery ?: false;
67 67
     	
68 68
 	}
69 69
 
@@ -80,12 +80,12 @@  discard block
 block discarded – undo
80 80
     	}
81 81
     	$updateSql = "UPDATE `$tableName` SET ";
82 82
     	unset($associative1DArray['id']);
83
-    	$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->getColumnNames($this->model, $this->dbConnection),$associative1DArray);
83
+    	$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->getColumnNames($this->model, $this->dbConnection), $associative1DArray);
84 84
     	
85 85
     	if (count($unexpectedFields) > 0) {
86 86
     		throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
87 87
     	}
88
-    	foreach($associative1DArray as $field => $value) {
88
+    	foreach ($associative1DArray as $field => $value) {
89 89
     	    $sql .= "`$field` = '$value'".",";
90 90
     	}
91 91
     	
@@ -96,7 +96,7 @@  discard block
 block discarded – undo
96 96
     	}
97 97
     	$stmt = $dbConn->prepare($updateSql);
98 98
     	$boolResponse = $stmt->execute();
99
-    	return $boolResponse ?  : false;
99
+    	return $boolResponse ?: false;
100 100
     }
101 101
     
102 102
   /**
@@ -111,7 +111,7 @@  discard block
 block discarded – undo
111 111
    	if (is_null($dbConn)) {
112 112
    	    $dbConn = new DatabaseConnection();
113 113
    	}
114
-   	$sql = $id  ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
114
+   	$sql = $id ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
115 115
    	
116 116
    	try {
117 117
    	    $stmt = $dbConn->prepare($sql);
@@ -123,7 +123,7 @@  discard block
 block discarded – undo
123 123
    	}
124 124
    	$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
125 125
    	
126
-   	foreach($results as $result) {
126
+   	foreach ($results as $result) {
127 127
    	    array_push($tableData, $result);
128 128
    	}
129 129
    	return $tableData;
@@ -142,7 +142,7 @@  discard block
 block discarded – undo
142 142
       
143 143
       $sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
144 144
       $boolResponse = $dbConn->exec($sql);
145
-      return $boolResponse ? : false;
145
+      return $boolResponse ?: false;
146 146
   }
147 147
   
148 148
   /**
@@ -155,7 +155,7 @@  discard block
 block discarded – undo
155 155
   {
156 156
       $unexpectedFields = [];
157 157
       foreach ($userSetterArray as $key => $val) {
158
-          if (!in_array($key,$tableColumn)) {
158
+          if (!in_array($key, $tableColumn)) {
159 159
               $unexpectedFields[] = $key;
160 160
           }
161 161
       }
@@ -169,9 +169,9 @@  discard block
 block discarded – undo
169 169
     */
170 170
   public function prepareUpdateQuery($sql)
171 171
   {
172
-      $splittedQuery = explode(",",$sql);
172
+      $splittedQuery = explode(",", $sql);
173 173
       array_pop($splittedQuery);
174
-      $mergeData = implode(",",$splittedQuery);
174
+      $mergeData = implode(",", $splittedQuery);
175 175
       return $mergeData;
176 176
   }
177 177
   
@@ -197,7 +197,7 @@  discard block
 block discarded – undo
197 197
           $statement->execute();
198 198
           $returnedRowNumbers = $statement->rowCount();
199 199
           
200
-          return $returnedRowNumbers  ? true : false;
200
+          return $returnedRowNumbers ? true : false;
201 201
       }
202 202
       throw EmptyArrayException::checkEmptyArrayException("Array Expected: parameter passed to this function is not an array");
203 203
   }
@@ -221,7 +221,7 @@  discard block
 block discarded – undo
221 221
      $stmt->execute();
222 222
      $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
223 223
      
224
-     foreach($results as $result) {
224
+     foreach ($results as $result) {
225 225
          array_push($tableFields, $result['Field']);
226 226
      }
227 227
      return $tableFields;
Please login to merge, or discard this patch.
src/Database/DatabaseHelper.php 3 patches
Unused Use Statements   -1 removed lines patch added patch discarded remove patch
@@ -8,7 +8,6 @@
 block discarded – undo
8 8
 
9 9
 namespace Laztopaz\potatoORM;
10 10
 
11
-use PDO;
12 11
 use Laztopaz\potatoORM\TableNotCreatedException;
13 12
 
14 13
 class DatabaseHelper {
Please login to merge, or discard this patch.
Indentation   +14 added lines, -14 removed lines patch added patch discarded remove patch
@@ -13,25 +13,25 @@
 block discarded – undo
13 13
 
14 14
 class DatabaseHelper {
15 15
 	
16
-    public $dbConn;
16
+	public $dbConn;
17 17
     
18
-    /**
19
-      * This is a constructor; a default method  that will be called automatically during class instantiation
20
-      */
21
-    public function __construct($dbConnect)
22
-    {
23
-    	$this->dbConn = $dbConnect;
24
-    }
18
+	/**
19
+	 * This is a constructor; a default method  that will be called automatically during class instantiation
20
+	 */
21
+	public function __construct($dbConnect)
22
+	{
23
+		$this->dbConn = $dbConnect;
24
+	}
25 25
     
26
-    /**
27
-      * This method creates a particular table
28
-      * @param tableName
29
-      * $return boolean true or false
30
-      */
26
+	/**
27
+	 * This method creates a particular table
28
+	 * @param tableName
29
+	 * $return boolean true or false
30
+	 */
31 31
    public function createTable($tableName, $conn = NULL)
32 32
    {
33 33
    	if (is_null($conn)) {
34
-   	    $conn = $this->dbConn;
34
+   		$conn = $this->dbConn;
35 35
    	}
36 36
    	
37 37
    	$sql = 'CREATE TABLE IF NOT EXISTS '.$tableName.'(';
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -35,7 +35,7 @@
 block discarded – undo
35 35
    	}
36 36
    	
37 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 ) )';
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 40
    	return $conn->exec($sql);
41 41
    	throw TableNotCreatedException::tableNotCreatedException("Check your database connection");
Please login to merge, or discard this patch.
src/Exceptions/NoRecordDeletionException.php 1 patch
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -12,8 +12,8 @@
 block discarded – undo
12 12
 
13 13
 class NoRecordDeletionException extends  Exception
14 14
 {
15
-    public static function checkNoRecordUpdateException($message)
16
-    {
17
-        return new static($message);
18
-    }
15
+	public static function checkNoRecordUpdateException($message)
16
+	{
17
+		return new static($message);
18
+	}
19 19
 }
Please login to merge, or discard this patch.
src/Exceptions/EmptyArrayException.php 1 patch
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -12,9 +12,9 @@
 block discarded – undo
12 12
 
13 13
 class EmptyArrayException extends Exception {
14 14
 	
15
-    public static function checkEmptyArrayException($message)
16
-    {
17
-    	return new static($message);
18
-    }
15
+	public static function checkEmptyArrayException($message)
16
+	{
17
+		return new static($message);
18
+	}
19 19
 
20 20
 }
Please login to merge, or discard this patch.
src/Exceptions/NoArgumentPassedToFunctionException.php 1 patch
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -12,9 +12,9 @@
 block discarded – undo
12 12
 
13 13
 class NoArgumentPassedToFunctionException extends Exception {
14 14
 	
15
-    public static function checkNoArgumentPassedToFunction($message)
16
-    {
17
-    	return new static($message);
18
-    }
15
+	public static function checkNoArgumentPassedToFunction($message)
16
+	{
17
+		return new static($message);
18
+	}
19 19
 
20 20
 }
Please login to merge, or discard this patch.
src/Exceptions/NoRecordUpdateException.php 1 patch
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -12,9 +12,9 @@
 block discarded – undo
12 12
 
13 13
 class NoRecordUpdateException extends  Exception {
14 14
 	
15
-    public static function checkNoRecordUpdateException($message)
16
-    {
17
-    	return new static($message);
18
-    }
15
+	public static function checkNoRecordUpdateException($message)
16
+	{
17
+		return new static($message);
18
+	}
19 19
 
20 20
 }
Please login to merge, or discard this patch.