Completed
Push — test ( d4aaf0...06ea2e )
by Temitope
02:33
created
src/Database/DatabaseConnection.php 2 patches
Indentation   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -21,8 +21,8 @@  discard block
 block discarded – undo
21 21
 
22 22
 	public  function  __construct() 
23 23
 	{
24
-	    $this->loadEnv(); // load the environment variables
25
-	    $this->databaseName     =  getenv('databaseName');
24
+		$this->loadEnv(); // load the environment variables
25
+		$this->databaseName     =  getenv('databaseName');
26 26
 		$this->databaseHost     =  getenv('databaseHost');
27 27
 		$this->databaseDriver   =  getenv('databaseDriver');
28 28
 		$this->databaseUsername =  getenv('databaseUsername');
@@ -78,7 +78,7 @@  discard block
 block discarded – undo
78 78
 	{
79 79
 		if (!getenv("APP_ENV")) {
80 80
 			$dotenv = new Dotenv(__DIR__.'/../../');
81
-		    $dotenv->load();
81
+			$dotenv->load();
82 82
 		}
83 83
 
84 84
 	}
Please login to merge, or discard this patch.
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -22,11 +22,11 @@  discard block
 block discarded – undo
22 22
 	public  function  __construct() 
23 23
 	{
24 24
 	    $this->loadEnv(); // load the environment variables
25
-	    $this->databaseName     =  getenv('databaseName');
26
-		$this->databaseHost     =  getenv('databaseHost');
27
-		$this->databaseDriver   =  getenv('databaseDriver');
28
-		$this->databaseUsername =  getenv('databaseUsername');
29
-		$this->databasePassword =  getenv('databasePassword');
25
+	    $this->databaseName = getenv('databaseName');
26
+		$this->databaseHost     = getenv('databaseHost');
27
+		$this->databaseDriver   = getenv('databaseDriver');
28
+		$this->databaseUsername = getenv('databaseUsername');
29
+		$this->databasePassword = getenv('databasePassword');
30 30
 
31 31
 		try {
32 32
 			$options = [
@@ -34,7 +34,7 @@  discard block
 block discarded – undo
34 34
 			PDO::ATTR_ERRMODE       => PDO::ERRMODE_EXCEPTION
35 35
 			];
36 36
 			parent::__construct($this->getDatabaseDriver(), $this->databaseUsername, $this->databasePassword, $options);
37
-			} catch(PDOException $e) {
37
+			} catch (PDOException $e) {
38 38
 
39 39
 			return $e->getMessage();
40 40
 		}
@@ -53,20 +53,20 @@  discard block
 block discarded – undo
53 53
 		{
54 54
 			case 'mysql':
55 55
 				// Set DSN
56
-				$dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName;
56
+				$dsn = 'mysql:host='.$this->databaseHost.';dbname='.$this->databaseName;
57 57
 				break;
58 58
 			case 'sqlite':
59 59
 				// Set DSN
60
-				$dsn = 'sqlite:host='.$this->databaseHost.';dbname='. $this->databaseName;
60
+				$dsn = 'sqlite:host='.$this->databaseHost.';dbname='.$this->databaseName;
61 61
 				break;
62 62
 			case 'pgsql':
63 63
 
64 64
 				// Set DSN
65
-				$dsn = 'pgsqlsql:host='.$this->databaseHost.';dbname='. $this->databaseName;
65
+				$dsn = 'pgsqlsql:host='.$this->databaseHost.';dbname='.$this->databaseName;
66 66
 				break;
67 67
 			default:
68 68
 				// Set DSN
69
-				$dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName;
69
+				$dsn = 'mysql:host='.$this->databaseHost.';dbname='.$this->databaseName;
70 70
 		}
71 71
 		return $dsn;
72 72
 	}
Please login to merge, or discard this patch.
src/Database/DatabaseHandler.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -42,10 +42,10 @@  discard block
 block discarded – undo
42 42
 	{
43 43
 		$tableFields = $this->getColumnNames($this->model, $this->dbConnection);
44 44
 
45
-		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($tableFields,$associative1DArray);
45
+		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($tableFields, $associative1DArray);
46 46
 
47 47
 		if (count($unexpectedFields) > 0) {
48
-			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields,"needs to be created as table field");
48
+			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
49 49
 		}
50 50
 		unset($tableFields[0]);
51 51
 
@@ -60,17 +60,17 @@  discard block
 block discarded – undo
60 60
 	private function  insertRecord($dbConn, $tableName, $associative1DArray) {
61 61
 
62 62
 		$insertQuery = 'INSERT INTO '.$tableName;
63
-		$TableValues = implode(',',array_keys($associative1DArray));
63
+		$TableValues = implode(',', array_keys($associative1DArray));
64 64
 		foreach ($associative1DArray as $field => $value) {
65 65
 
66 66
 			$FormValues[] = "'".trim(addslashes($value))."'";
67 67
 		}
68 68
 		$splittedTableValues = implode(',', $FormValues);
69
-		$insertQuery.= ' ('.$TableValues.')';
70
-		$insertQuery.= ' VALUES ('.$splittedTableValues.')';
69
+		$insertQuery .= ' ('.$TableValues.')';
70
+		$insertQuery .= ' VALUES ('.$splittedTableValues.')';
71 71
 		$executeQuery = $dbConn->exec($insertQuery);
72 72
 
73
-		return $executeQuery ? : false;
73
+		return $executeQuery ?: false;
74 74
 	}
75 75
 
76 76
 	/*
@@ -87,13 +87,13 @@  discard block
 block discarded – undo
87 87
 
88 88
 		$updateSql = "UPDATE `$tableName` SET ";
89 89
 		unset($associative1DArray['id']);
90
-		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->getColumnNames($this->model, $this->dbConnection),$associative1DArray);
90
+		$unexpectedFields = self::checkIfMagicSetterContainsIsSameAsClassModel($this->getColumnNames($this->model, $this->dbConnection), $associative1DArray);
91 91
 
92 92
 		if (count($unexpectedFields) > 0) {
93 93
 			throw TableFieldUndefinedException::fieldsNotDefinedException($unexpectedFields, "needs to be created as table field");
94 94
 		}
95 95
 
96
-		foreach($associative1DArray as $field => $value) {
96
+		foreach ($associative1DArray as $field => $value) {
97 97
 			$sql .= "`$field` = '$value'".",";
98 98
 		}
99 99
 
@@ -105,7 +105,7 @@  discard block
 block discarded – undo
105 105
 		$stmt = $dbConn->prepare($updateSql);
106 106
 		$boolResponse = $stmt->execute();
107 107
 
108
-		return $boolResponse ?  : false;
108
+		return $boolResponse ?: false;
109 109
 	}
110 110
 
111 111
 	/**
@@ -120,7 +120,7 @@  discard block
 block discarded – undo
120 120
 		if (is_null($dbConn)) {
121 121
 			$dbConn = new DatabaseConnection();
122 122
 		}
123
-		$sql = $id  ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
123
+		$sql = $id ? 'SELECT * FROM '.$tableName.' WHERE id = '.$id : 'SELECT * FROM '.$tableName;
124 124
 
125 125
 		try {
126 126
 			$stmt = $dbConn->prepare($sql);
@@ -132,7 +132,7 @@  discard block
 block discarded – undo
132 132
 		}
133 133
 		$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
134 134
 
135
-		foreach($results as $result) {
135
+		foreach ($results as $result) {
136 136
 			array_push($tableData, $result);
137 137
 		}
138 138
 
@@ -152,7 +152,7 @@  discard block
 block discarded – undo
152 152
 		$sql = 'DELETE FROM '.$tableName.' WHERE id = '.$id;
153 153
 		$boolResponse = $dbConn->exec($sql);
154 154
 
155
-		return $boolResponse ? : false;
155
+		return $boolResponse ?: false;
156 156
 	}
157 157
 
158 158
 	/**
@@ -166,7 +166,7 @@  discard block
 block discarded – undo
166 166
 		$unexpectedFields = [];
167 167
 
168 168
 		foreach ($userSetterArray as $key => $val) {
169
-			if (!in_array($key,$tableColumn)) {
169
+			if (!in_array($key, $tableColumn)) {
170 170
 
171 171
 				$unexpectedFields[] = $key;
172 172
 			}
@@ -181,9 +181,9 @@  discard block
 block discarded – undo
181 181
 	 */
182 182
 	public function prepareUpdateQuery($sql)
183 183
 	{
184
-		$splittedQuery = explode(",",$sql);
184
+		$splittedQuery = explode(",", $sql);
185 185
 		array_pop($splittedQuery);
186
-		$mergeData = implode(",",$splittedQuery);
186
+		$mergeData = implode(",", $splittedQuery);
187 187
 
188 188
 		return $mergeData;
189 189
 	}
@@ -208,7 +208,7 @@  discard block
 block discarded – undo
208 208
 			$statement = $dbConn->prepare($sql);
209 209
 			$statement->execute();
210 210
 			$returnedRowNumbers = $statement->rowCount();
211
-			return $returnedRowNumbers  ? true : false;
211
+			return $returnedRowNumbers ? true : false;
212 212
 		}
213 213
 
214 214
 		throw EmptyArrayException::checkEmptyArrayException("Array Expected: parameter passed to this function is not an array");
@@ -234,7 +234,7 @@  discard block
 block discarded – undo
234 234
 		$stmt->execute();
235 235
 		$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
236 236
 
237
-		foreach($results as $result) {
237
+		foreach ($results as $result) {
238 238
 			array_push($tableFields, $result['Field']);
239 239
 		}
240 240
 			return $tableFields;
Please login to merge, or discard this patch.