Added branch 1.0.

[wolnelektury.git] / wolnelektury / sphinx.conf

diff --git a/wolnelektury/sphinx.conf b/wolnelektury/sphinx.conf
new file mode 100644 (file)
index 0000000..80c4112
--- /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
+}