Example 66 with AwfulTableMapper
use of mbg.test.mb3.generated.dsql.mapper.AwfulTableMapper in project generator by mybatis.
the class ConditionalJava5Test method testAwfulTableSelectByExampleIn.
@Test
public void testAwfulTableSelectByExampleIn() {
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("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<Integer> ids = new ArrayList<>();
ids.add(1);
ids.add(11);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andId1In(ids);
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(11, returnedRecord.getId1().intValue());
assertEquals(22, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
Also used :
AwfulTableExample(mbg.test.mb3.generated.conditional.model.AwfulTableExample)
SqlSession(org.apache.ibatis.session.SqlSession)
AwfulTableMapper(mbg.test.mb3.generated.conditional.mapper.AwfulTableMapper)
ArrayList(java.util.ArrayList)
AwfulTable(mbg.test.mb3.generated.conditional.model.AwfulTable)
Test(org.junit.jupiter.api.Test)
Example 67 with AwfulTableMapper
use of mbg.test.mb3.generated.dsql.mapper.AwfulTableMapper in project generator by mybatis.
the class ConditionalJava5Test method testAwfulTableSelectByExampleNotLike.
@Test
public void testAwfulTableSelectByExampleNotLike() {
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("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);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andFirstFirstNameNotLike("b%");
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(11, returnedRecord.getId1().intValue());
assertEquals(22, returnedRecord.getId2().intValue());
returnedRecord = answer.get(2);
assertEquals(111, returnedRecord.getId1().intValue());
assertEquals(222, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
Also used :
AwfulTableExample(mbg.test.mb3.generated.annotated.conditional.model.AwfulTableExample)
SqlSession(org.apache.ibatis.session.SqlSession)
AwfulTableMapper(mbg.test.mb3.generated.annotated.conditional.mapper.AwfulTableMapper)
AwfulTable(mbg.test.mb3.generated.annotated.conditional.model.AwfulTable)
Test(org.junit.jupiter.api.Test)
Example 68 with AwfulTableMapper
use of mbg.test.mb3.generated.dsql.mapper.AwfulTableMapper in project generator by mybatis.
the class ConditionalJava5Test method testAwfulTableSelectByExampleIn.
@Test
public void testAwfulTableSelectByExampleIn() {
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("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<Integer> ids = new ArrayList<>();
ids.add(1);
ids.add(11);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andId1In(ids);
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(2, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(11, returnedRecord.getId1().intValue());
assertEquals(22, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
Also used :
AwfulTableExample(mbg.test.mb3.generated.annotated.conditional.model.AwfulTableExample)
SqlSession(org.apache.ibatis.session.SqlSession)
AwfulTableMapper(mbg.test.mb3.generated.annotated.conditional.mapper.AwfulTableMapper)
ArrayList(java.util.ArrayList)
AwfulTable(mbg.test.mb3.generated.annotated.conditional.model.AwfulTable)
Test(org.junit.jupiter.api.Test)
Example 69 with AwfulTableMapper
use of mbg.test.mb3.generated.dsql.mapper.AwfulTableMapper in project generator by mybatis.
the class ConditionalJava5Test method testAwfulTableSelectByExampleLike.
@Test
public void testAwfulTableSelectByExampleLike() {
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("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);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andFirstFirstNameLike("b%");
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(1111, returnedRecord.getId1().intValue());
assertEquals(2222, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(11111, returnedRecord.getId1().intValue());
assertEquals(22222, returnedRecord.getId2().intValue());
returnedRecord = answer.get(2);
assertEquals(111111, returnedRecord.getId1().intValue());
assertEquals(222222, returnedRecord.getId2().intValue());
} finally {
sqlSession.close();
}
}
Also used :
AwfulTableExample(mbg.test.mb3.generated.annotated.conditional.model.AwfulTableExample)
SqlSession(org.apache.ibatis.session.SqlSession)
AwfulTableMapper(mbg.test.mb3.generated.annotated.conditional.mapper.AwfulTableMapper)
AwfulTable(mbg.test.mb3.generated.annotated.conditional.model.AwfulTable)
Test(org.junit.jupiter.api.Test)
Example 70 with AwfulTableMapper
use of mbg.test.mb3.generated.dsql.mapper.AwfulTableMapper 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);
}
}
Also used :
FieldsblobsDynamicSqlSupport.fieldsblobs(mbg.test.mb3.generated.dsql.mapper.FieldsblobsDynamicSqlSupport.fieldsblobs)
FieldsonlyDynamicSqlSupport.fieldsonly(mbg.test.mb3.generated.dsql.mapper.FieldsonlyDynamicSqlSupport.fieldsonly)
Arrays(java.util.Arrays)
SqlBuilder(org.mybatis.dynamic.sql.SqlBuilder)
Pkfieldsblobs(mbg.test.mb3.generated.dsql.model.Pkfieldsblobs)
SelectDSLCompleter(org.mybatis.dynamic.sql.select.SelectDSLCompleter)
TestUtilities.generateRandomBlob(mbg.test.common.util.TestUtilities.generateRandomBlob)
Assertions.assertThat(org.assertj.core.api.Assertions.assertThat)
Pkonly(mbg.test.mb3.generated.dsql.model.Pkonly)
LocalDateTime(java.time.LocalDateTime)
PkonlyMapper(mbg.test.mb3.generated.dsql.mapper.PkonlyMapper)
Pkblobs(mbg.test.mb3.generated.dsql.model.Pkblobs)
TranslationMapper(mbg.test.mb3.generated.dsql.mapper.mbgtest.sub.TranslationMapper)
CountDSLCompleter(org.mybatis.dynamic.sql.select.CountDSLCompleter)
Fieldsblobs(mbg.test.mb3.generated.dsql.model.Fieldsblobs)
PkonlyDynamicSqlSupport.pkonly(mbg.test.mb3.generated.dsql.mapper.PkonlyDynamicSqlSupport.pkonly)
ArrayList(java.util.ArrayList)
Id(mbg.test.mb3.generated.dsql.model.mbgtest.Id)
BigDecimal(java.math.BigDecimal)
AwfulTableDynamicSqlSupport.awfulTable(mbg.test.mb3.generated.dsql.mapper.AwfulTableDynamicSqlSupport.awfulTable)
PkblobsDynamicSqlSupport.pkblobs(mbg.test.mb3.generated.dsql.mapper.PkblobsDynamicSqlSupport.pkblobs)
LocalTime(java.time.LocalTime)
PkfieldsblobsMapper(mbg.test.mb3.generated.dsql.mapper.PkfieldsblobsMapper)
SqlSession(org.apache.ibatis.session.SqlSession)
PkfieldsMapper(mbg.test.mb3.generated.dsql.mapper.PkfieldsMapper)
TestUtilities.blobsAreEqual(mbg.test.common.util.TestUtilities.blobsAreEqual)
PkfieldsblobsDynamicSqlSupport.pkfieldsblobs(mbg.test.mb3.generated.dsql.mapper.PkfieldsblobsDynamicSqlSupport.pkfieldsblobs)
Collection(java.util.Collection)
AwfulTable(mbg.test.mb3.generated.dsql.model.AwfulTable)
Assertions.within(org.assertj.core.api.Assertions.within)
Fieldsonly(mbg.test.mb3.generated.dsql.model.Fieldsonly)
Translation(mbg.test.mb3.generated.dsql.model.mbgtest.sub.Translation)
IdMapper(mbg.test.mb3.generated.dsql.mapper.mbgtest.IdMapper)
Test(org.junit.jupiter.api.Test)
PkblobsMapper(mbg.test.mb3.generated.dsql.mapper.PkblobsMapper)
List(java.util.List)
AwfulTableMapper(mbg.test.mb3.generated.dsql.mapper.AwfulTableMapper)
ChronoUnit(java.time.temporal.ChronoUnit)
FieldsonlyMapper(mbg.test.mb3.generated.dsql.mapper.FieldsonlyMapper)
Pkfields(mbg.test.mb3.generated.dsql.model.Pkfields)
LocalDate(java.time.LocalDate)
Assertions(org.junit.jupiter.api.Assertions)
Optional(java.util.Optional)
PkfieldsDynamicSqlSupport.pkfieldstable(mbg.test.mb3.generated.dsql.mapper.PkfieldsDynamicSqlSupport.pkfieldstable)
FieldsblobsMapper(mbg.test.mb3.generated.dsql.mapper.FieldsblobsMapper)
SqlSession(org.apache.ibatis.session.SqlSession)
AwfulTableMapper(mbg.test.mb3.generated.dsql.mapper.AwfulTableMapper)
AwfulTable(mbg.test.mb3.generated.dsql.model.AwfulTable)
Test(org.junit.jupiter.api.Test)
Aggregations
SqlSession (org.apache.ibatis.session.SqlSession)163
Test (org.junit.jupiter.api.Test)163
AwfulTableMapper (mbg.test.mb3.generated.dsql.mapper.AwfulTableMapper)17
AwfulTable (mbg.test.mb3.generated.dsql.model.AwfulTable)17
AwfulTableMapper (mbg.test.mb3.generated.annotated.conditional.mapper.AwfulTableMapper)16
AwfulTable (mbg.test.mb3.generated.annotated.conditional.model.AwfulTable)16
AwfulTableMapper (mbg.test.mb3.generated.annotated.flat.mapper.AwfulTableMapper)16
AwfulTable (mbg.test.mb3.generated.annotated.flat.model.AwfulTable)16
AwfulTableMapper (mbg.test.mb3.generated.annotated.hierarchical.mapper.AwfulTableMapper)16
AwfulTable (mbg.test.mb3.generated.annotated.hierarchical.model.AwfulTable)16
AwfulTableMapper (mbg.test.mb3.generated.conditional.mapper.AwfulTableMapper)16
AwfulTable (mbg.test.mb3.generated.conditional.model.AwfulTable)16
AwfulTableMapper (mbg.test.mb3.generated.flat.mapper.AwfulTableMapper)16
AwfulTable (mbg.test.mb3.generated.flat.model.AwfulTable)16
AwfulTableMapper (mbg.test.mb3.generated.hierarchical.mapper.AwfulTableMapper)16
AwfulTable (mbg.test.mb3.generated.hierarchical.model.AwfulTable)16
AwfulTableMapper (mbg.test.mb3.generated.mixed.conditional.mapper.AwfulTableMapper)16
AwfulTable (mbg.test.mb3.generated.mixed.conditional.model.AwfulTable)16
AwfulTableMapper (mbg.test.mb3.generated.mixed.flat.mapper.AwfulTableMapper)16
AwfulTable (mbg.test.mb3.generated.mixed.flat.model.AwfulTable)16
