extension.cache.sqlite3.php

Go to the documentation of this file.

<?php
//  available at http://getid3.sourceforge.net                                 //
//            or http://www.getid3.org                                         //
//          also https://github.com/JamesHeinrich/getID3                       //
// extension.cache.sqlite3.php - part of getID3()                              //
// Please see readme.txt for more information                                  //
//                                                                            ///
// MySQL extension written by Allan Hansen <ahØartemis*dk>                     //
// Table name mod by Carlo Capocasa <calroØcarlocapocasa*com>                  //
// MySQL extension was reworked for SQLite3 by Karl G. Holz <newaeonØmac*com>  //
//                                                                            ///

class getID3_cached_sqlite3 extends getID3 {

        public function __construct($table='getid3_cache', $hide=false) {
                $this->table = $table; // Set table
                $file = dirname(__FILE__).'/'.basename(__FILE__, 'php').'sqlite';
                if ($hide) {
                        $file = dirname(__FILE__).'/.ht.'.basename(__FILE__, 'php').'sqlite';
                }
                $this->db = new SQLite3($file);
                $db = $this->db;
                $this->create_table();   // Create cache table if not exists
                $version = '';
                $sql = $this->version_check;
                $stmt = $db->prepare($sql);
                $stmt->bindValue(':filename', getID3::VERSION, SQLITE3_TEXT);
                $result = $stmt->execute();
                list($version) = $result->fetchArray();
                if ($version != getID3::VERSION) { // Check version number and clear cache if changed
                        $this->clear_cache();
                }
                return parent::__construct();
        }

        public function __destruct() {
                $db=$this->db;
                $db->close();
        }

        private $db;

        private $table;

        private function clear_cache() {
                $db = $this->db;
                $sql = $this->delete_cache;
                $db->exec($sql);
                $sql = $this->set_version;
                $stmt = $db->prepare($sql);
                $stmt->bindValue(':filename', getID3::VERSION, SQLITE3_TEXT);
                $stmt->bindValue(':dirname', getID3::VERSION, SQLITE3_TEXT);
                $stmt->bindValue(':val', getID3::VERSION, SQLITE3_TEXT);
                return $stmt->execute();
        }

        public function analyze($filename, $filesize=null, $original_filename='') {
                if (!file_exists($filename)) {
                        return false;
                }
                // items to track for caching
                $filetime = filemtime($filename);
                $filesize = filesize($filename);
                // this will be saved for a quick directory lookup of analized files
                // ... why do 50 seperate sql quries when you can do 1 for the same result
                $dirname  = dirname($filename);
                // Lookup file
                $db = $this->db;
                $sql = $this->get_id3_data;
                $stmt = $db->prepare($sql);
                $stmt->bindValue(':filename', $filename, SQLITE3_TEXT);
                $stmt->bindValue(':filesize', $filesize, SQLITE3_INTEGER);
                $stmt->bindValue(':filetime', $filetime, SQLITE3_INTEGER);
                $res = $stmt->execute();
                list($result) = $res->fetchArray();
                if (count($result) > 0 ) {
                        return unserialize(base64_decode($result));
                }
                // if it hasn't been analyzed before, then do it now
                $analysis = parent::analyze($filename, $filesize=null, $original_filename='');
                // Save result
                $sql = $this->cache_file;
                $stmt = $db->prepare($sql);
                $stmt->bindValue(':filename', $filename, SQLITE3_TEXT);
                $stmt->bindValue(':dirname', $dirname, SQLITE3_TEXT);
                $stmt->bindValue(':filesize', $filesize, SQLITE3_INTEGER);
                $stmt->bindValue(':filetime', $filetime, SQLITE3_INTEGER);
                $stmt->bindValue(':atime', time(), SQLITE3_INTEGER);
                $stmt->bindValue(':val', base64_encode(serialize($analysis)), SQLITE3_TEXT);
                $res = $stmt->execute();
                return $analysis;
        }

        private function create_table() {
                $db = $this->db;
                $sql = $this->make_table;
                return $db->exec($sql);
        }

        public function get_cached_dir($dir) {
                $db = $this->db;
                $rows = array();
                $sql = $this->get_cached_dir;
                $stmt = $db->prepare($sql);
                $stmt->bindValue(':dirname', $dir, SQLITE3_TEXT);
                $res = $stmt->execute();
                while ($row=$res->fetchArray()) {
                        $rows[] = unserialize(base64_decode($row));
                }
                return $rows;
        }

        public function __get($name) {
                switch($name) {
                        case 'version_check':
                                return "SELECT val FROM $this->table WHERE filename = :filename AND filesize = '-1' AND filetime = '-1' AND analyzetime = '-1'";
                                break;
                        case 'delete_cache':
                                return "DELETE FROM $this->table";
                                break;
                        case 'set_version':
                                return "INSERT INTO $this->table (filename, dirname, filesize, filetime, analyzetime, val) VALUES (:filename, :dirname, -1, -1, -1, :val)";
                                break;
                        case 'get_id3_data':
                                return "SELECT val FROM $this->table WHERE filename = :filename AND filesize = :filesize AND filetime = :filetime";
                                break;
                        case 'cache_file':
                                return "INSERT INTO $this->table (filename, dirname, filesize, filetime, analyzetime, val) VALUES (:filename, :dirname, :filesize, :filetime, :atime, :val)";
                                break;
                        case 'make_table':
                                //return "CREATE TABLE IF NOT EXISTS $this->table (filename VARCHAR(255) NOT NULL DEFAULT '', dirname VARCHAR(255) NOT NULL DEFAULT '', filesize INT(11) NOT NULL DEFAULT '0', filetime INT(11) NOT NULL DEFAULT '0', analyzetime INT(11) NOT NULL DEFAULT '0', val text not null, PRIMARY KEY (filename, filesize, filetime))";
                                return "CREATE TABLE IF NOT EXISTS $this->table (filename VARCHAR(255) DEFAULT '', dirname VARCHAR(255) DEFAULT '', filesize INT(11) DEFAULT '0', filetime INT(11) DEFAULT '0', analyzetime INT(11) DEFAULT '0', val text, PRIMARY KEY (filename, filesize, filetime))";
                                break;
                        case 'get_cached_dir':
                                return "SELECT val FROM $this->table WHERE dirname = :dirname";
                                break;
                }
                return null;
        }

}