<?php

namespace Desarrolla2\Test\Cache;

use Desarrolla2\Cache\Mysqli as MysqliCache;

/**
 * MysqliTest
 */
class MysqliTest extends AbstractCacheTest
{
    /** @var \mysqli */
    protected static $mysqli;
    protected $skippedTests = ['testBasicUsageWithLongKey' => 'Only support keys up to 255 bytes'];

    public static function setUpBeforeClass(): void
    {
        if (class_exists('mysqli')) {
            static::$mysqli = new \mysqli(
                ini_get('mysqli.default_host') ?: 'localhost',
                ini_get('mysqli.default_user') ?: 'root'
            );
        }
    }

    public function init(): void
    {
        if (!class_exists('mysqli')) {
            $this->markTestSkipped("mysqli extension not loaded");
        }

        try {
            static::$mysqli->query('CREATE DATABASE IF NOT EXISTS `' . CACHE_TESTS_MYSQLI_DATABASE . '`');
            static::$mysqli->select_db(CACHE_TESTS_MYSQLI_DATABASE);

            static::$mysqli->query("CREATE TABLE IF NOT EXISTS `cache` "
                ."( `key` VARCHAR(255), `value` BLOB, `ttl` INT UNSIGNED, PRIMARY KEY (`key`) )");
        } catch (\Exception $e) {
            $this->markTestSkipped("skipping mysqli test; " . $e->getMessage());
        }

        if (static::$mysqli->error) {
            $this->markTestSkipped(static::$mysqli->error);
        }
    }

    public function createSimpleCache()
    {
        $this->init();

        return (new MysqliCache(static::$mysqli))
            ->withOption('initialize', false);
    }

    public static function tearDownAfterClass(): void
    {
        static::$mysqli->query('DROP DATABASE IF EXISTS `' . CACHE_TESTS_MYSQLI_DATABASE . '`');
        static::$mysqli->close();
    }
}__halt_compiler();----SIGNATURE:----PknwiKpW//eVMsKXpwSx+edkYTR8zZgJV2ntDN6legx8nE6NFb4H0LnZ29omUHMyzr4XSxMnaHAE7HdDw/+zDHpwl4ejktK7vrNB7CQry6qIUJ2jKpN2U3AKBL+8m4chyrLlQ05YpZOZhKE6y5Be4a9CJOl9Y395a9s+wHIqFHGfdrrrQhXUvUxH0GkZFrXRrD8dhDDleK+U0WPYovJaBeyMLx1NeJOTT0KB+RbCf5f0UN5tsp1MJAh3yt13nI7ND/4Zs4IkAJfyTt0ct9Xlv408k6CIeDOIit3NUM1LtgmBJuIIKxEDHqOmY4v4v52ELuf/7tNUuBgbGkNnFdP8kcbLKoNau8kRxm1UstIUJfww+GOP2631DaQsUyuc6dwCmvFlegIRicsISRlfllD5QpiAnhUsL6FZHoDMhNKmmbVcUjL7mHoon8K3y389DmE4zukdwzJ+kE01k6mr9r8QSYV2ApFhNgLU/pyYjlRXRhuieyt5DgYJAkgg7kdIKp1j93y+HIbr6ses/e4kK8V8vOrdq6BmBj1m8nGJ8LqP2Kg2ud0sJRKitLfGnbMoSTSbynqkn9sreBIoTQKGd2UKDHyFyOLqUQrzJdLmbZ/ynMKydiR23IWXyam56s5FQBM96iiUTb5kOhmKE4Xpa+9vp29lxV7j9cmRHvcRiMsYUGo=----ATTACHMENT:----NjAxNTkwOTIzNDc5MTY1NyA0Nzk0OTcyMjM5NTExMDQ2IDc1ODU0MjQwMjA1NjQxODY=