gistfile1.txt

# Èíäåêñàöèÿ îôôåðîâ
source discash_offers : base_conect
{
	#sql_query_range    = SELECT MIN(id), MAX(id) FROM offers
 	#sql_range_step     = 500
	
	sql_query		= \
		SELECT id, name , description , internal_id, updated_at, 'offer' as model_name  \
		FROM offers
	
		
	sql_attr_uint 		= internal_id
	sql_attr_timestamp	= updated_at
	sql_field_string 	= name
    sql_field_string 	= description
	sql_attr_uint    	= model_name
	
	sql_query_pre = SET NAMES utf8;
	sql_query_info = SELECT * , 'offer' as model_name FROM offers WHERE id=$id
}

source discash_products : base_conect 
{
	sql_query_range    = SELECT MIN(id), MAX(id) FROM products
						 
 	sql_range_step     = 500
	
	sql_query		= \
		SELECT s.id, s.name, s.description, s.price, s.updated_at, o.id AS offer_id, 'product' AS model_name \
		FROM products AS s \
		INNER JOIN offers as o ON o.id = s.offer_id \
		WHERE s.id >= $start AND s.id <= $end
			
	
	#sql_attr_timestamp	= updated_at
	
	sql_attr_uint    = model_name
	sql_attr_uint    = offer_id
	sql_field_string = price
	sql_field_string = name
    sql_field_string = description
	sql_query_pre = SET NAMES utf8;
	
	sql_query_info = SELECT *, 'product' AS model_name FROM products WHERE id=$id
}

index discash_products 
{
	source			= discash_products
	path			= /usr/local/Cellar/sphinx/2.1.6/lib/discash_products
	
	docinfo			= extern
	charset_type	= utf-8
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
	morphology		= stem_enru, soundex, metaphone
	html_strip		= 'offer'
}


index discash_offers
{
	source			= discash_offers
	path			= /usr/local/Cellar/sphinx/2.1.6/lib/discash_offers
	
	docinfo			= extern
	charset_type	= utf-8
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
	morphology		= stem_enru, soundex, metaphone
	html_strip		= 'offer'

	
}