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 public class JxlDaoSupportTest extends TestCase {
  10         public void testBasic() throws Exception {
  11                 JxlDaoSupport jsd = new JxlDaoSupport();
  12                 jsd.getExternalRefs().put("test", new OtherObject());
  13
  14                 jsd.getResources().add(new ClassPathResource("/dao/simple.xls"));
  15                 jsd.init();
  16
  17                 SimpleObject soAaa = jsd.getByKey(SimpleObject.class, "aaa");
  18                 assertNotNull(soAaa);
  19                 assertEquals("aaa", soAaa.getString());
  20                 assertEquals(1, soAaa.getInteger().intValue());
  21                 assertNotNull(soAaa.getOtherObject());
  22                 assertEquals("USD", soAaa.getOtherObject().getKey());
  23                 assertEquals("US Dollar", soAaa.getOtherObject().getValue());
  24
  25                 SimpleObject soBbb = jsd.getByKey(SimpleObject.class, "bbb");
  26                 assertNotNull(soBbb.getOtherObject());
  27                 assertEquals("bbb", ((SimpleObject) soBbb.getOtherObject().getValue())
  28                                 .getString());
  29
  30                 List<SimpleObject> simpleObjects = jsd.list(SimpleObject.class, null);
  31                 assertEquals(4, simpleObjects.size());
  32
  33                 List<CollectionsObject> collectionsObjects = jsd.list(
  34                                 CollectionsObject.class, null);
  35                 assertEquals(4, collectionsObjects.size());
  36         }
  37 }