indexer
{
}

searchd
{
  listen = 127.0.0.1:9306:mysql41
  log = /home/darkwater/work/geotech_1c/log/development.searchd.log
  query_log = /home/darkwater/work/geotech_1c/log/development.searchd.query.log
  pid_file = /home/darkwater/work/geotech_1c/log/development.sphinx.pid
  workers = threads
  binlog_path = /home/darkwater/work/geotech_1c/tmp/binlog/development
}

source product_core_0
{
  type = pgsql
  sql_host = localhost
  sql_user = darkwater
  sql_pass = 555
  sql_db = geotech_1c
  sql_query_pre = SET TIME ZONE UTC
  sql_query = SELECT "products"."id" * 2 + 0 AS "id", "products"."title" AS "title", "products"."description" AS "description", "products"."supplier_code" AS "supplier_code", "products"."id" AS "sphinx_internal_id", 'Product' AS "sphinx_internal_class", 0 AS "sphinx_deleted", extract(epoch from "products"."created_at")::int AS "created_at", extract(epoch from "products"."updated_at")::int AS "updated_at" FROM "products" WHERE ("products"."id" BETWEEN $start AND $end) GROUP BY "products"."id", "products"."title", "products"."description", "products"."supplier_code", "products"."id", "products"."created_at", "products"."updated_at"
  sql_query_range = SELECT COALESCE(MIN("products"."id"), 1), COALESCE(MAX("products"."id"), 1) FROM "products"
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_timestamp = created_at
  sql_attr_timestamp = updated_at
  sql_attr_string = sphinx_internal_class
  sql_field_string = title
  sql_field_string = supplier_code
}

index product_core
{
  type = plain
  path = /home/darkwater/work/geotech_1c/db/sphinx/development/product_core
  docinfo = extern
  source = product_core_0
}

index product
{
  type = distributed
  local = product_core
}