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

Example 1 with NodeUserGroupThesaurus

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

the class CurrentUser2 method listAllGroupTheso.

private void listAllGroupTheso() {
    UserHelper2 userHelper = new UserHelper2();
    listeAllGroupTheso = userHelper.getAllGroupTheso(connect.getPoolConnexion(), connect.getWorkLanguage());
    // les thésos sans groupe
    ArrayList<NodeUserGroupThesaurus> listeAllGroupTheso_wtihoutGroup;
    listeAllGroupTheso_wtihoutGroup = userHelper.getAllThesoWithoutGroup(connect.getPoolConnexion(), connect.getWorkLanguage());
    if (listeAllGroupTheso_wtihoutGroup != null)
        if (!listeAllGroupTheso_wtihoutGroup.isEmpty())
            listeAllGroupTheso.addAll(listeAllGroupTheso_wtihoutGroup);
}

Example 2 with NodeUserGroupThesaurus

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

the class UserHelper2 method getAllThesoWithoutGroup.

/**
 * cette fonction permet de retourner la liste des thésaurus qui
 * n'apprtiennent à aucun groupe
 *
 * @param ds
 * @param idLangSource
 * @return #MR
 */
public ArrayList<NodeUserGroupThesaurus> getAllThesoWithoutGroup(HikariDataSource ds, String idLangSource) {
    Connection conn;
    Statement stmt;
    ResultSet resultSet;
    // / fonction prête à intégrer
    ArrayList<NodeUserGroupThesaurus> nodeUserGroupThesauruses = new ArrayList<>();
    try {
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "SELECT thesaurus_label.id_thesaurus, thesaurus_label.title " + " FROM  thesaurus_label" + " WHERE thesaurus_label.lang = '" + idLangSource + "'" + " and thesaurus_label.id_thesaurus not in " + "(select id_thesaurus from  user_group_thesaurus)" + " ORDER BY LOWER(thesaurus_label.title)";
                resultSet = stmt.executeQuery(query);
                while (resultSet.next()) {
                    NodeUserGroupThesaurus nodeUserGroupThesaurus = new NodeUserGroupThesaurus();
                    nodeUserGroupThesaurus.setIdThesaurus(resultSet.getString("id_thesaurus"));
                    nodeUserGroupThesaurus.setThesaurusName(resultSet.getString("title"));
                    nodeUserGroupThesaurus.setIdGroup(-1);
                    nodeUserGroupThesaurus.setGroupName("");
                    nodeUserGroupThesauruses.add(nodeUserGroupThesaurus);
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException ex) {
        Logger.getLogger(UserHelper2.class.getName()).log(Level.SEVERE, null, ex);
    }
    return nodeUserGroupThesauruses;
}

Example 3 with NodeUserGroupThesaurus

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

the class UserHelper2 method getAllGroupTheso.

/**
 * cette fonction permet de retourner la liste des thésaurus et les groupes
 * correspondants
 *
 * @param ds
 * @param idLangSource
 * @return #MR
 */
public ArrayList<NodeUserGroupThesaurus> getAllGroupTheso(HikariDataSource ds, String idLangSource) {
    Connection conn;
    Statement stmt;
    ResultSet resultSet;
    ArrayList<NodeUserGroupThesaurus> nodeUserGroupThesauruses = new ArrayList<>();
    try {
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "SELECT " + "  user_group_label.label_group," + "  thesaurus_label.title," + "  user_group_thesaurus.id_thesaurus," + "  user_group_thesaurus.id_group" + " FROM " + "  thesaurus_label, " + "  user_group_thesaurus, " + "  user_group_label" + " WHERE " + "  user_group_thesaurus.id_group = user_group_label.id_group AND" + "  user_group_thesaurus.id_thesaurus = thesaurus_label.id_thesaurus AND" + "  thesaurus_label.lang = '" + idLangSource + "'" + " ORDER BY LOWER(thesaurus_label.title)";
                resultSet = stmt.executeQuery(query);
                while (resultSet.next()) {
                    NodeUserGroupThesaurus nodeUserGroupThesaurus = new NodeUserGroupThesaurus();
                    nodeUserGroupThesaurus.setIdThesaurus(resultSet.getString("id_thesaurus"));
                    nodeUserGroupThesaurus.setThesaurusName(resultSet.getString("title"));
                    nodeUserGroupThesaurus.setIdGroup(resultSet.getInt("id_group"));
                    nodeUserGroupThesaurus.setGroupName(resultSet.getString("label_group"));
                    nodeUserGroupThesauruses.add(nodeUserGroupThesaurus);
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException ex) {
        Logger.getLogger(UserHelper2.class.getName()).log(Level.SEVERE, null, ex);
    }
    return nodeUserGroupThesauruses;
}