X-Git-Url: https://git.mdrn.pl/wolnelektury.git/blobdiff_plain/9b97d5a2faa6f56b439dcefe9c7bb23e0a84b39c..db833ba4517084f61a64907c6d15606e7c881edd:/wolnelektury/sphinx.conf?ds=inline

diff --git a/wolnelektury/sphinx.conf b/wolnelektury/sphinx.conf
new file mode 100644
index 000000000..80c411286
--- /dev/null
+++ b/wolnelektury/sphinx.conf
@@ -0,0 +1,127 @@
+searchd {
+	port					= 3312
+	log						= /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/searchd.log
+	query_log				= /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/query.log
+	read_timeout			= 5
+	max_children			= 30
+	pid_file				= /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/searchd.pid
+	max_matches				= 1000
+	seamless_rotate			= 1
+	preopen_indexes			= 0
+	unlink_old				= 1
+}
+
+source catalogue_book
+{
+    type                = mysql
+    strip_html          = 0
+    index_html_attrs    =
+    sql_host            = 
+    sql_user            = root
+    sql_pass            = 
+    sql_db              = wolnelektury
+    sql_port            = 
+
+    sql_query_pre       =
+    sql_query_post      =
+    sql_query           = \
+        SELECT id, title, slug, description, created_at, _short_html, parent_number, xml_file, html_file, pdf_file, odt_file, txt_file, parent_id \
+        FROM catalogue_book
+    sql_query_info      = SELECT * FROM `catalogue_book` WHERE `id` = $id
+
+    # ForeignKey's
+    sql_group_column    = parent_number
+    sql_group_column    = parent_id
+
+
+
+    # DateField's and DateTimeField's
+    sql_date_column     = created_at
+
+}
+
+index catalogue_book
+{
+    source          = catalogue_book
+    path            = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/catalogue_book
+    docinfo         = extern
+    morphology      = none
+    stopwords       =
+    min_word_len    = 2
+    charset_type    = sbcs
+    min_prefix_len  = 0
+    min_infix_len   = 0
+}
+
+
+source catalogue_fragment
+{
+    type                = mysql
+    strip_html          = 0
+    index_html_attrs    =
+    sql_host            = 
+    sql_user            = root
+    sql_pass            = 
+    sql_db              = wolnelektury
+    sql_port            = 
+
+    sql_query_pre       =
+    sql_query_post      =
+    sql_query           = \
+        SELECT id, text, short_text, _short_html, anchor, book_id \
+        FROM catalogue_fragment
+    sql_query_info      = SELECT * FROM `catalogue_fragment` WHERE `id` = $id
+
+    # ForeignKey's
+    sql_group_column    = book_id
+}
+
+index catalogue_fragment
+{
+    source          = catalogue_fragment
+    path            = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/catalogue_fragment
+    docinfo         = extern
+    morphology      = none
+    stopwords       =
+    min_word_len    = 2
+    charset_type    = sbcs
+    min_prefix_len  = 0
+    min_infix_len   = 0
+}
+
+source catalogue_tag
+{
+    type                = mysql
+    strip_html          = 0
+    index_html_attrs    =
+    sql_host            = 
+    sql_user            = root
+    sql_pass            = 
+    sql_db              = wolnelektury
+    sql_port            = 
+
+    sql_query_pre       =
+    sql_query_post      =
+    sql_query           = \
+        SELECT id, name, slug, sort_key, category, description, main_page, user_id, book_count \
+        FROM catalogue_tag
+    sql_query_info      = SELECT * FROM `catalogue_tag` WHERE `id` = $id
+
+    # ForeignKey's
+    sql_group_column    = main_page
+    sql_group_column    = user_id
+    sql_group_column    = book_count
+}
+
+index catalogue_tag
+{
+    source          = catalogue_tag
+    path            = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/catalogue_tag
+    docinfo         = extern
+    morphology      = none
+    stopwords       =
+    min_word_len    = 2
+    charset_type    = sbcs
+    min_prefix_len  = 0
+    min_infix_len   = 0
+}