v1.0.1
AtheraStudio Database
- <?php
- declare(strict_types=1);
-
- namespace Athera;
-
- defined('ATHERA') || exit;
-
- use PDO;
-
- final class Db
- {
- public PDO $pdo;
- public string $user;
- public string $host;
- private ?string $versionCache = null;
-
- private function __construct(PDO $pdo, string $user, string $host)
- {
- $this->pdo = $pdo;
- $this->user = $user;
- $this->host = $host;
- }
-
- public static function connect(string $host, int $port, string $user, string $pass, string $db = ''): self
- {
- if (!extension_loaded('pdo_mysql')) throw new UserError('PHP extension pdo_mysql is not available', 500, 'no_pdo');
- $dsn = 'mysql:charset=utf8mb4';
- if (str_starts_with($host, '/')) $dsn .= ';unix_socket=' . $host;
- else $dsn .= ';host=' . $host . ($port > 0 ? ';port=' . $port : '');
- if ($db !== '') $dsn .= ';dbname=' . $db;
- $opts = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => true,
- PDO::ATTR_STRINGIFY_FETCHES => false,
- PDO::ATTR_TIMEOUT => 8,
- PDO::MYSQL_ATTR_LOCAL_INFILE => false,
- PDO::MYSQL_ATTR_MULTI_STATEMENTS => false,
- PDO::MYSQL_ATTR_FOUND_ROWS => true,
- ];
- if (Config::bool('DB_SSL')) {
- $ca = Config::get('DB_SSL_CA');
- if ($ca !== '' && is_file($ca)) $opts[PDO::MYSQL_ATTR_SSL_CA] = $ca;
- $opts[PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] = $ca !== '';
- }
- $pdo = new PDO($dsn, $user, $pass, $opts);
- $pdo->exec("SET NAMES utf8mb4");
- $pdo->exec("SET SESSION sql_mode = CONCAT_WS(',', @@SESSION.sql_mode, 'NO_ENGINE_SUBSTITUTION')");
- return new self($pdo, $user, $host);
- }
-
- public static function id(string $name): string
- {
- if ($name === '' || str_contains($name, "\0")) throw new UserError('Invalid identifier', 400, 'bad_ident');
- return '`' . str_replace('`', '``', $name) . '`';
- }
-
- public static function tid(string $db, string $table): string
- {
- return self::id($db) . '.' . self::id($table);
- }
-
- public function quote($v): string
- {
- if ($v === null) return 'NULL';
- if (is_bool($v)) return $v ? '1' : '0';
- if (is_int($v) || is_float($v)) return (string)$v;
- return (string)$this->pdo->quote((string)$v);
- }
-
- public function run(string $sql, array $params = []): \PDOStatement
- {
- if (!$params) return $this->pdo->query($sql);
- $st = $this->pdo->prepare($sql);
- $st->execute($params);
- return $st;
- }
-
- public function all(string $sql, array $params = []): array
- {
- return $this->run($sql, $params)->fetchAll(PDO::FETCH_ASSOC);
- }
-
- public function one(string $sql, array $params = []): ?array
- {
- $r = $this->run($sql, $params)->fetch(PDO::FETCH_ASSOC);
- return $r === false ? null : $r;
- }
-
- public function value(string $sql, array $params = [])
- {
- $r = $this->run($sql, $params)->fetchColumn();
- return $r === false ? null : $r;
- }
-
- public function column(string $sql, array $params = []): array
- {
- return $this->run($sql, $params)->fetchAll(PDO::FETCH_COLUMN);
- }
-
- public function exec(string $sql): int
- {
- return (int)$this->pdo->exec($sql);
- }
-
- public function buffered(bool $on): void
- {
- $this->pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $on);
- }
-
- public function version(): string
- {
- return $this->versionCache ??= (string)$this->value('SELECT VERSION()');
- }
-
- public function isMaria(): bool
- {
- return stripos($this->version(), 'mariadb') !== false;
- }
-
- public function useDb(string $db): void
- {
- if ($db !== '') $this->pdo->exec('USE ' . self::id($db));
- }
-
- public static function cell($v)
- {
- if (is_int($v)) return ($v > 9007199254740991 || $v < -9007199254740991) ? (string)$v : $v;
- if ($v === null || is_float($v)) return $v;
- $v = (string)$v;
- if (!mb_check_encoding($v, 'UTF-8') || preg_match('/[\x00-\x08\x0B\x0C\x0E-\x1F]/', $v)) {
- return ['$bin' => strlen($v), 'hex' => bin2hex(substr($v, 0, 48))];
- }
- if (strlen($v) > 65536) {
- return ['$long' => strlen($v), 'text' => mb_strcut($v, 0, 4096, 'UTF-8')];
- }
- return $v;
- }
-
- public static function error(\Throwable $e): string
- {
- $m = $e->getMessage();
- if ($e instanceof \PDOException) {
- $m = preg_replace('/^SQLSTATE\[[0-9A-Z]{5}\]:?\s*(<<Unknown error>>:?\s*)?/', '', $m);
- $m = preg_replace('/^[^:]{0,60}: (\d{4}) /', '#$1 ', $m);
- }
- return (string)$m;
- }
- }
-