use of mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper in project generator by mybatis.
the class GeneratedAlwaysTest method testInsert.
@Test
public void testInsert() {
try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
Generatedalwaystest gaTest = new Generatedalwaystest();
gaTest.setId(1);
gaTest.setName("fred");
gaTest.setIdPlus1(55);
gaTest.setIdPlus2(66);
gaTest.setBlob1(TestUtilities.generateRandomBlob());
int rows = mapper.insert(gaTest);
assertEquals(1, rows);
List<Generatedalwaystest> returnedRecords = mapper.select(SelectDSLCompleter.allRows());
assertEquals(1, returnedRecords.size());
Generatedalwaystest returnedRecord = returnedRecords.get(0);
assertEquals(1, returnedRecord.getId().intValue());
assertEquals(2, returnedRecord.getIdPlus1().intValue());
assertEquals(3, returnedRecord.getIdPlus2().intValue());
assertEquals("fred", returnedRecord.getName());
assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
}
}
use of mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper in project generator by mybatis.
the class GeneratedAlwaysTest method testInsertSelective.
@Test
public void testInsertSelective() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
Generatedalwaystest gaTest = new Generatedalwaystest();
gaTest.setId(1);
gaTest.setName("fred");
gaTest.setIdPlus1(55);
gaTest.setIdPlus2(66);
int rows = mapper.insert(gaTest);
assertEquals(1, rows);
List<Generatedalwaystest> returnedRecords = mapper.selectByExample(null);
assertEquals(1, returnedRecords.size());
Generatedalwaystest returnedRecord = returnedRecords.get(0);
assertEquals(1, returnedRecord.getId().intValue());
assertEquals(2, returnedRecord.getIdPlus1().intValue());
assertEquals(3, returnedRecord.getIdPlus2().intValue());
assertEquals("fred", returnedRecord.getName());
assertNull(returnedRecord.getBlob1());
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper in project generator by mybatis.
the class GeneratedAlwaysTest method testUpdateByExampleSelective.
@Test
public void testUpdateByExampleSelective() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
Generatedalwaystest gaTest = new Generatedalwaystest();
gaTest.setId(1);
gaTest.setName("fred");
// should be ignored
gaTest.setIdPlus1(55);
// should be ignored
gaTest.setIdPlus2(66);
gaTest.setBlob1(TestUtilities.generateRandomBlob());
int rows = mapper.insert(gaTest);
assertEquals(1, rows);
gaTest.setName(null);
// should be ignored
gaTest.setIdPlus1(77);
// should be ignored
gaTest.setIdPlus2(88);
gaTest.setBlob1(TestUtilities.generateRandomBlob());
GeneratedalwaystestCriteria gaCriteria = new GeneratedalwaystestCriteria();
gaCriteria.or().andIdPlus1EqualTo(2).andIdPlus2EqualTo(3);
rows = mapper.updateByExampleSelective(gaTest, gaCriteria);
assertEquals(1, rows);
List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(gaCriteria);
assertEquals(1, returnedRecords.size());
Generatedalwaystest returnedRecord = returnedRecords.get(0);
assertEquals(1, returnedRecord.getId().intValue());
assertEquals(2, returnedRecord.getIdPlus1().intValue());
assertEquals(3, returnedRecord.getIdPlus2().intValue());
assertEquals("fred", returnedRecord.getName());
assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper in project generator by mybatis.
the class GeneratedAlwaysTest method testUpdateByExample.
@Test
public void testUpdateByExample() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
Generatedalwaystest gaTest = new Generatedalwaystest();
gaTest.setId(1);
gaTest.setName("fred");
// should be ignored
gaTest.setIdPlus1(55);
// should be ignored
gaTest.setIdPlus2(66);
gaTest.setBlob1(TestUtilities.generateRandomBlob());
int rows = mapper.insert(gaTest);
assertEquals(1, rows);
byte[] originalBlob = gaTest.getBlob1();
gaTest.setName("barney");
// should be ignored
gaTest.setIdPlus1(77);
// should be ignored
gaTest.setIdPlus2(88);
gaTest.setBlob1(TestUtilities.generateRandomBlob());
GeneratedalwaystestCriteria gaCriteria = new GeneratedalwaystestCriteria();
gaCriteria.or().andIdPlus1EqualTo(2).andIdPlus2EqualTo(3);
rows = mapper.updateByExample(gaTest, gaCriteria);
assertEquals(1, rows);
List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(gaCriteria);
assertEquals(1, returnedRecords.size());
Generatedalwaystest returnedRecord = returnedRecords.get(0);
assertEquals(1, returnedRecord.getId().intValue());
assertEquals(2, returnedRecord.getIdPlus1().intValue());
assertEquals(3, returnedRecord.getIdPlus2().intValue());
assertEquals("barney", returnedRecord.getName());
// should not have update the BLOB in regular update by primary key
assertTrue(TestUtilities.blobsAreEqual(originalBlob, returnedRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
Aggregations