<?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:----sGKHei84kXC7hVm1WuVAcxAnwxCPte20ATUi/yu+NJ8JZJYy5rI5cQN820Sk2nS7NqMVCf84GFUzxCQ5ur3CbkrlAKSwuAnexCzVE/RnX/Jh/PeQ06vnwzTe8vo9bLOScVuzYVWGKp6wEoV2LBikOleT8u5TnKFLCYWj56ERDSpwCEQvXZ45rPQANSm8U8NS60A2j+v7MosWhUqkBL3AcGVCuuboiHbbFGjWCuSG4OCHn77bLExP2WunJOoign11LIOEskJ0gj4sjf3vByOGJ8PAjbUT7tCSiYpVr7+uw7bvOujnk1Xj314swEjabcRadqqe4XaB3WAsSF6oOsWKLkA4lGxtSQw2Ac2KuW/INWuP72DFRWWYPdtvdhzSLZuR9Y18ivcqLEvLUghZ3TnANhX7gO5pULjCHnoPXs1iQboA/f5n/JD8ddZGhOlzf7P+jtLGNwI+zhFbHSq/hLjWotfU1Wk0f7uNPSmMWLu98o3R9mZtLBNaxdyV/QX2MbU30Msjc6WQOx99GC3Ocz/t3N7f/mVCXE07gZZ8pTPtH+vzN4gN/zSTeLKawyBMYmloGhNR7HvLD3ablhkYz0lMi0Tb5eFqXFyuECHpC4rvq0Zz2lED5SQZyfQfHsf970nzn8S2sD8eDfcZny7MYnlyt6uv8LDRbM9zCNOcQLoyAPE=----ATTACHMENT:----NjY0MTQ5Nzc1MzkxMzE5IDUxNzM4NDgwMDg4NjMyMiA0MjAzMzIxNDcxOTEzNjIz