indexer
{
}

searchd
{
  listen = 127.0.0.1:9312
  log = /home/alex/doc/sb/simplebooker/log/searchd.log
  query_log = /home/alex/doc/sb/simplebooker/log/searchd.query.log
  pid_file = /home/alex/doc/sb/simplebooker/log/searchd.development.pid
}

source city_core_0
{
  type = pgsql
  sql_host = localhost
  sql_user = ror
  sql_pass = ror
  sql_db = sb_development
  sql_query = SELECT "cities"."id" * 2 + 0 AS "id" , "cities"."city" AS "city", "cities"."id" AS "sphinx_internal_id", 2372513034 AS "class_crc", '2372513034' AS "subclass_crcs", 0 AS "sphinx_deleted", COALESCE("cities"."city", '') AS "city_sort" FROM "cities"    WHERE "cities"."id" >= $start AND "cities"."id" <= $end GROUP BY "cities"."id", "cities"."city", "cities"."id", "cities"."city"
  sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "cities"
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_str2ordinal = city_sort
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM "cities" WHERE "id" = (($id - 0) / 2)
}

index city_core
{
  source = city_core_0
  path = /home/alex/doc/sb/simplebooker/db/sphinx/development/city_core
  charset_type = utf-8
  min_prefix_len = 1
}

index city
{
  type = distributed
  local = city_core
}

source letter_core_0
{
  type = pgsql
  sql_host = localhost
  sql_user = ror
  sql_pass = ror
  sql_db = sb_development
  sql_query_pre = UPDATE "letters" SET "delta" = FALSE WHERE "delta" = TRUE
  sql_query = SELECT "letters"."id" * 2 + 1 AS "id" , "letters"."title" AS "title", "users"."first_name" AS "sender_name_f", "to_users_letters"."first_name" AS "receiver_name_f", "users"."last_name" AS "sender_name_l", "to_users_letters"."last_name" AS "receiver_name_l", array_to_string(array_accum(COALESCE("letter_answers"."body", '0')), ' ') AS "letter_answer_body", "letters"."id" AS "sphinx_internal_id", 2309942076 AS "class_crc", '2309942076' AS "subclass_crcs", 0 AS "sphinx_deleted", "letters"."from_user_id" AS "from_user_id", "letters"."to_user_id" AS "to_user_id", cast(extract(epoch from "letters"."last_message_at") as int) AS "last_message_at" FROM "letters"    LEFT OUTER JOIN "users" ON "users".id = "letters".from_user_id   LEFT OUTER JOIN "users" to_users_letters ON "to_users_letters".id = "letters".to_user_id   LEFT OUTER JOIN "letter_answers" ON letter_answers.letter_id = letters.id  WHERE "letters"."id" >= $start AND "letters"."id" <= $end AND "letters"."delta" = FALSE GROUP BY "letters"."id", "letters"."title", "users"."first_name", "to_users_letters"."first_name", "users"."last_name", "to_users_letters"."last_name", "letters"."id", "letters"."from_user_id", "letters"."to_user_id", "letters"."last_message_at"
  sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "letters" WHERE "letters"."delta" = FALSE
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = from_user_id
  sql_attr_uint = to_user_id
  sql_attr_timestamp = last_message_at
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM "letters" WHERE "id" = (($id - 1) / 2)
}

index letter_core
{
  source = letter_core_0
  path = /home/alex/doc/sb/simplebooker/db/sphinx/development/letter_core
  charset_type = utf-8
  min_prefix_len = 1
}

source letter_delta_0 : letter_core_0
{
  type = pgsql
  sql_host = localhost
  sql_user = ror
  sql_pass = ror
  sql_db = sb_development
  sql_query_pre =
  sql_query = SELECT "letters"."id" * 2 + 1 AS "id" , "letters"."title" AS "title", "users"."first_name" AS "sender_name_f", "to_users_letters"."first_name" AS "receiver_name_f", "users"."last_name" AS "sender_name_l", "to_users_letters"."last_name" AS "receiver_name_l", array_to_string(array_accum(COALESCE("letter_answers"."body", '0')), ' ') AS "letter_answer_body", "letters"."id" AS "sphinx_internal_id", 2309942076 AS "class_crc", '2309942076' AS "subclass_crcs", 0 AS "sphinx_deleted", "letters"."from_user_id" AS "from_user_id", "letters"."to_user_id" AS "to_user_id", cast(extract(epoch from "letters"."last_message_at") as int) AS "last_message_at" FROM "letters"    LEFT OUTER JOIN "users" ON "users".id = "letters".from_user_id   LEFT OUTER JOIN "users" to_users_letters ON "to_users_letters".id = "letters".to_user_id   LEFT OUTER JOIN "letter_answers" ON letter_answers.letter_id = letters.id  WHERE "letters"."id" >= $start AND "letters"."id" <= $end AND "letters"."delta" = TRUE GROUP BY "letters"."id", "letters"."title", "users"."first_name", "to_users_letters"."first_name", "users"."last_name", "to_users_letters"."last_name", "letters"."id", "letters"."from_user_id", "letters"."to_user_id", "letters"."last_message_at"
  sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "letters" WHERE "letters"."delta" = TRUE
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = from_user_id
  sql_attr_uint = to_user_id
  sql_attr_timestamp = last_message_at
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM "letters" WHERE "id" = (($id - 1) / 2)
}

index letter_delta : letter_core
{
  source = letter_delta_0
  path = /home/alex/doc/sb/simplebooker/db/sphinx/development/letter_delta
}

index letter
{
  type = distributed
  local = letter_delta
  local = letter_core
}