<?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:----XZMV29bn1Y6mkQF8uVvK5Uqg2/1YkdxNOl95KLMCnBJNzYHDFaUX3kmP1MQBTL4dbhXH8mWeqHgRLvPr94xcHtO3KMn6ab5wYD7gTh/dSiw0cjQ3Y30/+PXbMH2H6jjFyt5D7m7aWR28DEdYdGLyQQ1zaFlUKgkRemyg0kNO6bqPjJlSwWaCMgVzj5apzTTD/Uq9xYrLjh9iwRHezTqOcaEHEKTZPRCNPAawuwu9Ra7witWXtO264DdhSW7jF9aN69mSiQJ33KkYe+JqO2sCoXr4xxldvSeulH+X/yw8Hm+CCyct2UxQZg7i2mYimZRJGryP+pM9R5RUJXVdG4EOa4NGJc8Is8komYmk5DWWkd5/yPgnsqyZK47f9aAMrW7utaNn5kovU3G5ofpf9h6XQTQR/Q01EdMbZG1QWYQKfofjOYBf56Cyi2P8pjLsQOsZw/iK2XyEZKz2dgcpARkrh1i28TTKnJEzdGs8Bp2sh64WYF5QwKa2nD+XD+v4BzJdvAC0mJ9H/PB2IR0Agp/x2WYVx/3yKlbzDRg3Xz4qjPKvSSPmwPpo2U1ZgNyh1cnK8HQufi6pmH0smnC0sfvWw4w7D1MI1gbgRRMqBk5Ubu1s2KMu8TFFtfQ9IfV7tMKb4IdX6b2/PrpspS2RCnLLR08cYkZEREmBpLrt3oXu0h4=----ATTACHMENT:----NDQ0NTIyNDc2MTk2MDc2NyA4NzcyMDg5MjMzMjMwODA2IDgxNjgzNDEzMjkxMTY1MjQ=