Package org.dbunit.database

Examples of org.dbunit.database.DatabaseConnection


    @DatabaseSetup(value = EMPTY_DATASET)
    @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/tcn-create_no-id.xml")
                    .openStream());
            TCN tcn = new TCN();
            TCN ntcn;

            tcn.setId(null);
            tcn.setFreeText(DEFAULT_FREETEXT);
            tcn.setVersion(1);
            ntcn = tcnDAO.save(tcn);
            assertEquals(ntcn.getFreeText(), tcn.getFreeText());
            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) {
            e.printStackTrace();
View Full Code Here


    @Test
    @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());
            TCN tcn = new TCN();
            TCN ntcn;

            tcn.setId(1L);
            tcn.setFreeText(UPDATED_FREETEXT);
            tcn.setVersion(1);
            ntcn = tcnDAO.save(tcn);
            assertEquals(ntcn.getFreeText(), tcn.getFreeText());
            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) {
            e.printStackTrace();
View Full Code Here

    @DatabaseSetup(value = EMPTY_DATASET)
    @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/alert-create_no-id.xml")
                    .openStream());
            Alert alert = new Alert();
            Alert nalert;

            alert.setId(null);
            alert.setStartTime(DEFAULT_DATE);
            alert.setEndTime(DEFAULT_DATE);
            alert.setMonday(false);
            alert.setTuesday(false);
            alert.setWednesday(false);
            alert.setThursday(false);
            alert.setFriday(false);
            alert.setSaturday(false);
            alert.setSunday(false);
            alert.setVersion(1);
            nalert = alertDAO.save(alert);
            assertEquals(alert.getStartTime(), nalert.getStartTime());
            assertEquals(alert.getEndTime(), nalert.getEndTime());
            assertEquals(alert.getMonday(), nalert.getMonday());
            assertEquals(alert.getTuesday(), nalert.getTuesday());
            assertEquals(alert.getWednesday(), nalert.getWednesday());
            assertEquals(alert.getThursday(), nalert.getThursday());
            assertEquals(alert.getFriday(), nalert.getFriday());
            assertEquals(alert.getSaturday(), nalert.getSaturday());
            assertEquals(alert.getSunday(), nalert.getSunday());
            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) {
            e.printStackTrace();
View Full Code Here

    @Test
    @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());
            Alert alert = new Alert();
            Alert nalert;

            alert.setId(1L);
            alert.setStartTime(DEFAULT_DATE);
            alert.setEndTime(DEFAULT_DATE);
            alert.setMonday(true);
            alert.setTuesday(true);
            alert.setWednesday(true);
            alert.setThursday(true);
            alert.setFriday(true);
            alert.setSaturday(false);
            alert.setSunday(false);
            alert.setVersion(1);
            nalert = alertDAO.save(alert);
            assertEquals(alert.getStartTime(), nalert.getStartTime());
            assertEquals(alert.getEndTime(), nalert.getEndTime());
            assertEquals(alert.getMonday(), nalert.getMonday());
            assertEquals(alert.getTuesday(), nalert.getTuesday());
            assertEquals(alert.getWednesday(), nalert.getWednesday());
            assertEquals(alert.getThursday(), nalert.getThursday());
            assertEquals(alert.getFriday(), nalert.getFriday());
            assertEquals(alert.getSaturday(), nalert.getSaturday());
            assertEquals(alert.getSunday(), nalert.getSunday());
            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) {
            e.printStackTrace();
View Full Code Here

    @DatabaseSetup(value = EMPTY_DATASET)
    @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/document-create_no-id.xml")
                    .openStream());
            Document document = new Document();
            Document ndocument;

            document.setId(null);
            document.setName(DEFAULT_DOCUMENT_NAME);
            document.setVersion(1);
            ndocument = documentDAO.save(document);
            assertNotNull(ndocument);
            assertEquals(ndocument.getName(), document.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) {
            e.printStackTrace();
View Full Code Here

    @Test
    @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());
            Document document = new Document();
            Document ndocument;

            document.setId(1L);
            document.setName(UPDATED_DOCUMENT_NAME);
            document.setVersion(1);
            ndocument = documentDAO.save(document);
            assertNotNull(ndocument);
            assertEquals(ndocument.getName(), document.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) {
            e.printStackTrace();
View Full Code Here

    @DatabaseSetup(value = EMPTY_DATASET)
    @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/concretebusinesspartner-create_no-id.xml").openStream());
            ConcreteBusinessPartner cbp = new ConcreteBusinessPartner();
            ConcreteBusinessPartner ncbp;
            BusinessPartner bp = new BusinessPartner();

            cbp.setId(null);
            cbp.setAddress("");
            cbp.setCountry(COUNTRY);
            bp.setId(1L);
            bp.setName(BUSINESSPARTNER_NAME);
            bp.setVersion(1);
            cbp.setBusinessPartner(bp);
            cbp.setVersion(1);
            ncbp = cbpDAO.save(cbp);
            assertEquals(ncbp.getAddress(), cbp.getAddress());
            assertEquals(ncbp.getCountry(), cbp.getCountry());
            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) {
            e.printStackTrace();
View Full Code Here

    @Test
    @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());
            ConcreteBusinessPartner cbp = new ConcreteBusinessPartner();
            ConcreteBusinessPartner ncbp;
            BusinessPartner bp = new BusinessPartner();

            cbp.setId(1L);
            cbp.setAddress(UPDATED_ADDRESS);
            cbp.setCountry(COUNTRY);
            bp.setId(1L);
            bp.setName(BUSINESSPARTNER_NAME);
            bp.setVersion(1);
            cbp.setBusinessPartner(bp);
            cbp.setVersion(1);
            ncbp = cbpDAO.save(cbp);
            assertEquals(cbp.getAddress(), ncbp.getAddress());
            assertEquals(cbp.getCountry(), ncbp.getCountry());
            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) {
            e.printStackTrace();
View Full Code Here

    @DatabaseSetup(value = "/dbunit/dao/admin/item-empty_beforesave.xml")
    @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/item-create_no-id.xml")
                    .openStream());
            Item item = new Item();
            Item nitem;
            DSP5 dsp5 = new DSP5();

            dsp5.setId(1L);
            dsp5.setLicenseNumber(DSP5_LICENSE_NUMBER);
            dsp5.setVersion(1);
            item.setId(null);
            item.setQuantity(DEFAULT_QUANTITY);
            item.setDsp5(dsp5);
            item.setVersion(1);
            nitem = itemDAO.save(item);
            assertNotNull(nitem);
            assertEquals(nitem.getQuantity(), item.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) {
            e.printStackTrace();
View Full Code Here

    @Test
    @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());
            Item item = new Item();
            Item nitem;
            DSP5 dsp5 = new DSP5();

            dsp5.setId(1L);
            dsp5.setLicenseNumber(DSP5_LICENSE_NUMBER);
            dsp5.setVersion(1);
            item.setId(1L);
            item.setQuantity(UPDATED_QUANTITY);
            item.setDsp5(dsp5);
            item.setVersion(1);
            nitem = itemDAO.save(item);
            assertNotNull(nitem);
            assertEquals(nitem.getQuantity(), item.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) {
            e.printStackTrace();
View Full Code Here

TOP

Related Classes of org.dbunit.database.DatabaseConnection

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.