use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.
the class GeneratedAlwaysTest method testInsert.
@Test
public void testInsert() {
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);
gaTest.setBlob1(TestUtilities.generateRandomBlob());
int rows = mapper.insert(gaTest);
assertEquals(1, rows);
List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(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());
assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.
the class GeneratedAlwaysTest method testUpdateByExampleWithBlobs.
@Test
public void testUpdateByExampleWithBlobs() {
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("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.updateByExampleWithBLOBs(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());
assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.
the class GeneratedAlwaysTest method testUpdateByPrimaryKey.
@Test
public void testUpdateByPrimaryKey() {
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());
rows = mapper.updateByPrimaryKey(gaTest);
assertEquals(1, rows);
List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(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("barney", returnedRecord.getName());
// should not have update the BLOB in regular update by primary key
assertTrue(TestUtilities.blobsAreEqual(originalBlob, returnedRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.
the class GeneratedAlwaysTest method testUpdateByPrimaryKeySelective.
@Test
public void testUpdateByPrimaryKeySelective() {
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());
rows = mapper.updateByPrimaryKeySelective(gaTest);
assertEquals(1, rows);
List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(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());
assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.
the class GeneratedAlwaysTest method testUpdateByPrimaryKeyWithBlobs.
@Test
public void testUpdateByPrimaryKeyWithBlobs() {
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("barney");
// should be ignored
gaTest.setIdPlus1(77);
// should be ignored
gaTest.setIdPlus2(88);
gaTest.setBlob1(TestUtilities.generateRandomBlob());
rows = mapper.updateByPrimaryKeyWithBLOBs(gaTest);
assertEquals(1, rows);
List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(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("barney", returnedRecord.getName());
assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
} finally {
sqlSession.close();
}
}
Aggregations