@@ -21,105 +21,105 @@ |
||
| 21 | 21 | */ |
| 22 | 22 | class MySQL implements ConnectableInterface |
| 23 | 23 | { |
| 24 | - /** |
|
| 25 | - * @var string $dsn |
|
| 26 | - */ |
|
| 27 | - protected $dsn; |
|
| 24 | + /** |
|
| 25 | + * @var string $dsn |
|
| 26 | + */ |
|
| 27 | + protected $dsn; |
|
| 28 | 28 | |
| 29 | - /** |
|
| 30 | - * @var \PDO $connectionObject |
|
| 31 | - */ |
|
| 32 | - protected $connectionObject; |
|
| 29 | + /** |
|
| 30 | + * @var \PDO $connectionObject |
|
| 31 | + */ |
|
| 32 | + protected $connectionObject; |
|
| 33 | 33 | |
| 34 | - /** |
|
| 35 | - * @var array loginData |
|
| 36 | - */ |
|
| 37 | - private $loginData = []; |
|
| 34 | + /** |
|
| 35 | + * @var array loginData |
|
| 36 | + */ |
|
| 37 | + private $loginData = []; |
|
| 38 | 38 | |
| 39 | - /** |
|
| 40 | - * Setter for the DSN string {@see $dsn} |
|
| 41 | - * |
|
| 42 | - * @param array $dsnArray |
|
| 43 | - * @return void |
|
| 44 | - */ |
|
| 45 | - public function setDsn(array $dsnArray) |
|
| 46 | - { |
|
| 47 | - $this->dsn = $dsnArray; |
|
| 48 | - } |
|
| 39 | + /** |
|
| 40 | + * Setter for the DSN string {@see $dsn} |
|
| 41 | + * |
|
| 42 | + * @param array $dsnArray |
|
| 43 | + * @return void |
|
| 44 | + */ |
|
| 45 | + public function setDsn(array $dsnArray) |
|
| 46 | + { |
|
| 47 | + $this->dsn = $dsnArray; |
|
| 48 | + } |
|
| 49 | 49 | |
| 50 | - /** |
|
| 51 | - * Establishes connection |
|
| 52 | - * |
|
| 53 | - * @param string $username |
|
| 54 | - * @param string $password optional |
|
| 55 | - * @throws \EmmetBlue\Core\Exception\SQLException |
|
| 56 | - * @return void |
|
| 57 | - */ |
|
| 58 | - public function connect(string $username, string $password="") |
|
| 59 | - { |
|
| 60 | - $host = $this->dsn[0]; |
|
| 61 | - $database = $this->dsn[1]; |
|
| 50 | + /** |
|
| 51 | + * Establishes connection |
|
| 52 | + * |
|
| 53 | + * @param string $username |
|
| 54 | + * @param string $password optional |
|
| 55 | + * @throws \EmmetBlue\Core\Exception\SQLException |
|
| 56 | + * @return void |
|
| 57 | + */ |
|
| 58 | + public function connect(string $username, string $password="") |
|
| 59 | + { |
|
| 60 | + $host = $this->dsn[0]; |
|
| 61 | + $database = $this->dsn[1]; |
|
| 62 | 62 | |
| 63 | - $this->loginData['username'] = $username; |
|
| 64 | - $this->loginData['password'] = $password; |
|
| 63 | + $this->loginData['username'] = $username; |
|
| 64 | + $this->loginData['password'] = $password; |
|
| 65 | 65 | |
| 66 | - try |
|
| 67 | - { |
|
| 68 | - $this->connectionObject = new \PDO("mysql:host=$host;dbname=$database;", $username, $password); |
|
| 69 | - } |
|
| 70 | - catch (\PDOException $e) |
|
| 71 | - { |
|
| 72 | - throw new SQLException("Unable to connect to database", 400, $e); |
|
| 73 | - } |
|
| 66 | + try |
|
| 67 | + { |
|
| 68 | + $this->connectionObject = new \PDO("mysql:host=$host;dbname=$database;", $username, $password); |
|
| 69 | + } |
|
| 70 | + catch (\PDOException $e) |
|
| 71 | + { |
|
| 72 | + throw new SQLException("Unable to connect to database", 400, $e); |
|
| 73 | + } |
|
| 74 | 74 | |
| 75 | - $dsn = $this->dsn; |
|
| 76 | - unset($dsn[0], $dsn[1]); |
|
| 75 | + $dsn = $this->dsn; |
|
| 76 | + unset($dsn[0], $dsn[1]); |
|
| 77 | 77 | |
| 78 | - foreach ($dsn as $attribute) |
|
| 79 | - { |
|
| 80 | - foreach ($attribute as $key=>$value) |
|
| 81 | - { |
|
| 82 | - $this->connectionObject->setAttribute($key, $value); |
|
| 83 | - } |
|
| 84 | - } |
|
| 85 | - } |
|
| 78 | + foreach ($dsn as $attribute) |
|
| 79 | + { |
|
| 80 | + foreach ($attribute as $key=>$value) |
|
| 81 | + { |
|
| 82 | + $this->connectionObject->setAttribute($key, $value); |
|
| 83 | + } |
|
| 84 | + } |
|
| 85 | + } |
|
| 86 | 86 | |
| 87 | - /** |
|
| 88 | - * Returns an instance a pdo intance of the connection object |
|
| 89 | - * |
|
| 90 | - * @return \PDO |
|
| 91 | - */ |
|
| 92 | - public function getConnection() : \PDO |
|
| 93 | - { |
|
| 94 | - if ($this->connectionObject instanceof \PDO) |
|
| 95 | - { |
|
| 96 | - return $this->connectionObject; |
|
| 97 | - } |
|
| 87 | + /** |
|
| 88 | + * Returns an instance a pdo intance of the connection object |
|
| 89 | + * |
|
| 90 | + * @return \PDO |
|
| 91 | + */ |
|
| 92 | + public function getConnection() : \PDO |
|
| 93 | + { |
|
| 94 | + if ($this->connectionObject instanceof \PDO) |
|
| 95 | + { |
|
| 96 | + return $this->connectionObject; |
|
| 97 | + } |
|
| 98 | 98 | |
| 99 | - $this->connect( |
|
| 100 | - $this->loginData['username'] ?? '', |
|
| 101 | - $this->loginData['password'] ?? '' |
|
| 102 | - ); |
|
| 99 | + $this->connect( |
|
| 100 | + $this->loginData['username'] ?? '', |
|
| 101 | + $this->loginData['password'] ?? '' |
|
| 102 | + ); |
|
| 103 | 103 | |
| 104 | - return $this->connectionObject; |
|
| 105 | - } |
|
| 104 | + return $this->connectionObject; |
|
| 105 | + } |
|
| 106 | 106 | |
| 107 | - /** |
|
| 108 | - * Closes connection |
|
| 109 | - */ |
|
| 110 | - public function disableConnection() |
|
| 111 | - { |
|
| 112 | - $this->connectionObject = null; |
|
| 113 | - } |
|
| 107 | + /** |
|
| 108 | + * Closes connection |
|
| 109 | + */ |
|
| 110 | + public function disableConnection() |
|
| 111 | + { |
|
| 112 | + $this->connectionObject = null; |
|
| 113 | + } |
|
| 114 | 114 | |
| 115 | - /** |
|
| 116 | - * Sets attributes for the PDO object |
|
| 117 | - * |
|
| 118 | - * @param \PDO $attribute |
|
| 119 | - * @param \PDO $value |
|
| 120 | - */ |
|
| 121 | - public function setAttribute(\PDO $attribute, \PDO $value) |
|
| 122 | - { |
|
| 123 | - $this->connectionObject->setAttribute($attribute, $value); |
|
| 124 | - } |
|
| 115 | + /** |
|
| 116 | + * Sets attributes for the PDO object |
|
| 117 | + * |
|
| 118 | + * @param \PDO $attribute |
|
| 119 | + * @param \PDO $value |
|
| 120 | + */ |
|
| 121 | + public function setAttribute(\PDO $attribute, \PDO $value) |
|
| 122 | + { |
|
| 123 | + $this->connectionObject->setAttribute($attribute, $value); |
|
| 124 | + } |
|
| 125 | 125 | } |
@@ -23,7 +23,7 @@ |
||
| 23 | 23 | public function __construct(array $sender, array $recipients, array $message){ |
| 24 | 24 | $smtpConfigJson = file_get_contents(Constant::getGlobals()["config-dir"]["smtp-config"]); |
| 25 | 25 | |
| 26 | - $smtpConfig = json_decode($smtpConfigJson); |
|
| 26 | + $smtpConfig = json_decode($smtpConfigJson); |
|
| 27 | 27 | |
| 28 | 28 | $mail = new \PHPMailer; |
| 29 | 29 | $mail->SMTPDebug = $smtpConfig->debug; |
@@ -21,43 +21,43 @@ |
||
| 21 | 21 | */ |
| 22 | 22 | class DatabaseConnectionFactory |
| 23 | 23 | { |
| 24 | - /** |
|
| 25 | - * @var \PDO $connectionObject |
|
| 26 | - */ |
|
| 27 | - private static $connectionObject; |
|
| 28 | - |
|
| 29 | - /** |
|
| 30 | - * Gets the config values defined in the database-config.json file |
|
| 31 | - * and uses the values to create a new connection object. |
|
| 32 | - */ |
|
| 33 | - public static function bootstrap() |
|
| 34 | - { |
|
| 35 | - $databaseConfigJson = file_get_contents(Constant::getGlobals()["config-dir"]["database-config"]); |
|
| 36 | - |
|
| 37 | - $databaseConfig = json_decode($databaseConfigJson); |
|
| 38 | - |
|
| 39 | - $adapter = $databaseConfig->adapter; |
|
| 40 | - $server = $databaseConfig->server; |
|
| 41 | - $database = $databaseConfig->database; |
|
| 42 | - $username = $databaseConfig->username; |
|
| 43 | - $password = $databaseConfig->password; |
|
| 44 | - |
|
| 45 | - self::$connectionObject = new Connection($adapter, [$server, $database], $username, $password); |
|
| 46 | - |
|
| 47 | - if ($databaseConfig->showError) |
|
| 48 | - { |
|
| 49 | - self::$connectionObject->getConnection()->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); |
|
| 50 | - } |
|
| 51 | - } |
|
| 52 | - |
|
| 53 | - /** |
|
| 54 | - * Returns a new connection object |
|
| 55 | - * |
|
| 56 | - * @return \PDO |
|
| 57 | - */ |
|
| 58 | - public static function getConnection() : \PDO |
|
| 59 | - { |
|
| 60 | - self::bootstrap(); |
|
| 61 | - return self::$connectionObject->getConnection(); |
|
| 62 | - } |
|
| 24 | + /** |
|
| 25 | + * @var \PDO $connectionObject |
|
| 26 | + */ |
|
| 27 | + private static $connectionObject; |
|
| 28 | + |
|
| 29 | + /** |
|
| 30 | + * Gets the config values defined in the database-config.json file |
|
| 31 | + * and uses the values to create a new connection object. |
|
| 32 | + */ |
|
| 33 | + public static function bootstrap() |
|
| 34 | + { |
|
| 35 | + $databaseConfigJson = file_get_contents(Constant::getGlobals()["config-dir"]["database-config"]); |
|
| 36 | + |
|
| 37 | + $databaseConfig = json_decode($databaseConfigJson); |
|
| 38 | + |
|
| 39 | + $adapter = $databaseConfig->adapter; |
|
| 40 | + $server = $databaseConfig->server; |
|
| 41 | + $database = $databaseConfig->database; |
|
| 42 | + $username = $databaseConfig->username; |
|
| 43 | + $password = $databaseConfig->password; |
|
| 44 | + |
|
| 45 | + self::$connectionObject = new Connection($adapter, [$server, $database], $username, $password); |
|
| 46 | + |
|
| 47 | + if ($databaseConfig->showError) |
|
| 48 | + { |
|
| 49 | + self::$connectionObject->getConnection()->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); |
|
| 50 | + } |
|
| 51 | + } |
|
| 52 | + |
|
| 53 | + /** |
|
| 54 | + * Returns a new connection object |
|
| 55 | + * |
|
| 56 | + * @return \PDO |
|
| 57 | + */ |
|
| 58 | + public static function getConnection() : \PDO |
|
| 59 | + { |
|
| 60 | + self::bootstrap(); |
|
| 61 | + return self::$connectionObject->getConnection(); |
|
| 62 | + } |
|
| 63 | 63 | } |
@@ -26,7 +26,7 @@ |
||
| 26 | 26 | { |
| 27 | 27 | $configJson = file_get_contents(Constant::getGlobals()["config-dir"]["http-headers-config"]); |
| 28 | 28 | |
| 29 | - self::$headers = json_decode($configJson, true); |
|
| 29 | + self::$headers = json_decode($configJson, true); |
|
| 30 | 30 | } |
| 31 | 31 | |
| 32 | 32 | public static function get($url, $extraHeaders = []) |
@@ -26,9 +26,9 @@ |
||
| 26 | 26 | { |
| 27 | 27 | $configJson = file_get_contents(Constant::getGlobals()["config-dir"]["elasticsearch-config"]); |
| 28 | 28 | |
| 29 | - $config = json_decode($configJson, true); |
|
| 29 | + $config = json_decode($configJson, true); |
|
| 30 | 30 | |
| 31 | - self::$clientObject = \Elasticsearch\ClientBuilder::create()->setHosts($config["hosts"])->build(); |
|
| 31 | + self::$clientObject = \Elasticsearch\ClientBuilder::create()->setHosts($config["hosts"])->build(); |
|
| 32 | 32 | } |
| 33 | 33 | |
| 34 | 34 | public static function getClient() |
@@ -22,12 +22,12 @@ discard block |
||
| 22 | 22 | */ |
| 23 | 23 | class DatabaseLog implements LogInterface |
| 24 | 24 | { |
| 25 | - public static function logDeprecated(string $databaseUserId, string $event, string $objectSchema, string $object, string $tSql) |
|
| 26 | - { |
|
| 27 | - $insertBuilder = (new Builder("QueryBuilder", "Insert"))->getBuilder(); |
|
| 28 | - try { |
|
| 29 | - $insertBuilder |
|
| 30 | - ->into(' |
|
| 25 | + public static function logDeprecated(string $databaseUserId, string $event, string $objectSchema, string $object, string $tSql) |
|
| 26 | + { |
|
| 27 | + $insertBuilder = (new Builder("QueryBuilder", "Insert"))->getBuilder(); |
|
| 28 | + try { |
|
| 29 | + $insertBuilder |
|
| 30 | + ->into(' |
|
| 31 | 31 | [Logs].[DatabaseLog] |
| 32 | 32 | ( |
| 33 | 33 | PostTime, |
@@ -38,25 +38,25 @@ discard block |
||
| 38 | 38 | TSQL |
| 39 | 39 | ) |
| 40 | 40 | ') |
| 41 | - ->values([ |
|
| 42 | - 'GETDATE()', |
|
| 43 | - QB::wrapString($databaseUserId, "'"), |
|
| 44 | - QB::wrapString((string)$event, "'"), |
|
| 45 | - QB::wrapString($objectSchema, "'"), |
|
| 46 | - QB::wrapString($object, "'"), |
|
| 47 | - QB::wrapString(str_replace("'", "\"", $tSql), "'") |
|
| 48 | - ]); |
|
| 41 | + ->values([ |
|
| 42 | + 'GETDATE()', |
|
| 43 | + QB::wrapString($databaseUserId, "'"), |
|
| 44 | + QB::wrapString((string)$event, "'"), |
|
| 45 | + QB::wrapString($objectSchema, "'"), |
|
| 46 | + QB::wrapString($object, "'"), |
|
| 47 | + QB::wrapString(str_replace("'", "\"", $tSql), "'") |
|
| 48 | + ]); |
|
| 49 | 49 | |
| 50 | - DBConnectionFactory::getConnection()->query((string)$insertBuilder); |
|
| 51 | - } catch (\PDOException $e) { |
|
| 52 | - echo $e->getMessage(); |
|
| 53 | - throw new SQLException(sprintf( |
|
| 54 | - "Unable to store database log" |
|
| 55 | - ), 1); |
|
| 56 | - } |
|
| 57 | - } |
|
| 50 | + DBConnectionFactory::getConnection()->query((string)$insertBuilder); |
|
| 51 | + } catch (\PDOException $e) { |
|
| 52 | + echo $e->getMessage(); |
|
| 53 | + throw new SQLException(sprintf( |
|
| 54 | + "Unable to store database log" |
|
| 55 | + ), 1); |
|
| 56 | + } |
|
| 57 | + } |
|
| 58 | 58 | |
| 59 | - public static function log(string $databaseUserId, string $event, string $objectSchema, string $object, string $tSql){ |
|
| 59 | + public static function log(string $databaseUserId, string $event, string $objectSchema, string $object, string $tSql){ |
|
| 60 | 60 | |
| 61 | - } |
|
| 61 | + } |
|
| 62 | 62 | } |
@@ -22,21 +22,21 @@ discard block |
||
| 22 | 22 | */ |
| 23 | 23 | class ErrorLog implements LogInterface |
| 24 | 24 | { |
| 25 | - public static function logDeprecated(int $databaseUserId, string $errorNumber, string $errorSeverity, string $errorMessage, string $errorObject=null) |
|
| 26 | - { |
|
| 27 | - /** |
|
| 28 | - * For now I am not doing anything with $errorObject yet. |
|
| 29 | - * |
|
| 30 | - * As soon as it can be properly serialized for the MSSQL Server db |
|
| 31 | - * it shall be saved in the database. |
|
| 32 | - * |
|
| 33 | - * FUNNY: I'M GONNA INTENTIONALLY LEAVE THIS COMMIT FOR MY AMUSEMENT |
|
| 34 | - * $errorObject, wasn't the issue. My DB schema was. |
|
| 35 | - */ |
|
| 36 | - $insertBuilder = (new Builder("QueryBuilder", "Insert"))->getBuilder(); |
|
| 25 | + public static function logDeprecated(int $databaseUserId, string $errorNumber, string $errorSeverity, string $errorMessage, string $errorObject=null) |
|
| 26 | + { |
|
| 27 | + /** |
|
| 28 | + * For now I am not doing anything with $errorObject yet. |
|
| 29 | + * |
|
| 30 | + * As soon as it can be properly serialized for the MSSQL Server db |
|
| 31 | + * it shall be saved in the database. |
|
| 32 | + * |
|
| 33 | + * FUNNY: I'M GONNA INTENTIONALLY LEAVE THIS COMMIT FOR MY AMUSEMENT |
|
| 34 | + * $errorObject, wasn't the issue. My DB schema was. |
|
| 35 | + */ |
|
| 36 | + $insertBuilder = (new Builder("QueryBuilder", "Insert"))->getBuilder(); |
|
| 37 | 37 | |
| 38 | - $insertBuilder |
|
| 39 | - ->into(' |
|
| 38 | + $insertBuilder |
|
| 39 | + ->into(' |
|
| 40 | 40 | [Logs].[ErrorLog] |
| 41 | 41 | ( |
| 42 | 42 | ErrorTime, |
@@ -46,18 +46,18 @@ discard block |
||
| 46 | 46 | ErrorMessage |
| 47 | 47 | ) |
| 48 | 48 | ') |
| 49 | - ->values([ |
|
| 50 | - 'GETDATE()', |
|
| 51 | - $databaseUserId, |
|
| 52 | - QB::wrapString($errorNumber, "'"), |
|
| 53 | - QB::wrapString($errorSeverity, "'"), |
|
| 54 | - QB::wrapString($errorMessage, "'") |
|
| 55 | - ]); |
|
| 49 | + ->values([ |
|
| 50 | + 'GETDATE()', |
|
| 51 | + $databaseUserId, |
|
| 52 | + QB::wrapString($errorNumber, "'"), |
|
| 53 | + QB::wrapString($errorSeverity, "'"), |
|
| 54 | + QB::wrapString($errorMessage, "'") |
|
| 55 | + ]); |
|
| 56 | 56 | |
| 57 | - DBConnectionFactory::getConnection()->query((string)$insertBuilder); |
|
| 58 | - } |
|
| 57 | + DBConnectionFactory::getConnection()->query((string)$insertBuilder); |
|
| 58 | + } |
|
| 59 | 59 | |
| 60 | - public static function log(int $databaseUserId, string $errorNumber, string $errorSeverity, string $errorMessage, string $errorObject=null) { |
|
| 60 | + public static function log(int $databaseUserId, string $errorNumber, string $errorSeverity, string $errorMessage, string $errorObject=null) { |
|
| 61 | 61 | |
| 62 | - } |
|
| 62 | + } |
|
| 63 | 63 | } |
@@ -19,50 +19,50 @@ |
||
| 19 | 19 | */ |
| 20 | 20 | class Constant |
| 21 | 21 | { |
| 22 | - /** |
|
| 23 | - * Events |
|
| 24 | - */ |
|
| 25 | - const EVENT_INSERT = 'EVENT: INSERT DML EVENT'; |
|
| 26 | - const EVENT_SELECT = 'EVENT: SELECT DML EVENT'; |
|
| 27 | - const EVENT_UPDATE = 'EVENT: UPDATE DML EVENT'; |
|
| 22 | + /** |
|
| 23 | + * Events |
|
| 24 | + */ |
|
| 25 | + const EVENT_INSERT = 'EVENT: INSERT DML EVENT'; |
|
| 26 | + const EVENT_SELECT = 'EVENT: SELECT DML EVENT'; |
|
| 27 | + const EVENT_UPDATE = 'EVENT: UPDATE DML EVENT'; |
|
| 28 | 28 | |
| 29 | - /** |
|
| 30 | - * @author Lucky Bardeson |
|
| 31 | - */ |
|
| 32 | - const EVENT_DELETE = 'EVENT: DELETE DML EVENT'; |
|
| 29 | + /** |
|
| 30 | + * @author Lucky Bardeson |
|
| 31 | + */ |
|
| 32 | + const EVENT_DELETE = 'EVENT: DELETE DML EVENT'; |
|
| 33 | 33 | |
| 34 | - /** |
|
| 35 | - * Error Numbers |
|
| 36 | - */ |
|
| 37 | - const ERROR_401 = 'ERROR_401: Resource Inaccessible'; |
|
| 38 | - const ERROR_402 = 'ERROR_402: Resource Requirements Not Met'; |
|
| 39 | - const ERROR_403 = 'ERROR_403: Resource Not Writable'; |
|
| 40 | - const ERROR_404 = 'ERROR_404: Resource Not Found'; |
|
| 34 | + /** |
|
| 35 | + * Error Numbers |
|
| 36 | + */ |
|
| 37 | + const ERROR_401 = 'ERROR_401: Resource Inaccessible'; |
|
| 38 | + const ERROR_402 = 'ERROR_402: Resource Requirements Not Met'; |
|
| 39 | + const ERROR_403 = 'ERROR_403: Resource Not Writable'; |
|
| 40 | + const ERROR_404 = 'ERROR_404: Resource Not Found'; |
|
| 41 | 41 | |
| 42 | - /** |
|
| 43 | - * Error Severities |
|
| 44 | - */ |
|
| 45 | - const ERROR_HIGH = 'ERROR_SEVERITY: HIGH'; |
|
| 46 | - const ERROR_LOW = 'ERROR_SEVERITY: LOW'; |
|
| 47 | - const ERROR_NORMAL = 'ERROR_SEVERITY: NORMAL'; |
|
| 42 | + /** |
|
| 43 | + * Error Severities |
|
| 44 | + */ |
|
| 45 | + const ERROR_HIGH = 'ERROR_SEVERITY: HIGH'; |
|
| 46 | + const ERROR_LOW = 'ERROR_SEVERITY: LOW'; |
|
| 47 | + const ERROR_NORMAL = 'ERROR_SEVERITY: NORMAL'; |
|
| 48 | 48 | |
| 49 | - /** |
|
| 50 | - * |
|
| 51 | - */ |
|
| 52 | - const UNDEFINED = 0; |
|
| 49 | + /** |
|
| 50 | + * |
|
| 51 | + */ |
|
| 52 | + const UNDEFINED = 0; |
|
| 53 | 53 | |
| 54 | - public static function getGlobals($config = "configs") { |
|
| 55 | - if (is_file("globals.json")){ |
|
| 56 | - $globalLoc = json_decode(file_get_contents("globals.json"), true); |
|
| 54 | + public static function getGlobals($config = "configs") { |
|
| 55 | + if (is_file("globals.json")){ |
|
| 56 | + $globalLoc = json_decode(file_get_contents("globals.json"), true); |
|
| 57 | 57 | |
| 58 | - if (isset($globalLoc["globals"])){ |
|
| 59 | - $file = $globalLoc["globals"].".json"; |
|
| 58 | + if (isset($globalLoc["globals"])){ |
|
| 59 | + $file = $globalLoc["globals"].".json"; |
|
| 60 | 60 | |
| 61 | - return json_decode(file_get_contents($file), true); |
|
| 62 | - } |
|
| 63 | - } |
|
| 61 | + return json_decode(file_get_contents($file), true); |
|
| 62 | + } |
|
| 63 | + } |
|
| 64 | 64 | |
| 65 | - throw new Exception\UndefinedValueException("No configuration data set.", 0); |
|
| 65 | + throw new Exception\UndefinedValueException("No configuration data set.", 0); |
|
| 66 | 66 | |
| 67 | - } |
|
| 67 | + } |
|
| 68 | 68 | } |
@@ -11,27 +11,27 @@ |
||
| 11 | 11 | use EmmetBlue\Core\Database\Abstraction\QueryBuilder; |
| 12 | 12 | |
| 13 | 13 | /** |
| 14 | - * class QueryBuilderTest. |
|
| 15 | - * |
|
| 16 | - * @author Samuel Adeshina <[email protected]> |
|
| 17 | - * |
|
| 18 | - * @since v0.0.1 27/05/2016 14:27 |
|
| 19 | - */ |
|
| 14 | + * class QueryBuilderTest. |
|
| 15 | + * |
|
| 16 | + * @author Samuel Adeshina <[email protected]> |
|
| 17 | + * |
|
| 18 | + * @since v0.0.1 27/05/2016 14:27 |
|
| 19 | + */ |
|
| 20 | 20 | class QueryBuilderTest extends \PHPUnit\Framework\TestCase |
| 21 | 21 | { |
| 22 | - public function testBuilderActuallyBuilding() |
|
| 23 | - { |
|
| 24 | - $queryBuilder = new QueryBuilder('INSERT INTO tbl_name'); |
|
| 25 | - $queryBuilder = $queryBuilder->build("VALUES ('tbl_col1', 'tbl_col2')"); |
|
| 22 | + public function testBuilderActuallyBuilding() |
|
| 23 | + { |
|
| 24 | + $queryBuilder = new QueryBuilder('INSERT INTO tbl_name'); |
|
| 25 | + $queryBuilder = $queryBuilder->build("VALUES ('tbl_col1', 'tbl_col2')"); |
|
| 26 | 26 | |
| 27 | - $builtQuery = (string) $queryBuilder; |
|
| 28 | - $expectedQuery = "INSERT INTO tbl_name VALUES ('tbl_col1', 'tbl_col2')"; |
|
| 27 | + $builtQuery = (string) $queryBuilder; |
|
| 28 | + $expectedQuery = "INSERT INTO tbl_name VALUES ('tbl_col1', 'tbl_col2')"; |
|
| 29 | 29 | |
| 30 | - $this->assertEquals($expectedQuery, $builtQuery); |
|
| 31 | - } |
|
| 30 | + $this->assertEquals($expectedQuery, $builtQuery); |
|
| 31 | + } |
|
| 32 | 32 | |
| 33 | - public function testWrapStringFunctionBehavesStatically() |
|
| 34 | - { |
|
| 35 | - $built = QueryBuilder::wrapString('Name', "'"); |
|
| 36 | - } |
|
| 33 | + public function testWrapStringFunctionBehavesStatically() |
|
| 34 | + { |
|
| 35 | + $built = QueryBuilder::wrapString('Name', "'"); |
|
| 36 | + } |
|
| 37 | 37 | } |