Introduce JXL DAO support

[lgpl/argeo-commons.git] / server / runtime / org.argeo.server.jxl / src / test / java / org / argeo / server / jxl / dao / JxlDaoSupportTest.java

diff --git a/server/runtime/org.argeo.server.jxl/src/test/java/org/argeo/server/jxl/dao/JxlDaoSupportTest.java b/server/runtime/org.argeo.server.jxl/src/test/java/org/argeo/server/jxl/dao/JxlDaoSupportTest.java
new file mode 100644 (file)
index 0000000..b79a8a0
--- /dev/null
+++ b/server/runtime/org.argeo.server.jxl/src/test/java/org/argeo/server/jxl/dao/JxlDaoSupportTest.java
@@ -0,0 +1,26 @@
+package org.argeo.server.jxl.dao;
+
+import java.io.InputStream;
+
+import junit.framework.TestCase;
+
+public class JxlDaoSupportTest extends TestCase {
+       public void testBasic() {
+               JxlDaoSupport jsd = new JxlDaoSupport();
+               InputStream in = getClass().getResourceAsStream("/dao/simple.xls");
+               jsd.load(in);
+
+               SimpleObject soAaa = jsd.getByKey(SimpleObject.class, "aaa");
+               assertNotNull(soAaa);
+               assertEquals("aaa", soAaa.getString());
+               assertEquals(1, soAaa.getInteger().intValue());
+               assertNotNull(soAaa.getOtherObject());
+               assertEquals("USD", soAaa.getOtherObject().getKey());
+               assertEquals("US Dollar", soAaa.getOtherObject().getValue());
+
+               SimpleObject soBbb = jsd.getByKey(SimpleObject.class, "bbb");
+               assertNotNull(soBbb.getOtherObject());
+               assertEquals("bbb", ((SimpleObject) soBbb.getOtherObject().getValue())
+                               .getString());
+       }
+}