protected ITable executeDynamicQuery(IDatabaseConnection dbConn, String queryName, String sql, List<String> parameters, boolean needSort) throws Exception { // change join type to match current setting sql = changeJoinType(sql, joinType); PreparedStatement prepStat = dbConn.getConnection().prepareStatement(sql); for (int j = 1; j <= parameters.size(); ++j) { prepStat.setString(j, parameters.get(j - 1).trim()); } ITable queryTable = dbConn.createTable(resultTableName + queryName, prepStat); String[] columnNames = new String[queryTable.getTableMetaData().getColumns().length]; for (int i = 0; i < columnNames.length; i++) { columnNames[i] = queryTable.getTableMetaData().getColumns()[i].getColumnName(); } if (needSort) { queryTable = new SortedTable(queryTable, columnNames); } // printResult(queryTable); return queryTable; }
protected Column createColumn(String columnName) { return new Column(columnName, DataType.UNKNOWN); }
protected static void printResult(ITable resultTable) throws DataSetException { StringBuilder sb = new StringBuilder(); int columnCount = resultTable.getTableMetaData().getColumns().length; String[] columns = new String[columnCount]; for (int i = 0; i < columnCount; i++) { sb.append(resultTable.getTableMetaData().getColumns()[i].getColumnName()); sb.append("-"); sb.append(resultTable.getTableMetaData().getColumns()[i].getDataType()); sb.append("\t"); columns[i] = resultTable.getTableMetaData().getColumns()[i].getColumnName(); } sb.append("\n"); for (int i = 0; i < resultTable.getRowCount(); i++) { for (int j = 0; j < columns.length; j++) { sb.append(resultTable.getValue(i, columns[j])); sb.append("\t"); } sb.append("\n"); } System.out.println(sb.toString()); }
activeMetaData.getColumnIndex(getAttributeNameFromCache(attributes.getQName(i))); } catch (NoSuchColumnException e) { columnsToMerge.add(new Column(getAttributeNameFromCache(attributes.getQName(i)), DataType.UNKNOWN)); StringBuilder extraColumnNames = new StringBuilder(); for (Column col : columnsToMerge) { extraColumnNames.append(extraColumnNames.length() > 0 ? "," : "").append(col.getColumnName());
public static Collection<String> extractColumnNames(final Column[] columns) { final List<String> names = new ArrayList<String>(columns.length); for (Column column : columns) { names.add(column.getColumnName().toLowerCase()); } return names; }
private Column[] createColumns(Collection<String> columnNames) { final List<Column> columns = new ArrayList<Column>(); for (String columnName : columnNames) { Column column = new Column(columnName, DataType.UNKNOWN); columns.add(column); } return columns.toArray(new Column[columns.size()]); }
out.write(metaData.getColumns()[i].getColumnName()+": "); boolean isNumber = currentColumn.getDataType().isNumber(); if(!isNumber){ out.write("\"");
public static Collection<String> extractColumnNames(final Column[] columns) { final List<String> names = new ArrayList<String>(columns.length); for (Column column : columns) { names.add(column.getColumnName().toLowerCase()); } return names; }
private Column[] createColumns(Collection<String> columnNames) { final List<Column> columns = new ArrayList<Column>(); for (String columnName : columnNames) { Column column = new Column(columnName, DataType.UNKNOWN); columns.add(column); } return columns.toArray(new Column[columns.size()]); }
out.write(FOUR_SPACES+DOUBLE_SPACES+"\""+metaData.getColumns()[i].getColumnName() + "\": "); boolean isNumber = currentColumn.getDataType().isNumber(); if (!isNumber) { out.write("\"");
public static Collection<String> extractColumnNames(final Column[] columns) { final List<String> names = new ArrayList<String>(columns.length); for (Column column : columns) { names.add(column.getColumnName().toLowerCase()); } return names; }
private Column[] createColumns(Collection<String> columnNames) { final List<Column> columns = new ArrayList<Column>(); for (String columnName : columnNames) { Column column = new Column(columnName, DataType.UNKNOWN); columns.add(column); } return columns.toArray(new Column[columns.size()]); }
private ITable filterTableByPrimaryKey(ITable expectedDataSet, ITable actualDataSet) throws DataSetException { //PrimaryKeyFilteredTableWrapper uses Set.contains to check PK values, so types should be the same in both datasets DataType dataType = actualDataSet.getTableMetaData().getPrimaryKeys()[0].getDataType(); String pkName = actualDataSet.getTableMetaData().getPrimaryKeys()[0].getColumnName(); Set<Object> pkSet = new HashSet<>(); for (int i = 0; i < expectedDataSet.getRowCount(); i++) { pkSet.add(dataType.typeCast(expectedDataSet.getValue(i, pkName))); } return new PrimaryKeyFilteredTableWrapper(actualDataSet, pkSet); }
public static Collection<String> extractColumnNames(final Column[] columns) { final List<String> names = new ArrayList<String>(columns.length); for (Column column : columns) { names.add(column.getColumnName().toLowerCase()); } return names; }
private Column[] createColumns(Collection<String> columnNames) { final List<Column> columns = new ArrayList<Column>(); for (String columnName : columnNames) { Column column = new Column(columnName, DataType.UNKNOWN); columns.add(column); } return columns.toArray(new Column[columns.size()]); }
/** * Adds the rows of the DbUnit table to the given table. * * @param dbUnitTable The DbUnit table containing the rows, not null * @param table The table to add the rows to, not null * @param primaryKeyColumnNames The names of the pk columns, empty if there are none */ protected void addRows(ITable dbUnitTable, Table table, List<String> primaryKeyColumnNames) throws DataSetException { org.dbunit.dataset.Column[] columns = dbUnitTable.getTableMetaData().getColumns(); int rowCount = dbUnitTable.getRowCount(); for (int rowIndex = 0; rowIndex < rowCount; rowIndex++) { Row row = new Row(); table.addRow(row); for (org.dbunit.dataset.Column dbUnitColumn : columns) { String columnName = dbUnitColumn.getColumnName(); DataType columnType = dbUnitColumn.getDataType(); Object value = dbUnitTable.getValue(rowIndex, columnName); Column column = new Column(columnName, columnType, value); if (primaryKeyColumnNames.contains(columnName)) { row.addPrimaryKeyColumn(column); } else { row.addColumn(column); } } } }
protected ITable executeQuery(IDatabaseConnection dbConn, String queryName, String sql, boolean needSort) throws Exception { // change join type to match current setting sql = changeJoinType(sql, joinType); ITable queryTable = dbConn.createQueryTable(resultTableName + queryName, sql); String[] columnNames = new String[queryTable.getTableMetaData().getColumns().length]; for (int i = 0; i < columnNames.length; i++) { columnNames[i] = queryTable.getTableMetaData().getColumns()[i].getColumnName(); } if (needSort) { queryTable = new SortedTable(queryTable, columnNames); } // printResult(queryTable); return queryTable; }
private Column[] createColumns(Collection<String> columnNames) { final List<Column> columns = new ArrayList<Column>(); for (String columnName : columnNames) { Column column = new Column(columnName, DataType.UNKNOWN); columns.add(column); } return columns.toArray(new Column[columns.size()]); }
public void addColumn(Column column) { if (!CollectionUtils.exists(columnNames, new FindColumnPredicate(column.getColumnName()))) { boolean added = columns.add(column); if (added) { columnNames.add(column.getColumnName()); } } }
private Column[] createColumns(Collection<String> columnNames) { final List<Column> columns = new ArrayList<Column>(); for (String columnName : columnNames) { Column column = new Column(columnName, DataType.UNKNOWN); columns.add(column); } return columns.toArray(new Column[columns.size()]); }