development.sphinx.conf

indexer
{
}

searchd
{
  listen = 127.0.0.1:9312:mysql41
  log = /home/declan/Sites/purplebinder/log/development.searchd.log
  query_log = /home/declan/Sites/purplebinder/log/development.searchd.query.log
  pid_file = /home/declan/Sites/purplebinder/log/development.sphinx.pid
  max_matches = 10000
  workers = threads
  binlog_path = /home/declan/Sites/purplebinder/tmp/binlog/development
}

source location_program_core_0
{
  type = pgsql
  sql_host = localhost
  sql_user = railsdev
  sql_pass = railsdev
  sql_db = purplebinder
  sql_port = 5433
  sql_query_pre = SET TIME ZONE UTC
  sql_query = SELECT "location_programs"."id" * 3 + 0 AS "id", "programs"."name" AS "name", "programs"."description" AS "description", "programs"."services_offered" AS "services_offered", "programs"."eligibility" AS "eligibility", "programs"."referral_instructions" AS "referral_instructions", "organizations"."name" AS "org_name", "programs"."languages" AS "languages", array_to_string(array_agg(DISTINCT "datasets"."url"), ' ') AS "dataset", "new_locations"."name" AS "location_name", "location_programs"."id" AS "sphinx_internal_id", 'LocationProgram' AS "sphinx_internal_class", 0 AS "sphinx_deleted", "location_programs"."program_id" AS "program_id", "programs"."percent_complete" AS "percent_complete", "programs"."hidden" AS "program_hidden", RADIANS((SELECT lat FROM new_locations WHERE id = location_id)) AS "lat", RADIANS((SELECT lng FROM new_locations WHERE id = location_id)) AS "lng", "eligibilities"."men" AS "men", "eligibilities"."women" AS "women", "eligibilities"."residential" AS "residential", "eligibilities"."inpatient" AS "inpatient", "eligibilities"."intensive_outpatient" AS "intensive_outpatient", "eligibilities"."outpatient" AS "outpatient", "eligibilities"."child" AS "child", "eligibilities"."adolescent" AS "adolescent", "eligibilities"."adult" AS "adult", "eligibilities"."geriatric" AS "geriatric", "eligibilities"."free" AS "free", "eligibilities"."private_insurance" AS "private_insurance", "eligibilities"."medicaid" AS "medicaid", "eligibilities"."medicare" AS "medicare", "eligibilities"."sliding_scale" AS "sliding_scale", "programs"."closed" AS "closed", "new_locations"."is_mailing" AS "is_mailing" FROM "location_programs" LEFT OUTER JOIN "programs" ON "programs"."id" = "location_programs"."program_id" LEFT OUTER JOIN "organizations" ON "organizations"."id" = "programs"."organization_id" LEFT OUTER JOIN "dataset_programs" ON "dataset_programs"."program_id" = "programs"."id" LEFT OUTER JOIN "datasets" ON "datasets"."id" = "dataset_programs"."dataset_id" LEFT OUTER JOIN "eligibilities" ON "eligibilities"."program_id" = "programs"."id" LEFT OUTER JOIN "new_locations" ON "new_locations"."id" = "location_programs"."location_id" WHERE ("location_programs"."id" BETWEEN $start AND $end) GROUP BY "location_programs"."id", "programs"."name", "programs"."description", "programs"."services_offered", "programs"."eligibility", "programs"."referral_instructions", "organizations"."name", "programs"."languages", "new_locations"."name", "location_programs"."id", "location_programs"."program_id", "programs"."percent_complete", "programs"."hidden", "eligibilities"."men", "eligibilities"."women", "eligibilities"."residential", "eligibilities"."inpatient", "eligibilities"."intensive_outpatient", "eligibilities"."outpatient", "eligibilities"."child", "eligibilities"."adolescent", "eligibilities"."adult", "eligibilities"."geriatric", "eligibilities"."free", "eligibilities"."private_insurance", "eligibilities"."medicaid", "eligibilities"."medicare", "eligibilities"."sliding_scale", "programs"."closed", "new_locations"."is_mailing"
  sql_query_range = SELECT COALESCE(MIN("location_programs"."id"), 1), COALESCE(MAX("location_programs"."id"), 1) FROM "location_programs"
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = program_id
  sql_attr_bool = program_hidden
  sql_attr_bool = men
  sql_attr_bool = women
  sql_attr_bool = residential
  sql_attr_bool = inpatient
  sql_attr_bool = intensive_outpatient
  sql_attr_bool = outpatient
  sql_attr_bool = child
  sql_attr_bool = adolescent
  sql_attr_bool = adult
  sql_attr_bool = geriatric
  sql_attr_bool = free
  sql_attr_bool = private_insurance
  sql_attr_bool = medicaid
  sql_attr_bool = medicare
  sql_attr_bool = sliding_scale
  sql_attr_bool = closed
  sql_attr_bool = is_mailing
  sql_attr_float = percent_complete
  sql_attr_float = lat
  sql_attr_float = lng
  sql_attr_string = sphinx_internal_class
  sql_query_post_index = UPDATE "location_programs" SET "delta" = FALSE WHERE "delta" = TRUE
}

