[Trovacap-java-loginfo] jTrovaCap/test/uk/co/marcoratto/jtrovacap TestListProvince.java, NONE, 1.1
Brought to you by:
marcoratto
|
From: Marco R. <mar...@us...> - 2008-07-02 09:55:44
|
Update of /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv17571/test/uk/co/marcoratto/jtrovacap Added Files: TestListProvince.java TestCount.java TestLists.java TestAll.java Log Message: Update to release 1.2 --- NEW FILE: TestAll.java --- package uk.co.marcoratto.jtrovacap; import junit.framework.Test; import junit.framework.TestSuite; public class TestAll { public static void main (String[] args) { junit.swingui.TestRunner.run(TestAll.class); // junit.textui.TestRunner.run (suite()); } public static Test suite ( ) { TestSuite suite = new TestSuite("JUnit Test All"); suite.addTest(TestListProvince.suite()); suite.addTest(TestCount.suite()); suite.addTest(TestLists.suite()); return suite; } } --- NEW FILE: TestCount.java --- package uk.co.marcoratto.jtrovacap; import java.io.File; import java.util.List; import org.hibernate.Criteria; import org.hibernate.Hibernate; import org.hibernate.Session; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import uk.co.marcoratto.jtrovacap.hsqldb.Cap; import uk.co.marcoratto.util.HibernateUtil; import junit.framework.Test; import junit.framework.TestCase; import junit.framework.TestSuite; import junit.textui.TestRunner; /** * @author Marco Ratto * */ public class TestCount extends TestCase { private Session session; protected void setUp() { System.out.println(this.getName() + ".setUp()"); } protected void tearDown() { System.out.println(this.getName() + ".tearDown()"); } public static void main (String[] args) { TestRunner.run(suite()); } public static Test suite() { return new TestSuite(TestCount.class); } public void testTotal1() { System.out.println(this.getClass().getName() + ".testTotal1()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = session.createCriteria(Cap.class); criteria.add(Restrictions.eq("prov", "AG")); criteria.setProjection(Projections.rowCount()); int actual = ((Integer) criteria.list().get(0)).intValue(); session.getTransaction().commit(); int expected = 57; assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } public void testTotal2() { System.out.println(this.getClass().getName() + ".testTotal1()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = session.createCriteria(Cap.class); criteria.add(Restrictions.like("comu", "%CHIVASSO%")); criteria.setProjection(Projections.rowCount()); int actual = ((Integer) criteria.list().get(0)).intValue(); session.getTransaction().commit(); int expected = 4; assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } public void testTotal3() { System.out.println(this.getClass().getName() + ".testTotal3()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = session.createCriteria(Cap.class); criteria.add(Restrictions.like("capi", "%10034%")); criteria.setProjection(Projections.rowCount()); int actual = ((Integer) criteria.list().get(0)).intValue(); session.getTransaction().commit(); int expected = 4; assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } public void testTotal4() { System.out.println(this.getClass().getName() + ".testTotal4()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = session.createCriteria(Cap.class); criteria.add( Restrictions.or( Restrictions.like("comu", "%torino%"), Restrictions.like("fraz", "%%"))); criteria.add(Restrictions.like("prov", "%TO%")); criteria.add(Restrictions.like("topo", "%CHIVASSO%")); criteria.setProjection(Projections.rowCount()); int actual = ((Integer) criteria.list().get(0)).intValue(); session.getTransaction().commit(); int expected = 1; assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } } --- NEW FILE: TestLists.java --- package uk.co.marcoratto.jtrovacap; import java.io.File; import java.util.List; import org.hibernate.Criteria; import org.hibernate.Hibernate; import org.hibernate.Session; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import uk.co.marcoratto.jtrovacap.hsqldb.Cap; import uk.co.marcoratto.util.HibernateUtil; import junit.framework.Test; import junit.framework.TestCase; import junit.framework.TestSuite; import junit.textui.TestRunner; /** * @author Marco Ratto * */ public class TestLists extends TestCase { private Session session; protected void setUp() { System.out.println(this.getName() + ".setUp()"); } protected void tearDown() { System.out.println(this.getName() + ".tearDown()"); } public static void main (String[] args) { TestRunner.run(suite()); } public static Test suite() { return new TestSuite(TestLists.class); } public void testElenco1() { System.out.println(this.getClass().getName() + ".testElenco1()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = this.session.createCriteria(Cap.class); criteria.add(Restrictions.eq("prov", "AG")); criteria.addOrder( Order.asc("comu")); criteria.addOrder( Order.asc("fraz")); List l = criteria.list(); int actual = l.size(); System.out.println(this.getClass().getName() + ".testElenco1():size=" + actual); for (int i = 0; i < l.size(); i++) { Cap dto = (Cap) l.get(i); System.out.println(dto.getComu()); } session.getTransaction().commit(); int expected = 57; assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } public void testElenco2() { System.out.println(this.getClass().getName() + ".testElenco2()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = this.session.createCriteria(Cap.class); criteria.add(Restrictions.like("comu", "%CHIVASSO%")); criteria.addOrder( Order.asc("comu")); criteria.addOrder( Order.asc("fraz")); List l = criteria.list(); int actual = l.size(); System.out.println(this.getClass().getName() + ".testElenco2():size=" + actual); for (int i = 0; i < l.size(); i++) { Cap dto = (Cap) l.get(i); System.out.println(dto.getFraz()); } session.getTransaction().commit(); int expected = 4; assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } public void testElenco3() { System.out.println(this.getClass().getName() + ".testElenco3()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = this.session.createCriteria(Cap.class); criteria.add(Restrictions.like("capi", "%10034%")); criteria.addOrder( Order.asc("comu")); criteria.addOrder( Order.asc("fraz")); List l = criteria.list(); int actual = l.size(); System.out.println(this.getClass().getName() + ".testElenco3():size=" + actual); for (int i = 0; i < l.size(); i++) { Cap dto = (Cap) l.get(i); System.out.println(dto.getFraz()); } session.getTransaction().commit(); int expected = 4; assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } public void testElenco4() { System.out.println(this.getClass().getName() + ".testElenco3()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = this.session.createCriteria(Cap.class); criteria.add( Restrictions.or( Restrictions.like("comu", "%torino%"), Restrictions.like("fraz", "%%"))); criteria.add(Restrictions.like("prov", "%TO%")); criteria.add(Restrictions.like("topo", "%CHIVASSO%")); criteria.addOrder( Order.asc("comu")); criteria.addOrder( Order.asc("fraz")); List l = criteria.list(); int actual = l.size(); System.out.println(this.getClass().getName() + ".testElenco3():size=" + actual); for (int i = 0; i < l.size(); i++) { Cap dto = (Cap) l.get(i); System.out.println(dto.getCapi()); } session.getTransaction().commit(); int expected = 1; assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } } --- NEW FILE: TestListProvince.java --- package uk.co.marcoratto.jtrovacap; import java.util.List; import org.hibernate.Criteria; import org.hibernate.Session; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projections; import uk.co.marcoratto.jtrovacap.hsqldb.Cap; import uk.co.marcoratto.util.HibernateUtil; import junit.framework.Test; import junit.framework.TestCase; import junit.framework.TestSuite; import junit.textui.TestRunner; /** * @author Marco Ratto * */ public class TestListProvince extends TestCase { private Session session; protected void setUp() { System.out.println(this.getName() + ".setUp()"); } protected void tearDown() { System.out.println(this.getName() + ".tearDown()"); } public static void main (String[] args) { TestRunner.run(suite()); } public static Test suite() { return new TestSuite(TestListProvince.class); } public void testElencoProvince() { System.out.println(this.getClass().getName() + ".testList()"); try { this.session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); Criteria criteria = this.session.createCriteria(Cap.class); criteria.addOrder(Order.asc("prov")); criteria.setProjection( Projections.projectionList() .add( Projections.groupProperty("prov"), "prov")); List l = criteria.list(); int actual = l.size(); System.out.println(this.getClass().getName() + ".testList():size=" + actual); for (int i = 0; i < l.size(); i++) { String s = (String) l.get(i); System.out.println(s); } session.getTransaction().commit(); int expected = 108; this.assertEquals(expected, actual); } catch (Throwable t) { t.printStackTrace(); fail(t.getMessage()); } } } |