70 lines
2.0 KiB
PHP
70 lines
2.0 KiB
PHP
<?php declare(strict_types=1);
|
|
namespace App\Repository;
|
|
|
|
error_reporting(error_level: E_ALL);
|
|
|
|
use App\Provider\DatabaseConnection;
|
|
use App\Controller\EncryptionController;
|
|
use PDO;
|
|
use PDOException;
|
|
|
|
/**
|
|
*
|
|
*/
|
|
readonly class SettingsRepository
|
|
{
|
|
public function __construct(private DatabaseConnection $databaseConnection, EncryptionController $encryptionController)
|
|
{}
|
|
|
|
public function findByName(string $name): string|bool
|
|
{
|
|
$sql = "
|
|
SELECT value
|
|
FROM " . DatabaseConnection::TABLE_SETTINGS . "
|
|
WHERE name = :name;
|
|
";
|
|
|
|
try {
|
|
$statement = $this->databaseConnection->getConnection()->prepare(query: $sql);
|
|
$statement->bindParam(param: ':name', var: $name);
|
|
$statement->execute();
|
|
if ($result = $statement->fetch(mode: PDO::FETCH_ASSOC)) {
|
|
return $result['value'];
|
|
} else {
|
|
return false;
|
|
}
|
|
} catch (PDOException $e) {
|
|
exit($e->getMessage());
|
|
}
|
|
}
|
|
|
|
public function set(string $name, string $value): int
|
|
{
|
|
$currentSetting = $this->findByName($name);
|
|
if ($currentSetting !== false) {
|
|
$sql = "
|
|
UPDATE " . DatabaseConnection::TABLE_SETTINGS . "
|
|
SET value = :value
|
|
WHERE name = :name
|
|
";
|
|
} else {
|
|
$sql = "
|
|
INSERT INTO " . DatabaseConnection::TABLE_SETTINGS . " (id, name, value)
|
|
VALUES (UUID(), :name, :value)
|
|
";
|
|
}
|
|
|
|
try {
|
|
$statement = $this->databaseConnection->getConnection()->prepare(query: $sql);
|
|
$statement->bindParam(param: ':name', var: $name);
|
|
$statement->bindParam(param: ':value', var: $value);
|
|
|
|
$statement->execute();
|
|
return intval(value: $this->databaseConnection->getConnection()->lastInsertId());
|
|
} catch (PDOException $e) {
|
|
exit($e->getMessage());
|
|
}
|
|
}
|
|
|
|
}
|