SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
Pkblobs record = new Pkblobs();
record.setId(1);
record.setBlob1(TestUtilities.generateRandomBlob());
int rows = mapper.insert(record);
assertEquals(1, rows);
record = new Pkblobs();
record.setId(2);
record.setBlob1(TestUtilities.generateRandomBlob());
rows = mapper.insert(record);
assertEquals(1, rows);
List<Pkblobs> records = mapper.selectAll();
assertEquals(2, records.size());
Pkblobs returnedRecord = mapper.selectByPrimaryKey(record.getId());
assertNotNull(returnedRecord);
assertTrue(TestUtilities.blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
record.setBlob1(TestUtilities.generateRandomBlob());
rows = mapper.updateByPrimaryKey(record);
assertEquals(1, rows);
returnedRecord = mapper.selectByPrimaryKey(record.getId());
assertNotNull(returnedRecord);
assertTrue(TestUtilities.blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
rows = mapper.deleteByPrimaryKey(record.getId());
assertEquals(1, rows);
records = mapper.selectAll();