BootPress\Asset\Component::paths()

Complexity

Conditions	14
Paths	90

Size

Total Lines	67
Code Lines	52

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	61
CRAP Score	14

Importance

Changes	2
Bugs	0	Features	0

<?php
    private function paths(&$cache)
    {
        $page = Page::html();
        $count = 0;
        foreach ($cache as $dir => $files) {
            $count += count($files);
        }
        $ids = $this->ids($count);
        $insert = array();
        $update = array();
        $stmt = $this->db->prepare(array(
            'SELECT f.id AS file_id, f.updated, p.tiny, p.id AS path_id',
            'FROM files AS f INNER JOIN paths AS p ON f.id = p.file_id',
            'WHERE f.file = ? AND f.query = ?',
        ), 'assoc');
        foreach ($cache as $dir => $files) {
            foreach ($files as $path => $tiny) {
                list($file, $query) = explode('?', $path.'?');
                $file = $page->dir[$dir].$file;
                $updated = filemtime($file);
                $this->db->execute($stmt, array($file, $query));
                if ($row = $this->db->fetch($stmt)) {
                    if ($row['updated'] == $updated) {
                        $tiny = $row['tiny'];
                    } else {
                        list($path_id, $tiny) = each($ids);
                        $update[$row['file_id']] = array($path_id, $updated);
                    }
                } else {
                    list($path_id, $tiny) = each($ids);
                    $insert[] = array($path_id, $file, $query, $updated);
                }
                $cache[$dir][$path] = $tiny;
            }
        }
        $this->db->close($stmt);
        if (empty($insert) && empty($update)) {
            return;
        }
        $this->db->exec('BEGIN IMMEDIATE');
        $paths = array();
        if (!empty($insert)) {
            $stmt = $this->db->insert('files', array('path_id', 'file', 'query', 'updated'));
            foreach ($insert as $array) {
                $paths[$array[0]] = $this->db->insert($stmt, $array);
            }
            $this->db->close($stmt);
        }
        if (!empty($update)) {
            $stmt = $this->db->update('files', 'id', array('path_id', 'updated'));
            foreach ($update as $file_id => $array) {
                $this->db->update($stmt, $file_id, $array);
                $paths[$array[0]] = $file_id;
            }
            $this->db->close($stmt);
        }
        if (!empty($paths)) {
            $stmt = $this->db->update('paths', 'id', array('file_id'));
            foreach ($paths as $path_id => $file_id) {
                $this->db->update($stmt, $path_id, array($file_id));
            }
            $this->db->close($stmt);
        }
        $this->db->exec('COMMIT');

        return;
    }