From 4206f4d9614e2d04d968355775d6ea6e536c9cad Mon Sep 17 00:00:00 2001 From: millette Date: Sun, 23 Nov 2008 15:16:16 -0500 Subject: sphinx: fallback if no connection darcs-hash:20081123201616-099f7-54ac0134e38e145b99a81336ae0b51a8ecd560a8.gz --- classes/Memcached_DataObject.php | 17 +++++-- classes/SearchEngines.php | 104 --------------------------------------- 2 files changed, 12 insertions(+), 109 deletions(-) delete mode 100644 classes/SearchEngines.php (limited to 'classes') diff --git a/classes/Memcached_DataObject.php b/classes/Memcached_DataObject.php index e1d58dd70..674de9bc5 100644 --- a/classes/Memcached_DataObject.php +++ b/classes/Memcached_DataObject.php @@ -171,15 +171,22 @@ class Memcached_DataObject extends DB_DataObject } function getSearchEngine($table) { - require_once INSTALLDIR.'/classes/SearchEngines.php'; + require_once INSTALLDIR.'/lib/search_engines.php'; static $search_engine; if (!isset($search_engine)) { + $connected = false; if (common_config('sphinx', 'enabled')) { $search_engine = new SphinxSearch($this, $table); - } elseif ('mysql' === common_config('db', 'type')) { - $search_engine = new MySQLSearch($this, $table); - } else { - $search_engine = new PGSearch($this, $table); + $connected = $search_engine->is_connected(); + } + + // unable to connect to sphinx' search daemon + if (!$connected) { + if ('mysql' === common_config('db', 'type')) { + $search_engine = new MySQLSearch($this, $table); + } else { + $search_engine = new PGSearch($this, $table); + } } } return $search_engine; diff --git a/classes/SearchEngines.php b/classes/SearchEngines.php deleted file mode 100644 index 96fd7da90..000000000 --- a/classes/SearchEngines.php +++ /dev/null @@ -1,104 +0,0 @@ -. - */ - -if (!defined('LACONICA')) { exit(1); } - -class SearchEngine { - protected $target; - protected $table; - - function __construct($target, $table) { - $this->target = $target; - $this->table = $table; - } - - function query($q) { - } - - function limit($offset, $count, $rss = false) { - return $this->target->limit($offset, $count); - } - - function set_sort_mode($mode) { - if ('chron' === $mode) - return $this->target->orderBy('created desc'); - } -} - -class SphinxSearch extends SearchEngine { - private $sphinx; - - function __construct($target, $table) { - parent::__construct($target, $table); - $this->sphinx = new SphinxClient; - $this->sphinx->setServer(common_config('sphinx', 'server'), common_config('sphinx', 'port')); - } - - function limit($offset, $count, $rss = false) { - //FIXME without LARGEST_POSSIBLE, the most recent results aren't returned - // this probably has a large impact on performance - $LARGEST_POSSIBLE = 1e6; - - if ($rss) { - $this->sphinx->setLimits($offset, $count, $count, $LARGEST_POSSIBLE); - } - else { - // return at most 50 pages of results - $this->sphinx->setLimits($offset, $count, 50 * ($count - 1), $LARGEST_POSSIBLE); - } - - return $this->target->limit(0, $count); - } - - function query($q) { - $result = $this->sphinx->query($q, $this->table); - if (!isset($result['matches'])) return false; - $id_set = join(', ', array_keys($result['matches'])); - $this->target->whereAdd("id in ($id_set)"); - return true; - } - - function set_sort_mode($mode) { - if ('chron' === $mode) { - $this->sphinx->SetSortMode(SPH_SORT_ATTR_DESC, 'created_ts'); - return $this->target->orderBy('created desc'); - } - } -} - -class MySQLSearch extends SearchEngine { - function query($q) { - if ('identica_people' === $this->table) - return $this->target->whereAdd('MATCH(nickname, fullname, location, bio, homepage) ' . - 'against (\''.addslashes($q).'\')'); - if ('identica_notices' === $this->table) - return $this->target->whereAdd('MATCH(content) ' . - 'against (\''.addslashes($q).'\')'); - } -} - -class PGSearch extends SearchEngine { - function query($q) { - if ('identica_people' === $this->table) - return $this->target->whereAdd('textsearch @@ plainto_tsquery(\''.addslashes($q).'\')'); - if ('identica_notices' === $this->table) - return $this->target->whereAdd('to_tsvector(\'english\', content) @@ plainto_tsquery(\''.addslashes($q).'\')'); - } -} - -- cgit v1.2.3-54-g00ecf