development.sphinx.conf

indexer
{
  mem_limit = 4096M
}

searchd
{
  listen = 0.0.0.0:9312
  log = /Users/mikemondragon/projects/hark/search-engine/spec/dummy/log/searchd.log
  query_log = /Users/mikemondragon/projects/hark/search-engine/spec/dummy/log/searchd.query.log
  pid_file = /Users/mikemondragon/projects/hark/search-engine/spec/dummy/log/searchd.development.pid
  max_matches = 50000
}

source logophile_clip_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 
  sql_db = hark_development
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT SQL_NO_CACHE `clips`.`id` * CAST(2 AS SIGNED) + 0 AS `id` , lower(clips.name) AS `name`, `clips`.`description` AS `description`, `clips`.`quote` AS `quote`, `clips`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 1542246985 AS `class_crc`, IFNULL(lower(clips.name), '') AS `name_sort`, `clips`.`explicit` AS `explicit`, `clips`.`downloadable` AS `downloadable`, `clips`.`listens` AS `listens`, `clips`.`listens_day` AS `listens_day`, `clips`.`listens_week` AS `listens_week`, UNIX_TIMESTAMP(`clips`.`created_at`) AS `date`, UNIX_TIMESTAMP(`clips`.`updated_at`) AS `updated` FROM `clips`  WHERE (`clips`.`id` >= $start AND `clips`.`id` <= $end AND published = 1 AND deleted = 0 AND removed = 0 AND private = 0 AND duplicate = 0 AND (canonical_clip_id = clips.id OR canonical_clip_id is NULL)) GROUP BY `clips`.`id` ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `clips` 
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = class_crc
  sql_attr_uint = listens
  sql_attr_uint = listens_day
  sql_attr_uint = listens_week
  sql_attr_bool = explicit
  sql_attr_bool = downloadable
  sql_attr_timestamp = date
  sql_attr_timestamp = updated
  sql_attr_str2ordinal = name_sort
  sql_query_info = SELECT * FROM `clips` WHERE `id` = (($id - 0) / 2)
}

index logophile_clip_core
{
  source = logophile_clip_core_0
  path = /Users/mikemondragon/projects/hark/search-engine/spec/dummy/db/sphinx/development/logophile_clip_core
  charset_type = utf-8
  min_prefix_len = 1
  min_infix_len = 0
  enable_star = 1
}

index logophile_clip
{
  type = distributed
  local = logophile_clip_core
}

source standard_collection_index_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 
  sql_db = hark_development
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT SQL_NO_CACHE `collections`.`id` * CAST(2 AS SIGNED) + 1 AS `id` , lower(collections.name) AS `name`, description AS `description`, `collections`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 711738067 AS `class_crc`, IFNULL(lower(collections.name), '') AS `name_sort`, UNIX_TIMESTAMP(`collections`.`created_at`) AS `date`, UNIX_TIMESTAMP(`collections`.`updated_at`) AS `updated`, `collections`.`views` AS `views`, `collections`.`views_day` AS `views_day`, `collections`.`views_week` AS `views_week`, `collections`.`clips_count` AS `clip_count` FROM `collections`  WHERE (`collections`.`id` >= $start AND `collections`.`id` <= $end AND clips_count <> 0 AND collections.id NOT IN (4482, 3891, 80273, 85034, 5855, 80093, 7535, 84818, 3678, 79888, 80058, 80055, 6004, 80718, 6123, 80181, 80227, 5935) AND collections.duplicate_id IS NULL) GROUP BY `collections`.`id` ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `collections` 
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = class_crc
  sql_attr_uint = views
  sql_attr_uint = views_day
  sql_attr_uint = views_week
  sql_attr_uint = clip_count
  sql_attr_timestamp = date
  sql_attr_timestamp = updated
  sql_attr_str2ordinal = name_sort
  sql_query_info = SELECT * FROM `collections` WHERE `id` = (($id - 1) / 2)
}

index standard_collection_index_core
{
  source = standard_collection_index_core_0
  path = /Users/mikemondragon/projects/hark/search-engine/spec/dummy/db/sphinx/development/standard_collection_index_core
  charset_type = utf-8
  min_prefix_len = 1
  min_infix_len = 0
  enable_star = 1
}

index standard_collection_index
{
  type = distributed
  local = standard_collection_index_core
}