<?php declare(strict_types=1);
/**
 * A stand-in for the mysqli extension, backed by PDO SQLite, so tests can run
 * ipsDbOpen()'s real adapter code - prepare, bind_param, execute, get_result,
 * fetch_all - against actual SQL without a MySQL server.
 *
 * Loaded only when the mysqli extension is absent (the test runner starts PHP
 * with -n and doesn't load it).  Tests point FakeMysqliBackend::$pdo at a
 * seeded SQLite database; connecting as any user other than
 * FakeMysqliBackend::$validUser fails the way MySQL reports it.
 */

const MYSQLI_ASSOC         = 1;
const MYSQLI_REPORT_ERROR  = 1;
const MYSQLI_REPORT_STRICT = 2;

function mysqli_report(int $flags): bool
{
    return true;
}

class mysqli_sql_exception extends RuntimeException {}

final class FakeMysqliBackend
{
    public static ?PDO $pdo = null;
    public static string $validUser = 'tgpnet_hg_ivbd1_ro';
}

class mysqli
{
    public function __construct(string $host, string $user, string $pass, string $database)
    {
        if ($user !== FakeMysqliBackend::$validUser) {
            throw new mysqli_sql_exception("Access denied for user '{$user}'@'{$host}' (using password: YES)");
        }
    }

    public function set_charset(string $charset): bool
    {
        return true;
    }

    public function prepare(string $sql): mysqli_stmt
    {
        return new mysqli_stmt(FakeMysqliBackend::$pdo->prepare($sql));
    }
}

class mysqli_stmt
{
    private PDOStatement $stmt;
    private array $vars = [];
    private bool $executed = false;

    public function __construct(PDOStatement $stmt)
    {
        $this->stmt = $stmt;
    }

    public function bind_param(string $types, mixed &...$vars): bool
    {
        if (strlen($types) !== count($vars)) {
            throw new ArgumentCountError('The number of elements in the type definition string must match the number of bind variables');
        }
        if (preg_match('/[^isdb]/', $types)) {
            throw new ValueError('Unknown bind type in "' . $types . '"');
        }
        $this->vars = $vars;
        return true;
    }

    public function execute(): bool
    {
        $this->executed = $this->stmt->execute($this->vars);
        return $this->executed;
    }

    public function get_result(): mysqli_result
    {
        return new mysqli_result($this->stmt->fetchAll(PDO::FETCH_ASSOC));
    }

    public function close(): bool
    {
        return true;
    }
}

class mysqli_result
{
    private array $rows;

    public function __construct(array $rows)
    {
        $this->rows = $rows;
    }

    public function fetch_all(int $mode = MYSQLI_ASSOC): array
    {
        return $this->rows;
    }
}