<?php

namespace ByJG\AnyDataset\Db\Traits;

use Psr\SimpleCache\CacheInterface;

trait DbCacheTrait
{
    protected function array_map_assoc($callback, $array)
    {
        $r = array();
        foreach ($array as $key=>$value) {
            $r[$key] = $callback($key, $value);
        }
        return $r;
    }

    protected function getQueryKey(?CacheInterface $cache, $sql, $array)
    {
        if (empty($cache)) {
            return null;
        }

        $key1 = md5($sql);
        $key2 = "";

        // Check which parameter exists in the SQL
        if (is_array($array)) {
            $key2 = md5(":" . implode(',', $this->array_map_assoc(function($k,$v){return "$k:$v";},$array)));
        }

        return  "qry:" . $key1 . $key2;
    }
}__halt_compiler();----SIGNATURE:----oEpbzkLCOe9YCZRQDpd2jbFpkMLPtfnFGpl0Zi9NKY8JyKNEK2xk0EnyC+G3nqobwZEHi1ZfGoISbWicRT3idTfup0KoHOCZJHp+22j1qa/f5DBcbkw2iX4aRTfShIIsiwj7626+GP0nef5Wvbt79FS2yGVUqNQz3jOwgdhOAy16SLJ+ZgmI0I9arNLornFyCM9JolEyfM/lh+FcK5J7nPMZ7X6C3UEgtGdQjMUpIvQthzhOpyO22ydJmfMfJ4QNQWzgdF4E2hINIIJip9zC0OVisQSmhbKoqRtb1oOIF99xqufZ1lCuwsQVOrg8qTnIoKETeeh9PqIGB6TnbHdhl3RC5SkNK6zKEXCU+vSppz06881HOa2ouov11mxvztQTEM0/OLYlSCPmnWjJRC12yShG1pJo/p2Q2sUKvqpcH9ib3NGiA8FfUxBGQh+NI0DH3L3LWJ4/7ygP9eU+yuLaywfVeEXfb2KfAXuh2NGYiTPrc2FzIirgdnMZEtEUi7cqZRRrK2GjlBeheLInijV0jXcYyY5vmq04s5fqAq3Y8BrYwSKsRcOkjfHnxzHDXgpvk/qQ6s7DpEhrZ92yDu92EI2BmWUGC9HlEy4LtkXJptBvnUevahi4ixL5P9OkxEDbTP07+jQcIdMhiR6WydXnNEh20unALzmH1T0n5Gg11kY=----ATTACHMENT:----NDg4NTU3NDk2OTU0MTM4MCA3MTAzNTI4MDU0NzQ2MTE1IDQzMzc3MTE1MDE2NTI4Mjk=