source application
{
	type = pgsql
	sql_host = 192.168.1.2
	sql_user = www
	sql_pass = ghjcnjq
	sql_db = shop
	sql_port = 5432
	sql_query_pre = SET NAMES 'utf-8'
}


source legacySource : application
{
	sql_query = \
		SELECT i.id, 'i' AS prefix, i.title, i.photo, i.base_price, i.base_quantity, i.fixed_price, i.in_store, i.model, g.title AS group_title, g.id AS group_id, m.title AS manufactor \
		FROM legacy.data_item i \
		LEFT JOIN legacy.data_manufactor m ON i.manufactor_id = m.id \
		LEFT JOIN legacy.data_group g ON g.id = i.parent_id \
		WHERE i.id BETWEEN $start AND $end AND g.status = 1

	sql_query_range = SELECT MIN(id),MAX(id) FROM legacy.data_item
	sql_range_step = 5000
	#sql_attr_uint = id
	sql_attr_string = prefix
	sql_field_str2wordcount = title
	sql_attr_string = photo
	sql_attr_uint = base_price
	sql_attr_uint = base_quantity
	sql_attr_uint = fixed_price
	sql_attr_uint = in_store
	sql_field_str2wordcount = model
	sql_field_str2wordcount = group_title
	sql_attr_uint = group_id
	sql_attr_string = manufactor
}

source publicSource : application
{
	sql_query = \
		SELECT p.id, 'p' AS prefix, p.title, p.photo, p.base_price, p.base_quantity, p.fixed_price, p.in_store, p.model, g.title AS group_title, g.id AS group_id, l.value as manufactor \
		FROM public.data_item p \
		LEFT JOIN legacy.data_group_type gt ON gt.type_id = p.type_id \
		LEFT JOIN legacy.data_group g ON g.id = gt.group_id \
		LEFT JOIN public.data_item_feature f ON  f.item_id=p.id AND f.feature_id=2 \
		LEFT JOIN public.data_feature_list l ON f.value::int=l.id AND l.feature_id=f.feature_id \
		WHERE p.id BETWEEN $start AND $end AND g.status = 1

	sql_query_range = SELECT MIN(id),MAX(id) FROM public.data_item
	sql_range_step = 5000

	#sql_attr_uint = id
	sql_attr_string = prefix
	sql_field_str2wordcount = title
	sql_attr_string = photo
	sql_attr_uint = base_price
	sql_attr_uint = base_quantity
	sql_attr_uint = fixed_price
	sql_attr_uint = in_store
	sql_field_str2wordcount = model
	sql_field_str2wordcount = group_title
	sql_attr_uint = group_id
	sql_attr_string = manufactor
}


index legacyIndex
{
	source = legacySource
	path = /var/run/sphinx/legacySource/legacyIndex
	docinfo = extern
	mlock = 0
	morphology = stem_enru, soundex, metaphone
	charset_type = utf-8
	html_strip = 1
}

index publicIndex
{
	source = publicSource
	path = /var/run/sphinx/publicSource/publicIndex
	docinfo = extern
	mlock = 0
	morphology = stem_enru, soundex, metaphone
	charset_type = utf-8
	html_strip = 1
}

indexer
{
	mem_limit = 64M
}

searchd
{
	listen = 127.0.0.1
	port = 5000
	log = /var/log/sphinx/searchd.log
	query_log = /var/log/sphinx/query.log
	read_timeout = 5
	max_children = 30
	pid_file = /var/log/sphinx/searchd.pid
}