wolnelektury/sphinx.conf

   1 searchd {
   2         port                                    = 3312
   3         log                                             = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/searchd.log
   4         query_log                               = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/query.log
   5         read_timeout                    = 5
   6         max_children                    = 30
   7         pid_file                                = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/searchd.pid
   8         max_matches                             = 1000
   9         seamless_rotate                 = 1
  10         preopen_indexes                 = 0
  11         unlink_old                              = 1
  12 }
  13
  14 source catalogue_book
  15 {
  16     type                = mysql
  17     strip_html          = 0
  18     index_html_attrs    =
  19     sql_host            =
  20     sql_user            = root
  21     sql_pass            =
  22     sql_db              = wolnelektury
  23     sql_port            =
  24
  25     sql_query_pre       =
  26     sql_query_post      =
  27     sql_query           = \
  28         SELECT id, title, slug, description, created_at, _short_html, parent_number, xml_file, html_file, pdf_file, odt_file, txt_file, parent_id \
  29         FROM catalogue_book
  30     sql_query_info      = SELECT * FROM `catalogue_book` WHERE `id` = $id
  31
  32     # ForeignKey's
  33     sql_group_column    = parent_number
  34     sql_group_column    = parent_id
  35
  36
  37
  38     # DateField's and DateTimeField's
  39     sql_date_column     = created_at
  40
  41 }
  42
  43 index catalogue_book
  44 {
  45     source          = catalogue_book
  46     path            = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/catalogue_book
  47     docinfo         = extern
  48     morphology      = none
  49     stopwords       =
  50     min_word_len    = 2
  51     charset_type    = sbcs
  52     min_prefix_len  = 0
  53     min_infix_len   = 0
  54 }
  55
  56
  57 source catalogue_fragment
  58 {
  59     type                = mysql
  60     strip_html          = 0
  61     index_html_attrs    =
  62     sql_host            =
  63     sql_user            = root
  64     sql_pass            =
  65     sql_db              = wolnelektury
  66     sql_port            =
  67
  68     sql_query_pre       =
  69     sql_query_post      =
  70     sql_query           = \
  71         SELECT id, text, short_text, _short_html, anchor, book_id \
  72         FROM catalogue_fragment
  73     sql_query_info      = SELECT * FROM `catalogue_fragment` WHERE `id` = $id
  74
  75     # ForeignKey's
  76     sql_group_column    = book_id
  77 }
  78
  79 index catalogue_fragment
  80 {
  81     source          = catalogue_fragment
  82     path            = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/catalogue_fragment
  83     docinfo         = extern
  84     morphology      = none
  85     stopwords       =
  86     min_word_len    = 2
  87     charset_type    = sbcs
  88     min_prefix_len  = 0
  89     min_infix_len   = 0
  90 }
  91
  92 source catalogue_tag
  93 {
  94     type                = mysql
  95     strip_html          = 0
  96     index_html_attrs    =
  97     sql_host            =
  98     sql_user            = root
  99     sql_pass            =
 100     sql_db              = wolnelektury
 101     sql_port            =
 102
 103     sql_query_pre       =
 104     sql_query_post      =
 105     sql_query           = \
 106         SELECT id, name, slug, sort_key, category, description, main_page, user_id, book_count \
 107         FROM catalogue_tag
 108     sql_query_info      = SELECT * FROM `catalogue_tag` WHERE `id` = $id
 109
 110     # ForeignKey's
 111     sql_group_column    = main_page
 112     sql_group_column    = user_id
 113     sql_group_column    = book_count
 114 }
 115
 116 index catalogue_tag
 117 {
 118     source          = catalogue_tag
 119     path            = /Users/zuber/Projekty/wolnelektury.pl-sphinx/wolnelektury/sphinx/catalogue_tag
 120     docinfo         = extern
 121     morphology      = none
 122     stopwords       =
 123     min_word_len    = 2
 124     charset_type    = sbcs
 125     min_prefix_len  = 0
 126     min_infix_len   = 0
 127 }