Examples with SearchHelper mom.trd.opentheso.bdd.helper.SearchHelper used on opensource projects

Example 1 with SearchHelper

use of mom.trd.opentheso.bdd.helper.SearchHelper in project opentheso by miledrousset.

the class Rest method getListId.

/**
 * Fin Temporaire à refaire (Miled)
 */
private ArrayList<String> getListId(String value, String idLang, String idTheso) {
    ArrayList<String> listId = new ArrayList<>();
    ArrayList<NodeSearch> listRes = new SearchHelper().searchTerm(ds, value, idLang, idTheso, "", 1, false);
    for (NodeSearch listRe : listRes) {
        listId.add(listRe.getIdConcept());
    }
    return listId;
}

Example 2 with SearchHelper

use of mom.trd.opentheso.bdd.helper.SearchHelper in project opentheso by miledrousset.

the class CompareConceptTest method testExportAllDatas.

/**
 * Test of Get datas for SiteMap.
 */
@org.junit.Test
public void testExportAllDatas() {
    ConnexionTest connexionTest = new ConnexionTest();
    HikariDataSource conn = connexionTest.getConnexionPool();
    String idTheso = "TH_1";
    String idLang = "fr";
    String idGroup = "6";
    ConceptHelper conceptHelper = new ConceptHelper();
    StringPlus stringPlus = new StringPlus();
    NodeConcept nodeConcept;
    SearchHelper searchHelper = new SearchHelper();
    ArrayList<NodeSearch> nodeSearchs;
    StringBuilder stringBuilder = new StringBuilder();
    // lecture du fichier tabulé /Users/Miled/
    String path = "/Users/Miled/Desktop/inist.csv";
    FileInputStream file = readFile(path);
    if (file == null)
        return;
    String line;
    String lineTmp;
    String[] lineOrigine;
    boolean first = true;
    stringBuilder.append("Numéro BDD\tnom d'origine\tnom PACTOLS\tId PACTOLS\tURL Ark\tDéfinition\tTerme générique\tSynonyme\n");
    BufferedReader bf = new BufferedReader(new InputStreamReader(file));
    try {
        while ((line = bf.readLine()) != null) {
            lineOrigine = line.split("\t");
            if (lineOrigine.length < 2)
                continue;
            lineTmp = removeStopWords(lineOrigine[1]);
            nodeSearchs = searchHelper.searchTerm(conn, lineTmp, idLang, idTheso, idGroup, 2, false);
            stringBuilder.append(lineOrigine[0]);
            stringBuilder.append("\t");
            stringBuilder.append(lineOrigine[1]);
            // stringBuilder.append(" #### ");
            stringBuilder.append("\t");
            first = true;
            for (NodeSearch nodeSearch : nodeSearchs) {
                if (!first) {
                    // stringBuilder.append(" $$$$ ");
                    stringBuilder.append("\n");
                    stringBuilder.append("\t");
                    stringBuilder.append("\t");
                }
                stringBuilder.append(nodeSearch.getLexical_value());
                stringBuilder.append("\t");
                stringBuilder.append(nodeSearch.getIdConcept());
                // récupération des données d'un Concept
                nodeConcept = conceptHelper.getConcept(conn, nodeSearch.getIdConcept(), idTheso, idLang);
                // URL
                stringBuilder.append("\t");
                if (nodeConcept.getConcept().getIdArk() != null || !nodeConcept.getConcept().getIdArk().isEmpty()) {
                    stringBuilder.append("http://ark.frantiq.fr/ark:/");
                    stringBuilder.append(nodeConcept.getConcept().getIdArk());
                }
                // définition
                stringBuilder.append("\t");
                for (NodeNote nodeNote : nodeConcept.getNodeNotesTerm()) {
                    if (nodeNote.getNotetypecode().equalsIgnoreCase("definition"))
                        stringBuilder.append(stringPlus.clearNewLine(nodeNote.getLexicalvalue()));
                }
                // BT
                stringBuilder.append("\t");
                for (NodeBT nodeBT : nodeConcept.getNodeBT()) {
                    stringBuilder.append(nodeBT.getTitle());
                }
                // UF
                stringBuilder.append("\t");
                for (NodeEM nodeEM : nodeConcept.getNodeEM()) {
                    stringBuilder.append(nodeEM.getLexical_value());
                }
                first = false;
            }
            System.out.println(stringBuilder.toString());
            stringBuilder.delete(0, stringBuilder.capacity());
        }
    } catch (IOException ex) {
        Logger.getLogger(CompareConceptTest.class.getName()).log(Level.SEVERE, null, ex);
    }
    // ArrayList<NodeConceptArkId> allIds = conceptHelper.getAllConceptArkIdOfThesaurus(conn, idTheso);
    // StringBuilder file = new StringBuilder();
    /*  ArrayList<String> allIds = conceptHelper.getAllIdConceptOfThesaurusByGroup(conn, idTheso, idGroup);
        
        
        for (String idConcept : allIds) {

            nodeConcept = conceptHelper.getConcept(conn, idConcept, idTheso, idLang);
            System.out.println("idConcept = " + idConcept + "  " + nodeConcept.getTerm().getLexical_value());
            
        }*/
    conn.close();
}

