Search in sources :

Example 41 with AwfulTable

use of mbg.test.ib2j5.generated.conditional.model.AwfulTable in project generator by mybatis.

the class FlatJava5Test method testHashCode3.

@Test
public void testHashCode3() {
    AwfulTable awfulTable1 = new AwfulTable();
    awfulTable1.setActive(false);
    awfulTable1.setCustomerId(3);
    awfulTable1.seteMail("fred@fred.com");
    awfulTable1.setEmailaddress("fred@fred.com");
    awfulTable1.setFirstFirstName("Fred");
    awfulTable1.setFrom("from");
    awfulTable1.setId1(22);
    awfulTable1.setId2(33);
    awfulTable1.setId5(55);
    awfulTable1.setId6(66);
    awfulTable1.setId7(77);
    awfulTable1.setLastName("Rubble");
    awfulTable1.setSecondFirstName("Bamm Bamm");
    awfulTable1.setThirdFirstName("Pebbles");
    AwfulTable awfulTable2 = new AwfulTable();
    awfulTable2.setActive(false);
    awfulTable2.setCustomerId(3);
    awfulTable2.seteMail("fred@fred.com");
    awfulTable2.setEmailaddress("fred@fred.com");
    awfulTable2.setFirstFirstName("Fred");
    awfulTable2.setFrom("from");
    awfulTable2.setId1(22);
    awfulTable2.setId2(33);
    awfulTable2.setId5(55);
    awfulTable2.setId6(66);
    awfulTable2.setId7(77);
    awfulTable2.setLastName("Rubble");
    awfulTable2.setSecondFirstName("Bamm Bamm");
    awfulTable2.setThirdFirstName("Pebbles");
    assertTrue(awfulTable1.hashCode() == awfulTable2.hashCode());
}
Also used : AwfulTable(mbg.test.ib2j5.generated.flat.model.AwfulTable) Test(org.junit.Test)

Example 42 with AwfulTable

use of mbg.test.ib2j5.generated.conditional.model.AwfulTable in project generator by mybatis.

the class DeleteByExampleTest method testAwfulTableDeleteByExample.

public void testAwfulTableDeleteByExample() {
    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);
        AwfulTableExample example = new AwfulTableExample();
        List answer = dao.selectByExample(example);
        assertEquals(2, answer.size());
        example = new AwfulTableExample();
        example.createCriteria().andEMailLike("fred@%");
        int rows = dao.deleteByExample(example);
        assertEquals(1, rows);
        example.clear();
        answer = dao.selectByExample(example);
        assertEquals(1, answer.size());
    } catch (Exception e) {
        fail(e.getMessage());
    }
}
Also used : AwfulTableExample(mbg.test.ib2j2.generated.conditional.model.AwfulTableExample) AwfulTableDAO(mbg.test.ib2j2.generated.conditional.dao.AwfulTableDAO) AwfulTable(mbg.test.ib2j2.generated.conditional.model.AwfulTable) List(java.util.List)

Example 43 with AwfulTable

use of mbg.test.ib2j5.generated.conditional.model.AwfulTable in project generator by mybatis.

the class InsertTest method testAwfulTableInsert.

public void testAwfulTableInsert() {
    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");
        record.setActive(true);
        Integer generatedCustomerId = dao.insert(record);
        assertEquals(57, generatedCustomerId.intValue());
        AwfulTable returnedRecord = dao.selectByPrimaryKey(generatedCustomerId);
        assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
        assertEquals(record.geteMail(), returnedRecord.geteMail());
        assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
        assertEquals(record.getFirstFirstName(), returnedRecord.getFirstFirstName());
        assertEquals(record.getFrom(), returnedRecord.getFrom());
        assertEquals(record.getId1(), returnedRecord.getId1());
        assertEquals(record.getId2(), returnedRecord.getId2());
        assertEquals(record.getId5(), returnedRecord.getId5());
        assertEquals(record.getId6(), returnedRecord.getId6());
        assertEquals(record.getId7(), returnedRecord.getId7());
        assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
        assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
        assertEquals(record.isActive(), returnedRecord.isActive());
    } catch (Exception e) {
        fail(e.getMessage());
    }
}
Also used : AwfulTableDAO(mbg.test.ib2j2.generated.conditional.dao.AwfulTableDAO) AwfulTable(mbg.test.ib2j2.generated.conditional.model.AwfulTable)

Example 44 with AwfulTable

use of mbg.test.ib2j5.generated.conditional.model.AwfulTable in project generator by mybatis.

the class CountByExampleTest method testAwfulTableCountByExample.

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(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);
        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());
    }
}
Also used : AwfulTableExample(mbg.test.ib2j2.generated.conditional.model.AwfulTableExample) AwfulTableDAO(mbg.test.ib2j2.generated.conditional.dao.AwfulTableDAO) AwfulTable(mbg.test.ib2j2.generated.conditional.model.AwfulTable)

