Package org.dbunit.dataset

Examples of org.dbunit.dataset.ITableMetaData

41
42
43
44
45
46
47
48
49
50
51
52
53
    ITable table = DataSetUtils.stringsTable("tryme",
      col("id", "name", "active_yn"),
      row("1", "John", "Y"),
      row("2", "Matt", "N")
    );
    ITableMetaData tableMetaData = table.getTableMetaData();
    assertEquals("tryme", tableMetaData.getTableName());
    Column[] columns = tableMetaData.getColumns();
    assertEquals(3, columns.length);
    assertColumn(columns[0], "id", DataType.UNKNOWN, "UNKNOWN");
    assertColumn(columns[1], "name", DataType.UNKNOWN, "UNKNOWN");
    assertColumn(columns[2], "active_yn", DataType.UNKNOWN, "UNKNOWN");
    assertEquals(2, table.getRowCount());
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
    ITable table = DataSetUtils.csvTable("tryme",
      "id,name,active_yn\n" +
      "1,John,Y\n" +
      "2,Matt,N"
    );
    ITableMetaData tableMetaData = table.getTableMetaData();
    assertEquals("tryme", tableMetaData.getTableName());
    Column[] columns = tableMetaData.getColumns();
    assertEquals(3, columns.length);
    assertColumn(columns[0], "id", DataType.UNKNOWN, "UNKNOWN");
    assertColumn(columns[1], "name", DataType.UNKNOWN, "UNKNOWN");
    assertColumn(columns[2], "active_yn", DataType.UNKNOWN, "UNKNOWN");
    assertEquals(2, table.getRowCount());
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
    return stringsTable(name, builder.getCols(), builder.getRows());
  }

  public static DefaultTable copyTable(ITable other) {
    try {
      ITableMetaData tableMetaData = other.getTableMetaData();
      DefaultTable result = new DefaultTable(tableMetaData);
      Column[] columns = tableMetaData.getColumns();
      for (int i = 0; i < other.getRowCount(); i++) {
        Object[] row = new Object[columns.length];
        for (int j = 0; j < columns.length; j++) {
          row[j] = other.getValue(i, columns[j].getColumnName());
        }
View Full Code Here
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
            while(iterator.next())
            {
                ITable table = iterator.getTable();
                String tableName = table.getTableMetaData().getTableName();

                ITableMetaData metaData =
                        databaseDataSet.getTableMetaData(tableName);

                // enable identity insert
                boolean hasIdentityColumn = hasIdentityColumn(metaData, connection);

                if (hasIdentityColumn)
                {
                    StringBuffer sqlBuffer = new StringBuffer(128);
                    sqlBuffer.append("SET IDENTITY_INSERT ");
                    sqlBuffer.append(getQualifiedName(connection.getSchema(),
                            metaData.getTableName(), connection));
                    sqlBuffer.append(" ON");
                    statement.execute(sqlBuffer.toString());
                }

                try
                {
                    _operation.execute(connection, new DefaultDataSet(table));
                }
                finally
                {
                    // disable identity insert
                    if (hasIdentityColumn)
                    {
                        StringBuffer sqlBuffer = new StringBuffer(128);
                        sqlBuffer.append("SET IDENTITY_INSERT ");
                        sqlBuffer.append(getQualifiedName(connection.getSchema(),
                                metaData.getTableName(), connection));
                        sqlBuffer.append(" OFF");
                        statement.execute(sqlBuffer.toString());
                    }
                    jdbcConnection.commit();
                }
View Full Code Here
287
288
289
290
291
292
293
294
295
296
297
                    _tableMap);
            throw new NoSuchTableException(tableName);
        }

        // Try to find cached metadata
        ITableMetaData metaData = (ITableMetaData)_tableMap.get(tableName);
        if (metaData != null)
        {
            return metaData;
        }
View Full Code Here
309
310
311
312
313
314
315
316
317
318
319
        initialize();

        try
        {
            ITableMetaData metaData = getTableMetaData(tableName);

            DatabaseConfig config = _connection.getConfig();
            IResultSetTableFactory factory = (IResultSetTableFactory)config.getProperty(
                    DatabaseConfig.PROPERTY_RESULTSET_TABLE_FACTORY);
            return factory.createTable(metaData, _connection);
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
        ITableIterator iterator = dataSet.iterator();
        while(iterator.next())
        {
            // create the table i.e. sheet
            ITable table = iterator.getTable();
            ITableMetaData metaData = table.getTableMetaData();
            HSSFSheet sheet = workbook.createSheet(metaData.getTableName());

            // write table metadata i.e. first row in sheet
            workbook.setSheetName(index, metaData.getTableName());

            HSSFRow headerRow = sheet.createRow(0);
            Column[] columns = metaData.getColumns();
            for (int j = 0; j < columns.length; j++)
            {
                Column column = columns[j];
                HSSFCell cell = headerRow.createCell(j);
                cell.setCellValue(new HSSFRichTextString(column.getColumnName()));
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
115
            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));
                String sql = sqlBuffer.toString();
View Full Code Here
356
357
358
359
360
361
362
363
364
365
366
367
        if (failureHandler == null) {
            logger.debug("FailureHandler is null. Using default implementation");
            failureHandler = getDefaultFailureHandler();
        }

        ITableMetaData expectedMetaData = expectedTable.getTableMetaData();
        ITableMetaData actualMetaData = actualTable.getTableMetaData();
        String expectedTableName = expectedMetaData.getTableName();

        // Verify row count
        int expectedRowsCount = expectedTable.getRowCount();
        int actualRowsCount = actualTable.getRowCount();
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
            if (isEmpty(table))
            {
                continue;
            }

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

            try
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.