WebOrbiton
v1.0.1

AtheraStudio Database

150 lines · 4.7 KB
  1. <?php
  2. declare(strict_types=1);
  3. ​
  4. namespace Athera;
  5. ​
  6. defined('ATHERA') || exit;
  7. ​
  8. use PDO;
  9. ​
  10. final class Db
  11. {
  12. public PDO $pdo;
  13. public string $user;
  14. public string $host;
  15. private ?string $versionCache = null;
  16. ​
  17. private function __construct(PDO $pdo, string $user, string $host)
  18. {
  19. $this->pdo = $pdo;
  20. $this->user = $user;
  21. $this->host = $host;
  22. }
  23. ​
  24. public static function connect(string $host, int $port, string $user, string $pass, string $db = ''): self
  25. {
  26. if (!extension_loaded('pdo_mysql')) throw new UserError('PHP extension pdo_mysql is not available', 500, 'no_pdo');
  27. $dsn = 'mysql:charset=utf8mb4';
  28. if (str_starts_with($host, '/')) $dsn .= ';unix_socket=' . $host;
  29. else $dsn .= ';host=' . $host . ($port > 0 ? ';port=' . $port : '');
  30. if ($db !== '') $dsn .= ';dbname=' . $db;
  31. $opts = [
  32. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  33. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  34. PDO::ATTR_EMULATE_PREPARES => true,
  35. PDO::ATTR_STRINGIFY_FETCHES => false,
  36. PDO::ATTR_TIMEOUT => 8,
  37. PDO::MYSQL_ATTR_LOCAL_INFILE => false,
  38. PDO::MYSQL_ATTR_MULTI_STATEMENTS => false,
  39. PDO::MYSQL_ATTR_FOUND_ROWS => true,
  40. ];
  41. if (Config::bool('DB_SSL')) {
  42. $ca = Config::get('DB_SSL_CA');
  43. if ($ca !== '' && is_file($ca)) $opts[PDO::MYSQL_ATTR_SSL_CA] = $ca;
  44. $opts[PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] = $ca !== '';
  45. }
  46. $pdo = new PDO($dsn, $user, $pass, $opts);
  47. $pdo->exec("SET NAMES utf8mb4");
  48. $pdo->exec("SET SESSION sql_mode = CONCAT_WS(',', @@SESSION.sql_mode, 'NO_ENGINE_SUBSTITUTION')");
  49. return new self($pdo, $user, $host);
  50. }
  51. ​
  52. public static function id(string $name): string
  53. {
  54. if ($name === '' || str_contains($name, "\0")) throw new UserError('Invalid identifier', 400, 'bad_ident');
  55. return '`' . str_replace('`', '``', $name) . '`';
  56. }
  57. ​
  58. public static function tid(string $db, string $table): string
  59. {
  60. return self::id($db) . '.' . self::id($table);
  61. }
  62. ​
  63. public function quote($v): string
  64. {
  65. if ($v === null) return 'NULL';
  66. if (is_bool($v)) return $v ? '1' : '0';
  67. if (is_int($v) || is_float($v)) return (string)$v;
  68. return (string)$this->pdo->quote((string)$v);
  69. }
  70. ​
  71. public function run(string $sql, array $params = []): \PDOStatement
  72. {
  73. if (!$params) return $this->pdo->query($sql);
  74. $st = $this->pdo->prepare($sql);
  75. $st->execute($params);
  76. return $st;
  77. }
  78. ​
  79. public function all(string $sql, array $params = []): array
  80. {
  81. return $this->run($sql, $params)->fetchAll(PDO::FETCH_ASSOC);
  82. }
  83. ​
  84. public function one(string $sql, array $params = []): ?array
  85. {
  86. $r = $this->run($sql, $params)->fetch(PDO::FETCH_ASSOC);
  87. return $r === false ? null : $r;
  88. }
  89. ​
  90. public function value(string $sql, array $params = [])
  91. {
  92. $r = $this->run($sql, $params)->fetchColumn();
  93. return $r === false ? null : $r;
  94. }
  95. ​
  96. public function column(string $sql, array $params = []): array
  97. {
  98. return $this->run($sql, $params)->fetchAll(PDO::FETCH_COLUMN);
  99. }
  100. ​
  101. public function exec(string $sql): int
  102. {
  103. return (int)$this->pdo->exec($sql);
  104. }
  105. ​
  106. public function buffered(bool $on): void
  107. {
  108. $this->pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $on);
  109. }
  110. ​
  111. public function version(): string
  112. {
  113. return $this->versionCache ??= (string)$this->value('SELECT VERSION()');
  114. }
  115. ​
  116. public function isMaria(): bool
  117. {
  118. return stripos($this->version(), 'mariadb') !== false;
  119. }
  120. ​
  121. public function useDb(string $db): void
  122. {
  123. if ($db !== '') $this->pdo->exec('USE ' . self::id($db));
  124. }
  125. ​
  126. public static function cell($v)
  127. {
  128. if (is_int($v)) return ($v > 9007199254740991 || $v < -9007199254740991) ? (string)$v : $v;
  129. if ($v === null || is_float($v)) return $v;
  130. $v = (string)$v;
  131. if (!mb_check_encoding($v, 'UTF-8') || preg_match('/[\x00-\x08\x0B\x0C\x0E-\x1F]/', $v)) {
  132. return ['$bin' => strlen($v), 'hex' => bin2hex(substr($v, 0, 48))];
  133. }
  134. if (strlen($v) > 65536) {
  135. return ['$long' => strlen($v), 'text' => mb_strcut($v, 0, 4096, 'UTF-8')];
  136. }
  137. return $v;
  138. }
  139. ​
  140. public static function error(\Throwable $e): string
  141. {
  142. $m = $e->getMessage();
  143. if ($e instanceof \PDOException) {
  144. $m = preg_replace('/^SQLSTATE\[[0-9A-Z]{5}\]:?\s*(<<Unknown error>>:?\s*)?/', '', $m);
  145. $m = preg_replace('/^[^:]{0,60}: (\d{4}) /', '#$1 ', $m);
  146. }
  147. return (string)$m;
  148. }
  149. }
  150. ​