use of mbg.test.mb3.generated.hierarchical.mapper.different.subpackage.FieldsOnlyMapper in project generator by mybatis.
the class ConditionalJava5Test method testFieldsOnlyCountByExample.
@Test
public void testFieldsOnlyCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(44.55);
record.setFloatfield(66.77);
record.setIntegerfield(8);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(88.99);
record.setFloatfield(100.111);
record.setIntegerfield(9);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria().andIntegerfieldGreaterThan(5);
long rows = mapper.countByExample(example);
assertEquals(2, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(3, rows);
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.hierarchical.mapper.different.subpackage.FieldsOnlyMapper in project generator by mybatis.
the class FlatJava5Test method testFieldsOnlySelectByExampleDistinct.
@Test
public void testFieldsOnlySelectByExampleDistinct() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
mapper.insert(record);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(44.55);
record.setFloatfield(66.77);
record.setIntegerfield(8);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(88.99);
record.setFloatfield(100.111);
record.setIntegerfield(9);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria().andIntegerfieldEqualTo(5);
example.setDistinct(true);
List<Fieldsonly> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
example.clear();
answer = mapper.selectByExample(example);
assertEquals(5, answer.size());
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.hierarchical.mapper.different.subpackage.FieldsOnlyMapper in project generator by mybatis.
the class FlatJava5Test method testFieldsOnlyCountByExample.
@Test
public void testFieldsOnlyCountByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(11.22);
record.setFloatfield(33.44);
record.setIntegerfield(5);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(44.55);
record.setFloatfield(66.77);
record.setIntegerfield(8);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(88.99);
record.setFloatfield(100.111);
record.setIntegerfield(9);
mapper.insert(record);
FieldsonlyExample example = new FieldsonlyExample();
example.createCriteria().andIntegerfieldGreaterThan(5);
long rows = mapper.countByExample(example);
assertEquals(2, rows);
example.clear();
rows = mapper.countByExample(example);
assertEquals(3, rows);
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.hierarchical.mapper.different.subpackage.FieldsOnlyMapper in project generator by mybatis.
the class SimpleAnnotatedTest method testFieldsOnly.
@Test
public void testFieldsOnly() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
FieldsonlyMapper mapper = sqlSession.getMapper(FieldsonlyMapper.class);
Fieldsonly record = new Fieldsonly();
record.setDoublefield(1.23);
record.setFloatfield(4.35);
record.setIntegerfield(9);
mapper.insert(record);
record = new Fieldsonly();
record.setDoublefield(11.2233);
record.setFloatfield(44.3355);
record.setIntegerfield(99);
mapper.insert(record);
List<Fieldsonly> records = mapper.selectAll();
assertEquals(2, records.size());
} finally {
sqlSession.close();
}
}
Aggregations