Example 45 with AwfulTable

use of mbg.test.ib2j5.generated.conditional.model.AwfulTable in project generator by mybatis.

the class SelectByExampleTest method testAwfulTableSelectByExampleBetween.

public void testAwfulTableSelectByExampleBetween() {
    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("wilma@wilma.com");
        record.setEmailaddress("alsoWilma@wilma.com");
        record.setFirstFirstName("wilma1");
        record.setFrom("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("wilma2");
        record.setThirdFirstName("wilma3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("pebbles@pebbles.com");
        record.setEmailaddress("alsoPebbles@pebbles.com");
        record.setFirstFirstName("pebbles1");
        record.setFrom("from field");
        record.setId1(new Integer(111));
        record.setId2(new Integer(222));
        record.setId5(new Integer(555));
        record.setId6(new Integer(666));
        record.setId7(new Integer(777));
        record.setSecondFirstName("pebbles2");
        record.setThirdFirstName("pebbles3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("barney@barney.com");
        record.setEmailaddress("alsoBarney@barney.com");
        record.setFirstFirstName("barney1");
        record.setFrom("from field");
        record.setId1(new Integer(1111));
        record.setId2(new Integer(2222));
        record.setId5(new Integer(5555));
        record.setId6(new Integer(6666));
        record.setId7(new Integer(7777));
        record.setSecondFirstName("barney2");
        record.setThirdFirstName("barney3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("betty@betty.com");
        record.setEmailaddress("alsoBetty@betty.com");
        record.setFirstFirstName("betty1");
        record.setFrom("from field");
        record.setId1(new Integer(11111));
        record.setId2(new Integer(22222));
        record.setId5(new Integer(55555));
        record.setId6(new Integer(66666));
        record.setId7(new Integer(77777));
        record.setSecondFirstName("betty2");
        record.setThirdFirstName("betty3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("bammbamm@bammbamm.com");
        record.setEmailaddress("alsoBammbamm@bammbamm.com");
        record.setFirstFirstName("bammbamm1");
        record.setFrom("from field");
        record.setId1(new Integer(111111));
        record.setId2(new Integer(222222));
        record.setId5(new Integer(555555));
        record.setId6(new Integer(666666));
        record.setId7(new Integer(777777));
        record.setSecondFirstName("bammbamm2");
        record.setThirdFirstName("bammbamm3");
        dao.insert(record);
        AwfulTableExample example = new AwfulTableExample();
        example.createCriteria().andId1Between(new Integer(1), new Integer(1000));
        List answer = dao.selectByExample(example);
        assertEquals(3, answer.size());
    } catch (Exception e) {
        fail(e.getMessage());
    }
}
Also used : AwfulTableExample(mbg.test.ib2j2.generated.conditional.model.AwfulTableExample) AwfulTableDAO(mbg.test.ib2j2.generated.conditional.dao.AwfulTableDAO) AwfulTable(mbg.test.ib2j2.generated.conditional.model.AwfulTable) ArrayList(java.util.ArrayList) List(java.util.List)

Aggregations

Test (org.junit.Test)66 SQLException (java.sql.SQLException)32 AwfulTable (mbg.test.ib2j5.generated.flat.model.AwfulTable)18 AwfulTableDAO (mbg.test.ib2j2.generated.conditional.dao.AwfulTableDAO)16 AwfulTable (mbg.test.ib2j2.generated.conditional.model.AwfulTable)16 AwfulTableDAO (mbg.test.ib2j5.generated.conditional.dao.AwfulTableDAO)16 AwfulTable (mbg.test.ib2j5.generated.conditional.model.AwfulTable)16 AwfulTableDAO (mbg.test.ib2j5.generated.flat.dao.AwfulTableDAO)16 AwfulTableDAO (mbg.test.ib2j5.generated.hierarchical.dao.AwfulTableDAO)16 AwfulTable (mbg.test.ib2j5.generated.hierarchical.model.AwfulTable)16 AwfulTableMapper (mbg.test.mb3.generated.conditional.mapper.AwfulTableMapper)16 AwfulTable (mbg.test.mb3.generated.conditional.model.AwfulTable)16 SqlSession (org.apache.ibatis.session.SqlSession)16 AwfulTableExample (mbg.test.ib2j2.generated.conditional.model.AwfulTableExample)11 AwfulTableExample (mbg.test.ib2j5.generated.conditional.model.AwfulTableExample)11 AwfulTableExample (mbg.test.ib2j5.generated.flat.model.AwfulTableExample)11 AwfulTableExample (mbg.test.ib2j5.generated.hierarchical.model.AwfulTableExample)11 AwfulTableExample (mbg.test.mb3.generated.conditional.model.AwfulTableExample)11 ArrayList (java.util.ArrayList)10 List (java.util.List)10