@@ -12,71 +12,71 @@ |
||
12 | 12 | |
13 | 13 | class DatabaseConnection extends PDO |
14 | 14 | { |
15 | - private $databaseName; |
|
16 | - private $databaseHost; |
|
17 | - private $databaseDriver; |
|
18 | - private $databaseUsername; |
|
19 | - private $databasePassword; |
|
15 | + private $databaseName; |
|
16 | + private $databaseHost; |
|
17 | + private $databaseDriver; |
|
18 | + private $databaseUsername; |
|
19 | + private $databasePassword; |
|
20 | 20 | |
21 | - public function __construct() |
|
22 | - { |
|
23 | - $this->loadEnv(); // load the environment variables |
|
21 | + public function __construct() |
|
22 | + { |
|
23 | + $this->loadEnv(); // load the environment variables |
|
24 | 24 | |
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 | - try { |
|
32 | - $options = [ |
|
33 | - PDO::ATTR_PERSISTENT => true, |
|
34 | - PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, |
|
35 | - ]; |
|
31 | + try { |
|
32 | + $options = [ |
|
33 | + PDO::ATTR_PERSISTENT => true, |
|
34 | + PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, |
|
35 | + ]; |
|
36 | 36 | |
37 | - parent::__construct($this->getDatabaseDriver(), $this->databaseUsername, $this->databasePassword, $options); |
|
38 | - } catch (PDOException $e) { |
|
39 | - return $e->getMessage(); |
|
40 | - } |
|
41 | - } |
|
37 | + parent::__construct($this->getDatabaseDriver(), $this->databaseUsername, $this->databasePassword, $options); |
|
38 | + } catch (PDOException $e) { |
|
39 | + return $e->getMessage(); |
|
40 | + } |
|
41 | + } |
|
42 | 42 | |
43 | - /** |
|
44 | - * This method determines the driver to be used for appropriate database server. |
|
45 | - * |
|
46 | - * @params void |
|
47 | - * |
|
48 | - * @return string dsn |
|
49 | - */ |
|
50 | - public function getDatabaseDriver() |
|
51 | - { |
|
52 | - $dsn = ''; |
|
43 | + /** |
|
44 | + * This method determines the driver to be used for appropriate database server. |
|
45 | + * |
|
46 | + * @params void |
|
47 | + * |
|
48 | + * @return string dsn |
|
49 | + */ |
|
50 | + public function getDatabaseDriver() |
|
51 | + { |
|
52 | + $dsn = ''; |
|
53 | 53 | |
54 | - switch ($this->databaseDriver) { |
|
55 | - case 'mysql': |
|
56 | - $dsn = 'mysql:host='.$this->databaseHost.';dbname='.$this->databaseName; // Set DSN |
|
57 | - break; |
|
58 | - case 'sqlite': |
|
59 | - $dsn = 'sqlite:host='.$this->databaseHost.';dbname='.$this->databaseName; |
|
60 | - break; |
|
61 | - case 'pgsql': |
|
62 | - $dsn = 'pgsqlsql:host='.$this->databaseHost.';dbname='.$this->databaseName; |
|
63 | - break; |
|
64 | - default: |
|
65 | - $dsn = 'mysql:host='.$this->databaseHost.';dbname='.$this->databaseName; |
|
66 | - break; |
|
67 | - } |
|
54 | + switch ($this->databaseDriver) { |
|
55 | + case 'mysql': |
|
56 | + $dsn = 'mysql:host='.$this->databaseHost.';dbname='.$this->databaseName; // Set DSN |
|
57 | + break; |
|
58 | + case 'sqlite': |
|
59 | + $dsn = 'sqlite:host='.$this->databaseHost.';dbname='.$this->databaseName; |
|
60 | + break; |
|
61 | + case 'pgsql': |
|
62 | + $dsn = 'pgsqlsql:host='.$this->databaseHost.';dbname='.$this->databaseName; |
|
63 | + break; |
|
64 | + default: |
|
65 | + $dsn = 'mysql:host='.$this->databaseHost.';dbname='.$this->databaseName; |
|
66 | + break; |
|
67 | + } |
|
68 | 68 | |
69 | - return $dsn; |
|
70 | - } |
|
69 | + return $dsn; |
|
70 | + } |
|
71 | 71 | |
72 | - /** |
|
73 | - * Load Dotenv to grant getenv() access to environment variables in .env file. |
|
74 | - */ |
|
75 | - public function loadEnv() |
|
76 | - { |
|
77 | - if (!getenv('APP_ENV')) { |
|
78 | - $dotenv = new Dotenv(__DIR__.'/../../'); |
|
79 | - $dotenv->load(); |
|
80 | - } |
|
81 | - } |
|
72 | + /** |
|
73 | + * Load Dotenv to grant getenv() access to environment variables in .env file. |
|
74 | + */ |
|
75 | + public function loadEnv() |
|
76 | + { |
|
77 | + if (!getenv('APP_ENV')) { |
|
78 | + $dotenv = new Dotenv(__DIR__.'/../../'); |
|
79 | + $dotenv->load(); |
|
80 | + } |
|
81 | + } |
|
82 | 82 | } |
@@ -37,62 +37,62 @@ |
||
37 | 37 | |
38 | 38 | trait Inflector |
39 | 39 | { |
40 | - /** |
|
41 | - * Pluralizes English nouns. |
|
42 | - * |
|
43 | - * @static |
|
44 | - * |
|
45 | - * @param string $word English noun to pluralize |
|
46 | - * |
|
47 | - * @return string Plural noun |
|
48 | - */ |
|
49 | - public static function pluralize($word) |
|
50 | - { |
|
51 | - $plural = [ |
|
52 | - '/(quiz)$/i' => '$1zes', |
|
53 | - '/^(ox)$/i' => '$1en', |
|
54 | - '/([m|l])ouse$/i' => '$1ice', |
|
55 | - '/(matr|vert|ind)ix|ex$/i' => '$1ices', |
|
56 | - '/(x|ch|ss|sh)$/i' => '$1es', |
|
57 | - '/([^aeiouy]|qu)y$/i' => '$1ies', |
|
58 | - '/(hive)$/i' => '$1s', |
|
59 | - '/(?:([^f])fe|([lr])f)$/i' => '$1$2ves', |
|
60 | - '/(shea|lea|loa|thie)f$/i' => '$1ves', |
|
61 | - '/sis$/i' => 'ses', |
|
62 | - '/([ti])um$/i' => '$1a', |
|
63 | - '/(tomat|potat|ech|her|vet)o$/i' => '$1oes', |
|
64 | - '/(bu)s$/i' => '$1ses', |
|
65 | - '/(alias)$/i' => '$1es', |
|
66 | - '/(octop)us$/i' => '$1i', |
|
67 | - '/(ax|test)is$/i' => '$1es', |
|
68 | - '/(us)$/i' => '$1es', |
|
69 | - '/s$/i' => 's', |
|
70 | - '/$/' => 's', |
|
71 | - ]; |
|
72 | - $uncountable = ['equipment', 'information', 'rice', 'money', 'species', 'series', 'fish', 'sheep']; |
|
73 | - $irregular = [ |
|
74 | - 'person' => 'people', |
|
75 | - 'man' => 'men', |
|
76 | - 'child' => 'children', |
|
77 | - 'sex' => 'sexes', |
|
78 | - 'move' => 'moves', ]; |
|
79 | - $lowercased_word = strtolower($word); |
|
80 | - foreach ($uncountable as $_uncountable) { |
|
81 | - if (substr($lowercased_word, (-1 * strlen($_uncountable))) == $_uncountable) { |
|
82 | - return $word; |
|
83 | - } |
|
84 | - } |
|
85 | - foreach ($irregular as $_plural => $_singular) { |
|
86 | - if (preg_match('/('.$_plural.')$/i', $word, $arr)) { |
|
87 | - return preg_replace('/('.$_plural.')$/i', substr($arr[0], 0, 1).substr($_singular, 1), $word); |
|
88 | - } |
|
89 | - } |
|
90 | - foreach ($plural as $rule => $replacement) { |
|
91 | - if (preg_match($rule, $word)) { |
|
92 | - return preg_replace($rule, $replacement, $word); |
|
93 | - } |
|
94 | - } |
|
40 | + /** |
|
41 | + * Pluralizes English nouns. |
|
42 | + * |
|
43 | + * @static |
|
44 | + * |
|
45 | + * @param string $word English noun to pluralize |
|
46 | + * |
|
47 | + * @return string Plural noun |
|
48 | + */ |
|
49 | + public static function pluralize($word) |
|
50 | + { |
|
51 | + $plural = [ |
|
52 | + '/(quiz)$/i' => '$1zes', |
|
53 | + '/^(ox)$/i' => '$1en', |
|
54 | + '/([m|l])ouse$/i' => '$1ice', |
|
55 | + '/(matr|vert|ind)ix|ex$/i' => '$1ices', |
|
56 | + '/(x|ch|ss|sh)$/i' => '$1es', |
|
57 | + '/([^aeiouy]|qu)y$/i' => '$1ies', |
|
58 | + '/(hive)$/i' => '$1s', |
|
59 | + '/(?:([^f])fe|([lr])f)$/i' => '$1$2ves', |
|
60 | + '/(shea|lea|loa|thie)f$/i' => '$1ves', |
|
61 | + '/sis$/i' => 'ses', |
|
62 | + '/([ti])um$/i' => '$1a', |
|
63 | + '/(tomat|potat|ech|her|vet)o$/i' => '$1oes', |
|
64 | + '/(bu)s$/i' => '$1ses', |
|
65 | + '/(alias)$/i' => '$1es', |
|
66 | + '/(octop)us$/i' => '$1i', |
|
67 | + '/(ax|test)is$/i' => '$1es', |
|
68 | + '/(us)$/i' => '$1es', |
|
69 | + '/s$/i' => 's', |
|
70 | + '/$/' => 's', |
|
71 | + ]; |
|
72 | + $uncountable = ['equipment', 'information', 'rice', 'money', 'species', 'series', 'fish', 'sheep']; |
|
73 | + $irregular = [ |
|
74 | + 'person' => 'people', |
|
75 | + 'man' => 'men', |
|
76 | + 'child' => 'children', |
|
77 | + 'sex' => 'sexes', |
|
78 | + 'move' => 'moves', ]; |
|
79 | + $lowercased_word = strtolower($word); |
|
80 | + foreach ($uncountable as $_uncountable) { |
|
81 | + if (substr($lowercased_word, (-1 * strlen($_uncountable))) == $_uncountable) { |
|
82 | + return $word; |
|
83 | + } |
|
84 | + } |
|
85 | + foreach ($irregular as $_plural => $_singular) { |
|
86 | + if (preg_match('/('.$_plural.')$/i', $word, $arr)) { |
|
87 | + return preg_replace('/('.$_plural.')$/i', substr($arr[0], 0, 1).substr($_singular, 1), $word); |
|
88 | + } |
|
89 | + } |
|
90 | + foreach ($plural as $rule => $replacement) { |
|
91 | + if (preg_match($rule, $word)) { |
|
92 | + return preg_replace($rule, $replacement, $word); |
|
93 | + } |
|
94 | + } |
|
95 | 95 | |
96 | - return false; |
|
97 | - } |
|
96 | + return false; |
|
97 | + } |
|
98 | 98 | } |
@@ -78,7 +78,7 @@ |
||
78 | 78 | 'move' => 'moves', ]; |
79 | 79 | $lowercased_word = strtolower($word); |
80 | 80 | foreach ($uncountable as $_uncountable) { |
81 | - if (substr($lowercased_word, (-1 * strlen($_uncountable))) == $_uncountable) { |
|
81 | + if (substr($lowercased_word, (-1*strlen($_uncountable))) == $_uncountable) { |
|
82 | 82 | return $word; |
83 | 83 | } |
84 | 84 | } |
@@ -10,8 +10,8 @@ |
||
10 | 10 | |
11 | 11 | class NoRecordDeletionException extends Exception |
12 | 12 | { |
13 | - public static function create($message) |
|
14 | - { |
|
15 | - return new static($message); |
|
16 | - } |
|
13 | + public static function create($message) |
|
14 | + { |
|
15 | + return new static($message); |
|
16 | + } |
|
17 | 17 | } |
@@ -10,8 +10,8 @@ |
||
10 | 10 | |
11 | 11 | class NoRecordDeletionException extends Exception |
12 | 12 | { |
13 | - public static function create($message) |
|
14 | - { |
|
15 | - return new static($message); |
|
16 | - } |
|
13 | + public static function create($message) |
|
14 | + { |
|
15 | + return new static($message); |
|
16 | + } |
|
17 | 17 | } |
@@ -10,8 +10,8 @@ |
||
10 | 10 | |
11 | 11 | class NoRecordDeletionException extends Exception |
12 | 12 | { |
13 | - public static function create($message) |
|
14 | - { |
|
15 | - return new static($message); |
|
16 | - } |
|
13 | + public static function create($message) |
|
14 | + { |
|
15 | + return new static($message); |
|
16 | + } |
|
17 | 17 | } |
@@ -10,8 +10,8 @@ |
||
10 | 10 | |
11 | 11 | class NoRecordDeletionException extends Exception |
12 | 12 | { |
13 | - public static function create($message) |
|
14 | - { |
|
15 | - return new static($message); |
|
16 | - } |
|
13 | + public static function create($message) |
|
14 | + { |
|
15 | + return new static($message); |
|
16 | + } |
|
17 | 17 | } |
@@ -10,8 +10,8 @@ |
||
10 | 10 | |
11 | 11 | class NoRecordDeletionException extends Exception |
12 | 12 | { |
13 | - public static function create($message) |
|
14 | - { |
|
15 | - return new static($message); |
|
16 | - } |
|
13 | + public static function create($message) |
|
14 | + { |
|
15 | + return new static($message); |
|
16 | + } |
|
17 | 17 | } |