MySQL::__construct( string $location, string $name, SimplePie\Cache\Base::TYPE_FEED|SimplePie\Cache\Base::TYPE_IMAGE $type )

90    public function __construct($location, $name, $type)91    {92        $this->options = [93            'user' => null,94            'pass' => null,95            'host' => '127.0.0.1',96            'port' => '3306',97            'path' => '',98            'extras' => [99                'prefix' => '',100                'cache_purge_time' => 2592000101            ],102        ];103 104        $this->options = array_replace_recursive($this->options, \SimplePie\Cache::parse_URL($location));105 106        // Path is prefixed with a "/"107        $this->options['dbname'] = substr($this->options['path'], 1);108 109        try {110            $this->mysql = new \PDO("mysql:dbname={$this->options['dbname']};host={$this->options['host']};port={$this->options['port']}", $this->options['user'], $this->options['pass'], [\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8']);111        } catch (\PDOException $e) {112            $this->mysql = null;113            return;114        }115 116        $this->id = $name . $type;117 118        if (!$query = $this->mysql->query('SHOW TABLES')) {119            $this->mysql = null;120            return;121        }122 123        $db = [];124        while ($row = $query->fetchColumn()) {125            $db[] = $row;126        }127 128        if (!in_array($this->options['extras']['prefix'] . 'cache_data', $db)) {129            $query = $this->mysql->exec('CREATE TABLE `' . $this->options['extras']['prefix'] . 'cache_data` (`id` TEXT CHARACTER SET utf8 NOT NULL, `items` SMALLINT NOT NULL DEFAULT 0, `data` BLOB NOT NULL, `mtime` INT UNSIGNED NOT NULL, UNIQUE (`id`(125)))');130            if ($query === false) {131                trigger_error("Can't create " . $this->options['extras']['prefix'] . "cache_data table, check permissions", \E_USER_WARNING);132                $this->mysql = null;133                return;134            }135        }136 137        if (!in_array($this->options['extras']['prefix'] . 'items', $db)) {138            $query = $this->mysql->exec('CREATE TABLE `' . $this->options['extras']['prefix'] . 'items` (`feed_id` TEXT CHARACTER SET utf8 NOT NULL, `id` TEXT CHARACTER SET utf8 NOT NULL, `data` MEDIUMBLOB NOT NULL, `posted` INT UNSIGNED NOT NULL, INDEX `feed_id` (`feed_id`(125)))');139            if ($query === false) {140                trigger_error("Can't create " . $this->options['extras']['prefix'] . "items table, check permissions", \E_USER_WARNING);141                $this->mysql = null;142                return;143            }144        }145    }