@@ -12,9 +12,9 @@ |
||
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 | } |
@@ -12,9 +12,9 @@ |
||
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 | } |
@@ -12,8 +12,8 @@ |
||
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 | } |
@@ -12,9 +12,9 @@ |
||
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 | } |
@@ -12,9 +12,9 @@ |
||
12 | 12 | |
13 | 13 | class WrongArgumentException extends Exception { |
14 | 14 | |
15 | - public function checkWrongArgumentException($message) |
|
16 | - { |
|
17 | - return new static ($message); |
|
18 | - } |
|
15 | + public function checkWrongArgumentException($message) |
|
16 | + { |
|
17 | + return new static ($message); |
|
18 | + } |
|
19 | 19 | |
20 | 20 | } |
@@ -13,25 +13,25 @@ |
||
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.'('; |
@@ -10,12 +10,12 @@ |
||
10 | 10 | |
11 | 11 | interface InterfaceBaseClass { |
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 | 20 | /** |
21 | 21 | * This method create or update record in a database table |
@@ -14,73 +14,73 @@ |
||
14 | 14 | |
15 | 15 | class DatabaseConnection extends \PDO { |
16 | 16 | |
17 | - private $databaseName; |
|
18 | - private $databaseHost; |
|
19 | - private $databaseDriver; |
|
20 | - private $databaseUsername; |
|
21 | - private $databasePassword; |
|
17 | + private $databaseName; |
|
18 | + private $databaseHost; |
|
19 | + private $databaseDriver; |
|
20 | + private $databaseUsername; |
|
21 | + private $databasePassword; |
|
22 | 22 | |
23 | - public function __construct() |
|
24 | - { |
|
25 | - $this->loadEnv(); // load the environment variables |
|
26 | - $this->databaseName = getenv('databaseName'); |
|
27 | - $this->databaseHost = getenv('databaseHost'); |
|
28 | - $this->databaseDriver = getenv('databaseDriver'); |
|
29 | - $this->databaseUsername = getenv('databaseUsername'); |
|
30 | - $this->databasePassword = getenv('databasePassword'); |
|
23 | + public function __construct() |
|
24 | + { |
|
25 | + $this->loadEnv(); // load the environment variables |
|
26 | + $this->databaseName = getenv('databaseName'); |
|
27 | + $this->databaseHost = getenv('databaseHost'); |
|
28 | + $this->databaseDriver = getenv('databaseDriver'); |
|
29 | + $this->databaseUsername = getenv('databaseUsername'); |
|
30 | + $this->databasePassword = getenv('databasePassword'); |
|
31 | 31 | |
32 | - try { |
|
33 | - $options = [ |
|
34 | - PDO::ATTR_PERSISTENT => true, |
|
35 | - PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION |
|
36 | - ]; |
|
37 | - parent::__construct($this->getDatabaseDriver(), $this->databaseUsername, $this->databasePassword, $options); |
|
32 | + try { |
|
33 | + $options = [ |
|
34 | + PDO::ATTR_PERSISTENT => true, |
|
35 | + PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION |
|
36 | + ]; |
|
37 | + parent::__construct($this->getDatabaseDriver(), $this->databaseUsername, $this->databasePassword, $options); |
|
38 | 38 | |
39 | - } catch(PDOException $e) { |
|
40 | - return $e->getMessage(); |
|
41 | - } |
|
39 | + } catch(PDOException $e) { |
|
40 | + return $e->getMessage(); |
|
41 | + } |
|
42 | 42 | |
43 | - } |
|
43 | + } |
|
44 | 44 | |
45 | - /** |
|
46 | - * This method determines the driver to be used for appropriate database server |
|
47 | - * @params void |
|
48 | - * @return string dsn |
|
49 | - */ |
|
50 | - public function getDatabaseDriver() |
|
51 | - { |
|
52 | - $dsn = ""; |
|
45 | + /** |
|
46 | + * This method determines the driver to be used for appropriate database server |
|
47 | + * @params void |
|
48 | + * @return string dsn |
|
49 | + */ |
|
50 | + public function getDatabaseDriver() |
|
51 | + { |
|
52 | + $dsn = ""; |
|
53 | 53 | |
54 | - switch ($this->databaseDriver) |
|
55 | - { |
|
56 | - case 'mysql': |
|
57 | - // Set DSN |
|
58 | - $dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName; |
|
59 | - break; |
|
60 | - case 'sqlite': |
|
61 | - // Set DSN |
|
62 | - $dsn = 'sqlite:host='.$this->databaseHost.';dbname='. $this->databaseName; |
|
63 | - break; |
|
64 | - case 'pgsql': |
|
65 | - // Set DSN |
|
66 | - $dsn = 'pgsqlsql:host='.$this->databaseHost.';dbname='. $this->databaseName; |
|
67 | - break; |
|
68 | - default: |
|
69 | - // Set DSN |
|
70 | - $dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName; |
|
71 | - } |
|
72 | - return $dsn; |
|
73 | - } |
|
54 | + switch ($this->databaseDriver) |
|
55 | + { |
|
56 | + case 'mysql': |
|
57 | + // Set DSN |
|
58 | + $dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName; |
|
59 | + break; |
|
60 | + case 'sqlite': |
|
61 | + // Set DSN |
|
62 | + $dsn = 'sqlite:host='.$this->databaseHost.';dbname='. $this->databaseName; |
|
63 | + break; |
|
64 | + case 'pgsql': |
|
65 | + // Set DSN |
|
66 | + $dsn = 'pgsqlsql:host='.$this->databaseHost.';dbname='. $this->databaseName; |
|
67 | + break; |
|
68 | + default: |
|
69 | + // Set DSN |
|
70 | + $dsn = 'mysql:host='.$this->databaseHost.';dbname='. $this->databaseName; |
|
71 | + } |
|
72 | + return $dsn; |
|
73 | + } |
|
74 | 74 | |
75 | - /** |
|
76 | - * Load Dotenv to grant getenv() access to environment variables in .env file |
|
77 | - */ |
|
78 | - public function loadEnv() |
|
79 | - { |
|
80 | - if (!getenv("APP_ENV")) { |
|
81 | - $dotenv = new Dotenv(__DIR__.'/../../'); |
|
82 | - $dotenv->load(); |
|
83 | - } |
|
84 | - } |
|
75 | + /** |
|
76 | + * Load Dotenv to grant getenv() access to environment variables in .env file |
|
77 | + */ |
|
78 | + public function loadEnv() |
|
79 | + { |
|
80 | + if (!getenv("APP_ENV")) { |
|
81 | + $dotenv = new Dotenv(__DIR__.'/../../'); |
|
82 | + $dotenv->load(); |
|
83 | + } |
|
84 | + } |
|
85 | 85 | |
86 | 86 | } |
@@ -12,8 +12,8 @@ |
||
12 | 12 | |
13 | 13 | class NoRecordDeletionException extends Exception |
14 | 14 | { |
15 | - public static function checkNoRecordDeleteException($message) |
|
16 | - { |
|
17 | - return new static($message); |
|
18 | - } |
|
15 | + public static function checkNoRecordDeleteException($message) |
|
16 | + { |
|
17 | + return new static($message); |
|
18 | + } |
|
19 | 19 | } |