Examples with AwfulTable mbg.test.mb3.generated.dsql.model.AwfulTable used on opensource projects

Example 36 with AwfulTable

use of mbg.test.mb3.generated.dsql.model.AwfulTable in project generator by mybatis.

the class DynamicSqlTest method testAwfulTablecount.

@Test
public void testAwfulTablecount() {
    try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
        AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
        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");
        mapper.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");
        mapper.insert(record);
        long rows = mapper.count(dsl -> dsl.where(awfulTable.eMail, isLike("fred@%")));
        assertEquals(1, rows);
        rows = mapper.count(dsl -> dsl);
        assertEquals(2, rows);
    }
}

Example 37 with AwfulTable

use of mbg.test.mb3.generated.dsql.model.AwfulTable in project generator by mybatis.

the class DynamicSqlTest method testAwfulTableSelectByPrimaryKey.

@Test
public void testAwfulTableSelectByPrimaryKey() {
    try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
        AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
        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");
        mapper.insert(record);
        AwfulTable record1 = new AwfulTable();
        record1.seteMail("fred2@fred.com");
        record1.setEmailaddress("alsofred2@fred.com");
        record1.setFirstFirstName("fred11");
        record1.setFrom("from from field");
        record1.setId1(11);
        record1.setId2(22);
        record1.setId5(55);
        record1.setId6(66);
        record1.setId7(77);
        record1.setSecondFirstName("fred22");
        record1.setThirdFirstName("fred33");
        mapper.insert(record1);
        Integer generatedKey = record1.getCustomerId();
        Optional<AwfulTable> returnedRecord = mapper.selectByPrimaryKey(generatedKey);
        assertThat(returnedRecord).hasValueSatisfying(rr -> {
            assertEquals(record1.getCustomerId(), rr.getCustomerId());
            assertEquals(record1.geteMail(), rr.geteMail());
            assertEquals(record1.getEmailaddress(), rr.getEmailaddress());
            assertEquals(record1.getFirstFirstName(), rr.getFirstFirstName());
            assertEquals(record1.getFrom(), rr.getFrom());
            assertEquals(record1.getId1(), rr.getId1());
            assertEquals(record1.getId2(), rr.getId2());
            assertEquals(record1.getId5(), rr.getId5());
            assertEquals(record1.getId6(), rr.getId6());
            assertEquals(record1.getId7(), rr.getId7());
            assertEquals(record1.getSecondFirstName(), rr.getSecondFirstName());
            assertEquals(record1.getThirdFirstName(), rr.getThirdFirstName());
        });
    }
}

Example 38 with AwfulTable

use of mbg.test.mb3.generated.dsql.model.AwfulTable in project generator by mybatis.

the class DynamicSqlTest method testEquals5.

@Test
public void testEquals5() {
    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");
    assertEquals(awfulTable2, awfulTable1);
    awfulTable2.setActive(true);
    assertNotEquals(awfulTable2, awfulTable1);
}

Example 39 with AwfulTable

use of mbg.test.mb3.generated.dsql.model.AwfulTable in project generator by mybatis.

the class DynamicSqlTest method testAwfulTableSelectByExampleNoCriteria.

@Test
public void testAwfulTableSelectByExampleNoCriteria() {
    try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
        AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
        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");
        mapper.insert(record);
        record = new AwfulTable();
        record.seteMail("wilma@wilma.com");
        record.setEmailaddress("alsoWilma@wilma.com");
        record.setFirstFirstName("wilma1");
        record.setFrom("from field");
        record.setId1(11);
        record.setId2(22);
        record.setId5(55);
        record.setId6(66);
        record.setId7(77);
        record.setSecondFirstName("wilma2");
        record.setThirdFirstName("wilma3");
        mapper.insert(record);
        record = new AwfulTable();
        record.seteMail("pebbles@pebbles.com");
        record.setEmailaddress("alsoPebbles@pebbles.com");
        record.setFirstFirstName("pebbles1");
        record.setFrom("from field");
        record.setId1(111);
        record.setId2(222);
        record.setId5(555);
        record.setId6(666);
        record.setId7(777);
        record.setSecondFirstName("pebbles2");
        record.setThirdFirstName("pebbles3");
        mapper.insert(record);
        record = new AwfulTable();
        record.seteMail("barney@barney.com");
        record.setEmailaddress("alsoBarney@barney.com");
        record.setFirstFirstName("barney1");
        record.setFrom("from field");
        record.setId1(1111);
        record.setId2(2222);
        record.setId5(5555);
        record.setId6(6666);
        record.setId7(7777);
        record.setSecondFirstName("barney2");
        record.setThirdFirstName("barney3");
        mapper.insert(record);
        record = new AwfulTable();
        record.seteMail("betty@betty.com");
        record.setEmailaddress("alsoBetty@betty.com");
        record.setFirstFirstName("betty1");
        record.setFrom("from field");
        record.setId1(11111);
        record.setId2(22222);
        record.setId5(55555);
        record.setId6(66666);
        record.setId7(77777);
        record.setSecondFirstName("betty2");
        record.setThirdFirstName("betty3");
        mapper.insert(record);
        record = new AwfulTable();
        record.seteMail("bammbamm@bammbamm.com");
        record.setEmailaddress("alsoBammbamm@bammbamm.com");
        record.setFirstFirstName("bammbamm1");
        record.setFrom("from field");
        record.setId1(111111);
        record.setId2(222222);
        record.setId5(555555);
        record.setId6(666666);
        record.setId7(777777);
        record.setSecondFirstName("bammbamm2");
        record.setThirdFirstName("bammbamm3");
        mapper.insert(record);
        List<AwfulTable> answer = mapper.select(SelectDSLCompleter.allRowsOrderedBy(awfulTable.customerId.descending()));
        assertEquals(6, answer.size());
        AwfulTable returnedRecord = answer.get(0);
        assertEquals(111111, returnedRecord.getId1().intValue());
        returnedRecord = answer.get(1);
        assertEquals(11111, returnedRecord.getId1().intValue());
        returnedRecord = answer.get(2);
        assertEquals(1111, returnedRecord.getId1().intValue());
        returnedRecord = answer.get(3);
        assertEquals(111, returnedRecord.getId1().intValue());
        returnedRecord = answer.get(4);
        assertEquals(11, returnedRecord.getId1().intValue());
        returnedRecord = answer.get(5);
        assertEquals(1, returnedRecord.getId1().intValue());
    }
}

Example 40 with AwfulTable

use of mbg.test.mb3.generated.dsql.model.AwfulTable in project generator by mybatis.

the class FlatJava5Test method testAwfulTableCountByExample.

@Test
public void testAwfulTableCountByExample() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        AwfulTableMapper mapper = sqlSession.getMapper(AwfulTableMapper.class);
        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");
        mapper.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");
        mapper.insert(record);
        AwfulTableExample example = new AwfulTableExample();
        example.createCriteria().andEMailLike("fred@%");
        long rows = mapper.countByExample(example);
        assertEquals(1, rows);
        example.clear();
        rows = mapper.countByExample(example);
        assertEquals(2, rows);
    } finally {
        sqlSession.close();
    }
}