Package org.dbunit.dataset

Examples of org.dbunit.dataset.ITableMetaData

79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
        _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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
     * @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
95
96
97
98
99
100
101
102
103
        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
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
        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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
    );
  }

  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
93
94
95
96
97
98
99
100
101
102
103
104
105
            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
125
126
127
128
129
130
131
132
133
134
135
            if (isEmpty(table))
            {
                continue;
            }

            ITableMetaData metaData = getOperationMetaData(connection,
                    table.getTableMetaData());
            BitSet ignoreMapping = null;
            OperationData operationData = null;
            IPreparedBatchStatement statement = null;
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
        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
83
84
85
86
87
88
89
90
91
92
93
            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
117
118
119
120
121
122
123
124
125
126
127
                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

Related Classes of org.dbunit.dataset.ITableMetaData

  • cn.baiweigang.qtaf.toolkit.dbunit.data.excel.XlsDataSetWriter
  • cn.baiweigang.qtaf.toolkit.dbunit.data.excel.XlsTableWrapper
  • com.aconex.scrutineer.jdbc.HSQLHelper
  • com.btmatthews.maven.plugins.inmemdb.ldr.dbunit.DBUnitCSVLoader
  • com.excilys.ebi.spring.dbunit.dataset.xml.flyweight.FlyWeightFlatXmlProducer
  • org.dbcooper.dataset.CsvTableTest
  • org.dbcooper.dataset.DataSetUtils
  • org.dbcooper.dataset.DataSetUtilsTest
  • org.dbcooper.dataset.StringsTableTest
  • org.dbunit.ant.Compare
    • Copyright © 2018 www.massapicom. 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.