WebSVN – Applications.papyrus – Diff – /trunk/papyrus/applettes/moteur_recherche/sphinx-min.conf

Rev 2134		Rev 2137
Line 10...		Line 10...
10	`source common`	10	`source common`
11	`{`	11	`{`
12	`type = mysql`	12	`type = mysql`
Line 13...		Line 13...
13		13
14	`sql_host = localhost`	14	`sql_host = localhost`
15	`sql_user = root`	15	`sql_user = telabotap`
16	`sql_pass =`	16	`sql_pass =`
17	`sql_db = raphdb`	17	`sql_db = tela_prod_v4`
18	`sql_sock = /var/lib/mysql/mysql.sock`	18	`sql_sock = /run/mysqld/mysqld.sock`
19		19
20	`sql_query_pre = SET NAMES utf8`	20	`sql_query_pre = SET NAMES utf8`
Line 21...		Line 21...
21	`sql_query_pre = SET CHARACTER_SET_RESULTS=utf8`	21	`sql_query_pre = SET CHARACTER_SET_RESULTS=utf8`
22		22
Line 26...		Line 26...
26	`index i_common`	26	`index i_common`
27	`{`	27	`{`
28	`# ces deux directive permettent à la source abstraite d'être valide`	28	`# ces deux directive permettent à la source abstraite d'être valide`
29	`# lors de l'utilisation de sphinx-search sans précision d'index`	29	`# lors de l'utilisation de sphinx-search sans précision d'index`
30	`source = common`	30	`source = common`
31	`path = /var/lib/sphinx/void`	31	`path = /var/lib/sphinxsearch/void`
32	`docinfo = extern`	32	`docinfo = extern`
33	`stopwords = /etc/sphinx/stopwords.txt`	33	`stopwords = /etc/sphinx/stopwords.txt`
Line 34...		Line 34...
34		34
35	`# http://sphinxsearch.com/docs/2.1.1/conf-morphology.html`	35	`# http://sphinxsearch.com/docs/2.1.1/conf-morphology.html`
Line 43...		Line 43...
43	`# infix_fields =`	43	`# infix_fields =`
Line 44...		Line 44...
44		44
Line 45...		Line 45...
45	`phrase_boundary = ., ?, !, U+2026`	45	`phrase_boundary = ., ?, !, U+2026`
46		46
47	`# http://sphinxsearch.com/wiki/doku.php?id=charset_tables`	47	`# http://sphinxsearch.com/wiki/doku.php?id=charset_tables`
48	`# mysql raphdb<<<"SELECT p_description FROM projet WHERE p_id = 121"\|xxd`	48	`# mysql tela_prod_v4<<<"SELECT p_description FROM projet WHERE p_id = 121"\|xxd`
49	`# sphinx-search -q -c sphinx-min.conf -i i_projet "homoge*\|homogé"\|grep -w hits`	49	`# sphinx-search -q -c sphinx-min.conf -i i_projet "homoge*\|homogé"\|grep -w hits`
50	`# SELECT * FROM i_projet WHERE MATCH('homoge*\|homogé'); SHOW META;`	50	`# SELECT * FROM i_projet WHERE MATCH('homoge*\|homogé'); SHOW META;`
51	`charset_type = utf-8`	51	`charset_type = utf-8`
Line 195...		Line 195...
195	`sql_query_info = SELECT * FROM spip_articles WHERE id_article=$id`	195	`sql_query_info = SELECT * FROM spip_articles WHERE id_article=$id`
196	`}`	196	`}`
Line 197...		Line 197...
197		197
198	`index i_spip : i_common {`	198	`index i_spip : i_common {`
199	`source = spip`	199	`source = spip`
Line 200...		Line 200...
200	`path = /var/lib/sphinx/spip`	200	`path = /var/lib/sphinxsearch/spip`
201		201
202	`# prefix_fields = titre, texte`	202	`# prefix_fields = titre, texte`
Line 243...		Line 243...
243	`sql_query_info = SELECT * FROM gen_menu WHERE gm_id_menu=$id`	243	`sql_query_info = SELECT * FROM gen_menu WHERE gm_id_menu=$id`
244	`}`	244	`}`
Line 245...		Line 245...
245		245
246	`index i_papyrus : i_common {`	246	`index i_papyrus : i_common {`
247	`source = papyrus`	247	`source = papyrus`
Line 248...		Line 248...
248	`path = /var/lib/sphinx/papyrus`	248	`path = /var/lib/sphinxsearch/papyrus`
249		249
250	`# prefix_fields = titre, texte`	250	`# prefix_fields = titre, texte`
Line 276...		Line 276...
276	`sql_query_info = SELECT * FROM projet WHERE p_id=$id`	276	`sql_query_info = SELECT * FROM projet WHERE p_id=$id`
277	`}`	277	`}`
Line 278...		Line 278...
278		278
279	`index i_projet : i_common {`	279	`index i_projet : i_common {`
280	`source = projet`	280	`source = projet`
Line 281...		Line 281...
281	`path = /var/lib/sphinx/projet`	281	`path = /var/lib/sphinxsearch/projet`
282		282
283	`# prefix_fields = titre, texte`	283	`# prefix_fields = titre, texte`
Line 300...		Line 300...
300	`sql_query_info = SELECT * FROM bazar_fiche WHERE bf_id_fiche=$id`	300	`sql_query_info = SELECT * FROM bazar_fiche WHERE bf_id_fiche=$id`
301	`}`	301	`}`
Line 302...		Line 302...
302		302
303	`index i_bazar : i_common {`	303	`index i_bazar : i_common {`
304	`source = bazar`	304	`source = bazar`
Line 305...		Line 305...
305	`path = /var/lib/sphinx/bazar`	305	`path = /var/lib/sphinxsearch/bazar`
306		306
307	`# prefix_fields = titre, texte`	307	`# prefix_fields = titre, texte`
Line 328...		Line 328...
328	`sql_query_info = SELECT * FROM coste_v2_00 WHERE flore_bdtfx_nn=$id`	328	`sql_query_info = SELECT * FROM coste_v2_00 WHERE flore_bdtfx_nn=$id`
329	`}`	329	`}`
Line 330...		Line 330...
330		330
331	`index i_coste : i_common {`	331	`index i_coste : i_common {`
332	`source = coste`	332	`source = coste`
Line 333...		Line 333...
333	`path = /var/lib/sphinx/coste`	333	`path = /var/lib/sphinxsearch/coste`
334		334
Line 360...		Line 360...
360	`sql_query_info = SELECT * FROM nvjfl_v2007 WHERE num_taxon=$id`	360	`sql_query_info = SELECT * FROM nvjfl_v2007 WHERE num_taxon=$id`
361	`}`	361	`}`
Line 362...		Line 362...
362		362
363	`index i_nvjfl : i_common {`	363	`index i_nvjfl : i_common {`
364	`source = nvjfl`	364	`source = nvjfl`
Line 365...		Line 365...
365	`path = /var/lib/sphinx/nvjfl`	365	`path = /var/lib/sphinxsearch/nvjfl`
366		366
Line 380...		Line 380...
380	`FROM bdtfx_v1_01 b LEFT JOIN bdtfx_v1_01 bret ON b.num_nom_retenu = bret.num_nom \`	380	`FROM bdtfx_v1_01 b LEFT JOIN bdtfx_v1_01 bret ON b.num_nom_retenu = bret.num_nom \`
381	`UNION ALL \`	381	`UNION ALL \`
382	`SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \`	382	`SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \`
383	`"bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom, \`	383	`"bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom, \`
384	`CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \`	384	`CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \`
385	`FROM bdtxa_v1_00 a LEFT JOIN bdtxa_v1_00 aret ON a.num_nom_retenu = aret.num_nom \`	385	`FROM bdtxa_v1_01 a LEFT JOIN bdtxa_v1_01 aret ON a.num_nom_retenu = aret.num_nom \`
386	`UNION ALL \`	386	`UNION ALL \`
387	`SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \`	387	`SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \`
388	`"isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \`	388	`"isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \`
389	`CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \`	389	`CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \`
390	`FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom`	390	`FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom`
Line 394...		Line 394...
394	`sql_field_string = auteur`	394	`sql_field_string = auteur`
395	`sql_attr_string = main_id`	395	`sql_attr_string = main_id`
396	`sql_attr_uint = num_nom`	396	`sql_attr_uint = num_nom`
397	`sql_attr_string = nom_ret`	397	`sql_attr_string = nom_ret`
Line 398...		Line 398...
398		398
-		399	`sql_query_info = SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, homonyme, nom_francais, num_taxonomique, nom_complet, famille FROM bdtfx_v1_01 \`
-		400	`WHERE num_nom=$id UNION \`
-		401	`SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, homonyme, nom_francais, num_tax, nom_complet, famille FROM bdtxa_v1_01 \`
-		402	`WHERE num_nom=$id UNION \`
-		403	`SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, NULL, NULL, num_taxonomique, nom_complet, famille FROM isfan_v2013 \`
399	`sql_query_info = SELECT * FROM bdtfx_v1_01 b, bdtxa_v1_00 a, isfan_v2013 is WHERE b.num_nom=$id OR a.num_nom=$id OR is.num_nom=$id`	404	`WHERE num_nom=$id`
Line 400...		Line 405...
400	`}`	405	`}`
401		406
402	`index i_bdtfx : i_common {`	407	`index i_bdtfx : i_common {`
Line 403...		Line 408...
403	`source = bdtfx`	408	`source = bdtfx`
404	`path = /var/lib/sphinx/bdtfx`	409	`path = /var/lib/sphinxsearch/bdtfx`
405		410
406	`stopwords =`	411	`stopwords =`
Line 425...		Line 430...
425	`FROM bdtfx_v2_00 b LEFT JOIN bdtfx_v2_00 bret ON b.num_nom_retenu = bret.num_nom \`	430	`FROM bdtfx_v2_00 b LEFT JOIN bdtfx_v2_00 bret ON b.num_nom_retenu = bret.num_nom \`
426	`UNION ALL \`	431	`UNION ALL \`
427	`SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \`	432	`SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \`
428	`"bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom, \`	433	`"bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom, \`
429	`CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \`	434	`CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \`
430	`FROM bdtxa_v1_00 a LEFT JOIN bdtxa_v1_00 aret ON a.num_nom_retenu = aret.num_nom \`	435	`FROM bdtxa_v1_01 a LEFT JOIN bdtxa_v1_01 aret ON a.num_nom_retenu = aret.num_nom \`
431	`UNION ALL \`	436	`UNION ALL \`
432	`SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \`	437	`SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \`
433	`"isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \`	438	`"isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \`
434	`CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \`	439	`CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \`
435	`FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom`	440	`FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom`
Line 439...		Line 444...
439	`sql_field_string = auteur`	444	`sql_field_string = auteur`
440	`sql_attr_string = main_id`	445	`sql_attr_string = main_id`
441	`sql_attr_uint = num_nom`	446	`sql_attr_uint = num_nom`
442	`sql_attr_string = nom_ret`	447	`sql_attr_string = nom_ret`
Line 443...		Line 448...
443		448
-		449	`sql_query_info = SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, homonyme, nom_francais, num_taxonomique, nom_complet, famille FROM bdtfx_v2_00 \`
-		450	`WHERE num_nom=$id UNION \`
-		451	`SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, homonyme, nom_francais, num_tax, nom_complet, famille FROM bdtxa_v1_01 \`
-		452	`WHERE num_nom=$id UNION \`
-		453	`SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, NULL, NULL, num_taxonomique, nom_complet, famille FROM isfan_v2013 \`
444	`sql_query_info = SELECT * FROM bdtfx_v2_00 b, bdtxa_v1_00 a, isfan_v2013 is WHERE b.num_nom=$id OR a.num_nom=$id OR is.num_nom=$id`	454	`WHERE num_nom=$id`
Line 445...		Line 455...
445	`}`	455	`}`
446		456
447	`index i_bdtfx2 : i_common {`	457	`index i_bdtfx2 : i_common {`
Line 448...		Line 458...
448	`source = bdtfx2`	458	`source = bdtfx2`
449	`path = /var/lib/sphinx/bdtfx2`	459	`path = /var/lib/sphinxsearch/bdtfx2`
450		460
451	`stopwords =`	461	`stopwords =`
Line 482...		Line 492...
482	`# sql_query_info = SELECT * FROM coste_v2_00 WHERE flore_bdtfx_nn=$id`	492	`# sql_query_info = SELECT * FROM coste_v2_00 WHERE flore_bdtfx_nn=$id`
483	`# }`	493	`# }`
Line 484...		Line 494...
484		494
485	`# index i_costenvjfl : i_common {`	495	`# index i_costenvjfl : i_common {`
486	`# source = costenvjfl`	496	`# source = costenvjfl`
Line 487...		Line 497...
487	`# path = /var/lib/sphinx/costenvjfl`	497	`# path = /var/lib/sphinxsearch/costenvjfl`
488		498
Line 489...		Line 499...
489	`# infix_fields = texte, titre`	499	`# infix_fields = texte, titre`
Line 500...		Line 510...
500	`# index testrt`	510	`# index testrt`
501	`# {`	511	`# {`
502	`# type = rt`	512	`# type = rt`
503	`# rt_mem_limit = 32M`	513	`# rt_mem_limit = 32M`
Line 504...		Line 514...
504		514
505	`# path = /var/lib/sphinx/testrt`	515	`# path = /var/lib/sphinxsearch/testrt`
Line 506...		Line 516...
506	`# charset_type = utf-8`	516	`# charset_type = utf-8`
507		517
508	`# rt_field = title`	518	`# rt_field = title`

Subversion Repositories Applications.papyrus

(root)/trunk/papyrus/applettes/moteur_recherche/sphinx-min.conf – Rev 2134 → 2137