Example 3 with SearchHelper

use of mom.trd.opentheso.bdd.helper.SearchHelper in project opentheso by miledrousset.

the class SearchBean method researchDeconn.

/**
 * méthode pour la recherceh qui ne passe pas par l'arbre
 */
public void researchDeconn() {
    ConceptHelper ch = new ConceptHelper();
    SearchHelper sh = new SearchHelper();
    if (onlyNote) {
        result1 = new SearchHelper().searchNote(connect.getPoolConnexion(), rechercheDeconn, langue.trim(), theso.getThesaurus().getId_thesaurus(), idGroup, startByOrContain);
    } else {
        if (onlyNotation) {
            result1 = new SearchHelper().searchNotation(connect.getPoolConnexion(), rechercheDeconn, langue.trim(), theso.getThesaurus().getId_thesaurus(), idGroup);
        } else {
            result1 = new SearchHelper().searchTerm(connect.getPoolConnexion(), rechercheDeconn, langue.trim(), theso.getThesaurus().getId_thesaurus(), idGroup, startByOrContain, withNote);
        }
    }
    nbRes = result1.size();
}

Example 4 with SearchHelper

use of mom.trd.opentheso.bdd.helper.SearchHelper in project opentheso by miledrousset.

the class SearchBean method research.

public void research() {
    result1 = new ArrayList<>();
    result2 = new ArrayList<>();
    if (typeSearch == 1) {
        // ALPHABETIQUE/HIERARCHIQUE
        if (typeValueSearch == 0) {
            if (onlyNote) {
                result1 = new SearchHelper().searchNote(connect.getPoolConnexion(), entry, langue.trim(), theso.getThesaurus().getId_thesaurus(), idGroup, startByOrContain);
            } else {
                if (onlyNotation) {
                    result1 = new SearchHelper().searchNotation(connect.getPoolConnexion(), entry, langue.trim(), theso.getThesaurus().getId_thesaurus(), idGroup);
                } else {
                    result1 = new SearchHelper().searchTerm(connect.getPoolConnexion(), entry, langue.trim(), theso.getThesaurus().getId_thesaurus(), idGroup, startByOrContain, withNote);
                }
            }
        } else if (typeValueSearch == 1) {
            // idC
            result1 = new SearchHelper().searchIdConcept(connect.getPoolConnexion(), entry, theso.getThesaurus().getId_thesaurus(), theso.getWorkLanguage());
        }
        nbRes = result1.size();
    } else if (typeSearch == 2) {
        // PERMUTEE
        if (typeValueSearch == 0) {
            // Terme
            if (idGroup == null || idGroup.equals("")) {
                result2 = new SearchHelper().getListPermute(connect.getPoolConnexion(), theso.getThesaurus().getId_thesaurus(), langue.trim(), entry);
            // result2.addAll(new SearchHelper().getListPermuteNonPreferredTerm(connect.getPoolConnexion(), theso.getThesaurus().getId_thesaurus(), langue.trim(), entry));
            } else {
                result2 = new SearchHelper().getListPermute(connect.getPoolConnexion(), theso.getThesaurus().getId_thesaurus(), langue.trim(), entry, idGroup);
            // result2.addAll(new SearchHelper().getListPermuteNonPreferredTerm(connect.getPoolConnexion(), theso.getThesaurus().getId_thesaurus(), langue.trim(), entry, idGroup));
            }
            nbRes = result2.size();
        } else if (typeValueSearch == 1) {
            // idC
            typeSearch = 1;
            result1 = new SearchHelper().searchIdConcept(connect.getPoolConnexion(), entry, theso.getThesaurus().getId_thesaurus());
            nbRes = result1.size();
        }
    }
    if (!langue.isEmpty()) {
        if (!langue.trim().equals(theso.getThesaurus().getLanguage())) {
            theso.getThesaurus().setLanguage(langue.trim());
            theso.update();
        }
    }
    for (NodeSearch ns : result1) {
        String temp;
        if (typeValueSearch == 1) {
            temp = new GroupHelper().getLexicalValueOfGroup(connect.getPoolConnexion(), ns.getIdGroup(), theso.getThesaurus().getId_thesaurus(), theso.getWorkLanguage());
        } else
            temp = new GroupHelper().getLexicalValueOfGroup(connect.getPoolConnexion(), ns.getIdGroup(), theso.getThesaurus().getId_thesaurus(), theso.getThesaurus().getLanguage());
        ns.setGroupLabel(temp);
    }
    theso.getVue().setOnglet(1);
}

