Application: gvSIG desktop

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2005 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

/* CVS MESSAGES:

*

* $Id$

* $Log$

* Revision 1.1  2006-11-08 10:57:55  jaume

* remove unecessary imports

*

*

*/

package test;

import java.io.DataInputStream;

import java.io.File;

import java.io.IOException;

import java.io.InputStream;

import java.net.MalformedURLException;

import java.net.URL;

import java.util.ArrayList;

import java.util.Enumeration;

import java.util.Hashtable;

import java.util.jar.JarException;

import java.util.zip.ZipEntry;

import java.util.zip.ZipFile;

public class TestClassLoader extends ClassLoader{

	private Hashtable jarz = new Hashtable();

	private Hashtable classes = new Hashtable();

	private String baseDir;

	public TestClassLoader(String baseDir) throws IOException {

		this.baseDir = baseDir;

		File dir = new File(baseDir);

		URL[] jars = (URL[]) getJarURLs(dir).toArray(new URL[0]);

		if (jars == null) {

			throw new IllegalArgumentException("jars cannot be null"); //$NON-NLS-1$

		}

		//Se itera por las URLS que deben de ser jar's

		ZipFile[] jarFiles = new ZipFile[jars.length];

		for (int i = 0; i < jars.length; i++) {

			jarFiles[i] = new ZipFile(jars[i].getPath());

			Enumeration files = jarFiles[i].entries();

			while (files.hasMoreElements()) {

				//Se obtiene la entrada

				ZipEntry file = (ZipEntry) files.nextElement();

				String fileName = file.getName();

				//Se obtiene el nombre de la clase

				if (!fileName.toLowerCase().endsWith(".class")) { //$NON-NLS-1$

					continue;

				}

				fileName = fileName.substring(0, fileName.length() - 6).replace('/',

				'.');

				//Se cromprueba si ya hab?a una clase con dicho nombre

				if (jarz.get(fileName) != null) {

					throw new JarException(

							"two or more classes with the same name in the jars: " +

							fileName);

				}

				//Se registra la clase

				jarz.put(fileName, jarFiles[i]);

				try {

					loadClass(fileName, true);

				} catch (ClassNotFoundException e) {

					// TODO Auto-generated catch block

					e.printStackTrace();

				}

			}

		}

	}

	private ArrayList getJarURLs(File file) {

		ArrayList jars = new ArrayList();

		if (file.isDirectory()) {

			String[] fileNames = file.list();

			for (int i = 0; i < fileNames.length; i++) {

				File file1 = new File(file+ File.separator + fileNames[i]);

				if (file1.isDirectory()) {

					jars.addAll(getJarURLs(file1));

				} else {

					if (file1.getAbsolutePath().endsWith(".jar")) {

						try {

							jars.add(file1.toURL());

						} catch (MalformedURLException e) {

							e.printStackTrace();

						}

					}

				}

			}

		} else {

			if (file.getAbsolutePath().endsWith(".jar")) {

				try {

					jars.add(new URL(file.getAbsolutePath()));

				} catch (MalformedURLException e) {

					e.printStackTrace();

				}

			}

		}

		return jars;

	}

	protected synchronized Class loadClass(String className, boolean resolve) throws ClassNotFoundException {

		Class c;

		System.out.print("Loading class ["+className+"]...");

		try {

			c = super.loadClass(className, resolve);

		} catch (ClassNotFoundException e) {

			ZipFile file = (ZipFile) jarz.get(className);

			ZipEntry classFile = file.getEntry(className);

			byte[] classBytes;

			try {

				classBytes = loadClassBytes(classFile, file.getInputStream(classFile));

			} catch (IOException e1) {

				throw new ClassNotFoundException(className);

			}

			c = defineClass(className, classBytes, 0, classBytes.length);

		}

		System.out.println(" Ok!");

		return c;

	}

	protected Class findClass(String className) throws ClassNotFoundException {

		return loadClass(className);

	}

	private byte[] loadClassBytes(ZipEntry classFile, InputStream is)

	throws IOException {

		// Get size of class file

		int size = (int) classFile.getSize();

		// Reserve space to read

		byte[] buff = new byte[size];

		// Get stream to read from

		DataInputStream dis = new DataInputStream(is);

		// Read in data

		dis.readFully(buff);

		// close stream

		dis.close();

		// return data

		return buff;

	}

