/** @see Issue #119 为何从数据库里面取出二进制数据时会被转成String类型？ */
@Test
public void test_simple_byte_array() throws IOException {
String path = "org/nutz/dao/test/meta/goods.png";
dao.create(TheGoods.class, true);
TheGoods tg = TheGoods.create("AAA", path);
dao.insert(tg);
// 读取
TheGoods tg2 = dao.fetch(TheGoods.class, tg.getId());
// 比较字节流
byte[] olds = Files.readBytes(path);
byte[] dbs = tg2.getThumbnail();
assertEquals(olds.length, dbs.length);
for (int i = 0; i < olds.length; i++) {
assertEquals(olds[i], dbs[i]);
}
}
@Test
// 如果报错且mysql的话,设置数据库的max_allowed_packet属性哦
public void test_big_blob() throws IOException {
String path = "~/tmp/big.blob";
Files.createFileIfNoExists(path);
OutputStream fos = Streams.fileOut(path);
for (int i = 0; i < 5 * 1024; i++) { // 更多的数据需要不同的类型
fos.write(new byte[1024]);
}
fos.close();
dao.create(TheGoods.class, true);
TheGoods tg = TheGoods.create("AAA", path);
dao.insert(tg);
new File(path).delete();
}