public List<ColumnInfo> getNumericOrStringTypeColumns(TableInfo table, int numCols) { List<ColumnInfo> columns = table.getColumnList(); int colCnt = columns.size(); List<ColumnInfo> partColumns = new ArrayList<ColumnInfo>(); for (int i = 0; i < numCols; i++) { ColumnInfo col = null; boolean f = false; for (int j = 0; j < 10 && !f; j++) { col = columns.get(random.nextInt(colCnt)); if ((col.getColumnType() == Types.INTEGER || col.getColumnType() == Types.DOUBLE || col.getColumnType() == Types.FLOAT || col.getColumnType() == Types.SMALLINT || col.getColumnType() == Types.BIGINT || col.getColumnType() == Types.DECIMAL || col.getColumnType() == Types.NUMERIC || col.getColumnType() == Types.REAL || col.getColumnType() == Types.CHAR || col.getColumnType() == Types.LONGNVARCHAR || col.getColumnType() == Types.VARCHAR) && !partColumns.contains(col)) { f = true; } } if (f) partColumns.add(col); } return partColumns; }
public List<ColumnInfo> getNonClobBlobXmlTypeColumns(TableInfo table, int numCols) { List<ColumnInfo> columns = table.getColumnList(); int colCnt = columns.size(); List<ColumnInfo> partColumns = new ArrayList<ColumnInfo>(); for (int i = 0; i < numCols; i++) { ColumnInfo col = null; boolean f = false; for (int j = 0; j < 10 && !f; j++) { col = columns.get(random.nextInt(colCnt)); if (col.getColumnType() != Types.BLOB && col.getColumnType() != Types.CLOB && col.getColumnType() != Types.SQLXML && !partColumns.contains(col)) { f = true; } } if (f) partColumns.add(col); } return partColumns; }
public List<ColumnInfo> getDateTypeColumns(TableInfo table, int numCols) { List<ColumnInfo> columns = table.getColumnList(); int colCnt = columns.size(); List<ColumnInfo> partColumns = new ArrayList<ColumnInfo>(); for (int i = 0; i < numCols; i++) { ColumnInfo col = null; boolean f = false; for (int j = 0; j < 10 && !f; j++) { col = columns.get(random.nextInt(colCnt)); if ((col.getColumnType() == Types.DATE || col.getColumnType() == Types.TIME || col.getColumnType() == Types.TIMESTAMP) && !partColumns.contains(col)) { f = true; } } if (f) partColumns.add(col); } return partColumns; }