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

Example 1 with NodeTT

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

the class ConceptHelper method getAllListIdsOfTopConcepts.

/**
 * Cette fonction permet de récupérer la liste des Ids of Topconcepts pour
 * un thésaurus
 *
 * @param ds
 * @param idThesaurus
 * @return Objet class NodeTT
 */
public ArrayList<NodeTT> getAllListIdsOfTopConcepts(HikariDataSource ds, String idThesaurus) {
    Connection conn;
    Statement stmt;
    ResultSet resultSet;
    ArrayList<NodeTT> listIdOfTopConcept = new ArrayList<>();
    try {
        // Get connection from pool
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "select id_concept," + "id_ark, id_handle, idgroup from concept left join concept_group_concept on id_concept = idconcept and id_thesaurus = idthesaurus where id_thesaurus = '" + idThesaurus + "'" + " and top_concept = true";
                stmt.executeQuery(query);
                resultSet = stmt.getResultSet();
                while (resultSet.next()) {
                    NodeTT nodeTT = new NodeTT();
                    nodeTT.setIdConcept(resultSet.getString("id_concept"));
                    nodeTT.setIdArk(resultSet.getString("id_ark"));
                    nodeTT.setIdArk(resultSet.getString("id_handle"));
                    nodeTT.setIdGroup(resultSet.getString("idgroup"));
                    listIdOfTopConcept.add(nodeTT);
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException sqle) {
        // Log exception
        log.error("Error while getting Ids of TopConcept of thésaurus : " + idThesaurus, sqle);
        listIdOfTopConcept = null;
    }
    return listIdOfTopConcept;
}

Example 2 with NodeTT

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

the class ThesaurusDatas method exportAllDatas.

/**
 * permet de récupérer toutes les données d'un thésaurus
 * puis les chargées dans les variables de la classe
 *
 * @param ds
 * @param idThesaurus
 * @return
 */
public boolean exportAllDatas(HikariDataSource ds, String idThesaurus) {
    // récupération du thésaurus
    this.nodeThesaurus = new ThesaurusHelper().getNodeThesaurus(ds, idThesaurus);
    // récupération des groupes
    ArrayList<String> idGroups = new GroupHelper().getListIdOfGroup(ds, idThesaurus);
    for (String idGroup : idGroups) {
        this.nodeGroupLabels.add(new GroupHelper().getNodeGroupLabel(ds, idGroup, idThesaurus));
    // System.out.println("idGroup = : " + idGroup);
    }
    // récupération des ids des Tops Concepts
    nodeTTs = new ConceptHelper().getAllListIdsOfTopConcepts(ds, idThesaurus);
    // récupération de tous les concepts
    for (NodeTT nodeTT1 : nodeTTs) {
        new ConceptHelper().exportAllConcepts(ds, nodeTT1.getIdConcept(), idThesaurus, nodeConceptExports);
    }
    return true;
}