	public static void main(String args[]) {

		try {

			TestClassLoader cl = new TestClassLoader("lib-test/");

		} catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

package org.gvsig.app.test;

import junit.framework.TestCase;

import org.gvsig.app.extension.ProjectExtension;

/**

 * @author Fernando Gonz?lez Cort?s

 */

//TODO comentado para que compile

public class Persistence extends TestCase {

	private ProjectExtension pe;

	/*

	 * @see TestCase#setUp()

	 */

	protected void setUp() throws Exception {

		pe = new ProjectExtension();

//		pe.inicializar();

//		LayerFactory.setDriversPath(

//		"/root/workspace/Andami/gvSIG/extensiones/com.iver.cit.gvsig/drivers");

//

//		LayerFactory.getDataSourceFactory().addFileDataSource("gdbms dbf driver", "prueba",

//				"test/cities.dbf");

	}

	public void testPersist() throws Throwable {

//		Project p = new Project();

//

//		/*

//		 * A?adimos una vista con una capa

//		 */

//		ProjectView v = new ProjectView();

//		ViewPort vp = new ViewPort( CRSFactory.getCRS("EPSG:23030"));

//		vp.setImageSize(new Dimension(500, 500));

//

//		MapContext fmap = new MapContext(vp);

//		v.setMapContext(fmap);

//		FLayer l = LayerFactory.createLayer("Vias",

//			(VectorialFileDriver) LayerFactory.getDM().getDriver("gvSIG shp driver"),

//			new File("test/cities.shp"),

//			CRSFactory.getCRS("EPSG:23030"));

//		fmap.getLayers().addLayer(l);

//

//		/*

//		 * A?adimos la tabla del tema anterior

//		 */

//		SelectableDataSource sds1 = ((FLyrVect) l).getRecordset();

//		EditableAdapter ea1 = new EditableAdapter();

//		ea1.setOriginalDataSource(sds1);

//

//		ProjectTable pt1 = ProjectFactory.createTable("tabla", ea1);

//		p.addDocument(pt1);

//

//		/*

//		 * A?adimos otra tabla

//		 */

//		SelectableDataSource sds2 = new SelectableDataSource(LayerFactory.getDataSourceFactory().createRandomDataSource("prueba", DataSourceFactory.MANUAL_OPENING));

//		EditableAdapter ea2 = new EditableAdapter();

//		ea2.setOriginalDataSource(sds2);

//		ProjectTable pt2 = ProjectFactory.createTable("tabla2", ea2);

//		p.addTable(pt2);

//

//		/*

//		 * Creamos un join

//		 */

//		String sql = "custom com_iver_cit_gvsig_arcjoin tables '"+

//		sds1.getName()+"', '"+sds1.getName()+"' values(NAME,NAME);";

//

//		SelectableDataSource result = new SelectableDataSource(

//				LayerFactory.getDataSourceFactory()

//				.executeSQL(sql, DataSourceFactory.MANUAL_OPENING));

//		EditableAdapter auxea=new EditableAdapter();

//		auxea.setOriginalDataSource(result);

//

//		pt1.replaceDataSource(auxea);

//

//		/*

//		 * Guardamos y cargamos

//		 */

//		File temp = File.createTempFile("junit-", ".gvp");

//		temp.deleteOnExit();

//		pe.writeProject(temp, p);

//

//		Project p2 = pe.readProject(temp);

//

//		/*

//		 * Comprobamos que las dos tablas son id?nticas

//		 */

//		assertTrue(((ProjectTable)p2.getDocumentsByType(ProjectTableFactory.registerName).get(0)).getModel().getRecordset().getAsString().equals(((ProjectTable)p.getTables().get(0)).getModel().getRecordset().getAsString()));

//		assertTrue(((ProjectTable)p2.getDocumentsByType(ProjectTableFactory.registerName).get(1)).getModel().getRecordset().getAsString().equals(((ProjectTable)p.getTables().get(1)).getModel().getRecordset().getAsString()));

	}

}

package org.gvsig.app.sqlQueryValidation;

import junit.framework.TestCase;

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

/**

 * Tests the methods of the class SQLQueryValidation

 *    (This class is made without inner static methods for don't create problems to Zql, in this way,

 *     it's possible to add more tests, with or without long queries.)

 * 

 * @author Pablo Piqueras Bartolom? (p_queras@hotmail.com)

 */

 public class TestSQLQueryValidation extends TestCase{

	/*

	 *  (non-Javadoc)

	 * @see junit.framework.TestCase#setUp()

	 */

	protected void setUp() throws Exception {

		super.setUp();

	}

	/*

	 *  (non-Javadoc)

	 * @see junit.framework.TestCase#tearDown()

	 */

	protected void tearDown() throws Exception {

		super.tearDown();

	}

	/**

	 * A test (Correct)

	 */

	public void test1() {

		String query = "SELECT r.name, f.id FROM room r, flat f WHERE (r.user_name LIKE 'P%') AND (r.flat = f.id) AND (r.color_wall LIKE 'white') AND (r.height < 2.20);";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, false);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test2() {

		String query = "SELECT * FROM House;";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, false);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());

			fail();

		}

	}

	/**

	 * A test (Incorrect)

	 */

	public void test3() {

		String query = "SELECT a* FROM House;";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, false);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test4() {

		String query = "SELECT * FROM House;";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, false);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test5() {

		String query = "r.level = f.level AND r.user_name LIKE \'P%\';";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());

			fail();

		}

	}

	/**

	 * A test (Incorrect)

	 */

	public void test6() {

		String query = "r.level = f.level a e3 w 	q3 	 ?32	9'}97AND r.user_name LIKE \'P%\';";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test7() {

		String query = "\"codigo\" = 'Canal d'Elx'";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test8() {

		String query = "\"codigo\" = 'Canal de la M?nega'";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test9() {

		String query = "\"codigo\" = 'Espa?a'";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test10() {

		String query = "\"codigo\" = ('Canal d'Elx')";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test11() {

		String query = "\"codigo\" = ( 'Canal d'Elx' )";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test12() {

		String query = "\"codigo\" = ( 'Canal d'Elx')";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test13() {

		String query = "\"codigo\" = ('Canal d'Elx' )";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}	

	/**

	 * A test (Incorrect)

	 */

	public void test14() {

		String query = "\"codigo\" = ('Canal d' Elx' )";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Incorrect)

	 */

	public void test15() {

		String query = "\"codigo\" = ('Canal d'Elx d'Alacant' )";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}	

	/**

	 * A test (Incorrect)

	 */

	public void test16() {

		String query = "\"fecha\" = Date(11-ene-2004)";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

	/**

	 * A test (Correct)

	 */

	public void test17() {

		String query = "\"fecha\" = 11-ene-2004";

		System.out.println("?Es v?lida '" + query + "' ?");

		SQLQueryValidation sqlQueryValidation = new SQLQueryValidation(query, true);

		if (sqlQueryValidation.validateQuery()) {

			System.out.println("Yes.");

		}

		else {

			System.out.println("No.");

			System.out.println(sqlQueryValidation.getErrorPositionAsMessage());

			System.out.println(sqlQueryValidation.getErrorMessage());			

			fail();

		}

	}

 }

package org.gvsig.app.gui.filter;

import junit.framework.TestCase;

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

/**

 * @author Pablo Piqueras Bartolom? (p_queras@hotmail.com)

 */

public class TestFilterExpressionFromWhereIsEmpty_Method extends TestCase {

	/*

	 *  (non-Javadoc)

	 * @see junit.framework.TestCase#setUp()

	 */

	protected void setUp() throws Exception {

		super.setUp();

	}

	/*

	 *  (non-Javadoc)

	 * @see junit.framework.TestCase#tearDown()

	 */

	protected void tearDown() throws Exception {

		super.tearDown();

	}	

	/**

	 * Test 1 (valid)

	 */

	public void test1() {

		String expression = new String("select * from 'gdbms144426c_10fc90fa1aa__7c18' where ;");

		System.out.println("? Es vac?o el filtro en: " + expression + " ? ");

		if (this.filterExpressionFromWhereIsEmpty(expression))

			System.out.println("Si.");

		else

			System.out.println("No.");

	}

	/**

	 * Test 2 (invalid)

	 */

	public void test2() {

		String expression = new String("select * from 'gdbms158fd70_10fc92ee61e__7c18' where layer < '61';");

		System.out.println("? Es vac?o el filtro en: " + expression + " ? ");

		if (this.filterExpressionFromWhereIsEmpty(expression))

			System.out.println("Si.");

		else

			System.out.println("No.");

	}	

	/**

	 * Returns true if the WHERE subconsultation of the filterExpression is empty ("")

	 * 

	 * @param expression An string

	 * @return A boolean value 

	 */

	private boolean filterExpressionFromWhereIsEmpty(String expression) {

		String subExpression = expression.trim();

		int pos;	

		// Remove last ';' if exists

		if (subExpression.charAt(subExpression.length() -1) == ';')

			subExpression = subExpression.substring(0, subExpression.length() -1).trim();

		// If there is no 'where' clause

		if ((pos = subExpression.indexOf("where")) == -1)

			return false;

		// If there is no subexpression in the WHERE clause -> true

		subExpression = subExpression.substring(pos + 5, subExpression.length()).trim(); // + 5 is the length of 'where'

		if ( subExpression.length() == 0 )

			return true;

		else

			return false;

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2005 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

/* CVS MESSAGES:

*

* $Id$

* $Log$

* Revision 1.1  2006-11-08 10:57:55  jaume

* remove unecessary imports

*

*

*/

package org.gvsig.app.project;

import junit.framework.TestCase;

//TODO comentado para que compile

public class ProjectTest extends TestCase {

	static final String projectFile1 = "test/test.gvp";

	static final String projectFile2 = "test/test.gvp";

	static final String projectFile3 = null;

	static final String projectFile4 = null;

	static final String driversPath = "lib-test/drivers";

	Project p1, p2;

	public void setUp() {

//		LayerFactory.setDriversPath(driversPath);

//

//		Reader reader;

//

//		// TODO Install drivers support for testing

//		try {

//			reader = new FileReader(new File(projectFile1));

//

//			XmlTag tag = (XmlTag) XmlTag.unmarshal(reader);

//			XMLEntity xml=new XMLEntity(tag);

//			p1 = Project.createFromXML(xml);

//			p2 = Project.createFromXML(xml);

//		} catch (Exception e) {

//			e.printStackTrace();

//		}

	}

//	public void testSignature() {

//		try {

//			assertTrue(p1.computeSignature() == p2.computeSignature());

//		} catch (SaveException e) {}

////		assertTrue(p1.equals(p2));

//	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2005 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *

 *    or

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

/* CVS MESSAGES:

*

* $Id$

* $Log$

* Revision 1.2  2007-07-30 12:56:04  jaume

* organize imports, java 5 code downgraded to 1.4 and added PictureFillSymbol

*

* Revision 1.1  2007/07/13 12:31:03  caballero

* TableTest

*

* Revision 1.1.2.1  2006/11/15 04:10:44  jjdelcerro

* *** empty log message ***

*

* Revision 1.1  2006/11/08 10:57:55  jaume

* remove unecessary imports

*

*

*/

package org.gvsig.app.project;

import junit.framework.TestCase;

//TODO comentado para que compile

public class TableTest extends TestCase {

	public void testTable() {

//		DriverManager dm = new DriverManager();

//		dm.setValidation(new DriverValidation() {

//				public boolean validate(Driver d) {

//					return ((d instanceof ObjectDriver) ||

//					(d instanceof FileDriver) ||

//					(d instanceof DBDriver));

//				}

//			});

//		dm.loadDrivers(new File("../_fwAndami/gvSIG/extensiones/com.iver.cit.gvsig/drivers"));

//

//		String[] Campos= {"Tipo_Via","Nombre","Numero","Sexo","CoorX","CoorY"};

//        int [] fieldTypes={12,12,12,12,12,12};

//        DBFDriver driver = new DBFDriver();

//        String name = "Tabla";

//        DataSourceFactory dsf =LayerFactory.getDataSourceFactory();

//        dsf.setDriverManager(dm);

//        dsf.createFileDataSource(driver.getName(), name, "Archivo", Campos, fieldTypes);

//        DataSource dataSource = null;

//        dsf.createFileDataSource(driver.getName(), name, "MYTABLA.dbf", Campos, fieldTypes);

//

//        try {

//            dataSource = dsf.createRandomDataSource(name, DataSourceFactory.AUTOMATIC_OPENING);

//

//            dataSource.setDataSourceFactory(dsf);

//            SelectableDataSource sds = new SelectableDataSource(dataSource);

//            EditableAdapter auxea = new EditableAdapter();

//            auxea.setOriginalDataSource(sds);

//

//

//            ProjectTable projectTables = ProjectFactory.createTable(name,

//                auxea);

//

//            ProjectExtension ext = (ProjectExtension)PluginServices.getExtension(ProjectExtension.class);

//            ext.getProject().addDocument(projectTables);

//        } catch (DriverLoadException e) {

//            // TODO Auto-generated catch block

//            e.printStackTrace();

//        } catch (NoSuchTableException e) {

//            // TODO Auto-generated catch block

//            e.printStackTrace();

//        } catch (ReadDriverException e) {

//			// TODO Auto-generated catch block

//			e.printStackTrace();

//		}

        }

//	public void testSignature() {

//		try {

//			assertTrue(p1.computeSignature() == p2.computeSignature());

//		} catch (SaveException e) {}

////		assertTrue(p1.equals(p2));

//	}

}

package org.gvsig.app;

import junit.framework.Test;

import junit.framework.TestSuite;

import org.gvsig.app.gui.filter.TestFilterExpressionFromWhereIsEmpty_Method;

import org.gvsig.app.panelGroup.Test2ExceptionsUsingTabbedPanel;

import org.gvsig.app.panelGroup.Test2ExceptionsUsingTreePanel;

import org.gvsig.app.panelGroup.TestPanelGroupLoaderFromExtensionPoint;

import org.gvsig.app.project.ProjectTest;

import org.gvsig.app.project.TableTest;

import org.gvsig.app.sqlQueryValidation.TestSQLQueryValidation;

import org.gvsig.app.test.Persistence;

public class AllTests {

	public static Test suite() {

		TestSuite suite = new TestSuite("Test for org.gvsig.app");

		//$JUnit-BEGIN$

		suite.addTestSuite(Persistence.class);

		suite.addTestSuite(ProjectTest.class);

		suite.addTestSuite(TableTest.class);

		suite.addTestSuite(TestFilterExpressionFromWhereIsEmpty_Method.class);

		suite.addTestSuite(TestSQLQueryValidation.class);

		suite.addTestSuite(TestPanelGroupLoaderFromExtensionPoint.class);

		suite.addTestSuite(Test2ExceptionsUsingTabbedPanel.class);

		suite.addTestSuite(Test2ExceptionsUsingTreePanel.class);

		//$JUnit-END$

		return suite;

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2007 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 */

package org.gvsig.app.panelGroup;

import javax.swing.JFrame;

import org.gvsig.gui.beans.panelGroup.PanelGroupManager;

import org.gvsig.gui.beans.panelGroup.tabbedPanel.TabbedPanel;

import org.gvsig.tools.exception.BaseException;

import org.gvsig.app.panelGroup.loaders.PanelGroupLoaderFromExtensionPoint;

import org.gvsig.app.panelGroup.samples.Samples_ExtensionPointsOfIPanels;

/**

 * <p>Tests the creation of a {@link TabbedPanel TabbedPanel} object using {@link PanelGroupLoaderFromExtensionPoint PanelGroupLoaderFromExtensionPoint} .</p>

 * 

 * @version 16/10/2007

 * @author Pablo Piqueras Bartolom? (pablo.piqueras@iver.es) 

 */

public class Test2TabbedPanel {

	/**

	 * <p>Test method for the Test2TabbedPanel.</p>

	 * 

	 * @param args optional arguments

	 */

	public static void main(String[] args) {

		try {

			Samples_ExtensionPointsOfIPanels.loadSample();

			PanelGroupManager manager = PanelGroupManager.getManager();

			manager.registerPanelGroup(TabbedPanel.class);

			manager.setDefaultType(TabbedPanel.class);

			TabbedPanel panelGroup = (TabbedPanel) manager.getPanelGroup(Samples_ExtensionPointsOfIPanels.REFERENCE2);

			PanelGroupLoaderFromExtensionPoint loader = new PanelGroupLoaderFromExtensionPoint(Samples_ExtensionPointsOfIPanels.EXTENSIONPOINT2_NAME);

			// Begin: Test the normal load

			panelGroup.loadPanels(loader);

			// End: Test the normal load

			// Objects creation

			JFrame jFrame = new JFrame();

			jFrame.setTitle("Test TabbedPanel using PanelGroupLoaderFromExtensionPoint");

		    jFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		    jFrame.setSize(panelGroup.getPreferredSize());

		    jFrame.getContentPane().add(panelGroup);

			jFrame.setVisible(true);

		} catch (BaseException bE) {

			System.out.println(bE.getLocalizedMessageStack());

		} catch (Exception e) {

			e.printStackTrace();

		}

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2007 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 */

package org.gvsig.app.panelGroup.samples;

import java.awt.Color;

import java.io.Serializable;

import javax.swing.JScrollPane;

import javax.swing.JTextArea;

import org.gvsig.gui.beans.panelGroup.panels.AbstractPanel;

/**

 * <p>Sample of {@link AbstractPanel AbstractPanel}.</p>

 * 

 * @version 16/10/2007

 * @author Pablo Piqueras Bartolom? (pablo.piqueras@iver.es) 

 */

public class SampleInitializingExcetionPanel extends AbstractPanel implements Serializable {

	private static final long serialVersionUID = -876907003975432865L;

	/**

	 * <p>Element for the interface.</p>

	 */

	private JTextArea jTextArea = null;

	/**

	 * @see AbstractPanel#AbstractPanel()

	 */

	public SampleInitializingExcetionPanel() {

		super();

		initialize();

	}

	/**

	 * @see AbstractPanel#AbstractPanel(String, String, String)

	 */

	public SampleInitializingExcetionPanel(String id, String label, String labelGroup) {

		super(id, label, labelGroup);

		initialize();

	}

	@Override

	protected void initialize() {

		add(new JScrollPane(getJTextArea()));

		setToolTipText(getID());

		setID(Samples_ExtensionPointsOfIPanels.PANELS1_IDS[0]);

		setLabel(Samples_ExtensionPointsOfIPanels.PANELS1_LABELS[0]);

		setLabelGroup(Samples_ExtensionPointsOfIPanels.PANELS1_LABELGROUPS[0]);

		// Force to generate an exception

		double badValue = 2 / 0;

		resetChangedStatus();

	}

	/**

	 * This method initializes jTextArea

	 *

	 * @return JTextArea

	 */

	private JTextArea getJTextArea() {

		if (jTextArea == null) {

			jTextArea = new JTextArea(5, 40);

			jTextArea.setText("I\'m a JTextArea object in the \"Panel\" with:\n\nID: " + getID() + "\nLabel: " + getLabel() + "\nLabelGroup: " + getLabelGroup());

			jTextArea.setEditable(false);

			jTextArea.setBackground(Color.GREEN);

		}

		return jTextArea;

	}

	@Override

	public void setID(String id) {

		super.setID(id);

		setToolTipText(getID());

		getJTextArea().setText("I\'m a JTextArea object in the \"Panel\" with:\n\nID: " + getID() + "\nLabel: " + getLabel() + "\nLabelGroup: " + getLabelGroup());

		hasChanged = true;

	}

	@Override

	public void setLabel(String label) {

		super.setLabel(label);

		getJTextArea().setText("I\'m a JTextArea object in the \"Panel\" with:\n\nID: " + getID() + "\nLabel: " + getLabel() + "\nLabelGroup: " + getLabelGroup());

		hasChanged = true;

	}

	@Override

	public void setLabelGroup(String labelGroup) {

		super.setLabelGroup(labelGroup);

		getJTextArea().setText("I\'m a JTextArea object in the \"Panel\" with:\n\nID: " + getID() + "\nLabel: " + getLabel() + "\nLabelGroup: " + getLabelGroup());

		hasChanged = true;

	}

	/*

	 * (non-Javadoc)

	 * @see org.gvsig.gui.beans.panelGroup.panels.IPanel#accept()

	 */

	public void accept() {

		System.out.println("I'm the IPanel: " + toString() + "\n and I'm executing an 'accept' method.");

	}

	/*

	 * (non-Javadoc)

	 * @see org.gvsig.gui.beans.panelGroup.panels.IPanel#apply()

	 */

	public void apply() {

		System.out.println("I'm the IPanel: " + toString() + "\n and I'm executing an 'apply' method.");

	}

	/*

	 * (non-Javadoc)

	 * @see org.gvsig.gui.beans.panelGroup.panels.IPanel#cancel()

	 */

	public void cancel() {

		System.out.println("I'm the IPanel: " + toString() + "\n and I'm executing a 'cancel' method.");

	}

	/*

	 * (non-Javadoc)

	 * @see org.gvsig.gui.beans.panelGroup.panels.IPanel#selected()

	 */

	public void selected() {

		System.out.println("I'm the IPanel: " + toString() + "\n and I've been selected. My information is: " +

		 "\n\tID: " + getID() + "\n\tLABEL_GROUP: " + getLabelGroup() + "\n\tLABEL: " + getLabel() + "\n\tCLASS: " + getClass() +

		 "\n\tMy Preferred Size: " + getPreferredSize() + "\n\tAnd My size: " + getSize());

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2007 IVER T.I. and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 */

package org.gvsig.app.panelGroup.samples;

import java.awt.Color;

import java.awt.Dimension;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import java.io.Serializable;

import javax.swing.JScrollPane;

import javax.swing.JTextArea;

import org.gvsig.gui.beans.panelGroup.panels.AbstractPanel;

/**

 * <p>Sample of {@link AbstractPanel AbstractPanel}.</p>

 * 

 * @version 16/10/2007

 * @author Pablo Piqueras Bartolom? (pablo.piqueras@iver.es) 

 */

public class SampleTransparencyPanel extends AbstractPanel implements Serializable {

	private static final long serialVersionUID = -4145789119404234621L;

	/**

	 * <p>Element for the interface.</p>

	 */

	private JTextArea jTextArea = null;

	/**

	 * @see AbstractPanel#AbstractPanel()

	 */

	public SampleTransparencyPanel() {

		super();

		initialize();

	}

	/**

	 * @see AbstractPanel#AbstractPanel(String, String, String)

	 */

	public SampleTransparencyPanel(String id, String label, String labelGroup) {

		super(id, label, labelGroup);

		initialize();

	}

	@Override

	protected void initialize() {

		add(new JScrollPane(getJTextArea()));

		setToolTipText(getID());

		setID(Samples_ExtensionPointsOfIPanels.PANELS1_IDS[2]);

		setLabel(Samples_ExtensionPointsOfIPanels.PANELS1_LABELS[2]);

		setLabelGroup(Samples_ExtensionPointsOfIPanels.PANELS1_LABELGROUPS[2]);

		setPreferredSize(new Dimension(Samples_ExtensionPointsOfIPanels.PANELS_DEFAULT_WIDTH, Samples_ExtensionPointsOfIPanels.PANELS_DEFAULT_HEIGHT));

		resetChangedStatus();

	}

	/**

	 * This method initializes jTextArea

	 *

	 * @return JTextArea

	 */

	private JTextArea getJTextArea() {

		if (jTextArea == null) {

			jTextArea = new JTextArea(5, 40);

			jTextArea.setText("I\'m a JTextArea object in the \"Panel\" with:\n\nID: " + getID() + "\nLabel: " + getLabel() + "\nLabelGroup: " + getLabelGroup());

			jTextArea.setEditable(false);

			jTextArea.setBackground(Color.BLUE);

			jTextArea.addMouseListener(new MouseAdapter() {

				public void mouseClicked(MouseEvent e) {

					if (getPanelGroup() != null) {

						getPanelGroup().setEnabledApplyButton(! getPanelGroup().isEnabledApplyButton());

					}	

				}

			});

		}

		return jTextArea;

	}

	@Override

	public void setID(String id) {

		super.setID(id);