[Trovacap-java-loginfo] jTrovaCap/test/uk/co/marcoratto/jtrovacap TestListProvince.java, NONE, 1.1 TestCount.java, NONE, 1.1 TestLists.java, NONE, 1.1 TestAll.java, NONE, 1.1

[Marco R. <mar...@us...>]

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());
		} 
	}	
			
}