index location_program_core
{
  type = plain
  path = /home/declan/Sites/purplebinder/db/sphinx/development/location_program_core
  docinfo = extern
  morphology = stem_en
  source = location_program_core_0
}

source location_program_delta_0
{
  type = pgsql
  sql_host = localhost
  sql_user = railsdev
  sql_pass = railsdev
  sql_db = purplebinder
  sql_port = 5433
  sql_query_pre = SET TIME ZONE UTC
  sql_query = SELECT "location_programs"."id" * 3 + 0 AS "id", "programs"."name" AS "name", "programs"."description" AS "description", "programs"."services_offered" AS "services_offered", "programs"."eligibility" AS "eligibility", "programs"."referral_instructions" AS "referral_instructions", "organizations"."name" AS "org_name", "programs"."languages" AS "languages", array_to_string(array_agg(DISTINCT "datasets"."url"), ' ') AS "dataset", "new_locations"."name" AS "location_name", "location_programs"."id" AS "sphinx_internal_id", 'LocationProgram' AS "sphinx_internal_class", 0 AS "sphinx_deleted", "location_programs"."program_id" AS "program_id", "programs"."percent_complete" AS "percent_complete", "programs"."hidden" AS "program_hidden", RADIANS((SELECT lat FROM new_locations WHERE id = location_id)) AS "lat", RADIANS((SELECT lng FROM new_locations WHERE id = location_id)) AS "lng", "eligibilities"."men" AS "men", "eligibilities"."women" AS "women", "eligibilities"."residential" AS "residential", "eligibilities"."inpatient" AS "inpatient", "eligibilities"."intensive_outpatient" AS "intensive_outpatient", "eligibilities"."outpatient" AS "outpatient", "eligibilities"."child" AS "child", "eligibilities"."adolescent" AS "adolescent", "eligibilities"."adult" AS "adult", "eligibilities"."geriatric" AS "geriatric", "eligibilities"."free" AS "free", "eligibilities"."private_insurance" AS "private_insurance", "eligibilities"."medicaid" AS "medicaid", "eligibilities"."medicare" AS "medicare", "eligibilities"."sliding_scale" AS "sliding_scale", "programs"."closed" AS "closed", "new_locations"."is_mailing" AS "is_mailing" FROM "location_programs" LEFT OUTER JOIN "programs" ON "programs"."id" = "location_programs"."program_id" LEFT OUTER JOIN "organizations" ON "organizations"."id" = "programs"."organization_id" LEFT OUTER JOIN "dataset_programs" ON "dataset_programs"."program_id" = "programs"."id" LEFT OUTER JOIN "datasets" ON "datasets"."id" = "dataset_programs"."dataset_id" LEFT OUTER JOIN "eligibilities" ON "eligibilities"."program_id" = "programs"."id" LEFT OUTER JOIN "new_locations" ON "new_locations"."id" = "location_programs"."location_id" WHERE ("location_programs"."delta" = TRUE AND "location_programs"."id" BETWEEN $start AND $end) GROUP BY "location_programs"."id", "programs"."name", "programs"."description", "programs"."services_offered", "programs"."eligibility", "programs"."referral_instructions", "organizations"."name", "programs"."languages", "new_locations"."name", "location_programs"."id", "location_programs"."program_id", "programs"."percent_complete", "programs"."hidden", "eligibilities"."men", "eligibilities"."women", "eligibilities"."residential", "eligibilities"."inpatient", "eligibilities"."intensive_outpatient", "eligibilities"."outpatient", "eligibilities"."child", "eligibilities"."adolescent", "eligibilities"."adult", "eligibilities"."geriatric", "eligibilities"."free", "eligibilities"."private_insurance", "eligibilities"."medicaid", "eligibilities"."medicare", "eligibilities"."sliding_scale", "programs"."closed", "new_locations"."is_mailing"
  sql_query_range = SELECT COALESCE(MIN("location_programs"."id"), 1), COALESCE(MAX("location_programs"."id"), 1) FROM "location_programs"  WHERE ("location_programs"."delta" = TRUE)
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = program_id
  sql_attr_bool = program_hidden
  sql_attr_bool = men
  sql_attr_bool = women
  sql_attr_bool = residential
  sql_attr_bool = inpatient
  sql_attr_bool = intensive_outpatient
  sql_attr_bool = outpatient
  sql_attr_bool = child
  sql_attr_bool = adolescent
  sql_attr_bool = adult
  sql_attr_bool = geriatric
  sql_attr_bool = free
  sql_attr_bool = private_insurance
  sql_attr_bool = medicaid
  sql_attr_bool = medicare
  sql_attr_bool = sliding_scale
  sql_attr_bool = closed
  sql_attr_bool = is_mailing
  sql_attr_float = percent_complete
  sql_attr_float = lat
  sql_attr_float = lng
  sql_attr_string = sphinx_internal_class
}

index location_program_delta
{
  type = plain
  path = /home/declan/Sites/purplebinder/db/sphinx/development/location_program_delta
  docinfo = extern
  morphology = stem_en
  source = location_program_delta_0
}

index location_program
{
  type = distributed
  local = location_program_core
  local = location_program_delta
}