| 335,6 → 335,66 |
|---|
| infix_fields = texte, titre |
| } |
| |
| |
| |
| # NVJFL |
| source nvjfl : common { |
| sql_db = tb_eflore |
| |
| # note: 66 taxons nvjfl n'ont pas de numéro nomenclatural |
| sql_query = \ |
| SELECT b.num_nom, num_taxon, nom_sci, GROUP_CONCAT(nom_vernaculaire), \ |
| "nvjfl" AS group_id, CONCAT("nvjfl-", b.num_nom) as main_id \ |
| FROM nvjfl_v2007 n \ |
| LEFT JOIN bdtfx_v1_02 b ON n.num_taxon = b.num_taxonomique \ |
| WHERE b.num_nom IS NOT NULL \ |
| GROUP by num_taxon |
| |
| sql_field_string = group_id |
| sql_attr_string = main_id |
| sql_attr_uint = num_taxon |
| |
| sql_query_info = SELECT * FROM nvjfl_v2007 WHERE num_taxon=$id |
| } |
| |
| index i_nvjfl : i_common { |
| source = nvjfl |
| path = /var/lib/sphinx/nvjfl |
| |
| infix_fields = texte, titre |
| } |
| |
| |
| |
| # COSTE / NVJFL |
| # source costenvjfl : common { |
| # sql_db = tb_eflore |
| |
| # sql_query = \ |
| # SELECT c.flore_bdtfx_nn AS id, c.nom_sci AS titre, dsc.body AS texte, cle.body AS determination, \ |
| # GROUP_CONCAT(n.nom_vernaculaire) AS nvjfl, n.num_taxon AS num_taxonomique, \ |
| # "costenvjfl" AS group_id, CONCAT("costenvjfl-", c.flore_bdtfx_nn) as main_id \ |
| # FROM tb_eflore.coste_v2_00 c \ |
| # LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \ |
| # LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' \ |
| # LEFT JOIN bdtfx_v1_02 b ON c.flore_bdtfx_nn = b.num_nom \ |
| # LEFT JOIN nvjfl_v2007 n ON b.num_taxonomique = n.num_taxon \ |
| # WHERE c.flore_bdtfx_nn != '' |
| |
| # sql_field_string = group_id |
| # sql_attr_string = main_id |
| # sql_attr_uint = num_taxonomique |
| |
| # sql_query_info = SELECT * FROM coste_v2_00 WHERE flore_bdtfx_nn=$id |
| # } |
| |
| # index i_costenvjfl : i_common { |
| # source = costenvjfl |
| # path = /var/lib/sphinx/costenvjfl |
| |
| # infix_fields = texte, titre |
| # } |
| |
| # notes: |
| # une nouvelle source d'indexation *DOIT*, pour être utilisable par le moteur de recherche papyrus, |
| # définir les attributs *group_id* et *main_id*. |