Examples with AwfulTableExample mbg.test.mb3.generated.hierarchical.model.AwfulTableExample used on opensource projects

Example 91 with AwfulTableExample

use of mbg.test.mb3.generated.hierarchical.model.AwfulTableExample in project generator by mybatis.

the class UpdateByExampleTest method testAwfulTableUpdateByExample.

public void testAwfulTableUpdateByExample() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(new Integer(1));
        record.setId2(new Integer(2));
        record.setId5(new Integer(5));
        record.setId6(new Integer(6));
        record.setId7(new Integer(7));
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("fred2@fred.com");
        record.setEmailaddress("alsofred2@fred.com");
        record.setFirstFirstName("fred11");
        record.setFrom("from from field");
        record.setId1(new Integer(11));
        record.setId2(new Integer(22));
        record.setId5(new Integer(55));
        record.setId6(new Integer(66));
        record.setId7(new Integer(77));
        record.setSecondFirstName("fred22");
        record.setThirdFirstName("fred33");
        dao.insert(record);
        AwfulTable newRecord = new AwfulTable();
        newRecord.setFirstFirstName("Alonzo");
        newRecord.setCustomerId(new Integer(58));
        newRecord.setId1(new Integer(111));
        newRecord.setId2(new Integer(222));
        newRecord.setId5(new Integer(555));
        newRecord.setId6(new Integer(666));
        newRecord.setId7(new Integer(777));
        AwfulTableExample example = new AwfulTableExample();
        example.createCriteria().andEMailLike("fred2@%");
        int rows = dao.updateByExample(newRecord, example);
        assertEquals(1, rows);
        example.clear();
        example.createCriteria().andCustomerIdEqualTo(new Integer(58));
        List answer = dao.selectByExample(example);
        assertEquals(1, answer.size());
        AwfulTable returnedRecord = (AwfulTable) answer.get(0);
        assertEquals(newRecord.getCustomerId(), returnedRecord.getCustomerId());
        assertNull(returnedRecord.geteMail());
        assertNull(returnedRecord.getEmailaddress());
        assertEquals(newRecord.getFirstFirstName(), returnedRecord.getFirstFirstName());
        assertNull(returnedRecord.getFrom());
        assertEquals(newRecord.getId1(), returnedRecord.getId1());
        assertEquals(newRecord.getId2(), returnedRecord.getId2());
        assertEquals(newRecord.getId5(), returnedRecord.getId5());
        assertEquals(newRecord.getId6(), returnedRecord.getId6());
        assertEquals(newRecord.getId7(), returnedRecord.getId7());
        assertNull(returnedRecord.getSecondFirstName());
        assertNull(returnedRecord.getThirdFirstName());
    } catch (SQLException e) {
        fail(e.getMessage());
    }
}

Example 92 with AwfulTableExample

use of mbg.test.mb3.generated.hierarchical.model.AwfulTableExample in project generator by mybatis.

the class HierarchicalJava2Test method testAwfulTableDeleteByPrimaryKey.

public void testAwfulTableDeleteByPrimaryKey() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(new Integer(1));
        record.setId2(new Integer(2));
        record.setId5(new Integer(5));
        record.setId6(new Integer(6));
        record.setId7(new Integer(7));
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        Integer generatedCustomerId = dao.insert(record);
        AwfulTableKey key = new AwfulTableKey();
        key.setCustomerId(generatedCustomerId);
        int rows = dao.deleteByPrimaryKey(key);
        assertEquals(1, rows);
        AwfulTableExample example = new AwfulTableExample();
        List answer = dao.selectByExample(example);
        assertEquals(0, answer.size());
    } catch (SQLException e) {
        fail(e.getMessage());
    }
}

Example 93 with AwfulTableExample

use of mbg.test.mb3.generated.hierarchical.model.AwfulTableExample in project generator by mybatis.

the class HierarchicalJava5Test method testAwfulTableCountByExample.

