v1.5.0
AtheraStudio Code
- (window.Athera = window.Athera || {}).mysqlShim = "<?php\n\nfinal class AthMy\n{\n const ID = '(?:`[^`]+`|[A-Za-z_\\x80-\\xff][\\w$\\x80-\\xff]*)';\n const NOOP = 'SELECT 1 WHERE 0';\n const OPT = \"\\0\";\n\n public static $dir = '/tmp/athera-mysql';\n public static $root = '/www';\n public static $db = 'default';\n public static $report = 3;\n public static $dump = null;\n public static $problems = [];\n private static $likeCache = [];\n\n public static function unescape(string $e): string\n {\n switch ($e) {\n case 'n': return \"\\n\";\n case 'r': return \"\\r\";\n case 't': return \"\\t\";\n case '0': return \"\\0\";\n case 'Z': return \"\\x1a\";\n case 'b': return \"\\x08\";\n case '%': return '\\\\%';\n case '_': return '\\\\_';\n }\n return $e;\n }\n\n public static function mask(string $sql, array &$lits): string\n {\n $re = '~\\'((?:[^\\'\\\\\\\\]|\\\\\\\\.|\\'\\')*)\\'|\"((?:[^\"\\\\\\\\]|\\\\\\\\.|\"\")*)\"|(`[^`]*`)|(--(?:[ \\t\\r\\n]|$)[^\\n]*)|(#[^\\n]*)|(/\\*.*?\\*/)~s';\n return preg_replace_callback($re, function ($m) use (&$lits) {\n if ($m[1] !== null) {\n $q = \"'\";\n $v = $m[1];\n } elseif ($m[2] !== null) {\n $q = '\"';\n $v = $m[2];\n } elseif ($m[3] !== null) {\n return $m[3];\n } else {\n return ' ';\n }\n $v = preg_replace_callback('~\\\\\\\\(.)|\\'\\'|\"\"~s', function ($x) use ($q) {\n if ($x[0][0] === '\\\\') return AthMy::unescape($x[1]);\n return $x[0] === $q . $q ? $q : $x[0];\n }, $v);\n $lits[] = $v;\n return \"\\x01\" . (count($lits) - 1) . \"\\x02\";\n }, $sql, -1, $count, PREG_UNMATCHED_AS_NULL);\n }\n\n public static function unmask(string $s, array $lits): string\n {\n if (strpos($s, \"\\x01\") === false) return $s;\n return preg_replace_callback('~\\x01(\\d+)\\x02~', function ($m) use ($lits) {\n return \"'\" . str_replace(\"'\", \"''\", $lits[(int)$m[1]]) . \"'\";\n }, $s);\n }\n\n public static function splitSql(string $masked): array\n {\n $out = [];\n foreach (preg_split('~`[^`]*`(*SKIP)(*FAIL)|;~', $masked) as $part) {\n $part = trim($part);\n if ($part !== '') $out[] = $part;\n }\n return $out;\n }\n\n public static function splitTop(string $s, string $sep = ','): array\n {\n $out = [];\n $cur = '';\n $depth = 0;\n $n = strlen($s);\n for ($i = 0; $i < $n; $i++) {\n $c = $s[$i];\n if ($c === '`') {\n $j = strpos($s, '`', $i + 1);\n if ($j === false) $j = $n - 1;\n $cur .= substr($s, $i, $j - $i + 1);\n $i = $j;\n continue;\n }\n if ($c === '(') $depth++;\n elseif ($c === ')') $depth--;\n if ($c === $sep && $depth === 0) {\n $out[] = $cur;\n $cur = '';\n continue;\n }\n $cur .= $c;\n }\n $out[] = $cur;\n return $out;\n }\n\n public static function unq(string $id): string\n {\n return trim($id, '`');\n }\n\n public static function quote(string $name): string\n {\n return '\"' . str_replace('\"', '\"\"', $name) . '\"';\n }\n\n public static function isQuery(string $sql): bool\n {\n $lits = [];\n $m = ltrim(self::mask(substr($sql, 0, 400), $lits), \" \\t\\r\\n(\");\n return (bool)preg_match('/^(SELECT|SHOW|DESCRIBE|DESC|EXPLAIN|WITH|VALUES|TABLE|PRAGMA)\\b/i', $m);\n }\n\n public static function kind(string $sql): string\n {\n $lits = [];\n $m = ltrim(self::mask(substr($sql, 0, 400), $lits), \" \\t\\r\\n(\");\n return preg_match('/^([A-Za-z]+)/', $m, $w) ? strtoupper($w[1]) : '';\n }\n\n public static function translate(string $sql): array\n {\n $lits = [];\n $masked = self::mask($sql, $lits);\n $out = [];\n foreach (self::splitSql($masked) as $stmt) {\n foreach (self::convert($stmt) as $one) {\n $out[] = self::unmask($one, $lits);\n }\n }\n return $out;\n }\n\n public static function convert(string $s): array\n {\n $s = trim($s);\n if ($s === '') return [];\n preg_match('/^\\(*\\s*([A-Za-z_]+)/', $s, $w);\n $word = isset($w[1]) ? strtoupper($w[1]) : '';\n switch ($word) {\n case 'SET':\n return self::convertSet($s);\n case 'USE':\n case 'LOCK':\n case 'UNLOCK':\n case 'FLUSH':\n case 'OPTIMIZE':\n case 'ANALYZE':\n case 'REPAIR':\n case 'CHECK':\n case 'GRANT':\n case 'REVOKE':\n case 'KILL':\n case 'DELIMITER':\n case 'COMMENT':\n return [self::NOOP];\n case 'START':\n return ['BEGIN'];\n case 'CREATE':\n if (preg_match('/^CREATE\\s+(?:DATABASE|SCHEMA|USER|ROLE)\\b/i', $s)) return [self::NOOP];\n if (preg_match('/^CREATE\\s+(?:TEMPORARY\\s+)?TABLE\\b/i', $s)) return self::createTable($s);\n if (preg_match('/^CREATE\\s+(?:UNIQUE\\s+|FULLTEXT\\s+|SPATIAL\\s+)?INDEX\\b/i', $s)) return self::createIndex($s);\n if (preg_match('/^CREATE\\s+(?:OR\\s+REPLACE\\s+)?(?:ALGORITHM\\s*=\\s*\\w+\\s+)?(?:DEFINER\\s*=\\s*\\S+\\s+)?(?:SQL\\s+SECURITY\\s+\\w+\\s+)?VIEW\\b/i', $s)) {\n $s = preg_replace('/^CREATE\\s+(?:OR\\s+REPLACE\\s+)?(?:ALGORITHM\\s*=\\s*\\w+\\s+)?(?:DEFINER\\s*=\\s*\\S+\\s+)?(?:SQL\\s+SECURITY\\s+\\w+\\s+)?VIEW/i', 'CREATE VIEW', $s);\n return [self::dml($s)];\n }\n return [$s];\n case 'DROP':\n if (preg_match('/^DROP\\s+(?:DATABASE|SCHEMA|USER|ROLE)\\b/i', $s)) return [self::NOOP];\n if (preg_match('/^DROP\\s+(?:TEMPORARY\\s+)?TABLE\\b/i', $s)) return self::dropTable($s);\n if (preg_match('/^DROP\\s+INDEX\\b/i', $s)) return self::dropIndex($s);\n return [self::dml($s)];\n case 'ALTER':\n return self::alterTable($s);\n case 'TRUNCATE':\n return self::truncate($s);\n case 'RENAME':\n return self::renameTable($s);\n case 'SHOW':\n case 'DESCRIBE':\n case 'DESC':\n return self::show($s);\n case 'EXPLAIN':\n if (preg_match('/^EXPLAIN\\s+(?:SELECT|INSERT|UPDATE|DELETE|REPLACE|WITH|FORMAT|ANALYZE)\\b/i', $s)) {\n return ['EXPLAIN QUERY PLAN ' . self::dml(preg_replace('/^EXPLAIN\\s+(?:(?:FORMAT|EXTENDED|PARTITIONS)\\s*(?:=\\s*\\w+)?\\s+)?/i', '', $s))];\n }\n return self::show($s);\n }\n return [self::dml($s)];\n }\n\n public static function convertSet(string $s): array\n {\n if (preg_match('/^SET\\s+(?:@@(?:SESSION\\.|GLOBAL\\.)?|SESSION\\s+|GLOBAL\\s+)?FOREIGN_KEY_CHECKS\\s*=\\s*(\\w+)/i', $s, $m)) {\n return ['PRAGMA foreign_keys = ' . (in_array(strtoupper($m[1]), ['0', 'OFF', 'FALSE'], true) ? 'OFF' : 'ON')];\n }\n return [self::NOOP];\n }\n\n public static function cleanCols(string $cols): string\n {\n return trim(preg_replace('/\\(\\s*\\d+\\s*\\)/', '', $cols));\n }\n\n public static function indexName(string $table, ?string $name, string $cols): string\n {\n if ($name === null || $name === '') {\n $first = trim(explode(',', $cols)[0]);\n $first = preg_replace('/\\s+(ASC|DESC)$/i', '', $first);\n $name = preg_replace('/[^\\w]+/', '_', self::unq($first));\n }\n return self::quote(self::unq($table) . '_' . self::unq($name));\n }\n\n public static function tableName(string $q, ?string $t): string\n {\n return ($t !== null && $t !== '') ? $t : $q;\n }\n\n public static function parseColumn(string $name, string $rest): array\n {\n $auto = (bool)preg_match('/\\bAUTO_INCREMENT\\b/i', $rest);\n $rest = preg_replace('/\\bAUTO_INCREMENT\\b/i', '', $rest);\n $type = 'NUM';\n $text = false;\n $after = $rest;\n if (preg_match('/^\\s*([A-Za-z]+)(?:\\s+VARYING)?(\\s*\\(([^)]*)\\))?/', $rest, $t)) {\n $base = strtoupper($t[1]);\n $args = isset($t[3]) ? $t[3] : '';\n $after = substr($rest, strlen($t[0]));\n if ($base === 'ENUM' || $base === 'SET' || $base === 'JSON') {\n $type = 'TEXT';\n $text = true;\n } elseif (in_array($base, ['CHAR', 'VARCHAR', 'NCHAR', 'NVARCHAR', 'CHARACTER', 'TINYTEXT', 'TEXT', 'MEDIUMTEXT', 'LONGTEXT'], true)) {\n $type = $base . ($args !== '' ? '(' . $args . ')' : '');\n $text = true;\n } else {\n $type = $base . ($args !== '' ? '(' . $args . ')' : '');\n }\n }\n $after = preg_replace('/\\b(?:UNSIGNED|ZEROFILL|SIGNED)\\b/i', '', $after);\n $after = preg_replace('/\\b(?:CHARACTER\\s+SET|CHAR\\s+SET|CHARSET)\\s+\\w+/i', '', $after);\n $binary = false;\n if (preg_match('/\\bCOLLATE\\s+(\\w+)/i', $after, $c)) {\n $binary = stripos($c[1], 'bin') !== false;\n $after = preg_replace('/\\bCOLLATE\\s+\\w+/i', '', $after);\n }\n $after = preg_replace('/\\bCOMMENT\\s+\\x01\\d+\\x02/i', '', $after);\n $after = preg_replace('/\\bON\\s+UPDATE\\s+(?:CURRENT_TIMESTAMP|NOW|LOCALTIME(?:STAMP)?)\\s*(?:\\(\\s*\\d*\\s*\\))?/i', '', $after);\n $after = preg_replace('/\\bDEFAULT\\s+(?:CURRENT_TIMESTAMP|NOW|LOCALTIME(?:STAMP)?)\\s*(?:\\(\\s*\\d*\\s*\\))?/i', 'DEFAULT (now())', $after);\n $after = preg_replace('/\\bUNIQUE\\s+KEY\\b/i', 'UNIQUE', $after);\n $after = preg_replace('/\\b(?:VISIBLE|INVISIBLE)\\b/i', '', $after);\n $attrs = trim(preg_replace('/\\s+/', ' ', $after));\n if ($text && !$binary) $attrs = trim($attrs . ' COLLATE NOCASE');\n return ['name' => $name, 'type' => $type, 'attrs' => $attrs, 'auto' => $auto];\n }\n\n public static function parseCreate(string $s): ?array\n {\n $I = self::ID;\n if (!preg_match('/^CREATE\\s+(TEMPORARY\\s+)?TABLE\\s+(IF\\s+NOT\\s+EXISTS\\s+)?(' . $I . ')(?:\\s*\\.\\s*(' . $I . '))?\\s*\\(/is', $s, $m, PREG_OFFSET_CAPTURE)) return null;\n $name = (isset($m[4]) && $m[4][0] !== '') ? $m[4][0] : $m[3][0];\n $open = $m[0][1] + strlen($m[0][0]) - 1;\n $n = strlen($s);\n $depth = 0;\n $close = null;\n for ($i = $open; $i < $n; $i++) {\n $c = $s[$i];\n if ($c === '`') {\n $j = strpos($s, '`', $i + 1);\n if ($j === false) return null;\n $i = $j;\n continue;\n }\n if ($c === '(') $depth++;\n elseif ($c === ')') {\n $depth--;\n if ($depth === 0) {\n $close = $i;\n break;\n }\n }\n }\n if ($close === null) return null;\n $st = [\n 'temp' => trim($m[1][0]) !== '',\n 'ine' => trim($m[2][0]) !== '',\n 'name' => $name,\n 'cols' => [],\n 'pk' => [],\n 'uniq' => [],\n 'idx' => [],\n 'fks' => [],\n 'checks' => [],\n 'seq' => null\n ];\n if (preg_match('/\\bAUTO_INCREMENT\\s*=\\s*(\\d+)/i', substr($s, $close + 1), $q)) $st['seq'] = (int)$q[1];\n foreach (self::splitTop(substr($s, $open + 1, $close - $open - 1)) as $part) {\n $part = trim($part);\n if ($part === '') continue;\n if (preg_match('/^(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?PRIMARY\\s+KEY\\s*(?:USING\\s+\\w+\\s*)?\\((.*)\\)/is', $part, $x)) {\n $st['pk'] = array_map('trim', explode(',', self::cleanCols($x[1])));\n } elseif (preg_match('/^(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?UNIQUE(?:\\s+(?:KEY|INDEX))?\\s*(?:' . $I . ')?\\s*(?:USING\\s+\\w+\\s*)?\\((.*)\\)/is', $part, $x)) {\n $st['uniq'][] = self::cleanCols($x[1]);\n } elseif (preg_match('/^(?:FULLTEXT\\s+|SPATIAL\\s+)?(?:KEY|INDEX)\\s*(' . $I . ')?\\s*(?:USING\\s+\\w+\\s*)?\\((.*)\\)/is', $part, $x)) {\n $st['idx'][] = ['name' => $x[1] !== '' ? $x[1] : null, 'cols' => self::cleanCols($x[2]), 'unique' => false];\n } elseif (preg_match('/^(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?FOREIGN\\s+KEY/i', $part)) {\n $st['fks'][] = preg_replace('/FOREIGN\\s+KEY\\s+(?!\\()' . $I . '\\s*/i', 'FOREIGN KEY ', $part);\n } elseif (preg_match('/^(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?CHECK\\b/i', $part)) {\n $st['checks'][] = $part;\n } elseif (preg_match('/^(' . $I . ')\\s+(.*)$/s', $part, $x)) {\n $st['cols'][] = self::parseColumn($x[1], $x[2]);\n }\n }\n return $st;\n }\n\n public static function buildCreate(array $st): array\n {\n $lines = [];\n $auto = false;\n foreach ($st['cols'] as $c) {\n if ($c['auto']) {\n $auto = true;\n $lines[] = $c['name'] . ' INTEGER PRIMARY KEY AUTOINCREMENT';\n } else {\n $lines[] = trim($c['name'] . ' ' . $c['type'] . ' ' . $c['attrs']);\n }\n }\n if ($st['pk'] && !$auto) $lines[] = 'PRIMARY KEY (' . implode(', ', $st['pk']) . ')';\n foreach ($st['uniq'] as $u) $lines[] = 'UNIQUE (' . $u . ')';\n foreach ($st['fks'] as $f) $lines[] = $f;\n foreach ($st['checks'] as $f) $lines[] = $f;\n $out = ['CREATE ' . ($st['temp'] ? 'TEMPORARY ' : '') . 'TABLE ' . ($st['ine'] ? 'IF NOT EXISTS ' : '') . $st['name'] . \" (\\n \" . implode(\",\\n \", $lines) . \"\\n)\"];\n foreach ($st['idx'] as $i) {\n $out[] = 'CREATE ' . ($i['unique'] ? 'UNIQUE ' : '') . 'INDEX IF NOT EXISTS ' . self::indexName($st['name'], $i['name'], $i['cols']) . ' ON ' . $st['name'] . ' (' . $i['cols'] . ')';\n }\n return $out;\n }\n\n public static function createTable(string $s): array\n {\n $st = self::parseCreate($s);\n if ($st === null) {\n $s = preg_replace('/^CREATE\\s+(TEMPORARY\\s+)?TABLE\\s+(IF\\s+NOT\\s+EXISTS\\s+)?(' . self::ID . ')\\s*\\.\\s*(' . self::ID . ')/i', 'CREATE $1TABLE $2$4', $s);\n if (preg_match('/^(CREATE\\s+(?:TEMPORARY\\s+)?TABLE\\s+(?:IF\\s+NOT\\s+EXISTS\\s+)?' . self::ID . ')\\s+LIKE\\s+(' . self::ID . ')(?:\\s*\\.\\s*(' . self::ID . '))?/i', $s, $m)) {\n $src = (isset($m[3]) && $m[3] !== '') ? $m[3] : $m[2];\n return [$m[1] . ' AS SELECT * FROM ' . $src . ' WHERE 0'];\n }\n return [self::dml($s)];\n }\n return self::buildCreate($st);\n }\n\n public static function createIndex(string $s): array\n {\n $I = self::ID;\n if (!preg_match('/^CREATE\\s+(UNIQUE\\s+)?(?:FULLTEXT\\s+|SPATIAL\\s+)?INDEX\\s+(IF\\s+NOT\\s+EXISTS\\s+)?(' . $I . ')\\s*(?:USING\\s+\\w+\\s*)?ON\\s+(' . $I . ')(?:\\s*\\.\\s*(' . $I . '))?\\s*\\((.*?)\\)\\s*(?:USING\\s+\\w+)?\\s*$/is', $s, $m)) return [self::NOOP];\n $table = (isset($m[5]) && $m[5] !== '') ? $m[5] : $m[4];\n $cols = self::cleanCols($m[6]);\n return ['CREATE ' . (trim($m[1]) !== '' ? 'UNIQUE ' : '') . 'INDEX IF NOT EXISTS ' . self::indexName($table, $m[3], $cols) . ' ON ' . $table . ' (' . $cols . ')'];\n }\n\n public static function dropTable(string $s): array\n {\n $I = self::ID;\n if (!preg_match('/^DROP\\s+(?:TEMPORARY\\s+)?TABLE\\s+(IF\\s+EXISTS\\s+)?(.*?)(?:\\s+(?:RESTRICT|CASCADE))?\\s*$/is', $s, $m)) return [$s];\n $out = [];\n foreach (explode(',', $m[2]) as $t) {\n $t = trim($t);\n if (!preg_match('/^(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')$/', $t, $x)) continue;\n $out[] = 'DROP TABLE ' . (trim($m[1]) !== '' ? 'IF EXISTS ' : '') . $x[1];\n }\n return $out ?: [self::NOOP];\n }\n\n public static function dropIndex(string $s): array\n {\n $I = self::ID;\n if (!preg_match('/^DROP\\s+INDEX\\s+(' . $I . ')\\s+ON\\s+(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')/i', $s, $m)) return [$s];\n return ['DROP INDEX IF EXISTS ' . self::indexName($m[2], $m[1], '')];\n }\n\n public static function truncate(string $s): array\n {\n $I = self::ID;\n if (!preg_match('/^TRUNCATE\\s+(?:TABLE\\s+)?(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')/i', $s, $m)) return [self::NOOP];\n return ['DELETE FROM ' . $m[1], self::OPT . \"DELETE FROM sqlite_sequence WHERE name = '\" . str_replace(\"'\", \"''\", self::unq($m[1])) . \"'\"];\n }\n\n public static function renameTable(string $s): array\n {\n $I = self::ID;\n if (!preg_match('/^RENAME\\s+TABLE\\s+(.*)$/is', $s, $m)) return [self::NOOP];\n $out = [];\n foreach (explode(',', $m[1]) as $pair) {\n if (preg_match('/^\\s*(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')\\s+TO\\s+(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')\\s*$/i', $pair, $x)) {\n $out[] = 'ALTER TABLE ' . $x[1] . ' RENAME TO ' . $x[2];\n }\n }\n return $out ?: [self::NOOP];\n }\n\n public static function alterTable(string $s): array\n {\n $I = self::ID;\n if (!preg_match('/^ALTER\\s+(?:IGNORE\\s+)?TABLE\\s+(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')\\s+(.*)$/is', $s, $m)) return [self::NOOP];\n $out = [];\n foreach (self::splitTop($m[2]) as $clause) {\n foreach (self::alterClause($m[1], trim($clause)) as $q) $out[] = $q;\n }\n return $out ?: [self::NOOP];\n }\n\n public static function alterClause(string $t, string $c): array\n {\n $I = self::ID;\n if (preg_match('/^ADD\\s+(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?PRIMARY\\s+KEY/i', $c)) return [];\n if (preg_match('/^ADD\\s+(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?FOREIGN\\s+KEY/i', $c)) return [];\n if (preg_match('/^ADD\\s+(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?(UNIQUE\\s+)?(?:FULLTEXT\\s+|SPATIAL\\s+)?(?:(?:KEY|INDEX)\\s*|(?=UNIQUE))(?:UNIQUE\\s*)?(?:(?:KEY|INDEX)\\s*)?(' . $I . ')?\\s*(?:USING\\s+\\w+\\s*)?\\((.*)\\)\\s*(?:USING\\s+\\w+)?$/is', $c, $m)) {\n $cols = self::cleanCols($m[3]);\n $name = $m[2] !== '' ? $m[2] : null;\n return ['CREATE ' . (trim($m[1]) !== '' ? 'UNIQUE ' : '') . 'INDEX IF NOT EXISTS ' . self::indexName($t, $name, $cols) . ' ON ' . $t . ' (' . $cols . ')'];\n }\n if (preg_match('/^ADD\\s+UNIQUE\\s*(?:(?:KEY|INDEX)\\s*)?(' . $I . ')?\\s*\\((.*)\\)/is', $c, $m)) {\n $cols = self::cleanCols($m[2]);\n return ['CREATE UNIQUE INDEX IF NOT EXISTS ' . self::indexName($t, $m[1] !== '' ? $m[1] : null, $cols) . ' ON ' . $t . ' (' . $cols . ')'];\n }\n if (preg_match('/^ADD\\s+(?:COLUMN\\s+)?(' . $I . ')\\s+(.+)$/is', $c, $m) && !preg_match('/^(?:INDEX|KEY|UNIQUE|PRIMARY|FOREIGN|CONSTRAINT|FULLTEXT|SPATIAL|CHECK)$/i', $m[1])) {\n $rest = preg_replace('/\\s+(?:AFTER\\s+' . $I . '|FIRST)\\s*$/i', '', $m[2]);\n $col = self::parseColumn($m[1], $rest);\n $attrs = preg_replace('/\\bDEFAULT\\s+\\(now\\(\\)\\)/i', '', $col['attrs']);\n $attrs = preg_replace('/\\b(?:PRIMARY\\s+KEY|UNIQUE)\\b/i', '', $attrs);\n if (preg_match('/\\bNOT\\s+NULL\\b/i', $attrs) && !preg_match('/\\bDEFAULT\\b/i', $attrs)) {\n $attrs .= preg_match('/^(?:CHAR|VARCHAR|NCHAR|NVARCHAR|CHARACTER|TINYTEXT|TEXT|MEDIUMTEXT|LONGTEXT)/i', $col['type']) || $col['type'] === 'TEXT' ? \" DEFAULT ''\" : ' DEFAULT 0';\n }\n return ['ALTER TABLE ' . $t . ' ADD COLUMN ' . trim($col['name'] . ' ' . $col['type'] . ' ' . trim($attrs))];\n }\n if (preg_match('/^DROP\\s+(?:COLUMN\\s+)?(' . $I . ')\\s*$/i', $c, $m) && !preg_match('/^(?:PRIMARY|INDEX|KEY|FOREIGN|CONSTRAINT|CHECK)$/i', $m[1])) {\n return ['ALTER TABLE ' . $t . ' DROP COLUMN ' . $m[1]];\n }\n if (preg_match('/^DROP\\s+(?:INDEX|KEY)\\s+(' . $I . ')/i', $c, $m)) return ['DROP INDEX IF EXISTS ' . self::indexName($t, $m[1], '')];\n if (preg_match('/^CHANGE\\s+(?:COLUMN\\s+)?(' . $I . ')\\s+(' . $I . ')\\s/i', $c, $m)) {\n if (self::unq($m[1]) !== self::unq($m[2])) return ['ALTER TABLE ' . $t . ' RENAME COLUMN ' . $m[1] . ' TO ' . $m[2]];\n return [];\n }\n if (preg_match('/^RENAME\\s+COLUMN\\s+(' . $I . ')\\s+TO\\s+(' . $I . ')/i', $c, $m)) return ['ALTER TABLE ' . $t . ' RENAME COLUMN ' . $m[1] . ' TO ' . $m[2]];\n if (preg_match('/^RENAME\\s+(?:TO\\s+|AS\\s+)?(' . $I . ')\\s*$/i', $c, $m) && !preg_match('/^(?:INDEX|KEY|COLUMN)$/i', $m[1])) return ['ALTER TABLE ' . $t . ' RENAME TO ' . $m[1]];\n return [];\n }\n\n public static function mergeAlter(array &$st, string $clauses): bool\n {\n $I = self::ID;\n foreach (self::splitTop($clauses) as $c) {\n $c = trim($c);\n if ($c === '') continue;\n if (preg_match('/^ADD\\s+(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?PRIMARY\\s+KEY\\s*(?:USING\\s+\\w+\\s*)?\\((.*)\\)/is', $c, $m)) {\n $st['pk'] = array_map('trim', explode(',', self::cleanCols($m[1])));\n } elseif (preg_match('/^ADD\\s+(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?UNIQUE\\s*(?:(?:KEY|INDEX)\\s*)?(?:' . $I . ')?\\s*(?:USING\\s+\\w+\\s*)?\\((.*)\\)/is', $c, $m)) {\n $st['uniq'][] = self::cleanCols($m[1]);\n } elseif (preg_match('/^ADD\\s+(?:FULLTEXT\\s+|SPATIAL\\s+)?(?:KEY|INDEX)\\s*(' . $I . ')?\\s*(?:USING\\s+\\w+\\s*)?\\((.*)\\)/is', $c, $m)) {\n $st['idx'][] = ['name' => $m[1] !== '' ? $m[1] : null, 'cols' => self::cleanCols($m[2]), 'unique' => false];\n } elseif (preg_match('/^ADD\\s+(?:CONSTRAINT\\s+(?:' . $I . '\\s+)?)?FOREIGN\\s+KEY/i', $c)) {\n $st['fks'][] = preg_replace('/^ADD\\s+/i', '', preg_replace('/FOREIGN\\s+KEY\\s+(?!\\()' . $I . '\\s*/i', 'FOREIGN KEY ', $c));\n } elseif (preg_match('/^MODIFY\\s+(?:COLUMN\\s+)?(' . $I . ')\\s+(.*)$/is', $c, $m)) {\n $col = self::parseColumn($m[1], $m[2]);\n foreach ($st['cols'] as $k => $existing) {\n if (self::unq($existing['name']) === self::unq($m[1])) $st['cols'][$k] = $col;\n }\n } elseif (preg_match('/^CHANGE\\s+(?:COLUMN\\s+)?(' . $I . ')\\s+(' . $I . ')\\s+(.*)$/is', $c, $m)) {\n $col = self::parseColumn($m[2], $m[3]);\n foreach ($st['cols'] as $k => $existing) {\n if (self::unq($existing['name']) === self::unq($m[1])) $st['cols'][$k] = $col;\n }\n } elseif (preg_match('/^(?:ENGINE|DEFAULT|CHARSET|CHARACTER|COLLATE|COMMENT|ROW_FORMAT|CONVERT)\\b/i', $c)) {\n continue;\n } elseif (preg_match('/^AUTO_INCREMENT\\s*=?\\s*(\\d+)/i', $c, $m)) {\n $st['seq'] = (int)$m[1];\n } else {\n return false;\n }\n }\n return true;\n }\n\n public static function show(string $s): array\n {\n $I = self::ID;\n $db = str_replace(\"'\", \"''\", self::$db);\n $skip = \"type IN ('table','view') AND substr(name,1,7) <> 'sqlite_'\";\n $empty = 'SELECT NULL AS \"Variable_name\", NULL AS \"Value\" WHERE 0';\n if (preg_match('/^SHOW\\s+(FULL\\s+)?TABLES\\b(?:\\s+(?:FROM|IN)\\s+' . $I . ')?(?:\\s+LIKE\\s+(\\x01\\d+\\x02))?/i', $s, $m)) {\n $like = (isset($m[2]) && $m[2] !== '') ? ' AND name LIKE ' . $m[2] : '';\n $extra = (isset($m[1]) && trim($m[1]) !== '') ? \", CASE type WHEN 'view' THEN 'VIEW' ELSE 'BASE TABLE' END AS \\\"Table_type\\\"\" : '';\n return ['SELECT name AS \"Tables_in_' . str_replace('\"', '', self::$db) . '\"' . $extra . ' FROM sqlite_master WHERE ' . $skip . $like . ' ORDER BY name'];\n }\n if (preg_match('/^SHOW\\s+TABLE\\s+STATUS\\b/i', $s)) {\n return ['SELECT name AS \"Name\", \\'InnoDB\\' AS \"Engine\", 0 AS \"Rows\" FROM sqlite_master WHERE ' . $skip . ' ORDER BY name'];\n }\n if (preg_match('/^SHOW\\s+(?:DATABASES|SCHEMAS)\\b/i', $s)) {\n return [\"SELECT '\" . $db . \"' AS \\\"Database\\\"\"];\n }\n if (preg_match('/^SHOW\\s+CREATE\\s+TABLE\\s+(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')/i', $s, $m)) {\n $t = str_replace(\"'\", \"''\", self::unq($m[1]));\n return [\"SELECT name AS \\\"Table\\\", sql AS \\\"Create Table\\\" FROM sqlite_master WHERE type = 'table' AND name = '\" . $t . \"'\"];\n }\n if (preg_match('/^SHOW\\s+(?:INDEX|INDEXES|KEYS)\\s+(?:FROM|IN)\\s+(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')/i', $s, $m)) {\n $t = str_replace(\"'\", \"''\", self::unq($m[1]));\n return [\"SELECT '\" . $t . \"' AS \\\"Table\\\", CASE il.\\\"unique\\\" WHEN 1 THEN 0 ELSE 1 END AS \\\"Non_unique\\\", il.name AS \\\"Key_name\\\", ii.seqno + 1 AS \\\"Seq_in_index\\\", ii.name AS \\\"Column_name\\\" FROM pragma_index_list('\" . $t . \"') il, pragma_index_info(il.name) ii\"];\n }\n if (preg_match('/^(?:SHOW\\s+(?:FULL\\s+)?(?:COLUMNS|FIELDS)\\s+(?:FROM|IN)|DESCRIBE|DESC|EXPLAIN)\\s+(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')(?:\\s+(?:FROM|IN)\\s+' . $I . ')?(?:\\s+LIKE\\s+(\\x01\\d+\\x02))?/i', $s, $m)) {\n $t = str_replace(\"'\", \"''\", self::unq($m[1]));\n $like = (isset($m[2]) && $m[2] !== '') ? ' WHERE p.name LIKE ' . $m[2] : '';\n return [\"SELECT p.name AS \\\"Field\\\", lower(p.type) AS \\\"Type\\\", CASE WHEN p.\\\"notnull\\\" = 1 OR p.pk > 0 THEN 'NO' ELSE 'YES' END AS \\\"Null\\\", CASE WHEN p.pk > 0 THEN 'PRI' ELSE '' END AS \\\"Key\\\", CASE WHEN substr(p.dflt_value, 1, 1) = '''' THEN substr(p.dflt_value, 2, length(p.dflt_value) - 2) ELSE p.dflt_value END AS \\\"Default\\\", CASE WHEN p.pk > 0 AND (SELECT instr(sql, 'AUTOINCREMENT') FROM sqlite_master WHERE name = '\" . $t . \"') > 0 THEN 'auto_increment' ELSE '' END AS \\\"Extra\\\" FROM pragma_table_info('\" . $t . \"') p\" . $like];\n }\n return [$empty];\n }\n\n public static function dml(string $s): string\n {\n $I = self::ID;\n $db = str_replace(\"'\", \"''\", self::$db);\n if (stripos($s, 'information_schema') !== false) {\n $s = preg_replace_callback('/\\binformation_schema\\s*\\.\\s*`?(\\w+)`?/i', function ($m) use ($db) {\n switch (strtolower($m[1])) {\n case 'tables':\n return \"(SELECT '$db' AS table_catalog, '$db' AS table_schema, name AS table_name, CASE type WHEN 'view' THEN 'VIEW' ELSE 'BASE TABLE' END AS table_type, 'InnoDB' AS engine, 0 AS table_rows FROM sqlite_master WHERE type IN ('table','view') AND substr(name,1,7) <> 'sqlite_')\";\n case 'columns':\n return \"(SELECT '$db' AS table_catalog, '$db' AS table_schema, m.name AS table_name, p.name AS column_name, p.cid + 1 AS ordinal_position, p.dflt_value AS column_default, CASE p.\\\"notnull\\\" WHEN 1 THEN 'NO' ELSE 'YES' END AS is_nullable, lower(p.type) AS data_type, lower(p.type) AS column_type, CASE WHEN p.pk > 0 THEN 'PRI' ELSE '' END AS column_key FROM sqlite_master m, pragma_table_info(m.name) p WHERE m.type IN ('table','view') AND substr(m.name,1,7) <> 'sqlite_')\";\n case 'schemata':\n return \"(SELECT '$db' AS schema_name, 'utf8mb4' AS default_character_set_name)\";\n }\n return '(SELECT NULL AS table_schema, NULL AS table_name WHERE 0)';\n }, $s);\n }\n $s = preg_replace('/\\b(FROM|JOIN|INTO|UPDATE|TABLE)\\s+(' . $I . ')\\s*\\.\\s*(' . $I . ')/i', '$1 $3', $s);\n\n if (preg_match('/^(INSERT\\s+(?:IGNORE\\s+)?INTO\\s+' . $I . ')\\s+SET\\s+(.+?)(\\s+ON\\s+DUPLICATE\\s+KEY\\s+UPDATE\\b.*)?$/is', $s, $m)) {\n $cols = [];\n $vals = [];\n foreach (self::splitTop($m[2]) as $a) {\n if (!preg_match('/^\\s*(' . $I . ')\\s*=\\s*(.+)$/s', $a, $x)) {\n $cols = [];\n break;\n }\n $cols[] = $x[1];\n $vals[] = trim($x[2]);\n }\n if ($cols) $s = $m[1] . ' (' . implode(', ', $cols) . ') VALUES (' . implode(', ', $vals) . ')' . (isset($m[3]) ? $m[3] : '');\n }\n\n if (preg_match('/^DELETE\\s+FROM\\s+(' . $I . ')(\\s+.*?)?\\s+LIMIT\\s+(\\d+|\\?|:\\w+)\\s*$/is', $s, $m) && !preg_match('/\\bJOIN\\b/i', $s)) {\n $s = 'DELETE FROM ' . $m[1] . ' WHERE rowid IN (SELECT rowid FROM ' . $m[1] . (isset($m[2]) ? $m[2] : '') . ' LIMIT ' . $m[3] . ')';\n } elseif (preg_match('/^UPDATE\\s+(?:IGNORE\\s+)?(' . $I . ')\\s+SET\\s+(.*?)((?:\\s+WHERE\\s+.*?)?(?:\\s+ORDER\\s+BY\\s+.*?)?)\\s+LIMIT\\s+(\\d+|\\?|:\\w+)\\s*$/is', $s, $m) && !preg_match('/\\bJOIN\\b/i', $s)) {\n $s = 'UPDATE ' . $m[1] . ' SET ' . $m[2] . ' WHERE rowid IN (SELECT rowid FROM ' . $m[1] . $m[3] . ' LIMIT ' . $m[4] . ')';\n }\n\n $s = preg_replace('/^INSERT\\s+(?:LOW_PRIORITY\\s+|DELAYED\\s+|HIGH_PRIORITY\\s+)*IGNORE\\b/i', 'INSERT OR IGNORE', $s);\n $s = preg_replace('/^UPDATE\\s+(?:LOW_PRIORITY\\s+)?IGNORE\\b/i', 'UPDATE OR IGNORE', $s);\n $s = preg_replace('/\\b(?:SQL_CALC_FOUND_ROWS|SQL_NO_CACHE|SQL_CACHE|SQL_SMALL_RESULT|SQL_BIG_RESULT|SQL_BUFFER_RESULT|HIGH_PRIORITY|LOW_PRIORITY|DELAYED)\\b/i', '', $s);\n $s = preg_replace('/\\bSTRAIGHT_JOIN\\b/i', 'JOIN', $s);\n $s = preg_replace('/\\s+(?:FOR\\s+(?:UPDATE|SHARE)|LOCK\\s+IN\\s+SHARE\\s+MODE)(?:\\s+(?:NOWAIT|SKIP\\s+LOCKED))?\\s*$/i', '', $s);\n $s = preg_replace('/\\b(?:USE|FORCE|IGNORE)\\s+(?:INDEX|KEY)\\s*(?:FOR\\s+\\w+(?:\\s+BY)?\\s*)?\\([^)]*\\)/i', '', $s);\n $s = preg_replace('/\\bFROM\\s+DUAL\\b/i', '', $s);\n if (preg_match('/^INSERT\\b/i', $s)) $s = preg_replace('/(?<![\\w`])DEFAULT(?=\\s*[,)])/i', 'NULL', $s);\n\n if (stripos($s, 'ON DUPLICATE') !== false) {\n $s = preg_replace_callback('/^(.*?)\\bON\\s+DUPLICATE\\s+KEY\\s+UPDATE\\b(.*)$/is', function ($m) use ($I) {\n $tail = preg_replace('/\\bVALUES\\s*\\(\\s*(' . $I . ')\\s*\\)/i', 'excluded.$1', $m[2]);\n return $m[1] . 'ON CONFLICT DO UPDATE SET' . $tail;\n }, $s);\n }\n\n $unit = 'MICROSECOND|SECOND|MINUTE|HOUR|DAY|WEEK|MONTH|QUARTER|YEAR';\n if (stripos($s, 'INTERVAL') !== false) {\n $s = preg_replace_callback('/\\b(DATE_ADD|ADDDATE|DATE_SUB|SUBDATE)\\s*\\(\\s*(.+?)\\s*,\\s*INTERVAL\\s+(.+?)\\s+(' . $unit . ')\\s*\\)/is', function ($m) {\n return 'ath_date_add(' . $m[2] . ', ' . $m[3] . \", '\" . strtoupper($m[4]) . \"', \" . (stripos($m[1], 'ADD') !== false ? '1' : '-1') . ')';\n }, $s);\n $left = '(\\bNOW\\s*\\(\\s*\\)|\\bCURRENT_TIMESTAMP\\b(?:\\s*\\(\\s*\\d*\\s*\\))?|\\bCURDATE\\s*\\(\\s*\\)|\\bCURRENT_DATE\\b(?:\\s*\\(\\s*\\))?|' . $I . '(?:\\s*\\.\\s*' . $I . ')?|\\x01\\d+\\x02)';\n $num = '(-?\\d+(?:\\.\\d+)?|\\x01\\d+\\x02|\\?|:\\w+|' . $I . '(?:\\.' . $I . ')?)';\n $s = preg_replace_callback('/' . $left . '\\s*([+-])\\s*INTERVAL\\s+' . $num . '\\s+(' . $unit . ')\\b/i', function ($m) {\n return 'ath_date_add(' . $m[1] . ', ' . $m[3] . \", '\" . strtoupper($m[4]) . \"', \" . ($m[2] === '+' ? '1' : '-1') . ')';\n }, $s);\n }\n if (stripos($s, 'TIMESTAMPDIFF') !== false) $s = preg_replace('/\\bTIMESTAMPDIFF\\s*\\(\\s*(\\w+)\\s*,/i', \"timestampdiff('$1',\", $s);\n if (stripos($s, 'SEPARATOR') !== false) {\n $s = preg_replace_callback('/\\bGROUP_CONCAT\\s*\\(\\s*(DISTINCT\\s+)?(.+?)(\\s+ORDER\\s+BY\\s+.+?)?\\s+SEPARATOR\\s+(\\x01\\d+\\x02)\\s*\\)/is', function ($m) {\n if (trim($m[1]) !== '') return 'group_concat(DISTINCT ' . $m[2] . ')';\n return 'group_concat(' . $m[2] . ', ' . $m[4] . $m[3] . ')';\n }, $s);\n }\n if (stripos($s, 'CAST') !== false || stripos($s, ' AS ') !== false) {\n $s = preg_replace('/\\bCAST\\s*\\(\\s*([^()]+?)\\s+AS\\s+DATETIME\\s*\\)/i', 'datetime($1)', $s);\n $s = preg_replace('/\\bCAST\\s*\\(\\s*([^()]+?)\\s+AS\\s+DATE\\s*\\)/i', 'date($1)', $s);\n $s = preg_replace('/\\bAS\\s+(?:UNSIGNED|SIGNED)(?:\\s+INTEGER)?\\b/i', 'AS INTEGER', $s);\n $s = preg_replace('/\\bAS\\s+(?:CHAR|NCHAR|BINARY)(?:\\s*\\(\\s*\\d+\\s*\\))?(?=\\s*\\))/i', 'AS TEXT', $s);\n }\n $s = preg_replace('/\\bLAST_INSERT_ID\\s*\\(\\s*\\)/i', 'last_insert_rowid()', $s);\n $s = preg_replace('/\\bROW_COUNT\\s*\\(\\s*\\)/i', 'changes()', $s);\n $s = preg_replace('/\\bGREATEST\\s*\\(/i', 'max(', $s);\n $s = preg_replace('/\\bLEAST\\s*\\(/i', 'min(', $s);\n $s = preg_replace('/\\b(?:CURRENT_TIMESTAMP|LOCALTIMESTAMP|LOCALTIME)\\b(?:\\s*\\(\\s*\\d*\\s*\\))?/i', 'now()', $s);\n $s = preg_replace('/\\bCURRENT_DATE\\b(?:\\s*\\(\\s*\\))?/i', 'curdate()', $s);\n $s = preg_replace('/\\bCURRENT_TIME\\b(?:\\s*\\(\\s*\\d*\\s*\\))?/i', 'curtime()', $s);\n $s = str_replace('<=>', ' IS ', $s);\n $s = preg_replace('/\\bDIV\\b/i', '/', $s);\n $s = preg_replace('/\\bMOD\\b(?!\\s*\\()/i', '%', $s);\n $s = preg_replace('/\\bRLIKE\\b/i', 'REGEXP', $s);\n if (stripos($s, 'BINARY') !== false) {\n $s = preg_replace('/\\bBINARY\\s+(' . $I . '(?:\\s*\\.\\s*' . $I . ')?|\\x01\\d+\\x02|\\?)/i', '$1 COLLATE BINARY', $s);\n }\n return trim($s);\n }\n\n public static function runList(AthPDO $pdo, array $list): int\n {\n $n = 0;\n foreach ($list as $q) {\n if ($q !== '' && $q[0] === self::OPT) {\n try {\n $pdo->rawExec(substr($q, 1));\n } catch (Throwable $e) {\n }\n continue;\n }\n $r = $pdo->rawExec($q);\n $n = $r === false ? 0 : $r;\n }\n return $n;\n }\n\n public static function escape(string $s): string\n {\n return strtr($s, [\"\\0\" => '\\\\0', \"\\n\" => '\\\\n', \"\\r\" => '\\\\r', '\\\\' => '\\\\\\\\', \"'\" => \"\\\\'\", '\"' => '\\\\\"', \"\\x1a\" => '\\\\Z']);\n }\n\n public static function mysqlError(string $msg): array\n {\n $db = self::$db;\n if (preg_match('/no such table:\\s*(?:\\w+\\.)?(\\S+)/i', $msg, $m)) {\n return [1146, '42S02', \"Table '$db.\" . $m[1] . \"' doesn't exist\", 'Base table or view not found'];\n }\n if (preg_match('/no such column:\\s*(\\S+)/i', $msg, $m) || preg_match('/table \\S+ has no column named (\\S+)/i', $msg, $m)) {\n return [1054, '42S22', \"Unknown column '\" . $m[1] . \"' in 'field list'\", 'Column not found'];\n }\n if (preg_match('/UNIQUE constraint failed:\\s*(\\S+)/i', $msg, $m)) {\n return [1062, '23000', \"Duplicate entry for key '\" . $m[1] . \"'\", 'Integrity constraint violation'];\n }\n if (preg_match('/NOT NULL constraint failed:\\s*(?:\\w+\\.)?(\\S+)/i', $msg, $m)) {\n return [1048, '23000', \"Column '\" . $m[1] . \"' cannot be null\", 'Integrity constraint violation'];\n }\n if (stripos($msg, 'FOREIGN KEY constraint failed') !== false) {\n return [1452, '23000', 'Cannot add or update a child row: a foreign key constraint fails', 'Integrity constraint violation'];\n }\n if (preg_match('/table (\\S+) already exists/i', $msg, $m)) {\n return [1050, '42S01', \"Table '\" . trim($m[1], '\"`') . \"' already exists\", 'Base table or view already exists'];\n }\n if (preg_match('/no such function:\\s*(\\S+)/i', $msg, $m)) {\n return [1305, '42000', \"FUNCTION $db.\" . $m[1] . ' does not exist', 'Syntax error or access violation'];\n }\n if (preg_match('/near \"([^\"]*)\"/', $msg, $m) || stripos($msg, 'syntax error') !== false || stripos($msg, 'incomplete input') !== false) {\n $near = isset($m[1]) ? $m[1] : '';\n return [1064, '42000', \"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$near' at line 1\", 'Syntax error or access violation'];\n }\n return [1105, 'HY000', 'Unknown error: ' . $msg, 'General error'];\n }\n\n public static function mapPdo(PDOException $e): PDOException\n {\n if (isset($e->errorInfo[1]) && (int)$e->errorInfo[1] >= 1000) return $e;\n if (!preg_match('/^SQLSTATE\\[[^\\]]*\\]:[^:]*:\\s*\\d+\\s+(.*)$/s', $e->getMessage(), $m)) return $e;\n list($no, $state, $text, $label) = self::mysqlError($m[1]);\n $e->errorInfo = [$state, $no, $text];\n (new ReflectionProperty('Exception', 'message'))->setValue($e, \"SQLSTATE[$state]: $label: $no $text\");\n (new ReflectionProperty('Exception', 'code'))->setValue($e, $state);\n return $e;\n }\n\n public static function dt($v): ?DateTimeImmutable\n {\n if ($v === null || $v === '') return null;\n $v = (string)$v;\n if (strpos($v, '0000-00-00') === 0) return null;\n try {\n return new DateTimeImmutable($v);\n } catch (Throwable $e) {\n return null;\n }\n }\n\n public static function fmt($v, $f): ?string\n {\n $d = self::dt($v);\n if ($d === null || $f === null) return null;\n $f = (string)$f;\n $map = ['Y' => 'Y', 'y' => 'y', 'm' => 'm', 'c' => 'n', 'd' => 'd', 'e' => 'j', 'H' => 'H', 'k' => 'G', 'h' => 'h', 'I' => 'h', 'l' => 'g', 'i' => 'i', 's' => 's', 'S' => 's', 'p' => 'A', 'M' => 'F', 'b' => 'M', 'W' => 'l', 'a' => 'D', 'w' => 'w', 'T' => 'H:i:s', 'r' => 'h:i:s A', 'u' => 'W'];\n $out = '';\n $n = strlen($f);\n for ($i = 0; $i < $n; $i++) {\n $c = $f[$i];\n if ($c !== '%' || $i + 1 >= $n) {\n $out .= $c;\n continue;\n }\n $x = $f[++$i];\n if ($x === 'j') $out .= str_pad((string)((int)$d->format('z') + 1), 3, '0', STR_PAD_LEFT);\n elseif ($x === 'f') $out .= '000000';\n elseif ($x === '%') $out .= '%';\n elseif (isset($map[$x])) $out .= $d->format($map[$x]);\n else $out .= $x;\n }\n return $out;\n }\n\n public static function dateAdd($v, $n, $unit, $sign = 1)\n {\n $d = self::dt($v);\n if ($d === null || $n === null) return null;\n $n = (int)round((float)$n) * (int)$sign;\n $unit = strtoupper((string)$unit);\n $time = (bool)preg_match('/\\d:\\d/', (string)$v) || in_array($unit, ['SECOND', 'MINUTE', 'HOUR', 'MICROSECOND'], true);\n if ($unit === 'MONTH' || $unit === 'QUARTER' || $unit === 'YEAR') {\n $months = $unit === 'YEAR' ? $n * 12 : ($unit === 'QUARTER' ? $n * 3 : $n);\n $total = (int)$d->format('Y') * 12 + ((int)$d->format('n') - 1) + $months;\n $y = intdiv($total, 12);\n $m = $total % 12 + 1;\n $last = (int)(new DateTimeImmutable(sprintf('%04d-%02d-01', $y, $m)))->format('t');\n $d = $d->setDate($y, $m, min((int)$d->format('j'), $last));\n } elseif ($unit === 'WEEK') {\n $d = $d->modify(($n * 7) . ' days');\n } elseif ($unit === 'DAY') {\n $d = $d->modify($n . ' days');\n } elseif ($unit === 'HOUR') {\n $d = $d->modify($n . ' hours');\n } elseif ($unit === 'MINUTE') {\n $d = $d->modify($n . ' minutes');\n } elseif ($unit === 'SECOND') {\n $d = $d->modify($n . ' seconds');\n }\n return $d->format($time ? 'Y-m-d H:i:s' : 'Y-m-d');\n }\n\n public static function tsDiff($unit, $a, $b)\n {\n $x = self::dt($a);\n $y = self::dt($b);\n if ($x === null || $y === null) return null;\n $unit = strtoupper((string)$unit);\n $secs = $y->getTimestamp() - $x->getTimestamp();\n $div = ['SECOND' => 1, 'MINUTE' => 60, 'HOUR' => 3600, 'DAY' => 86400, 'WEEK' => 604800];\n if (isset($div[$unit])) return (int)($secs / $div[$unit]);\n $i = $x->diff($y);\n $months = ($i->y * 12 + $i->m) * ($i->invert ? -1 : 1);\n if ($unit === 'YEAR') return intdiv($months, 12);\n if ($unit === 'QUARTER') return intdiv($months, 3);\n return $months;\n }\n\n public static function strToDate($str, $fmt)\n {\n if ($str === null || $fmt === null) return null;\n $re = '';\n $order = [];\n $f = (string)$fmt;\n $map = ['Y' => '(\\d{4})', 'y' => '(\\d{2})', 'm' => '(\\d{1,2})', 'c' => '(\\d{1,2})', 'd' => '(\\d{1,2})', 'e' => '(\\d{1,2})', 'H' => '(\\d{1,2})', 'k' => '(\\d{1,2})', 'h' => '(\\d{1,2})', 'I' => '(\\d{1,2})', 'i' => '(\\d{1,2})', 's' => '(\\d{1,2})', 'S' => '(\\d{1,2})', 'p' => '([AaPp][Mm])'];\n for ($i = 0, $n = strlen($f); $i < $n; $i++) {\n if ($f[$i] === '%' && $i + 1 < $n) {\n $x = $f[++$i];\n if (isset($map[$x])) {\n $re .= $map[$x];\n $order[] = $x;\n } else {\n $re .= preg_quote($x, '~');\n }\n } else {\n $re .= preg_quote($f[$i], '~');\n }\n }\n if (!preg_match('~^\\s*' . $re . '~', (string)$str, $m)) return null;\n $p = ['Y' => 1970, 'm' => 1, 'd' => 1, 'H' => 0, 'i' => 0, 's' => 0];\n $pm = null;\n foreach ($order as $k => $x) {\n $v = $m[$k + 1];\n if ($x === 'Y') $p['Y'] = (int)$v;\n elseif ($x === 'y') $p['Y'] = (int)$v + ((int)$v < 70 ? 2000 : 1900);\n elseif ($x === 'm' || $x === 'c') $p['m'] = (int)$v;\n elseif ($x === 'd' || $x === 'e') $p['d'] = (int)$v;\n elseif ($x === 'H' || $x === 'k' || $x === 'h' || $x === 'I') $p['H'] = (int)$v;\n elseif ($x === 'i') $p['i'] = (int)$v;\n elseif ($x === 's' || $x === 'S') $p['s'] = (int)$v;\n elseif ($x === 'p') $pm = strtoupper($v);\n }\n if ($pm === 'PM' && $p['H'] < 12) $p['H'] += 12;\n if ($pm === 'AM' && $p['H'] === 12) $p['H'] = 0;\n $hasTime = (bool)array_intersect($order, ['H', 'k', 'h', 'I', 'i', 's', 'S']);\n $date = sprintf('%04d-%02d-%02d', $p['Y'], $p['m'], $p['d']);\n return $hasTime ? $date . sprintf(' %02d:%02d:%02d', $p['H'], $p['i'], $p['s']) : $date;\n }\n\n public static function register(PDO $pdo): void\n {\n $f = function ($name, $fn, $n = -1) use ($pdo) {\n $pdo->sqliteCreateFunction($name, $fn, $n);\n };\n $str = function ($v) {\n return $v === null ? null : (string)$v;\n };\n\n $pdo->sqliteCreateCollation('NOCASE', function ($a, $b) {\n return strcmp(mb_strtolower((string)$a), mb_strtolower((string)$b));\n });\n\n $f('like', function ($p, $s, $e = null) {\n if ($p === null || $s === null) return null;\n $e = ($e === null || $e === '') ? '\\\\' : (string)$e;\n $key = $p . \"\\0\" . $e;\n if (!isset(self::$likeCache[$key])) {\n if (count(self::$likeCache) > 500) self::$likeCache = [];\n $chars = preg_split('//u', (string)$p, -1, PREG_SPLIT_NO_EMPTY);\n if ($chars === false) $chars = str_split((string)$p);\n $re = '';\n for ($i = 0, $n = count($chars); $i < $n; $i++) {\n $c = $chars[$i];\n if ($c === $e && $i + 1 < $n) $re .= preg_quote($chars[++$i], '~');\n elseif ($c === '%') $re .= '.*';\n elseif ($c === '_') $re .= '.';\n else $re .= preg_quote($c, '~');\n }\n self::$likeCache[$key] = '~^' . $re . '$~isu';\n }\n $r = @preg_match(self::$likeCache[$key], (string)$s);\n if ($r === false) $r = @preg_match(substr(self::$likeCache[$key], 0, -1), (string)$s);\n return $r ? 1 : 0;\n });\n $f('regexp', function ($p, $s) {\n if ($p === null || $s === null) return null;\n return @preg_match('~' . str_replace('~', '\\\\~', (string)$p) . '~iu', (string)$s) ? 1 : 0;\n }, 2);\n\n foreach (['upper', 'ucase'] as $n) $f($n, function ($s) use ($str) { return $s === null ? null : mb_strtoupper((string)$s); }, 1);\n foreach (['lower', 'lcase'] as $n) $f($n, function ($s) use ($str) { return $s === null ? null : mb_strtolower((string)$s); }, 1);\n foreach (['char_length', 'character_length'] as $n) $f($n, function ($s) { return $s === null ? null : mb_strlen((string)$s); }, 1);\n\n $f('concat', function (...$a) {\n $o = '';\n foreach ($a as $v) {\n if ($v === null) return null;\n $o .= $v;\n }\n return $o;\n });\n $f('concat_ws', function ($sep, ...$a) {\n if ($sep === null) return null;\n $p = [];\n foreach ($a as $v) if ($v !== null) $p[] = $v;\n return implode((string)$sep, $p);\n });\n $f('left', function ($s, $n) { return $s === null ? null : mb_substr((string)$s, 0, max(0, (int)$n)); }, 2);\n $f('right', function ($s, $n) { return $s === null ? null : ((int)$n <= 0 ? '' : mb_substr((string)$s, -(int)$n)); }, 2);\n $f('lpad', function ($s, $n, $p) {\n if ($s === null || $n === null || $p === null) return null;\n $s = (string)$s;\n $len = mb_strlen($s);\n $n = (int)$n;\n if ($n <= $len) return mb_substr($s, 0, $n);\n if ($p === '') return null;\n $pad = '';\n while (mb_strlen($pad) < $n - $len) $pad .= $p;\n return mb_substr($pad, 0, $n - $len) . $s;\n }, 3);\n $f('rpad', function ($s, $n, $p) {\n if ($s === null || $n === null || $p === null) return null;\n $s = (string)$s;\n $len = mb_strlen($s);\n $n = (int)$n;\n if ($n <= $len) return mb_substr($s, 0, $n);\n if ($p === '') return null;\n $pad = '';\n while (mb_strlen($pad) < $n - $len) $pad .= $p;\n return $s . mb_substr($pad, 0, $n - $len);\n }, 3);\n $f('locate', function ($sub, $s, $pos = 1) {\n if ($sub === null || $s === null) return null;\n $r = mb_stripos((string)$s, (string)$sub, max(0, (int)$pos - 1));\n return $r === false ? 0 : $r + 1;\n });\n $f('find_in_set', function ($a, $list) {\n if ($a === null || $list === null) return null;\n $i = array_search(mb_strtolower((string)$a), array_map('mb_strtolower', explode(',', (string)$list)), true);\n return $i === false ? 0 : $i + 1;\n }, 2);\n $f('substring_index', function ($s, $d, $c) {\n if ($s === null || $d === null || $c === null) return null;\n $parts = explode((string)$d, (string)$s);\n $c = (int)$c;\n if ($c >= 0) return implode((string)$d, array_slice($parts, 0, $c));\n return implode((string)$d, array_slice($parts, $c));\n }, 3);\n $f('reverse', function ($s) { return $s === null ? null : implode('', array_reverse(preg_split('//u', (string)$s, -1, PREG_SPLIT_NO_EMPTY))); }, 1);\n $f('repeat', function ($s, $n) { return $s === null ? null : str_repeat((string)$s, max(0, (int)$n)); }, 2);\n $f('space', function ($n) { return str_repeat(' ', max(0, (int)$n)); }, 1);\n $f('strcmp', function ($a, $b) { return $a === null || $b === null ? null : (strcmp((string)$a, (string)$b) <=> 0); }, 2);\n $f('format', function ($n, $d = 0) { return $n === null ? null : number_format((float)$n, max(0, (int)$d), '.', ','); });\n $f('field', function ($v, ...$list) {\n foreach ($list as $i => $x) if ((string)$x === (string)$v) return $i + 1;\n return 0;\n });\n $f('isnull', function ($v) { return $v === null ? 1 : 0; }, 1);\n $f('any_value', function ($v) { return $v; }, 1);\n $f('truncate', function ($x, $d) {\n if ($x === null) return null;\n $m = pow(10, (int)$d);\n return ($x < 0 ? ceil($x * $m) : floor($x * $m)) / $m;\n }, 2);\n\n $f('md5', function ($s) { return $s === null ? null : md5((string)$s); }, 1);\n $f('sha1', function ($s) { return $s === null ? null : sha1((string)$s); }, 1);\n $f('sha2', function ($s, $b = 256) {\n $algo = [0 => 'sha256', 224 => 'sha224', 256 => 'sha256', 384 => 'sha384', 512 => 'sha512'][(int)$b] ?? null;\n return ($s === null || $algo === null) ? null : hash($algo, (string)$s);\n });\n $f('uuid', function () {\n $b = random_bytes(16);\n $b[6] = chr(ord($b[6]) & 0x0f | 0x40);\n $b[8] = chr(ord($b[8]) & 0x3f | 0x80);\n return vsprintf('%s%s-%s-%s-%s-%s%s%s', str_split(bin2hex($b), 4));\n }, 0);\n $f('rand', function ($seed = null) { return mt_rand() / mt_getrandmax(); });\n $f('database', function () { return self::$db; }, 0);\n $f('schema', function () { return self::$db; }, 0);\n $f('version', function () { return '8.0.36-athera'; }, 0);\n $f('user', function () { return 'root@localhost'; }, 0);\n $f('current_user', function () { return 'root@localhost'; }, 0);\n $f('connection_id', function () { return 1; }, 0);\n\n $f('now', function () { return date('Y-m-d H:i:s'); }, 0);\n $f('sysdate', function () { return date('Y-m-d H:i:s'); }, 0);\n $f('utc_timestamp', function () { return gmdate('Y-m-d H:i:s'); }, 0);\n $f('curdate', function () { return date('Y-m-d'); }, 0);\n $f('utc_date', function () { return gmdate('Y-m-d'); }, 0);\n $f('curtime', function () { return date('H:i:s'); }, 0);\n $f('unix_timestamp', function ($v = null) {\n if ($v === null) return time();\n $d = self::dt($v);\n return $d === null ? null : $d->getTimestamp();\n });\n $f('from_unixtime', function ($ts, $fmt = null) {\n if ($ts === null) return null;\n $d = date('Y-m-d H:i:s', (int)$ts);\n return $fmt === null ? $d : self::fmt($d, $fmt);\n });\n $f('date_format', function ($d, $fmt) { return self::fmt($d, $fmt); }, 2);\n $f('str_to_date', function ($s, $fmt) { return self::strToDate($s, $fmt); }, 2);\n $f('ath_date_add', function ($d, $n, $u, $s = 1) { return self::dateAdd($d, $n, $u, $s); });\n $f('timestampdiff', function ($u, $a, $b) { return self::tsDiff($u, $a, $b); }, 3);\n $f('datediff', function ($a, $b) {\n $x = self::dt($a);\n $y = self::dt($b);\n if ($x === null || $y === null) return null;\n return (int)round(($x->setTime(0, 0)->getTimestamp() - $y->setTime(0, 0)->getTimestamp()) / 86400);\n }, 2);\n $parts = [\n 'year' => 'Y', 'month' => 'n', 'day' => 'j', 'dayofmonth' => 'j', 'hour' => 'G', 'minute' => 'i', 'second' => 's',\n 'dayofyear' => 'z', 'weekday' => 'N', 'dayofweek' => 'w', 'quarter' => 'n', 'week' => 'W'\n ];\n foreach ($parts as $name => $code) {\n $f($name, function ($v) use ($name, $code) {\n $d = self::dt($v);\n if ($d === null) return null;\n $x = (int)$d->format($code);\n if ($name === 'dayofyear') return $x + 1;\n if ($name === 'weekday') return $x - 1;\n if ($name === 'dayofweek') return $x + 1;\n if ($name === 'quarter') return (int)ceil($x / 3);\n return $x;\n }, 1);\n }\n $f('monthname', function ($v) { $d = self::dt($v); return $d === null ? null : $d->format('F'); }, 1);\n $f('dayname', function ($v) { $d = self::dt($v); return $d === null ? null : $d->format('l'); }, 1);\n $f('last_day', function ($v) { $d = self::dt($v); return $d === null ? null : $d->format('Y-m-t'); }, 1);\n }\n\n public static function findDump(string $db): ?string\n {\n $found = [];\n foreach (['', 'sql', 'db', 'database', 'databases', 'data', 'dump', 'dumps', 'backup', 'backups', 'schema', 'install'] as $d) {\n $p = self::$root . ($d === '' ? '' : '/' . $d);\n if (!is_dir($p)) continue;\n foreach (glob($p . '/*.sql') ?: [] as $file) $found[] = $file;\n }\n foreach ($found as $file) {\n if (strcasecmp(basename($file, '.sql'), $db) === 0) return $file;\n }\n return count($found) === 1 ? $found[0] : null;\n }\n\n public static function dbFile(string $db, &$fresh): string\n {\n if (!is_dir(self::$dir)) @mkdir(self::$dir, 0777, true);\n $name = preg_replace('/[^\\w.\\-]+/', '_', $db);\n if ($name === null || $name === '') $name = 'default';\n $file = self::$dir . '/' . $name . '.sqlite';\n $sigFile = self::$dir . '/' . $name . '.sig';\n $dump = self::findDump($db);\n self::$dump = $dump;\n $sig = $dump !== null ? $dump . ':' . filemtime($dump) . ':' . filesize($dump) : '';\n $fresh = !is_file($file);\n if (!$fresh) {\n $old = is_file($sigFile) ? (string)file_get_contents($sigFile) : '';\n if ($old !== $sig) {\n @unlink($file);\n $fresh = true;\n }\n }\n if ($fresh) file_put_contents($sigFile, $sig);\n return $file;\n }\n\n public static function splitDump(string $masked): array\n {\n $out = [];\n $delim = ';';\n $pos = 0;\n $add = function ($seg) use (&$out, &$delim) {\n $parts = $delim === ';' ? preg_split('~`[^`]*`(*SKIP)(*FAIL)|;~', $seg) : explode($delim, $seg);\n foreach ($parts as $p) {\n $p = trim($p);\n if ($p !== '') $out[] = $p;\n }\n };\n while (preg_match('~^[ \\t]*DELIMITER[ \\t]+(\\S+)[ \\t]*$~mi', $masked, $m, PREG_OFFSET_CAPTURE, $pos)) {\n $add(substr($masked, $pos, $m[0][1] - $pos));\n $delim = $m[1][0];\n $pos = $m[0][1] + strlen($m[0][0]);\n }\n $add(substr($masked, $pos));\n return $out;\n }\n\n public static function importDump(AthPDO $pdo, string $sql, string $label): void\n {\n $I = self::ID;\n $lits = [];\n $masked = self::mask($sql, $lits);\n $tables = [];\n $plan = [];\n foreach (self::splitDump($masked) as $s) {\n if (preg_match('/^CREATE\\s+(?:TEMPORARY\\s+)?TABLE\\b/i', $s)) {\n $st = self::parseCreate($s);\n if ($st !== null) {\n $key = strtolower(self::unq($st['name']));\n $tables[$key] = $st;\n $plan[] = ['t', $key];\n continue;\n }\n }\n if (preg_match('/^ALTER\\s+(?:IGNORE\\s+)?TABLE\\s+(?:' . $I . '\\s*\\.\\s*)?(' . $I . ')\\s+(.*)$/is', $s, $m)) {\n $key = strtolower(self::unq($m[1]));\n if (isset($tables[$key]) && self::mergeAlter($tables[$key], $m[2])) continue;\n }\n $plan[] = ['s', $s];\n }\n $pdo->rawExec('PRAGMA foreign_keys = OFF');\n $pdo->rawExec('BEGIN');\n $done = 0;\n $failed = 0;\n $skipped = 0;\n $errors = [];\n foreach ($plan as $p) {\n if ($p[0] === 't') {\n $list = self::buildCreate($tables[$p[1]]);\n } else {\n if (preg_match('/^(?:START\\s+TRANSACTION|BEGIN|COMMIT|ROLLBACK|SAVEPOINT|RELEASE)\\b/i', $p[1])) continue;\n if (preg_match('/^CREATE\\s+(?:DEFINER\\s*=\\s*\\S+\\s+)?(?:TRIGGER|PROCEDURE|FUNCTION|EVENT)\\b/i', $p[1])) {\n $skipped++;\n continue;\n }\n $list = self::convert($p[1]);\n }\n foreach ($list as $q) {\n try {\n self::runList($pdo, [self::unmask($q, $lits)]);\n $done++;\n } catch (Throwable $e) {\n $failed++;\n if (count($errors) < 3) {\n $msg = $e instanceof PDOException ? self::mapPdo($e)->getMessage() : $e->getMessage();\n $errors[] = $msg;\n }\n }\n }\n }\n $pdo->rawExec('COMMIT');\n foreach ($tables as $st) {\n if (!$st['seq']) continue;\n $t = str_replace(\"'\", \"''\", self::unq($st['name']));\n $n = (int)$st['seq'] - 1;\n try {\n $pdo->rawExec(\"UPDATE sqlite_sequence SET seq = $n WHERE name = '$t' AND seq < $n\");\n $pdo->rawExec(\"INSERT INTO sqlite_sequence (name, seq) SELECT '$t', $n WHERE NOT EXISTS (SELECT 1 FROM sqlite_sequence WHERE name = '$t')\");\n } catch (Throwable $e) {\n }\n }\n $pdo->rawExec('PRAGMA foreign_keys = ON');\n if ($failed || $skipped) {\n $msg = '[Athera MySQL BETA] ' . $label . ': ' . $done . ' OK, ' . $failed . ' failed' . ($skipped ? ', ' . $skipped . ' skipped (triggers/procedures)' : '');\n if ($errors) $msg .= '. ' . implode(' | ', $errors);\n trigger_error($msg, E_USER_NOTICE);\n }\n }\n}\n\nclass AthStmt extends PDOStatement\n{\n private $athPdo = null;\n private $athSql = '';\n private $athPost = [];\n private $athBinds = [];\n private $athParams = null;\n\n public function athInit(AthPDO $pdo, string $sql, array $post = []): void\n {\n $this->athPdo = $pdo;\n $this->athSql = $sql;\n $this->athPost = $post;\n }\n\n public function athChanges(): int\n {\n return parent::rowCount();\n }\n\n public function execute(?array $params = null): bool\n {\n $this->athParams = $params;\n try {\n $ok = parent::execute($params);\n } catch (PDOException $e) {\n throw AthMy::mapPdo($e);\n }\n if ($ok && $this->athPost && $this->athPdo !== null) AthMy::runList($this->athPdo, $this->athPost);\n return $ok;\n }\n\n public function bindValue(string|int $param, mixed $value, int $type = PDO::PARAM_STR): bool\n {\n $this->athBinds[$param] = [$value, $type];\n return parent::bindValue($param, $value, $type);\n }\n\n public function bindParam(string|int $param, mixed &$var, int $type = PDO::PARAM_STR, int $maxLength = 0, mixed $driverOptions = null): bool\n {\n $this->athBinds[$param] = [&$var, $type];\n return parent::bindParam($param, $var, $type, $maxLength, $driverOptions);\n }\n\n public function rowCount(): int\n {\n if ($this->athPdo !== null && $this->columnCount() > 0 && AthMy::isQuery($this->athSql)) return $this->athCount();\n return parent::rowCount();\n }\n\n private function athCount(): int\n {\n try {\n $st = $this->athPdo->rawPrepare('SELECT COUNT(*) FROM (' . $this->athSql . ')');\n if ($this->athParams !== null) {\n $st->execute($this->athParams);\n } else {\n foreach ($this->athBinds as $k => $b) $st->bindValue($k, $b[0], $b[1]);\n $st->execute();\n }\n return (int)$st->fetchColumn();\n } catch (Throwable $e) {\n return 0;\n }\n }\n}\n\nclass AthPDO extends PDO\n{\n const MYSQL_ATTR_USE_BUFFERED_QUERY = 1000;\n const MYSQL_ATTR_LOCAL_INFILE = 1001;\n const MYSQL_ATTR_INIT_COMMAND = 1002;\n const MYSQL_ATTR_COMPRESS = 1003;\n const MYSQL_ATTR_DIRECT_QUERY = 1004;\n const MYSQL_ATTR_FOUND_ROWS = 1005;\n const MYSQL_ATTR_IGNORE_SPACE = 1006;\n const MYSQL_ATTR_SSL_KEY = 1007;\n const MYSQL_ATTR_SSL_CERT = 1008;\n const MYSQL_ATTR_SSL_CA = 1009;\n const MYSQL_ATTR_SSL_CAPATH = 1010;\n const MYSQL_ATTR_SSL_CIPHER = 1011;\n const MYSQL_ATTR_SERVER_PUBLIC_KEY = 1012;\n const MYSQL_ATTR_MULTI_STATEMENTS = 1013;\n const MYSQL_ATTR_SSL_VERIFY_SERVER_CERT = 1014;\n\n private $athMy = false;\n\n public function __construct($dsn, $username = null, $password = null, $options = null)\n {\n if (!is_string($dsn) || stripos(ltrim($dsn), 'mysql:') !== 0) {\n parent::__construct($dsn, $username, $password, $options);\n return;\n }\n $attrs = [];\n preg_match_all('/(\\w+)\\s*=\\s*([^;]*)/', substr(ltrim($dsn), 6), $pairs, PREG_SET_ORDER);\n foreach ($pairs as $x) $attrs[strtolower($x[1])] = trim($x[2]);\n $db = isset($attrs['dbname']) ? $attrs['dbname'] : '';\n if ($db === '') $db = 'default';\n $fresh = false;\n $file = AthMy::dbFile($db, $fresh);\n $keep = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION];\n $init = null;\n foreach ((array)$options as $k => $v) {\n if ($k === 1002) $init = $v;\n elseif (in_array($k, [PDO::ATTR_ERRMODE, PDO::ATTR_DEFAULT_FETCH_MODE, PDO::ATTR_CASE, PDO::ATTR_ORACLE_NULLS], true)) $keep[$k] = $v;\n }\n parent::__construct('sqlite:' . $file, null, null, $keep);\n $this->athMy = true;\n AthMy::$db = $db;\n $this->setAttribute(PDO::ATTR_STATEMENT_CLASS, ['AthStmt']);\n AthMy::register($this);\n parent::exec('PRAGMA foreign_keys = ON');\n if ($fresh && AthMy::$dump !== null) {\n AthMy::importDump($this, (string)file_get_contents(AthMy::$dump), basename(AthMy::$dump));\n }\n if (is_string($init) && $init !== '') $this->exec($init);\n }\n\n public static function getAvailableDrivers(): array\n {\n return array_values(array_unique(array_merge(parent::getAvailableDrivers(), ['mysql'])));\n }\n\n public function rawExec(string $sql): int|false\n {\n return parent::exec($sql);\n }\n\n public function rawQuery(string $sql): PDOStatement|false\n {\n return parent::query($sql);\n }\n\n public function rawPrepare(string $sql): PDOStatement|false\n {\n return parent::prepare($sql);\n }\n\n public function exec(string $statement): int|false\n {\n if (!$this->athMy) return parent::exec($statement);\n try {\n return AthMy::runList($this, AthMy::translate($statement));\n } catch (PDOException $e) {\n throw AthMy::mapPdo($e);\n }\n }\n\n public function query(string $query, ?int $fetchMode = null, mixed ...$fetchModeArgs): PDOStatement|false\n {\n if (!$this->athMy) return $fetchMode === null ? parent::query($query) : parent::query($query, $fetchMode, ...$fetchModeArgs);\n try {\n $list = AthMy::translate($query);\n if (!$list) $list = [AthMy::NOOP];\n $main = array_shift($list);\n $st = $fetchMode === null ? parent::query($main) : parent::query($main, $fetchMode, ...$fetchModeArgs);\n if ($st instanceof AthStmt) $st->athInit($this, $main);\n if ($list) AthMy::runList($this, $list);\n return $st;\n } catch (PDOException $e) {\n throw AthMy::mapPdo($e);\n }\n }\n\n public function prepare(string $query, array $options = []): PDOStatement|false\n {\n if (!$this->athMy) return parent::prepare($query, $options);\n try {\n $list = AthMy::translate($query);\n if (!$list) $list = [AthMy::NOOP];\n $main = array_shift($list);\n $st = parent::prepare($main, $options);\n if ($st instanceof AthStmt) $st->athInit($this, $main, $list);\n return $st;\n } catch (PDOException $e) {\n throw AthMy::mapPdo($e);\n }\n }\n\n public function quote(string $string, int $type = PDO::PARAM_STR): string|false\n {\n if (!$this->athMy) return parent::quote($string, $type);\n return \"'\" . AthMy::escape($string) . \"'\";\n }\n\n public function getAttribute(int $attribute): mixed\n {\n if ($this->athMy) {\n if ($attribute === PDO::ATTR_DRIVER_NAME) return 'mysql';\n if ($attribute === PDO::ATTR_SERVER_VERSION) return '8.0.36-athera';\n if ($attribute === PDO::ATTR_CLIENT_VERSION) return 'mysqlnd 8.3';\n }\n return parent::getAttribute($attribute);\n }\n}\n\nforeach ([\n 'MYSQLI_ASSOC' => 1, 'MYSQLI_NUM' => 2, 'MYSQLI_BOTH' => 3, 'MYSQLI_STORE_RESULT' => 0, 'MYSQLI_USE_RESULT' => 1, 'MYSQLI_ASYNC' => 8,\n 'MYSQLI_REPORT_OFF' => 0, 'MYSQLI_REPORT_ERROR' => 1, 'MYSQLI_REPORT_STRICT' => 2, 'MYSQLI_REPORT_INDEX' => 4, 'MYSQLI_REPORT_ALL' => 255,\n 'MYSQLI_OPT_CONNECT_TIMEOUT' => 0, 'MYSQLI_OPT_LOCAL_INFILE' => 8, 'MYSQLI_INIT_COMMAND' => 3, 'MYSQLI_OPT_INT_AND_FLOAT_NATIVE' => 201,\n 'MYSQLI_SET_CHARSET_NAME' => 7, 'MYSQLI_CLIENT_SSL' => 2048, 'MYSQLI_CLIENT_COMPRESS' => 32, 'MYSQLI_CLIENT_INTERACTIVE' => 1024, 'MYSQLI_CLIENT_FOUND_ROWS' => 2,\n 'MYSQLI_TRANS_START_WITH_CONSISTENT_SNAPSHOT' => 1, 'MYSQLI_TRANS_START_READ_WRITE' => 2, 'MYSQLI_TRANS_START_READ_ONLY' => 4,\n 'MYSQLI_TYPE_DECIMAL' => 0, 'MYSQLI_TYPE_TINY' => 1, 'MYSQLI_TYPE_SHORT' => 2, 'MYSQLI_TYPE_LONG' => 3, 'MYSQLI_TYPE_FLOAT' => 4, 'MYSQLI_TYPE_DOUBLE' => 5,\n 'MYSQLI_TYPE_NULL' => 6, 'MYSQLI_TYPE_TIMESTAMP' => 7, 'MYSQLI_TYPE_LONGLONG' => 8, 'MYSQLI_TYPE_INT24' => 9, 'MYSQLI_TYPE_DATE' => 10, 'MYSQLI_TYPE_TIME' => 11,\n 'MYSQLI_TYPE_DATETIME' => 12, 'MYSQLI_TYPE_YEAR' => 13, 'MYSQLI_TYPE_NEWDECIMAL' => 246, 'MYSQLI_TYPE_BLOB' => 252, 'MYSQLI_TYPE_VAR_STRING' => 253, 'MYSQLI_TYPE_STRING' => 254\n] as $ath_name => $ath_value) {\n if (!defined($ath_name)) define($ath_name, $ath_value);\n}\n\nfunction ath_extension_loaded($name)\n{\n return in_array(strtolower((string)$name), ['mysqli', 'pdo_mysql', 'mysqlnd'], true) ? true : extension_loaded($name);\n}\n\nclass mysqli_sql_exception extends RuntimeException\n{\n protected string $sqlstate = '00000';\n\n public function getSqlState(): string\n {\n return $this->sqlstate;\n }\n\n public function athState(string $state): void\n {\n $this->sqlstate = $state;\n }\n}\n\nfinal class AthMyi\n{\n public static function fail($obj, PDOException $e, string $where)\n {\n $e = AthMy::mapPdo($e);\n $info = (isset($e->errorInfo[1]) && $e->errorInfo[1] !== null) ? $e->errorInfo : ['HY000', 1105, $e->getMessage()];\n $obj->errno = (int)$info[1];\n $obj->error = (string)$info[2];\n $obj->sqlstate = (string)$info[0];\n $obj->error_list = [['errno' => $obj->errno, 'sqlstate' => $obj->sqlstate, 'error' => $obj->error]];\n if (AthMy::$report & 2) {\n $x = new mysqli_sql_exception($obj->error, $obj->errno);\n $x->athState($obj->sqlstate);\n throw $x;\n }\n if (AthMy::$report & 1) trigger_error($where . '(): ' . $obj->error, E_USER_WARNING);\n return false;\n }\n\n public static function clear($obj): void\n {\n $obj->errno = 0;\n $obj->error = '';\n $obj->sqlstate = '00000';\n $obj->error_list = [];\n }\n\n public static function open($db): AthPDO\n {\n return new AthPDO('mysql:dbname=' . (($db === null || $db === '') ? 'default' : $db));\n }\n\n public static function strings(array $row): array\n {\n foreach ($row as $k => $v) {\n if ($v !== null && !is_string($v)) $row[$k] = (string)$v;\n }\n return $row;\n }\n}\n\nclass mysqli_result implements IteratorAggregate\n{\n public $current_field = 0;\n public $field_count = 0;\n public $lengths = null;\n public $num_rows = 0;\n public $type = 0;\n private $names = [];\n private $rows = [];\n private $pos = 0;\n\n public function __construct($source = null, bool $strings = true)\n {\n if ($source instanceof PDOStatement) {\n $names = [];\n for ($i = 0, $n = $source->columnCount(); $i < $n; $i++) {\n $meta = $source->getColumnMeta($i);\n $names[] = is_array($meta) && isset($meta['name']) ? $meta['name'] : (string)$i;\n }\n $this->athLoad($names, $source->fetchAll(PDO::FETCH_NUM), $strings);\n }\n }\n\n public function athLoad(array $names, array $rows, bool $strings): void\n {\n $this->names = $names;\n $this->rows = $strings ? array_map([AthMyi::class, 'strings'], $rows) : $rows;\n $this->field_count = count($names);\n $this->num_rows = count($rows);\n $this->pos = 0;\n }\n\n private function assoc(array $row): array\n {\n $out = [];\n foreach ($this->names as $i => $name) $out[$name] = $row[$i] ?? null;\n return $out;\n }\n\n private function both(array $row): array\n {\n $out = [];\n foreach ($this->names as $i => $name) {\n $out[$i] = $row[$i] ?? null;\n $out[$name] = $row[$i] ?? null;\n }\n return $out;\n }\n\n private function next(): ?array\n {\n if ($this->pos >= count($this->rows)) return null;\n $row = $this->rows[$this->pos++];\n $this->lengths = array_map(function ($v) { return $v === null ? 0 : strlen((string)$v); }, $row);\n return $row;\n }\n\n public function fetch_assoc(): array|null|false\n {\n $row = $this->next();\n return $row === null ? null : $this->assoc($row);\n }\n\n public function fetch_row(): array|null|false\n {\n return $this->next();\n }\n\n public function fetch_array(int $mode = MYSQLI_BOTH): array|null|false\n {\n $row = $this->next();\n if ($row === null) return null;\n if ($mode === MYSQLI_ASSOC) return $this->assoc($row);\n if ($mode === MYSQLI_NUM) return $row;\n return $this->both($row);\n }\n\n public function fetch_object(string $class = 'stdClass', array $constructor_args = []): object|null|false\n {\n $row = $this->next();\n if ($row === null) return null;\n $obj = $class === 'stdClass' ? new stdClass() : new $class(...$constructor_args);\n foreach ($this->assoc($row) as $k => $v) $obj->$k = $v;\n return $obj;\n }\n\n public function fetch_all(int $mode = MYSQLI_NUM): array\n {\n $out = [];\n while (($row = $this->next()) !== null) {\n $out[] = $mode === MYSQLI_ASSOC ? $this->assoc($row) : ($mode === MYSQLI_BOTH ? $this->both($row) : $row);\n }\n return $out;\n }\n\n public function fetch_column(int $column = 0): string|int|float|null|false\n {\n $row = $this->next();\n if ($row === null) return false;\n return $row[$column] ?? null;\n }\n\n private function field(int $i): object\n {\n $o = new stdClass();\n $o->name = $this->names[$i];\n $o->orgname = $this->names[$i];\n $o->table = '';\n $o->orgtable = '';\n $o->def = '';\n $o->db = AthMy::$db;\n $o->catalog = 'def';\n $o->max_length = 0;\n $o->length = 0;\n $o->charsetnr = 255;\n $o->flags = 0;\n $o->type = MYSQLI_TYPE_VAR_STRING;\n $o->decimals = 0;\n return $o;\n }\n\n public function fetch_field(): object|false\n {\n if ($this->current_field >= count($this->names)) return false;\n return $this->field($this->current_field++);\n }\n\n public function fetch_fields(): array\n {\n $out = [];\n foreach ($this->names as $i => $n) $out[] = $this->field($i);\n return $out;\n }\n\n public function fetch_field_direct(int $index): object|false\n {\n return isset($this->names[$index]) ? $this->field($index) : false;\n }\n\n public function field_seek(int $index): bool\n {\n $this->current_field = $index;\n return true;\n }\n\n public function data_seek(int $offset): bool\n {\n if ($offset < 0 || $offset > count($this->rows)) return false;\n $this->pos = $offset;\n return true;\n }\n\n public function free(): void\n {\n $this->rows = [];\n $this->pos = 0;\n }\n\n public function close(): void\n {\n $this->free();\n }\n\n public function free_result(): void\n {\n $this->free();\n }\n\n public function getIterator(): Iterator\n {\n $this->pos = 0;\n return (function () {\n while (($row = $this->next()) !== null) yield $this->assoc($row);\n })();\n }\n}\n\nclass mysqli_stmt\n{\n public $affected_rows = 0;\n public $insert_id = 0;\n public $num_rows = 0;\n public $param_count = 0;\n public $field_count = 0;\n public $errno = 0;\n public $error = '';\n public $error_list = [];\n public $sqlstate = '00000';\n public $id = 1;\n private $conn = null;\n private $st = null;\n private $sql = '';\n private $types = '';\n private $refs = [];\n private $out = [];\n private $names = [];\n private $rows = null;\n private $pos = 0;\n private $isInsert = false;\n\n public function __construct($mysqli = null, $query = null)\n {\n $this->conn = $mysqli;\n if ($query !== null) $this->prepare($query);\n }\n\n public function prepare(string $query): bool\n {\n AthMyi::clear($this);\n try {\n $list = AthMy::translate($query);\n if (!$list) $list = [AthMy::NOOP];\n $main = array_shift($list);\n $this->st = $this->conn->athPdo()->rawPrepare($main);\n if ($this->st instanceof AthStmt) $this->st->athInit($this->conn->athPdo(), $main, $list);\n $this->sql = $main;\n $lits = [];\n $this->param_count = substr_count(AthMy::mask($main, $lits), '?');\n $this->isInsert = (bool)preg_match('/^\\s*(?:INSERT|REPLACE)\\b/i', $main);\n return true;\n } catch (PDOException $e) {\n return AthMyi::fail($this, $e, 'mysqli::prepare') !== false;\n }\n }\n\n public function bind_param(string $types, mixed &...$vars): bool\n {\n $this->types = $types;\n $this->refs = [];\n foreach ($vars as $i => &$v) $this->refs[$i] = &$v;\n unset($v);\n return true;\n }\n\n public function bind_result(mixed &...$vars): bool\n {\n $this->out = [];\n foreach ($vars as $i => &$v) $this->out[$i] = &$v;\n unset($v);\n return true;\n }\n\n public function execute(?array $params = null): bool\n {\n AthMyi::clear($this);\n try {\n $i = 1;\n if ($params !== null) {\n foreach (array_values($params) as $v) {\n $this->st->bindValue($i++, $v, $v === null ? PDO::PARAM_NULL : (is_int($v) ? PDO::PARAM_INT : PDO::PARAM_STR));\n }\n } else {\n foreach ($this->refs as $k => $v) {\n $t = isset($this->types[$k]) ? $this->types[$k] : 's';\n if ($v === null) $this->st->bindValue($i, null, PDO::PARAM_NULL);\n elseif ($t === 'i') $this->st->bindValue($i, (int)$v, PDO::PARAM_INT);\n elseif ($t === 'b') $this->st->bindValue($i, (string)$v, PDO::PARAM_LOB);\n else $this->st->bindValue($i, $t === 'd' ? (float)$v : (string)$v, PDO::PARAM_STR);\n $i++;\n }\n }\n $this->st->execute();\n $this->rows = null;\n $this->pos = 0;\n $this->num_rows = 0;\n $this->field_count = $this->st->columnCount();\n if ($this->field_count > 0) {\n $this->names = [];\n for ($c = 0; $c < $this->field_count; $c++) {\n $meta = $this->st->getColumnMeta($c);\n $this->names[] = is_array($meta) && isset($meta['name']) ? $meta['name'] : (string)$c;\n }\n $this->rows = $this->st->fetchAll(PDO::FETCH_NUM);\n $this->affected_rows = count($this->rows);\n } else {\n $this->affected_rows = $this->st instanceof AthStmt ? $this->st->athChanges() : $this->st->rowCount();\n $this->insert_id = $this->isInsert && $this->affected_rows > 0 ? (int)$this->conn->athPdo()->lastInsertId() : 0;\n $this->conn->athSetResult($this->affected_rows, $this->insert_id);\n }\n return true;\n } catch (PDOException $e) {\n return AthMyi::fail($this, $e, 'mysqli_stmt::execute') !== false;\n }\n }\n\n public function fetch(): ?bool\n {\n if ($this->rows === null || $this->pos >= count($this->rows)) return null;\n $row = $this->rows[$this->pos++];\n foreach ($this->out as $i => &$ref) $ref = $row[$i] ?? null;\n unset($ref);\n return true;\n }\n\n public function get_result(): mysqli_result|false\n {\n if ($this->rows === null) return false;\n $r = new mysqli_result();\n $r->athLoad($this->names, $this->rows, false);\n $this->num_rows = count($this->rows);\n return $r;\n }\n\n public function result_metadata(): mysqli_result|false\n {\n if ($this->st === null || $this->st->columnCount() === 0) return false;\n $names = [];\n for ($c = 0, $n = $this->st->columnCount(); $c < $n; $c++) {\n $meta = $this->st->getColumnMeta($c);\n $names[] = is_array($meta) && isset($meta['name']) ? $meta['name'] : (string)$c;\n }\n $r = new mysqli_result();\n $r->athLoad($names, [], false);\n return $r;\n }\n\n public function store_result(): bool\n {\n $this->num_rows = $this->rows === null ? 0 : count($this->rows);\n return true;\n }\n\n public function data_seek(int $offset): void\n {\n $this->pos = max(0, $offset);\n }\n\n public function free_result(): void\n {\n $this->rows = null;\n $this->pos = 0;\n }\n\n public function reset(): bool\n {\n $this->free_result();\n return true;\n }\n\n public function close(): bool\n {\n $this->free_result();\n return true;\n }\n\n public function attr_get(int $attribute): int|false\n {\n return 0;\n }\n\n public function attr_set(int $attribute, int $value): bool\n {\n return true;\n }\n\n public function more_results(): bool\n {\n return false;\n }\n\n public function next_result(): bool\n {\n return false;\n }\n\n public function send_long_data(int $param_num, string $data): bool\n {\n return true;\n }\n}\n\nclass mysqli\n{\n public $affected_rows = 0;\n public $client_info = 'mysqlnd 8.3';\n public $client_version = 80333;\n public $connect_errno = 0;\n public $connect_error = null;\n public $errno = 0;\n public $error = '';\n public $error_list = [];\n public $field_count = 0;\n public $host_info = 'localhost via Athera';\n public $info = null;\n public $insert_id = 0;\n public $protocol_version = 10;\n public $server_info = '8.0.36-athera';\n public $server_version = 80036;\n public $sqlstate = '00000';\n public $thread_id = 1;\n public $warning_count = 0;\n private $ath = null;\n private $last = null;\n private $queue = [];\n\n public function __construct($hostname = null, $username = null, $password = null, $database = null, $port = null, $socket = null)\n {\n if ($hostname !== null || $database !== null) $this->real_connect($hostname, $username, $password, $database, $port, $socket);\n }\n\n public function real_connect($hostname = null, $username = null, $password = null, $database = null, $port = null, $socket = null, $flags = 0): bool\n {\n $this->ath = AthMyi::open($database);\n return true;\n }\n\n public function athPdo(): AthPDO\n {\n if ($this->ath === null) throw new Error('mysqli object is already closed');\n return $this->ath;\n }\n\n public function athSetResult(int $affected, $insertId): void\n {\n $this->affected_rows = $affected;\n $this->insert_id = $insertId;\n }\n\n public function query(string $query, int $result_mode = MYSQLI_STORE_RESULT): mysqli_result|bool\n {\n AthMyi::clear($this);\n $pdo = $this->athPdo();\n try {\n $list = AthMy::translate($query);\n if (!$list) return true;\n if (AthMy::isQuery($query)) {\n $main = array_shift($list);\n $st = $pdo->rawQuery($main);\n if ($list) AthMy::runList($pdo, $list);\n $res = new mysqli_result($st, true);\n $this->affected_rows = $res->num_rows;\n $this->field_count = $res->field_count;\n return $res;\n }\n $this->affected_rows = AthMy::runList($pdo, $list);\n $this->field_count = 0;\n $this->insert_id = preg_match('/^(?:INSERT|REPLACE)$/', AthMy::kind($query)) && $this->affected_rows > 0 ? (int)$pdo->lastInsertId() : 0;\n return true;\n } catch (PDOException $e) {\n return AthMyi::fail($this, $e, 'mysqli::query');\n }\n }\n\n public function real_query(string $query): bool\n {\n $this->last = $this->query($query);\n return $this->last !== false;\n }\n\n public function store_result(int $mode = 0): mysqli_result|false\n {\n return $this->last instanceof mysqli_result ? $this->last : false;\n }\n\n public function use_result(): mysqli_result|false\n {\n return $this->store_result();\n }\n\n public function multi_query(string $query): bool\n {\n $this->queue = AthMy::translate($query);\n $this->last = null;\n return $this->queue ? $this->step() : true;\n }\n\n private function step(): bool\n {\n AthMyi::clear($this);\n $q = array_shift($this->queue);\n $pdo = $this->athPdo();\n try {\n if (AthMy::isQuery($q)) {\n $this->last = new mysqli_result($pdo->rawQuery($q), true);\n } else {\n $this->affected_rows = AthMy::runList($pdo, [$q]);\n $this->last = null;\n }\n return true;\n } catch (PDOException $e) {\n $this->queue = [];\n return AthMyi::fail($this, $e, 'mysqli::multi_query') !== false;\n }\n }\n\n public function more_results(): bool\n {\n return count($this->queue) > 0;\n }\n\n public function next_result(): bool\n {\n return $this->queue ? $this->step() : false;\n }\n\n public function prepare(string $query): mysqli_stmt|false\n {\n AthMyi::clear($this);\n $stmt = new mysqli_stmt($this);\n if (!$stmt->prepare($query)) return false;\n return $stmt;\n }\n\n public function execute_query(string $query, ?array $params = null): mysqli_result|bool\n {\n $stmt = $this->prepare($query);\n if ($stmt === false) return false;\n if (!$stmt->execute($params)) return false;\n $res = $stmt->get_result();\n return $res === false ? true : $res;\n }\n\n public function real_escape_string(string $string): string\n {\n return AthMy::escape($string);\n }\n\n public function escape_string(string $string): string\n {\n return AthMy::escape($string);\n }\n\n public function select_db(string $database): bool\n {\n $this->ath = AthMyi::open($database);\n return true;\n }\n\n public function set_charset(string $charset): bool\n {\n return true;\n }\n\n public function character_set_name(): string\n {\n return 'utf8mb4';\n }\n\n public function get_charset(): object\n {\n $o = new stdClass();\n $o->charset = 'utf8mb4';\n $o->collation = 'utf8mb4_general_ci';\n $o->dir = '';\n $o->min_length = 1;\n $o->max_length = 4;\n $o->number = 45;\n $o->state = 1;\n $o->comment = '';\n return $o;\n }\n\n public function begin_transaction(int $flags = 0, ?string $name = null): bool\n {\n $pdo = $this->athPdo();\n if (!$pdo->inTransaction()) $pdo->beginTransaction();\n return true;\n }\n\n public function commit(int $flags = 0, ?string $name = null): bool\n {\n $pdo = $this->athPdo();\n if ($pdo->inTransaction()) $pdo->commit();\n return true;\n }\n\n public function rollback(int $flags = 0, ?string $name = null): bool\n {\n $pdo = $this->athPdo();\n if ($pdo->inTransaction()) $pdo->rollBack();\n return true;\n }\n\n public function autocommit(bool $enable): bool\n {\n $pdo = $this->athPdo();\n if ($enable && $pdo->inTransaction()) $pdo->commit();\n if (!$enable && !$pdo->inTransaction()) $pdo->beginTransaction();\n return true;\n }\n\n public function ping(): bool\n {\n return $this->ath !== null;\n }\n\n public function close(): bool\n {\n $this->ath = null;\n return true;\n }\n\n public function options(int $option, $value): bool\n {\n return true;\n }\n\n public function ssl_set($key = null, $certificate = null, $ca = null, $capath = null, $cipher = null): bool\n {\n return true;\n }\n\n public function get_server_info(): string\n {\n return $this->server_info;\n }\n\n public function get_connection_stats(): array|false\n {\n return [];\n }\n\n public function stat(): string|false\n {\n return 'Uptime: 1 Threads: 1';\n }\n\n public function get_warnings(): mixed\n {\n return false;\n }\n\n public function kill(int $process_id): bool\n {\n return true;\n }\n}\n\nfunction mysqli_report(int $flags): bool { AthMy::$report = $flags; return true; }\nfunction mysqli_init(): mysqli { return new mysqli(); }\nfunction mysqli_connect($hostname = null, $username = null, $password = null, $database = null, $port = null, $socket = null) { return new mysqli($hostname ?? 'localhost', $username, $password, $database, $port, $socket); }\nfunction mysqli_real_connect(mysqli $mysql, $hostname = null, $username = null, $password = null, $database = null, $port = null, $socket = null, $flags = 0): bool { return $mysql->real_connect($hostname, $username, $password, $database, $port, $socket, $flags); }\nfunction mysqli_connect_error(): ?string { return null; }\nfunction mysqli_connect_errno(): int { return 0; }\nfunction mysqli_query(mysqli $mysql, string $query, int $result_mode = MYSQLI_STORE_RESULT) { return $mysql->query($query, $result_mode); }\nfunction mysqli_real_query(mysqli $mysql, string $query): bool { return $mysql->real_query($query); }\nfunction mysqli_multi_query(mysqli $mysql, string $query): bool { return $mysql->multi_query($query); }\nfunction mysqli_next_result(mysqli $mysql): bool { return $mysql->next_result(); }\nfunction mysqli_more_results(mysqli $mysql): bool { return $mysql->more_results(); }\nfunction mysqli_store_result(mysqli $mysql, int $mode = 0) { return $mysql->store_result($mode); }\nfunction mysqli_use_result(mysqli $mysql) { return $mysql->use_result(); }\nfunction mysqli_error(mysqli $mysql): string { return $mysql->error; }\nfunction mysqli_errno(mysqli $mysql): int { return $mysql->errno; }\nfunction mysqli_sqlstate(mysqli $mysql): string { return $mysql->sqlstate; }\nfunction mysqli_error_list(mysqli $mysql): array { return $mysql->error_list; }\nfunction mysqli_insert_id(mysqli $mysql): int|string { return $mysql->insert_id; }\nfunction mysqli_affected_rows(mysqli $mysql): int|string { return $mysql->affected_rows; }\nfunction mysqli_field_count(mysqli $mysql): int { return $mysql->field_count; }\nfunction mysqli_close(mysqli $mysql): bool { return $mysql->close(); }\nfunction mysqli_ping(mysqli $mysql): bool { return $mysql->ping(); }\nfunction mysqli_select_db(mysqli $mysql, string $database): bool { return $mysql->select_db($database); }\nfunction mysqli_set_charset(mysqli $mysql, string $charset): bool { return $mysql->set_charset($charset); }\nfunction mysqli_character_set_name(mysqli $mysql): string { return $mysql->character_set_name(); }\nfunction mysqli_real_escape_string(mysqli $mysql, string $string): string { return $mysql->real_escape_string($string); }\nfunction mysqli_escape_string(mysqli $mysql, string $string): string { return $mysql->real_escape_string($string); }\nfunction mysqli_begin_transaction(mysqli $mysql, int $flags = 0, ?string $name = null): bool { return $mysql->begin_transaction($flags, $name); }\nfunction mysqli_commit(mysqli $mysql, int $flags = 0, ?string $name = null): bool { return $mysql->commit($flags, $name); }\nfunction mysqli_rollback(mysqli $mysql, int $flags = 0, ?string $name = null): bool { return $mysql->rollback($flags, $name); }\nfunction mysqli_autocommit(mysqli $mysql, bool $enable): bool { return $mysql->autocommit($enable); }\nfunction mysqli_get_server_info(mysqli $mysql): string { return $mysql->get_server_info(); }\nfunction mysqli_get_client_info(?mysqli $mysql = null): string { return 'mysqlnd 8.3'; }\nfunction mysqli_options(mysqli $mysql, int $option, $value): bool { return true; }\nfunction mysqli_ssl_set(mysqli $mysql, $key = null, $certificate = null, $ca = null, $capath = null, $cipher = null): bool { return true; }\nfunction mysqli_stat(mysqli $mysql) { return $mysql->stat(); }\nfunction mysqli_thread_id(mysqli $mysql): int { return 1; }\nfunction mysqli_warning_count(mysqli $mysql): int { return 0; }\nfunction mysqli_info(mysqli $mysql): ?string { return null; }\nfunction mysqli_prepare(mysqli $mysql, string $query) { return $mysql->prepare($query); }\nfunction mysqli_execute_query(mysqli $mysql, string $query, ?array $params = null) { return $mysql->execute_query($query, $params); }\nfunction mysqli_fetch_assoc(mysqli_result $result) { return $result->fetch_assoc(); }\nfunction mysqli_fetch_row(mysqli_result $result) { return $result->fetch_row(); }\nfunction mysqli_fetch_array(mysqli_result $result, int $mode = MYSQLI_BOTH) { return $result->fetch_array($mode); }\nfunction mysqli_fetch_object(mysqli_result $result, string $class = 'stdClass', array $constructor_args = []) { return $result->fetch_object($class, $constructor_args); }\nfunction mysqli_fetch_all(mysqli_result $result, int $mode = MYSQLI_NUM): array { return $result->fetch_all($mode); }\nfunction mysqli_fetch_column(mysqli_result $result, int $column = 0) { return $result->fetch_column($column); }\nfunction mysqli_fetch_field(mysqli_result $result) { return $result->fetch_field(); }\nfunction mysqli_fetch_fields(mysqli_result $result): array { return $result->fetch_fields(); }\nfunction mysqli_fetch_field_direct(mysqli_result $result, int $index) { return $result->fetch_field_direct($index); }\nfunction mysqli_field_seek(mysqli_result $result, int $index): bool { return $result->field_seek($index); }\nfunction mysqli_data_seek(mysqli_result $result, int $offset): bool { return $result->data_seek($offset); }\nfunction mysqli_num_rows(mysqli_result $result): int|string { return $result->num_rows; }\nfunction mysqli_num_fields(mysqli_result $result): int { return $result->field_count; }\nfunction mysqli_free_result(mysqli_result $result): void { $result->free(); }\nfunction mysqli_stmt_bind_param(mysqli_stmt $statement, string $types, mixed &...$vars): bool { return $statement->bind_param($types, ...$vars); }\nfunction mysqli_stmt_bind_result(mysqli_stmt $statement, mixed &...$vars): bool { return $statement->bind_result(...$vars); }\nfunction mysqli_stmt_execute(mysqli_stmt $statement, ?array $params = null): bool { return $statement->execute($params); }\nfunction mysqli_stmt_fetch(mysqli_stmt $statement): ?bool { return $statement->fetch(); }\nfunction mysqli_stmt_get_result(mysqli_stmt $statement) { return $statement->get_result(); }\nfunction mysqli_stmt_store_result(mysqli_stmt $statement): bool { return $statement->store_result(); }\nfunction mysqli_stmt_num_rows(mysqli_stmt $statement): int|string { return $statement->num_rows; }\nfunction mysqli_stmt_affected_rows(mysqli_stmt $statement): int|string { return $statement->affected_rows; }\nfunction mysqli_stmt_insert_id(mysqli_stmt $statement): int|string { return $statement->insert_id; }\nfunction mysqli_stmt_close(mysqli_stmt $statement): bool { return $statement->close(); }\nfunction mysqli_stmt_reset(mysqli_stmt $statement): bool { return $statement->reset(); }\nfunction mysqli_stmt_free_result(mysqli_stmt $statement): void { $statement->free_result(); }\nfunction mysqli_stmt_error(mysqli_stmt $statement): string { return $statement->error; }\nfunction mysqli_stmt_errno(mysqli_stmt $statement): int { return $statement->errno; }\nfunction mysqli_stmt_param_count(mysqli_stmt $statement): int { return $statement->param_count; }\nfunction mysqli_stmt_field_count(mysqli_stmt $statement): int { return $statement->field_count; }\nfunction mysqli_stmt_data_seek(mysqli_stmt $statement, int $offset): void { $statement->data_seek($offset); }\nfunction mysqli_stmt_result_metadata(mysqli_stmt $statement) { return $statement->result_metadata(); }\n";
-