Package org.dbunit.dataset

Examples of org.dbunit.dataset.IDataSet


    CRLIssuer issuer = new CRLIssuer();
    this.service.delete(issuer);
   
    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


   
    this.service.delete(issuers);
   
    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

        Connection jdbcConnection = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/volunteerdb", "root", "root");
        IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);

        // full database export
        IDataSet fullDataSet = connection.createDataSet();
        FlatXmlDataSet.write(fullDataSet, new FileOutputStream("dataset.xml"));

    }
View Full Code Here

    @DatabaseTearDown(value = CREATE_DATASET, type = DatabaseOperation.DELETE_ALL)
    @Override
    public void testSave() throws Exception {
        try {
            DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
            IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(this.getClass()
                    .getResource("/dbunit/dao/admin/consumption-create_no-id.xml").openStream());
            Consumption consumption = new Consumption();
            Consumption nconsumption;
            Program program = new Program();
            Item item = new Item();
            DSP5 dsp5 = new DSP5();

            consumption.setId(null);
            consumption.setQuantity(1);
            program.setId(1L);
            program.setName(PROGRAM_NAME);
            program.setVersion(1);
            consumption.setProgram(program);
            dsp5.setId(1L);
            dsp5.setLicenseNumber(DSP5_LICENSE_NUMBER);
            dsp5.setVersion(1);
            item.setId(1L);
            item.setQuantity(5);
            item.setDsp5(dsp5);
            item.setVersion(1);
            consumption.setItem(item);
            consumption.setVersion(1);
            nconsumption = consumptionDAO.save(consumption);
            assertNotNull(nconsumption);
            assertEquals(nconsumption.getQuantity(), consumption.getQuantity());
            entityManager.getTransaction().commit();
            DatabaseAssertionMode.NON_STRICT.getDatabaseAssertion().assertEquals(expectedDataSet,
                    connection.createDataSet(expectedDataSet.getTableNames()));
            connection.close();
        } catch (DatabaseUnitException e) {
            e.printStackTrace();
            fail(e.getLocalizedMessage());
        } catch (SQLException e) {
View Full Code Here

    @DatabaseSetup(value = CREATE_DATASET)
    @DatabaseTearDown(value = UPDATE_DATASET, type = DatabaseOperation.DELETE_ALL)
    public void testSave2() throws Exception {
        try {
            DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
            IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(this.getClass().getResource(UPDATE_DATASET).openStream());
            Consumption consumption = new Consumption();
            Consumption nconsumption;
            Program program = new Program();
            Item item = new Item();
            DSP5 dsp5 = new DSP5();

            consumption.setId(1L);
            consumption.setQuantity(5);
            program.setId(1L);
            program.setName(PROGRAM_NAME);
            program.setVersion(1);
            consumption.setProgram(program);
            dsp5.setId(1L);
            dsp5.setLicenseNumber(DSP5_LICENSE_NUMBER);
            dsp5.setVersion(1);
            item.setId(1L);
            item.setQuantity(5);
            item.setDsp5(dsp5);
            item.setVersion(1);
            consumption.setItem(item);
            consumption.setVersion(1);
            nconsumption = consumptionDAO.save(consumption);
            assertNotNull(nconsumption);
            assertEquals(nconsumption.getQuantity(), consumption.getQuantity());
            entityManager.getTransaction().commit();
            DatabaseAssertionMode.NON_STRICT.getDatabaseAssertion().assertEquals(expectedDataSet,
                    connection.createDataSet(expectedDataSet.getTableNames()));
            connection.close();
        } catch (DatabaseUnitException e) {
            e.printStackTrace();
            fail(e.getLocalizedMessage());
        } catch (SQLException e) {
View Full Code Here

    @DatabaseTearDown(value = CREATE_DATASET, type = DatabaseOperation.DELETE_ALL)
    @Override
    public void testSave() throws Exception {
        try {
            DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
            IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(this.getClass()
                    .getResource("/dbunit/dao/admin/businesspartner-create_no-id.xml").openStream());
            BusinessPartner bp = new BusinessPartner();
            BusinessPartner nbp;

            bp.setId(null);
            bp.setName(DEFAULT_BUSINESSPARTNER_NAME);
            bp.setVersion(1);
            nbp = bpDAO.save(bp);
            assertEquals(bp.getName(), nbp.getName());
            entityManager.getTransaction().commit();
            DatabaseAssertionMode.NON_STRICT.getDatabaseAssertion().assertEquals(expectedDataSet,
                    connection.createDataSet(expectedDataSet.getTableNames()));
            connection.close();
        } catch (DatabaseUnitException e) {
            e.printStackTrace();
            fail(e.getLocalizedMessage());
        } catch (SQLException e) {
View Full Code Here

    @DatabaseSetup(value = CREATE_DATASET)
    @DatabaseTearDown(value = UPDATE_DATASET, type = DatabaseOperation.DELETE_ALL)
    public void testSave2() throws Exception {
        try {
            DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
            IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(this.getClass().getResource(UPDATE_DATASET).openStream());
            BusinessPartner bp = new BusinessPartner();
            BusinessPartner nbp;

            bp.setId(1L);
            bp.setName(UPDATED_BUSINESSPARTNER_NAME);
            bp.setVersion(1);
            nbp = bpDAO.save(bp);
            assertEquals(bp.getName(), nbp.getName());
            entityManager.getTransaction().commit();
            DatabaseAssertionMode.NON_STRICT.getDatabaseAssertion().assertEquals(expectedDataSet,
                    connection.createDataSet(expectedDataSet.getTableNames()));
            connection.close();
        } catch (DatabaseUnitException e) {
            e.printStackTrace();
            fail(e.getLocalizedMessage());
        } catch (SQLException e) {
View Full Code Here

    @Ignore("Seems to have 2 TAAs instead of 1")
    @Override
    public void testSave() throws Exception {
        try {
            DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
            IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(this.getClass().getResource("/dbunit/dao/admin/taa-create1_no-id.xml")
                    .openStream());
            GenericTAA taa = new GenericTAA();
            AbstractTAA ntaa;

            taa.setId(null);
            taa.setLicenseNumber(DEFAULT_LICENSENUMBER);
            taa.setVersion(1);
            ntaa = taaDAO.save(taa);
            assertEquals(ntaa.getLicenseNumber(), taa.getLicenseNumber());
            entityManager.getTransaction().commit();
            DatabaseAssertionMode.NON_STRICT.getDatabaseAssertion().assertEquals(expectedDataSet,
                    connection.createDataSet(expectedDataSet.getTableNames()));
            connection.close();
        } catch (DatabaseUnitException e) {
            e.printStackTrace();
            fail(e.getLocalizedMessage());
        } catch (SQLException e) {
View Full Code Here

    @DatabaseSetup(value = CREATEGENERIC_DATASET)
    @DatabaseTearDown(value = UPDATEGENERIC_DATASET, type = DatabaseOperation.DELETE_ALL)
    public void testSave2() throws Exception {
        try {
            DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
            IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(this.getClass().getResource(UPDATEGENERIC_DATASET).openStream());
            GenericTAA taa = new GenericTAA();
            AbstractTAA ntaa;

            taa.setId(1L);
            taa.setLicenseNumber(UPDATED_LICENSENUMBER);
            taa.setVersion(1);
            ntaa = taaDAO.save(taa);
            assertEquals(ntaa.getLicenseNumber(), taa.getLicenseNumber());
            entityManager.getTransaction().commit();
            DatabaseAssertionMode.NON_STRICT.getDatabaseAssertion().assertEquals(expectedDataSet,
                    connection.createDataSet(expectedDataSet.getTableNames()));
            connection.close();
        } catch (DatabaseUnitException e) {
            e.printStackTrace();
            fail(e.getLocalizedMessage());
        } catch (SQLException e) {
View Full Code Here

    @DatabaseSetup(value = EMPTY_DATASET)
    @DatabaseTearDown(value = CREATESPECIFIC_DATASET, type = DatabaseOperation.DELETE_ALL)
    public void testSaveSpecific() throws Exception {
        try {
            DatabaseConnection connection = new DatabaseConnection(dataSource.getConnection());
            IDataSet expectedDataSet = new FlatXmlDataSetBuilder().build(this.getClass().getResource("/dbunit/dao/admin/taa-create2_no-id.xml")
                    .openStream());
            SpecificTAA taa = new SpecificTAA();
            AbstractTAA ntaa;

            taa.setId(null);
            taa.setLicenseNumber(DEFAULT_LICENSENUMBER);
            taa.setVersion(1);
            ntaa = taaDAO.save(taa);
            assertEquals(ntaa.getLicenseNumber(), taa.getLicenseNumber());
            entityManager.getTransaction().commit();
            DatabaseAssertionMode.NON_STRICT.getDatabaseAssertion().assertEquals(expectedDataSet,
                    connection.createDataSet(expectedDataSet.getTableNames()));
            connection.close();
        } catch (DatabaseUnitException e) {
            e.printStackTrace();
            fail(e.getLocalizedMessage());
        } catch (SQLException e) {
View Full Code Here

TOP

Related Classes of org.dbunit.dataset.IDataSet

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.