Examples of ITableMetaData


Examples of org.dbunit.dataset.ITableMetaData

        _consumer.startDataSet();
        while(_iterator.next())
        {
            ITable table = _iterator.getTable();
            ITableMetaData metaData = table.getTableMetaData();

            _consumer.startTable(metaData);
            try
            {
                Column[] columns = metaData.getColumns();
                if (columns.length == 0)
                {
                    _consumer.endTable();
                    continue;
                }
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

     * @throws DataSetException
     */
    public String format(ITable table) throws DataSetException
    {
        StringBuffer sb = new StringBuffer();
        ITableMetaData tableMetaData = table.getTableMetaData();
        // Title line
        sb.append("******");
        sb.append(" table: ").append(tableMetaData.getTableName()).append(" ");
        sb.append("**");
        sb.append(" row count: ").append(table.getRowCount()).append(" ");
        sb.append("******");
        sb.append("\n");
       
        // Column headers
        int width = 20;
        Column[] cols = tableMetaData.getColumns();
        for (int i = 0; i < cols.length; i++) {
            sb.append(padRight(cols[i].getColumnName(), width, ' '));
            sb.append("|");
        }
        sb.append("\n");
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

        connection.getConfig().getConfigurator().configureStatement(preparedStatement);

        ResultSet rs = preparedStatement.executeQuery();
       
        boolean caseSensitiveTableNames = connection.getConfig().getFeature(DatabaseConfig.FEATURE_CASE_SENSITIVE_TABLE_NAMES);
        ITableMetaData metaData = new ResultSetTableMetaData(tableName, rs, connection, caseSensitiveTableNames);
        ForwardOnlyResultSetTable table = new ForwardOnlyResultSetTable(metaData, rs);
        return table;
    }
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

        expectedTable = expectedDataset.getTable(tableName);
      } catch (NoSuchTableException e) {
        throw new DatabaseUnitException("Did not find table in source file '" +
            _src + "' using format '" + getFormat() + "'", e);
      }
            ITableMetaData expectedMetaData = expectedTable.getTableMetaData();

            ITable actualTable;
      try {
        actualTable = actualDataset.getTable(tableName);
      } catch (NoSuchTableException e) {
        throw new DatabaseUnitException("Did not find table in actual dataset '" +
            actualDataset + "' via db connection '" + connection + "'", e);
      }
            // Only compare columns present in expected table. Extra columns
            // are filtered out from actual database table.
            actualTable = DefaultColumnFilter.includedColumnsTable(
                    actualTable, expectedMetaData.getColumns());

            if (_sort)
            {
                expectedTable = new SortedTable(expectedTable);
                actualTable = new SortedTable(actualTable);
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

    );
  }

  public void testGetTableMetaData() throws DataSetException {
    ITable table = getTable();
    ITableMetaData tableMetaData = table.getTableMetaData();
    assertEquals("table", tableMetaData.getTableName());
    Column[] columns = tableMetaData.getColumns();
    assertEquals(3, columns.length);
    assertEquals("ONE", columns[0].getColumnName());
    assertEquals("TWO", columns[1].getColumnName());
    assertEquals("THREE", columns[2].getColumnName());
    assertEquals(DataType.UNKNOWN, columns[0].getDataType());
    assertEquals(DataType.UNKNOWN, columns[1].getDataType());
    assertEquals(DataType.UNKNOWN, columns[2].getDataType());
    Column[] primaryKeys = tableMetaData.getPrimaryKeys();
    assertEquals(0, primaryKeys.length);
  }
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

            while (!tableNames.isEmpty())
            {
                String tableName = (String)tableNames.pop();

                // Use database table name. Required to support case sensitive database.
                ITableMetaData databaseMetaData =
                        databaseDataSet.getTableMetaData(tableName);
                tableName = databaseMetaData.getTableName();

                StringBuffer sqlBuffer = new StringBuffer(128);
                sqlBuffer.append(getDeleteAllCommand());
                sqlBuffer.append(getQualifiedName(connection.getSchema(), tableName, connection));
                statement.addBatch(sqlBuffer.toString());
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

            if (isEmpty(table))
            {
                continue;
            }

            ITableMetaData metaData = getOperationMetaData(connection,
                    table.getTableMetaData());
            BitSet ignoreMapping = null;
            OperationData operationData = null;
            IPreparedBatchStatement statement = null;
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

        for (int i = 0; i < tableNames.length; i++)
        {
            String tableName = tableNames[i];
            ITable expectedTable = expectedDataset.getTable(tableName);
            ITableMetaData expectedMetaData = expectedTable.getTableMetaData();

            // Only compare columns present in expected table. Extra columns
            // are filtered out from actual database table.
            ITable actualTable = actualDataset.getTable(tableName);
            actualTable = DefaultColumnFilter.includedColumnsTable(
                    actualTable, expectedMetaData.getColumns());

            if (_sort)
            {
                expectedTable = new SortedTable(expectedTable);
                actualTable = new SortedTable(actualTable);
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

            if (isEmpty(table))
            {
                continue;
            }

            ITableMetaData metaData = getOperationMetaData(connection,
                    table.getTableMetaData());
            RowOperation updateRowOperation = createUpdateOperation(connection,
                    metaData);
            RowOperation insertRowOperation = new InsertRowOperation(connection,
                    metaData);
View Full Code Here

Examples of org.dbunit.dataset.ITableMetaData

                columns[i] = new Column((String) readColumns.get(i), DataType.UNKNOWN);
            }

            String tableName = url.getFile();
            tableName = tableName.substring(tableName.lastIndexOf("/")+1, tableName.indexOf(".csv"));
            ITableMetaData metaData = new DefaultTableMetaData(tableName, columns);
            _consumer.startTable(metaData);
            for (int i = 1 ; i < readData.size(); i++) {
                List rowList = (List)readData.get(i);
                Object[] row = rowList.toArray();
                for(int col = 0; col < row.length; col++) {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.