示例#1
0
 public function get($url)
 {
     $this->request = \Request::active();
     $this->path = APPPATH . 'cache/pages/' . \CMF\Cache::uriCacheKey($url) . '.cache';
     if (file_exists($this->path)) {
         return file_get_contents($this->path);
     }
     return false;
 }
示例#2
0
 public static function exception_handler(\Exception $e)
 {
     // Try and stop the cache
     try {
         \CMF\Cache::stop();
     } catch (\Exception $e) {
     }
     parent::exception_handler($e);
 }
示例#3
0
 public function shutdown()
 {
     $queries = $this->logger->queries;
     $controller = $this->request->controller_instance;
     $tables = array();
     $subqueries = array();
     $queryTables = array();
     $sql = '';
     // Add the template files to be checked
     $template_loader = \View_Twig::loader();
     if (!is_null($template_loader) && method_exists($template_loader, 'getFiles')) {
         $templates = $template_loader->getFiles();
         $this->files = array_unique(array_merge($this->files, $templates));
     }
     // Add all loaded files within the app root, excluding cache and model proxies
     $this->files = array_merge($this->files, array_filter(get_included_files(), function ($path) {
         return strpos($path, APPPATH) === 0 && strpos($path, APPPATH . 'cache') !== 0 && strpos($path, APPPATH . 'classes/proxy') !== 0;
     }));
     $model_classes = array_filter(get_declared_classes(), function ($class) {
         return strpos($class, 'Model_') !== false;
     });
     // Construct an allowed list of tables for the cache queries
     $em = \D::manager();
     foreach ($model_classes as $model) {
         $meta = $em->getClassMetadata($model);
         if ($meta->isMappedSuperclass || !isset($meta->columnNames['updated_at']) || $meta->rootEntityName != $meta->name) {
             continue;
         }
         if (!in_array($meta->table['name'], $tables)) {
             $tables[] = $meta->table['name'];
         }
     }
     // Remove the app path from each file path, making them relative
     $this->files = array_map(function ($path) {
         return str_replace(PROJECTROOT, '', $path);
     }, $this->files);
     // Construct ourselves a number of sub queries to check all the relevant records in the database
     $num = 0;
     foreach ($queries as $query) {
         $parser = new \PHPSQL\Parser();
         $parsed = $parser->parse($query, true);
         if (!isset($parsed['FROM']) || count($parsed['FROM']) === 0) {
             continue;
         }
         $aliases = array();
         foreach ($parsed['FROM'] as $part) {
             if ($part['expr_type'] == 'table' && in_array($part['table'], $tables)) {
                 $aliases[] = isset($part['alias']['name']) ? $part['alias']['name'] : $part['table'];
             }
         }
         $from_pos = $parsed['FROM'][0]['position'];
         if (isset($parsed['ORDER']) && count($parsed['ORDER']) > 0) {
             $append = ' FROM ' . substr($query, $from_pos, $parsed['ORDER'][0]['position'] - $from_pos - 10);
         } else {
             $append = ' FROM ' . substr($query, $from_pos);
         }
         if (count($aliases) > 1) {
             $append = ', (COUNT(' . implode('.id)+COUNT(', $aliases) . '.id)) as count' . $append;
         } else {
             if (count($aliases) === 1) {
                 $append = ', COUNT(' . $aliases[0] . '.id) as count' . $append;
             } else {
                 continue;
             }
         }
         $subqueries[] = 'q' . $num;
         $queryTables[] = '(SELECT ' . (count($aliases) > 1 ? 'GREATEST(' : '') . 'COALESCE(MAX(' . implode('.updated_at),\'1000-01-01\'), COALESCE(MAX(', $aliases) . '.updated_at),\'1000-01-01\')' . (count($aliases) > 1 ? ')' : '') . ' AS updated_at' . $append . ') q' . $num;
         $num++;
     }
     if (count($this->queries) > 0) {
         foreach ($this->queries as $query) {
             $parser = new \PHPSQL\Parser();
             $parsed = $parser->parse($query, true);
             $field = null;
             if (!isset($parsed['FROM']) || count($parsed['FROM']) === 0) {
                 continue;
             }
             if (!isset($parsed['SELECT']) || count($parsed['SELECT']) === 0) {
                 continue;
             }
             foreach ($parsed['SELECT'] as $select) {
                 if ($select['expr_type'] == 'colref') {
                     $field = $select['base_expr'];
                     break;
                 }
             }
             if ($field === null) {
                 continue;
             }
             $aliases = array();
             foreach ($parsed['FROM'] as $part) {
                 if ($part['expr_type'] == 'table') {
                     $aliases[] = isset($part['alias']['name']) ? $part['alias']['name'] : $part['table'];
                 }
             }
             $from_pos = $parsed['FROM'][0]['position'];
             if (isset($parsed['ORDER']) && count($parsed['ORDER']) > 0) {
                 $append = ' FROM ' . substr($query, $from_pos, $parsed['ORDER'][0]['position'] - $from_pos - 10);
             } else {
                 $append = ' FROM ' . substr($query, $from_pos);
             }
             if (count($aliases) > 1) {
                 $append = ', (COUNT(' . implode('.' . $field . ')+COUNT(', $aliases) . '.' . $field . ')) as count' . $append;
             } else {
                 if (count($aliases) === 1) {
                     $append = ', COUNT(' . $aliases[0] . '.' . $field . ') as count' . $append;
                 } else {
                     continue;
                 }
             }
             $subqueries[] = 'q' . $num;
             $queryTables[] = '(SELECT ' . (count($aliases) > 1 ? 'GREATEST(' : '') . 'COALESCE(MAX(' . implode('.' . $field . '),\'1000-01-01\'), COALESCE(MAX(', $aliases) . '.' . $field . '),\'1000-01-01\')' . (count($aliases) > 1 ? ')' : '') . ' AS updated_at' . $append . ') q' . $num;
             $num++;
         }
     }
     if (count($queryTables)) {
         // TODO: proper chunking of subqueries! For now, we will truncate them if they exeed MySQL's limit of 61
         if (count($queryTables) > 60) {
             $queryTables = array_slice($queryTables, 0, 60);
             $subqueries = array_slice($subqueries, 0, 60);
         }
         // Complete the mega query that will check if items are updated or not...
         if (count($subqueries) > 1) {
             $sql = 'SELECT GREATEST(' . implode('.updated_at, ', $subqueries) . '.updated_at) AS updated_at, (' . implode('.count+', $subqueries) . '.count) AS count FROM ' . implode(', ', $queryTables);
         } else {
             $sql = 'SELECT q0.updated_at, q0.count FROM ' . implode(', ', $queryTables);
         }
         // Run the query - this must be done now because we can't reliably get the correct results from what we have
         try {
             $result = \DB::query($sql)->execute()->as_array();
             $result = $result[0];
             $result['updated_at'] = strtotime($result['updated_at']);
         } catch (\Exception $e) {
             // We can't continue if the query doesn't work
             return;
         }
     }
     // Add the rest of the stuff to the result
     $result['query_count'] = $num;
     $result['sql'] = $sql;
     $result['files'] = $this->files;
     $result['content'] = strval($this->request->response);
     $result['nocache'] = \CMF\Cache::getNoCacheAreas($result['content']);
     $result['logs_made'] = \CMF\Log::$logs_made;
     $result['content-type'] = 'text/html; charset=utf-8';
     $result['template'] = \CMF::$template;
     $result['module'] = \CMF::$module;
     // Store the content type header if it's set
     $headers = headers_list();
     foreach ($headers as $header) {
         if (stripos($header, 'content-type: ') === 0) {
             $result['content-type'] = substr($header, 14);
             break;
         }
     }
     // serialize and write it to disk
     \CMF\Cache::writeCacheFile($this->path, serialize($result));
 }