@@ -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 | } |