Example 5 with SearchHelper

use of mom.trd.opentheso.bdd.helper.SearchHelper in project opentheso by miledrousset.

the class CompareCandidatConceptTest method compareCandidatPactols.

/**
 * Test of Get datas for SiteMap.
 */
@org.junit.Test
public void compareCandidatPactols() {
    ConnexionTest connexionTest = new ConnexionTest();
    HikariDataSource conn = connexionTest.getConnexionPool();
    String idTheso = "TH_1";
    String idLang = "fr";
    String idGroup = "6";
    SearchHelper searchHelper = new SearchHelper();
    ArrayList<String> nodeSearchTerm;
    HashMap<String, String> hashMapSyn;
    StringBuilder stringBuilder = new StringBuilder();
    // lecture du fichier tabulé /Users/Miled/
    // String path = "/Users/Miled/Desktop/candidatsPactols.csv";
    String path = "C:/Users/jm.prudham/Desktop/candidatsPactols.csv";
    String line;
    boolean first;
    // stringBuilder.append("Numéro BDD\tnom d'origine\tnom PACTOLS\tId PACTOLS\tURL Ark\tDéfinition\tTerme générique\tSynonyme\n");
    // new InputStreamReader(file));
    BufferedWriter bw = openFile("C:/Users/jm.prudham/Desktop/candidatsPactols_out.csv");
    if (bw == null)
        return;
    // int i=0;
    try {
        File file = new File(path);
        BufferedReader bf = new BufferedReader(new InputStreamReader(new FileInputStream(file), "UTF8"));
        while ((line = bf.readLine()) != null) {
            /*    lineOrigine = line.split("\t");
                if(lineOrigine.length < 2) continue;
                
                lineTmp = removeStopWords(lineOrigine[1]);
                */
            nodeSearchTerm = searchHelper.simpleSearchPreferredTerm(conn, line.trim(), idLang, idTheso, idGroup);
            hashMapSyn = searchHelper.simpleSearchNonPreferredTerm(conn, line.trim(), idLang, idTheso, idGroup);
            stringBuilder.append(line.trim());
            // stringBuilder.append(" #### ");
            stringBuilder.append("\t");
            first = true;
            for (String term : nodeSearchTerm) {
                if (!first) {
                    stringBuilder.append("##");
                }
                stringBuilder.append(term);
                first = false;
            }
            stringBuilder.append("\t");
            first = true;
            for (Map.Entry<String, String> entry : hashMapSyn.entrySet()) {
                String key = entry.getKey();
                String value = entry.getValue();
                if (!first) {
                    stringBuilder.append("##");
                }
                stringBuilder.append("Alt: ");
                stringBuilder.append(value);
                stringBuilder.append("-> Pref: ");
                stringBuilder.append(key);
                first = false;
            }
            // System.out.println(stringBuilder.toString());
            bw.write(stringBuilder.toString());
            bw.newLine();
            stringBuilder.delete(0, stringBuilder.capacity());
        /*     i++;
                if(i==1000) {
                    closeFile(bw);
                    conn.close();
                    return;
                }*/
        }
    } catch (IOException ex) {
        Logger.getLogger(CompareConceptTest.class.getName()).log(Level.SEVERE, null, ex);
    }
    closeFile(bw);
    conn.close();
}