| gvSIG desktop 1

import com.hardcode.gdbms.parser.ParseException;

/**

 */

public class OperationTest extends DataSourceTestCase {

	static {

		QueryManager.registerQuery(new SumQuery());

	}

	public void testOrderOperationDataSource() throws Exception{

    	DataSource d = ds.executeSQL("(select id, nombre, apellido from persona) union (select  id, nombre, apellido from persona);",

    			DataSourceFactory.MANUAL_OPENING);

    	String sql = "select * from '" + d.getName() + "' order by id;";

    	d.getDataSourceFactory().executeSQL(sql, DataSourceFactory.MANUAL_OPENING);

    }

    /**

     * test a union query

     *

    	d.start();

    	String aux = d.getAsString();

    	d.stop();

    	FileInputStream fis = new FileInputStream("src/test/resources/union.txt");

    	byte[] correcto = new byte[aux.getBytes().length];

    	fis.read(correcto);

    	fis.close();

    	assertTrue("La uni?n no es correcta",

    		aux.toString().equals(new String(correcto)));

    }

    public void testSelect() throws Throwable {

    	DataSource d = ds.executeSQL("select apellido, PK from persona where nombre='fernando';",

    			DataSourceFactory.MANUAL_OPENING);

    	d.start();

    	String aux = d.getAsString();

    	d.stop();

    	FileInputStream fis = new FileInputStream("src/test/resources/select.txt");

    	byte[] correcto = new byte[aux.getBytes().length];

    	fis.read(correcto);

    	fis.close();

    	assertTrue("La select no es correcta", aux.equals(new String(correcto)));

    }

     * @throws IOException DOCUMENT ME!

     */

    public void testCustomQuery()

    		SemanticException, IOException {

    	DataSource d = ds.executeSQL("custom sumquery tables persona values (id);",

    			DataSourceFactory.MANUAL_OPENING);

    	d.start();

    	assertTrue(((BooleanValue) d.getFieldValue(0, 0).equals(ValueFactory.createValue(

    				3))).getValue());