Examples of ITable

com.aspose.slides.ITable
kakuro.table.ITable
Tábla interfész, az adatokat csak ezeken a függvényeken keresztül lehet elérni, plusz pár hasznos konstans
org.dbunit.dataset.ITable
A table represents a collection of tabular data. @author Manuel Laflamme @version $Revision: 746 $ @since Feb 17, 2002

Examples of org.dbunit.dataset.ITable

    StringBuffer dataSetFile = new StringBuffer();
    dataSetFile.append("config").append(File.separator).append("testBulkAddCRLIssuerBatchSizeOverlimitOK.xml");
    IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(new FileInputStream(dataSetFile.toString()));
    ReplacementDataSet replacement = new ReplacementDataSet(expectedDataSet);
    replacement.addReplacementObject("[null]", null);
    ITable expectedTable = replacement.getTable("CRL_ISSUER");
    SortedTable expectedSortedTable = new SortedTable(expectedTable, new String[] {"name"});
    expectedSortedTable.setUseComparable(true);
    
    IDataSet dataSet = this.databaseTester.getConnection().createDataSet();
    ITable actualTable = dataSet.getTable("CRL_ISSUER");
    ITable filteredActualTable = DefaultColumnFilter.includedColumnsTable(actualTable, expectedTable.getTableMetaData().getColumns());
    SortedTable actualSortedTable = new SortedTable(filteredActualTable, new String[] {"name"});
    actualSortedTable.setUseComparable(true);


    Assertion.assertEquals(expectedSortedTable, actualSortedTable);
  }

View Full Code Here

Examples of org.dbunit.dataset.ITable

    StringBuffer dataSetFile = new StringBuffer();
    dataSetFile.append("config").append(File.separator).append("testDeleteCRLIssuerOK.xml");
    IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(new FileInputStream(dataSetFile.toString()));
    ReplacementDataSet replacement = new ReplacementDataSet(expectedDataSet);
    replacement.addReplacementObject("[null]", null);
    ITable expectedTable = replacement.getTable("CRL_ISSUER");
    
    IDataSet actualDataSet = this.databaseTester.getConnection().createDataSet();
    ITable actualTable = actualDataSet.getTable("crl_issuer");
    ITable filteredActualTable = DefaultColumnFilter.includedColumnsTable(actualTable, expectedTable.getTableMetaData().getColumns());
    
    Assertion.assertEquals(expectedTable, filteredActualTable);
  }

View Full Code Here

Examples of org.dbunit.dataset.ITable

    StringBuffer dataSetFile = new StringBuffer();
    dataSetFile.append("config").append(File.separator).append("testDeleteInvalidCRLIssuerOK.xml");
    IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(new FileInputStream(dataSetFile.toString()));
    ReplacementDataSet replacement = new ReplacementDataSet(expectedDataSet);
    replacement.addReplacementObject("[null]", null);
    ITable expectedTable = replacement.getTable("CRL_ISSUER");
    
    IDataSet actualDataSet = this.databaseTester.getConnection().createDataSet();
    ITable actualTable = actualDataSet.getTable("crl_issuer");
    ITable filteredActualTable = DefaultColumnFilter.includedColumnsTable(actualTable, expectedTable.getTableMetaData().getColumns());
    
    Assertion.assertEquals(expectedTable, filteredActualTable);
  }

View Full Code Here

Examples of org.dbunit.dataset.ITable

    StringBuffer dataSetFile = new StringBuffer();
    dataSetFile.append("config").append(File.separator).append("testDeleteAllIssuersOK.xml");
    IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(new FileInputStream(dataSetFile.toString()));
    ReplacementDataSet replacement = new ReplacementDataSet(expectedDataSet);
    replacement.addReplacementObject("[null]", null);
    ITable expectedTable = replacement.getTable("CRL_ISSUER");
    
    IDataSet actualDataSet = this.databaseTester.getConnection().createDataSet();
    ITable actualTable = actualDataSet.getTable("crl_issuer");
    ITable filteredActualTable = DefaultColumnFilter.includedColumnsTable(actualTable, expectedTable.getTableMetaData().getColumns());
    
    Assertion.assertEquals(expectedTable, filteredActualTable);
  }

View Full Code Here

Examples of org.dbunit.dataset.ITable

    private void createHsqldbTables(IDataSet dataSet, Connection connection) throws DataSetException, SQLException {
        String[] tableNames = dataSet.getTableNames();


        String sql = "";
        for (String tableName : tableNames) {
            ITable table = dataSet.getTable(tableName);
            ITableMetaData metadata = table.getTableMetaData();
            Column[] columns = metadata.getColumns();


            sql += "create table " + tableName + "( ";
            boolean first = true;
            for (Column column : columns) {
                if (!first) {
                    sql += ", ";
                }
                String columnName = column.getColumnName();
                String type = resolveType((String) table.getValue(0, columnName));
                sql += columnName + " " + type;
                if (first) {
                    sql += " primary key";
                    first = false;
                }

View Full Code Here

Examples of org.dbunit.dataset.ITable

        
        // update
        storyMapper.addOrUpdate(storyToUpdate);
        
        // check
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_BASICPROJECT);
        
    assertEquals("number of row", 1, databaseData.getRowCount());
    
    assertEquals("name", "Super A", databaseData.getValue(0, "name"));


    }

View Full Code Here

Examples of org.dbunit.dataset.ITable

        
        // update
        storyMapper.addOrUpdate(storyToUpdate);
        
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_BUSINESSVALUE);
        
        assertEquals("number of row", 1, databaseData.getRowCount());
        
        assertEquals("description", "HIGH", databaseData.getValue(0, "description"));
    }

