3 * StatusNet - the distributed open-source microblogging tool
4 * Copyright (C) 2008, 2009, StatusNet, Inc.
6 * This program is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU Affero General Public License as published by
8 * the Free Software Foundation, either version 3 of the License, or
9 * (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU Affero General Public License for more details.
16 * You should have received a copy of the GNU Affero General Public License
17 * along with this program. If not, see <http://www.gnu.org/licenses/>.
20 if (!defined('STATUSNET') && !defined('LACONICA')) { exit(1); }
22 class Memcached_DataObject extends DB_DataObject
25 * Destructor to free global memory resources associated with
26 * this data object when it's unset or goes out of scope.
27 * DB_DataObject doesn't do this yet by itself.
33 if (method_exists('DB_DataObject', '__destruct')) {
39 * Magic function called at serialize() time.
41 * We use this to drop a couple process-specific references
42 * from DB_DataObject which can cause trouble in future
45 * @return array of variable names to include in serialization.
49 $vars = array_keys(get_object_vars($this));
50 $skip = array('_DB_resultid', '_link_loaded');
51 return array_diff($vars, $skip);
55 * Magic function called at unserialize() time.
57 * Clean out some process-specific variables which might
58 * be floating around from a previous process's cached
61 * Old cached objects may still have them.
65 // Refers to global state info from a previous process.
66 // Clear this out so we don't accidentally break global
67 // state in *this* process.
68 $this->_DB_resultid = null;
69 // We don't have any local DBO refs, so clear these out.
70 $this->_link_loaded = false;
74 * Wrapper for DB_DataObject's static lookup using memcached
75 * as backing instead of an in-process cache array.
77 * @param string $cls classname of object type to load
78 * @param mixed $k key field name, or value for primary key
79 * @param mixed $v key field value, or leave out for primary key lookup
80 * @return mixed Memcached_DataObject subtype or false
82 function &staticGet($cls, $k, $v=null)
92 $i = Memcached_DataObject::getcached($cls, $k, $v);
93 if ($i !== false) { // false == cache miss
96 $i = DB_DataObject::factory($cls);
100 $result = $i->get($k, $v);
105 // save the fact that no such row exists
106 $c = self::memcache();
108 $ck = self::cachekey($cls, $k, $v);
116 function &pkeyGet($cls, $kv)
118 $i = Memcached_DataObject::multicache($cls, $kv);
119 if ($i !== false) { // false == cache miss
122 $i = DB_DataObject::factory($cls);
126 foreach ($kv as $k => $v) {
129 if ($i->find(true)) {
133 $c = self::memcache();
135 $ck = self::multicacheKey($cls, $kv);
145 $result = parent::insert();
146 $this->encache(); // in case of cached negative lookups
150 function update($orig=null)
152 if (is_object($orig) && $orig instanceof Memcached_DataObject) {
153 $orig->decache(); # might be different keys
155 $result = parent::update($orig);
164 $this->decache(); # while we still have the values!
165 return parent::delete();
168 static function memcache() {
169 return common_memcache();
172 static function cacheKey($cls, $k, $v) {
173 if (is_object($cls) || is_object($k) || is_object($v)) {
174 $e = new Exception();
175 common_log(LOG_ERR, __METHOD__ . ' object in param: ' .
176 str_replace("\n", " ", $e->getTraceAsString()));
178 return common_cache_key(strtolower($cls).':'.$k.':'.$v);
181 static function getcached($cls, $k, $v) {
182 $c = Memcached_DataObject::memcache();
186 return $c->get(Memcached_DataObject::cacheKey($cls, $k, $v));
192 global $_DB_DATAOBJECT;
193 if (!isset($_DB_DATAOBJECT['INI'][$this->_database][$this->__table."__keys"])) {
194 $this->databaseStructure();
197 return $_DB_DATAOBJECT['INI'][$this->_database][$this->__table."__keys"];
202 $c = $this->memcache();
208 $keys = $this->_allCacheKeys();
210 foreach ($keys as $key) {
211 $c->set($key, $this);
217 $c = $this->memcache();
223 $keys = $this->_allCacheKeys();
225 foreach ($keys as $key) {
226 $c->delete($key, $this);
230 function _allCacheKeys()
234 $types = $this->keyTypes();
240 foreach ($types as $key => $type) {
242 assert(!empty($key));
245 if (empty($this->$key)) {
248 $ckeys[] = $this->cacheKey($this->tableName(), $key, $this->$key);
249 } else if ($type == 'K' || $type == 'N') {
251 $pval[] = $this->$key;
253 throw new Exception("Unknown key type $key => $type for " . $this->tableName());
257 assert(count($pkey) > 0);
259 // XXX: should work for both compound and scalar pkeys
260 $pvals = implode(',', $pval);
261 $pkeys = implode(',', $pkey);
263 $ckeys[] = $this->cacheKey($this->tableName(), $pkeys, $pvals);
268 function multicache($cls, $kv)
271 $c = self::memcache();
275 return $c->get(self::multicacheKey($cls, $kv));
279 static function multicacheKey($cls, $kv)
282 $pkeys = implode(',', array_keys($kv));
283 $pvals = implode(',', array_values($kv));
284 return self::cacheKey($cls, $pkeys, $pvals);
287 function getSearchEngine($table)
289 require_once INSTALLDIR.'/lib/search_engines.php';
290 static $search_engine;
291 if (!isset($search_engine)) {
292 if (Event::handle('GetSearchEngine', array($this, $table, &$search_engine))) {
293 if ('mysql' === common_config('db', 'type')) {
294 $type = common_config('search', 'type');
295 if ($type == 'like') {
296 $search_engine = new MySQLLikeSearch($this, $table);
297 } else if ($type == 'fulltext') {
298 $search_engine = new MySQLSearch($this, $table);
300 throw new ServerException('Unknown search type: ' . $type);
303 $search_engine = new PGSearch($this, $table);
307 return $search_engine;
310 static function cachedQuery($cls, $qry, $expiry=3600)
312 $c = Memcached_DataObject::memcache();
318 $key_part = common_keyize($cls).':'.md5($qry);
319 $ckey = common_cache_key($key_part);
320 $stored = $c->get($ckey);
322 if ($stored !== false) {
323 return new ArrayWrapper($stored);
329 while ($inst->fetch()) {
330 $cached[] = clone($inst);
333 $c->set($ckey, $cached, MEMCACHE_COMPRESSED, $expiry);
334 return new ArrayWrapper($cached);
337 // We overload so that 'SET NAMES "utf8"' is called for
342 global $_DB_DATAOBJECT;
344 $sum = $this->_getDbDsnMD5();
346 if (!empty($_DB_DATAOBJECT['CONNECTIONS'][$sum]) &&
347 !PEAR::isError($_DB_DATAOBJECT['CONNECTIONS'][$sum])) {
353 $result = parent::_connect();
355 if ($result && !$exists) {
356 $DB = &$_DB_DATAOBJECT['CONNECTIONS'][$this->_database_dsn_md5];
357 if (common_config('db', 'type') == 'mysql' &&
358 common_config('db', 'utf8')) {
359 $conn = $DB->connection;
361 if ($DB instanceof DB_mysqli) {
362 mysqli_set_charset($conn, 'utf8');
363 } else if ($DB instanceof DB_mysql) {
364 mysql_set_charset('utf8', $conn);
373 // XXX: largely cadged from DB_DataObject
375 function _getDbDsnMD5()
377 if ($this->_database_dsn_md5) {
378 return $this->_database_dsn_md5;
381 $dsn = $this->_getDbDsn();
383 if (is_string($dsn)) {
386 /// support array based dsn's
387 $sum = md5(serialize($dsn));
395 global $_DB_DATAOBJECT;
397 if (empty($_DB_DATAOBJECT['CONFIG'])) {
398 DB_DataObject::_loadConfig();
401 $options = &$_DB_DATAOBJECT['CONFIG'];
403 // if the databse dsn dis defined in the object..
405 $dsn = isset($this->_database_dsn) ? $this->_database_dsn : null;
409 if (!$this->_database) {
410 $this->_database = isset($options["table_{$this->__table}"]) ? $options["table_{$this->__table}"] : null;
413 if ($this->_database && !empty($options["database_{$this->_database}"])) {
414 $dsn = $options["database_{$this->_database}"];
415 } else if (!empty($options['database'])) {
416 $dsn = $options['database'];
421 throw new Exception("No database name / dsn found anywhere");