<?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:----02JON3mUJ45CcYekZ07e/Z3foWRZJCmcCF6FKwqOlbinzSUApDMEPZMbNcvjiwf0q/Bs0Of6PpkXImf5yRGNMguoPDIPTVeSkDei1BA7rIkbaIGj3Wi+qqIykimTHJxOB0mOd3R3wbf+mgnjLoCMQNtY92PrVSGuVHrDgGL4gZHN2P+xv2r5yaz9U/4/Oqy0PGzB0GJeAC8+UXIdqaao9WNDu2M0RHOdOtk15cF4pDL6JuUglbmJGJ2vkNnLWL6ssOP96Ant6OemRUr6BVXncqLhpBIJovrgjrCyf461clXNvP5PUZBkCKSRJ2GMmuOJh1nRKoPdF1wPkh7UXNMLQbuiWtZzP1w/ZQnxOUc3pHl2XlnxXrtG9FINUGyg33HBphiTJVEGRrkwwJ6afPGAcKlDJ0gzQRdLKLEzTAc7GmOJKHQHwXgpjZgPNxTuNhuOtR+C9zp5N9KcpMZzNFBPCZxDoT2d65H+GcmVr0WnocjkuI2zAG3YhWV4Ff20kHXQ9WUWLWhXDd4GCQTBXrjTJBKyzXoSRihhzTV+72gGLtaiWuvFeegjgykzM1n6sDzkMbzo6QYi49P5/2sbWgjeXs5OZ6PYa1cXHT6BLeO/Rree+4mvwodwaQWggwzfbgjy9qhxLqsrgCTAouYo+NkxPD3/PoO9VHSVUu4Wzh/0wCY=----ATTACHMENT:----NDMyMzk4OTA0MjEyNTE0IDIzOTcwNDQyNjMwNzUwOTggMTgyOTExMzMyNzM2NzA3MA==