View Full Code Here

Examples of org.dbunit.dataset.ITable

        
        // update
        storyMapper.addOrUpdate(storyToUpdate);
        
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_RISKLEVEL);
        
        assertEquals("number of row", 1, databaseData.getRowCount());
        
        assertEquals("description", "MEDIUM", databaseData.getValue(0, "description"));
    }

View Full Code Here

Examples of org.dbunit.dataset.ITable

        
        // update
        storyMapper.addOrUpdate(storyToUpdate);
        
        // check
        ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_USER1);
        
        assertEquals("number of row", 1, databaseData.getRowCount());
        
        assertEquals("firstname", "Pon", databaseData.getValue(0, "firstname"));
    }

View Full Code Here

Examples of org.dbunit.dataset.ITable

        
        // update
        storyMapper.addOrUpdate(storyToAdd);
        
        // check story
    ITable databaseData = getConnection().createQueryTable("ExpectedData", SELECT_STORY_TO_ADD);
        
    assertEquals("number of row", 1, databaseData.getRowCount());
    
    assertEquals("id", new Integer(storyToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "id"));
    assertEquals("pro_id", new Integer(storyToAdd.getProject().getPersistanceId()), (Integer) databaseData.getValue(0, "pro_id"));
    assertEquals("description", storyToAdd.getDescription(), (String) databaseData.getValue(0, "description")); 
    assertEquals("daysestimated", new Double(storyToAdd.getDaysEstimated()), new Double(databaseData.getValue(0, "daysestimated").toString()));
        assertEquals("bus_id", new Integer(storyToAdd.getBusinessValue().getId()),  (Integer) databaseData.getValue(0, "bus_id"));
        assertEquals("ris_id", new Integer(storyToAdd.getRiskLevel().getId()),  (Integer) databaseData.getValue(0, "ris_id"));
    assertEquals("shortdescription", storyToAdd.getShortDescription(), (String) databaseData.getValue(0, "shortdescription"));
      assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));
      
      // chek tasks


      // task1
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_TASK1_TO_ADD);
        
    assertEquals("number of row", 1, databaseData.getRowCount());
    
    assertEquals("pmu_id", task1ToAdd.getOwner(), databaseData.getValue(0, "pmu_id"));
    assertEquals("daysestimated", new Double(task1ToAdd.getDaysEstimated()), new Double(databaseData.getValue(0, "daysestimated").toString()));
    assertEquals("shortdescription", task1ToAdd.getShortDescription(), (String) databaseData.getValue(0, "shortdescription"));
    assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));
    
      // task2
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_TASK2_TO_ADD);
        
    assertEquals("number of row", 1, databaseData.getRowCount());
    
    assertEquals("pmu_id", task2ToAdd.getOwner(), databaseData.getValue(0, "pmu_id"));
    assertEquals("daysestimated", new Double(task2ToAdd.getDaysEstimated()), new Double(databaseData.getValue(0, "daysestimated").toString()));
    assertEquals("shortdescription", task2ToAdd.getShortDescription(), (String) databaseData.getValue(0, "shortdescription"));
    assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));


    // check charge
    
    // charge 1
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_CHARGE1_TO_ADD);
    
    assertEquals("number of row", 1, databaseData.getRowCount());
    
    assertEquals("id", new Integer(charge1ToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "id"));
    // TODO comment tester cela ?
    // assertEquals("tas_id", new Integer(task1ToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "tas_id"));
    assertEquals("pmu_id", new Integer(charge1ToAdd.getUser().getPersistanceId()), (Integer) databaseData.getValue(0, "pmu_id"));
    assertEquals("day", charge1ToAdd.getDay(), (Date) databaseData.getValue(0, "day"));
    assertEquals("timeused", new Double(charge1ToAdd.getTimeUsedToday()), new Double (databaseData.getValue(0, "timeused").toString()));
    assertEquals("daysneededtofinish", new Double(charge1ToAdd.getDaysNeededToFinish()), new Double (databaseData.getValue(0, "daysneededtofinish").toString()));
    assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));


    // charge 2
    databaseData = getConnection().createQueryTable("ExpectedData", SELECT_CHARGE2_TO_ADD);
    
    assertEquals("number of row", 1, databaseData.getRowCount());
    
    assertEquals("id", new Integer(charge2ToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "id"));
    // TODO comment tester cela ?
    //assertEquals("tas_id", new Integer(task1ToAdd.getPersistanceId()), (Integer) databaseData.getValue(0, "tas_id"));
    assertEquals("pmu_id", new Integer(charge2ToAdd.getUser().getPersistanceId()), (Integer) databaseData.getValue(0, "pmu_id"));
    assertEquals("day", charge2ToAdd.getDay(), (Date) databaseData.getValue(0, "day"));
    assertEquals("timeused", new Double(charge2ToAdd.getTimeUsedToday()), new Double (databaseData.getValue(0, "timeused").toString()));
    assertEquals("daysneededtofinish", new Double(charge2ToAdd.getDaysNeededToFinish()), new Double (databaseData.getValue(0, "daysneededtofinish").toString()));
    assertEquals("version", new Long(0), (Long) databaseData.getValue(0, "version"));




    }

View Full Code Here

0 1 2 3 4 5

TOP

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.