server/runtime/org.argeo.server.jxl/src/test/java/org/argeo/server/jxl/dao/JxlDaoSupportTest.java

   1 package org.argeo.server.jxl.dao;
   2
   3 import java.util.List;
   4
   5 import junit.framework.TestCase;
   6
   7 import org.springframework.core.io.ClassPathResource;
   8
   9 @SuppressWarnings("restriction")
  10 public class JxlDaoSupportTest extends TestCase {
  11         public void testBasic() throws Exception {
  12                 JxlDaoSupport jsd = new JxlDaoSupport();
  13                 jsd.getExternalRefs().put("test", new OtherObject());
  14
  15                 jsd.getResources().add(new ClassPathResource("/dao/simple.xls"));
  16                 jsd.init();
  17
  18                 SimpleObject soAaa = jsd.getByKey(SimpleObject.class, "aaa");
  19                 assertNotNull(soAaa);
  20                 assertEquals("aaa", soAaa.getString());
  21                 assertEquals(1, soAaa.getInteger().intValue());
  22                 assertNotNull(soAaa.getOtherObject());
  23                 assertEquals("USD", soAaa.getOtherObject().getKey());
  24                 assertEquals("US Dollar", soAaa.getOtherObject().getValue());
  25
  26                 SimpleObject soBbb = jsd.getByKey(SimpleObject.class, "bbb");
  27                 assertNotNull(soBbb.getOtherObject());
  28                 assertEquals("bbb", ((SimpleObject) soBbb.getOtherObject().getValue())
  29                                 .getString());
  30
  31                 List<SimpleObject> simpleObjects = jsd.list(SimpleObject.class, null);
  32                 assertEquals(4, simpleObjects.size());
  33
  34                 List<CollectionsObject> collectionsObjects = jsd.list(
  35                                 CollectionsObject.class, null);
  36                 assertEquals(4, collectionsObjects.size());
  37         }
  38 }