Examples with Table mom.trd.opentheso.core.exports.privatesdatas.tables.Table used on opensource projects

Example 16 with Table

use of mom.trd.opentheso.core.exports.privatesdatas.tables.Table in project opentheso by miledrousset.

the class ExportPrivatesDatas method getDatasOfTable.

public ArrayList<Table> getDatasOfTable(HikariDataSource ds, String tableName) {
    ArrayList<Table> tableList = new ArrayList<>();
    if (!isTableToIgnore(tableName)) {
        ArrayList<TablesColumn> tablesColumns = new ArrayList<>();
        Connection conn;
        Statement stmt;
        ResultSet resultSet;
        String colomneNameTemp;
        try {
            conn = ds.getConnection();
            try {
                stmt = conn.createStatement();
                try {
                    // récupération des noms des colonnes de la table
                    // et sont type de données
                    String query = "SELECT COLUMN_NAME," + " data_type FROM INFORMATION_SCHEMA.COLUMNS" + " where TABLE_NAME='" + tableName + "'";
                    resultSet = stmt.executeQuery(query);
                    while (resultSet.next()) {
                        colomneNameTemp = resultSet.getString("COLUMN_NAME");
                        if (!isToIgnore(colomneNameTemp)) {
                            TablesColumn tablesColumn = new TablesColumn();
                            tablesColumn.setColumnName(colomneNameTemp);
                            tablesColumn.setColumnType(resultSet.getString("data_type"));
                            tablesColumns.add(tablesColumn);
                        }
                    }
                    // récupération des données de la table
                    query = "SELECT * FROM " + tableName;
                    resultSet = stmt.executeQuery(query);
                    while (resultSet.next()) {
                        Table table = new Table();
                        ArrayList<LineOfData> lineOfDatas = new ArrayList<>();
                        for (TablesColumn tablesColumn : tablesColumns) {
                            LineOfData lineOfData = new LineOfData();
                            lineOfData.setColomne(tablesColumn.getColumnName());
                            if (tablesColumn.getColumnType().equalsIgnoreCase("integer")) {
                                lineOfData.setValue("" + resultSet.getInt(tablesColumn.getColumnName()));
                            }
                            if (tablesColumn.getColumnType().equalsIgnoreCase("character varying")) {
                                lineOfData.setValue(resultSet.getString(tablesColumn.getColumnName()));
                            }
                            if (tablesColumn.getColumnType().equalsIgnoreCase("character")) {
                                lineOfData.setValue(resultSet.getString(tablesColumn.getColumnName()));
                            }
                            if (tablesColumn.getColumnType().equalsIgnoreCase("text")) {
                                lineOfData.setValue(resultSet.getString(tablesColumn.getColumnName()));
                            }
                            if (tablesColumn.getColumnType().equalsIgnoreCase("timestamp with time zone")) {
                                lineOfData.setValue("" + resultSet.getDate(tablesColumn.getColumnName()));
                            }
                            if (tablesColumn.getColumnType().equalsIgnoreCase("timestamp without time zone")) {
                                lineOfData.setValue("" + resultSet.getDate(tablesColumn.getColumnName()));
                            }
                            if (tablesColumn.getColumnType().equalsIgnoreCase("boolean")) {
                                lineOfData.setValue("" + resultSet.getBoolean(tablesColumn.getColumnName()));
                            }
                            if (tablesColumn.getColumnType().equalsIgnoreCase("USER-DEFINED")) {
                                lineOfData.setValue(resultSet.getString(tablesColumn.getColumnName()));
                            }
                            lineOfDatas.add(lineOfData);
                        }
                        table.setLineOfDatas(lineOfDatas);
                        tableList.add(table);
                    }
                } finally {
                    stmt.close();
                }
            } finally {
                conn.close();
            }
        } catch (SQLException ex) {
            Logger.getLogger(Table.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    return tableList;
}

Example 17 with Table

use of mom.trd.opentheso.core.exports.privatesdatas.tables.Table in project opentheso by miledrousset.

the class ExportPrivatesDatas method showPrivateTables.

/**
 * On recupere seulement les tables privates
 *
 * @param ds
 * @return
 */
public ArrayList<String> showPrivateTables(HikariDataSource ds) {
    Connection conn;
    Statement stmt;
    ResultSet resultSet;
    ArrayList<String> tablesprivate = new ArrayList<>();
    try {
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "SELECT * from Information_Schema.Tables where table_type= 'BASE TABLE' and table_schema ='public'";
                resultSet = stmt.executeQuery(query);
                while (resultSet.next()) {
                    if (resultSet.getString("table_name").equalsIgnoreCase("users")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("roles")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("user_role")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("concept_term_candidat")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("proposition")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("concept_candidat")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("term_candidat")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("concept_orphan")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("concept_fusion")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("images")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("preferences")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("concept_group_historique")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("concept_group_label_historique")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("concept_historique")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("hierarchical_relationship_historique")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("non_preferred_term")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("note_historique")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                    if (resultSet.getString("table_name").equalsIgnoreCase("term_historique")) {
                        tablesprivate.add(resultSet.getString("table_name"));
                    }
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException ex) {
        Logger.getLogger(Table.class.getName()).log(Level.SEVERE, null, ex);
    }
    return tablesprivate;
}