cvs: php4 /pear/Cache/Container phplib.php

uw Sat Mar 3 03:46:19 2001 EDT Modified files: /php4/pear/Cache/Container phplib.php Log: bugfix: idExists(), inline Doc changes: class doc Index: php4/pear/Cache/Container/phplib.php diff -u php4/pear/Cache/Container/phplib.php:1.4 php4/pear/Cache/Container/phplib.php:1.5 --- php4/pear/Cache/Container/phplib.php:1.4 Fri Mar 2 06:16:38 2001 +++ php4/pear/Cache/Container/phplib.php Sat Mar 3 03:46:19 2001 @@ -16,29 +16,42 @@ // | Sebastian Bergmann <sb@sebastian-bergmann.de> | // +----------------------------------------------------------------------+ // -// $Id: phplib.php,v 1.4 2001/03/02 14:16:38 uw Exp $ +// $Id: phplib.php,v 1.5 2001/03/03 11:46:19 uw Exp $ -require_once 'Cache/Container.php'; +require_once '/Cache/Container.php'; -/* -CREATE TABLE cache ( - id CHAR(32) NOT NULL DEFAULT '', - content MEDIUMTEXT NOT NULL DEFAULT '', - expires INT(9) NOT NULL DEFAULT 0, - - changed TIMESTAMP(14), - - INDEX (expires), - PRIMARY KEY (id) -) -*/ - /** * Stores cache data into a database table. +* +* WARNING: Other systems might or might not support certain datatypes of +* the tables shown. As far as I know there's no large binary +* type in SQL-92 or SQL-99. Postgres seems to lack any +* BLOB or TEXT type, for MS-SQL you could use IMAGE, don't know +* about other databases. Please add sugestions for other databases to +* the inline docs. +* +* The field 'changed' has no meaning for the Cache itself. It's just there +* because it's a good idea to have an automatically updated timestamp +* field for debugging in all of your tables. +* +* For _MySQL_ you need this DB table: +* +* CREATE TABLE cache ( +* id CHAR(32) NOT NULL DEFAULT '', +* content BLOB NOT NULL DEFAULT '', +* expires INT(9) NOT NULL DEFAULT 0, +* +* changed TIMSTAMP(14) NOT NULL, +* +* INDEX (expires), +* PRIMARY KEY (id) +* ) +* * * @author Ulf Wendel <ulf.wendel@phpdoc.de>, Sebastian Bergmann <sb@sebastian-bergmann.de> -* @version $Id: phplib.php,v 1.4 2001/03/02 14:16:38 uw Exp $ +* @version $Id: phplib.php,v 1.5 2001/03/03 11:46:19 uw Exp $ * @package Cache +* @see save() */ class Cache_Container_phplib extends Cache_Container { @@ -115,10 +128,13 @@ return new CacheError("No database class specified.", __FILE__, __LINE__); // include the required files + if ($this->db_file) + include_once($this->db_path . $this->db_file); + if ($this->local_file) include_once($this->local_path . $this->local_file); - - // create a db object + + // create a db object $this->db = new $this->db_class; } // end constructor @@ -164,12 +180,12 @@ function delete($id) { $this->flushPreload($id); - - $query = sprintf("DELETE FROM %s WHERE id = '%s'", + $this->db->query( + sprintf("DELETE FROM %s WHERE id = '%s'", $this->cache_table, $id - ); - $this->db->query($query); + ) + ); return (boolean)$this->db->affected_rows(); } // end func delete @@ -178,9 +194,7 @@ function flush() { $this->flushPreload(); - - $query = sprintf("DELETE FROM %s", $this->cache_table); - $this->db->query($query); + $this->db->query(sprintf("DELETE FROM %s", $this->cache_table)); return $this->db->affected_rows(); } // end func flush @@ -188,11 +202,14 @@ function idExists($id) { - $query = sprintf("SELECT id FROM %s WHERE ID = '%s'", + $this->db->query( + sprintf("SELECT id FROM %s WHERE ID = '%s'", $this->cache_table, $id - ); - + ) + ); + + return $this->db->nf(); } // end func isExists @@ -200,11 +217,12 @@ $this->flushPreload(); - $query = sprintf("DELETE FORM %s WHERE expires <= %d AND expires > 0", + $this->db->query( + sprintf("DELETE FORM %s WHERE expires <= %d AND expires > 0", $this->cache_table, time() - ); - $this->db->query($query); + ) + ); } // end func garbageCollection