123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143 |
- <?php
- define('INSTALLDIR', dirname(__DIR__, 3));
- define('PUBLICDIR', INSTALLDIR . DIRECTORY_SEPARATOR . 'public');
- $longoptions = array('base=', 'network');
- $helptext = <<<END_OF_TRIM_HELP
- Generates sphinx.conf file based on StatusNet configuration.
- --base Base dir to Sphinx install
- (default /usr/local)
- --network Use status_network global config table
- (non-functional at present)
- END_OF_TRIM_HELP;
- require_once INSTALLDIR . '/scripts/commandline.inc';
- require dirname(__FILE__) . '/sphinx-utils.php';
- $timestamp = date('r');
- print <<<END
- #
- # Sphinx configuration for StatusNet
- # Generated {$timestamp}
- #
- END;
- sphinx_iterate_sites('sphinx_site_template');
- print <<<END
- indexer
- {
- mem_limit = 300M
- }
- searchd
- {
- port = 3312
- log = {$base}/log/searchd.log
- query_log = {$base}/log/query.log
- read_timeout = 5
- max_children = 30
- pid_file = {$base}/log/searchd.pid
- max_matches = 1000
- seamless_rotate = 1
- preopen_indexes = 0
- unlink_old = 1
- }
- END;
- function sphinx_site_template($sn)
- {
- if (common_config('db', 'type') !== 'mysql') {
- $created_ts = sprintf(
- '((EXTRACT(DAY %1$s) * 24 + EXTRACT(HOUR %1$s)) * 60 + ' .
- 'EXTRACT(MINUTE %1$s)) * 60 + FLOOR(EXTRACT(SECOND %1$s)) AS "created_ts"',
- 'FROM ("created" - TIMESTAMP \'1970-01-01 00:00:00\')'
- );
- } else {
- $created_ts = "timestampdiff(SECOND, '1970-01-01', `created`) AS `created_ts`";
- }
- return
- sphinx_template(
- $sn,
- 'profile',
- 'SELECT id, ' . $created_ts . ', nickname, fullname, location, bio, homepage FROM profile',
- 'SELECT * FROM profile WHERE id = $id'
- ) .
- sphinx_template(
- $sn,
- 'notice',
- 'SELECT id, ' . $created_ts . ', content FROM notice',
- 'SELECT * FROM notice WHERE notice.id = $id AND notice.is_local <> -2'
- );
- }
- function sphinx_template($sn, $table, $query, $query_info)
- {
- $base = sphinx_base();
- $dbtype = common_config('db', 'type');
- print <<<END
- #
- # {$sn->sitename}
- #
- source {$sn->dbname}_src_{$table}
- {
- type = {$dbtype}
- sql_host = {$sn->dbhost}
- sql_user = {$sn->dbuser}
- sql_pass = {$sn->dbpass}
- sql_db = {$sn->dbname}
- sql_query_pre = SET NAMES utf8;
- sql_query = {$query}
- sql_query_info = {$query_info}
- sql_attr_timestamp = created_ts
- }
- index {$sn->dbname}_{$table}
- {
- source = {$sn->dbname}_src_{$table}
- path = {$base}/data/{$sn->dbname}_{$table}
- docinfo = extern
- charset_type = utf-8
- min_word_len = 3
- }
- END;
- }
|