@Test
public void testAwfulTableCountByExample() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(1);
        record.setId2(2);
        record.setId5(5);
        record.setId6(6);
        record.setId7(7);
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("fred2@fred.com");
        record.setEmailaddress("alsofred2@fred.com");
        record.setFirstFirstName("fred11");
        record.setFrom("from from field");
        record.setId1(11);
        record.setId2(22);
        record.setId5(55);
        record.setId6(66);
        record.setId7(77);
        record.setSecondFirstName("fred22");
        record.setThirdFirstName("fred33");
        dao.insert(record);
        AwfulTableExample example = new AwfulTableExample();
        example.createCriteria().andEMailLike("fred@%");
        long rows = dao.countByExample(example);
        assertEquals(1, rows);
        example.clear();
        rows = dao.countByExample(example);
        assertEquals(2, rows);
    } catch (Exception e) {
        fail(e.getMessage());
    }
}

Example 94 with AwfulTableExample

use of mbg.test.mb3.generated.hierarchical.model.AwfulTableExample in project generator by mybatis.

the class UpdateByExampleTest method testAwfulTableUpdateByExample.

@Test
public void testAwfulTableUpdateByExample() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(1);
        record.setId2(2);
        record.setId5(5);
        record.setId6(6);
        record.setId7(7);
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("fred2@fred.com");
        record.setEmailaddress("alsofred2@fred.com");
        record.setFirstFirstName("fred11");
        record.setFrom("from from field");
        record.setId1(11);
        record.setId2(22);
        record.setId5(55);
        record.setId6(66);
        record.setId7(77);
        record.setSecondFirstName("fred22");
        record.setThirdFirstName("fred33");
        dao.insert(record);
        AwfulTable newRecord = new AwfulTable();
        newRecord.setFirstFirstName("Alonzo");
        newRecord.setCustomerId(58);
        newRecord.setId1(111);
        newRecord.setId2(222);
        newRecord.setId5(555);
        newRecord.setId6(666);
        newRecord.setId7(777);
        AwfulTableExample example = new AwfulTableExample();
        example.createCriteria().andEMailLike("fred2@%");
        int rows = dao.updateByExample(newRecord, example);
        assertEquals(1, rows);
        example.clear();
        example.createCriteria().andCustomerIdEqualTo(58);
        List<AwfulTable> answer = dao.selectByExample(example);
        assertEquals(1, answer.size());
        AwfulTable returnedRecord = answer.get(0);
        assertEquals(newRecord.getCustomerId(), returnedRecord.getCustomerId());
        assertNull(returnedRecord.geteMail());
        assertNull(returnedRecord.getEmailaddress());
        assertEquals(newRecord.getFirstFirstName(), returnedRecord.getFirstFirstName());
        assertNull(returnedRecord.getFrom());
        assertEquals(newRecord.getId1(), returnedRecord.getId1());
        assertEquals(newRecord.getId2(), returnedRecord.getId2());
        assertEquals(newRecord.getId5(), returnedRecord.getId5());
        assertEquals(newRecord.getId6(), returnedRecord.getId6());
        assertEquals(newRecord.getId7(), returnedRecord.getId7());
        assertNull(returnedRecord.getSecondFirstName());
        assertNull(returnedRecord.getThirdFirstName());
    } catch (Exception e) {
        fail(e.getMessage());
    }
}

Example 95 with AwfulTableExample

use of mbg.test.mb3.generated.hierarchical.model.AwfulTableExample in project generator by mybatis.

the class HierarchicalJava5Test method testAwfulTableDeleteByPrimaryKey.

@Test
public void testAwfulTableDeleteByPrimaryKey() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(1);
        record.setId2(2);
        record.setId5(5);
        record.setId6(6);
        record.setId7(7);
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        Integer generatedCustomerId = dao.insert(record);
        AwfulTableKey key = new AwfulTableKey();
        key.setCustomerId(generatedCustomerId);
        int rows = dao.deleteByPrimaryKey(key);
        assertEquals(1, rows);
        AwfulTableExample example = new AwfulTableExample();
        List<AwfulTable> answer = dao.selectByExample(example);
        assertEquals(0, answer.size());
    } catch (Exception e) {
        fail(e.getMessage());
    }
}