@@ -9,12 +9,9 @@ |
||
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 |
@@ -18,131 +18,131 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
@@ -14,7 +14,6 @@ |
||
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 |
@@ -20,155 +20,155 @@ discard block |
||
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 |
||
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 |
||
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 | } |
@@ -12,34 +12,34 @@ |
||
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 | } |
@@ -6,7 +6,7 @@ |
||
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 |
@@ -10,31 +10,31 @@ |
||
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 | } |