Application: gvSIG desktop

		    GNU GENERAL PUBLIC LICENSE

		       Version 2, June 1991

 Copyright (C) 1989, 1991 Free Software Foundation, Inc.

                       59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 Everyone is permitted to copy and distribute verbatim copies

 of this license document, but changing it is not allowed.

			    Preamble

  The licenses for most software are designed to take away your

freedom to share and change it.  By contrast, the GNU General Public

License is intended to guarantee your freedom to share and change free

software--to make sure the software is free for all its users.  This

General Public License applies to most of the Free Software

Foundation's software and to any other program whose authors commit to

using it.  (Some other Free Software Foundation software is covered by

the GNU Library General Public License instead.)  You can apply it to

your programs, too.

  When we speak of free software, we are referring to freedom, not

price.  Our General Public Licenses are designed to make sure that you

have the freedom to distribute copies of free software (and charge for

this service if you wish), that you receive source code or can get it

if you want it, that you can change the software or use pieces of it

in new free programs; and that you know you can do these things.

  To protect your rights, we need to make restrictions that forbid

anyone to deny you these rights or to ask you to surrender the rights.

These restrictions translate to certain responsibilities for you if you

distribute copies of the software, or if you modify it.

  For example, if you distribute copies of such a program, whether

gratis or for a fee, you must give the recipients all the rights that

you have.  You must make sure that they, too, receive or can get the

source code.  And you must show them these terms so they know their

rights.

  We protect your rights with two steps: (1) copyright the software, and

(2) offer you this license which gives you legal permission to copy,

distribute and/or modify the software.

  Also, for each author's protection and ours, we want to make certain

that everyone understands that there is no warranty for this free

software.  If the software is modified by someone else and passed on, we

want its recipients to know that what they have is not the original, so

that any problems introduced by others will not reflect on the original

authors' reputations.

  Finally, any free program is threatened constantly by software

patents.  We wish to avoid the danger that redistributors of a free

program will individually obtain patent licenses, in effect making the

program proprietary.  To prevent this, we have made it clear that any

patent must be licensed for everyone's free use or not licensed at all.

  The precise terms and conditions for copying, distribution and

modification follow.

		    GNU GENERAL PUBLIC LICENSE

   TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION

  0. This License applies to any program or other work which contains

a notice placed by the copyright holder saying it may be distributed

under the terms of this General Public License.  The "Program", below,

refers to any such program or work, and a "work based on the Program"

means either the Program or any derivative work under copyright law:

that is to say, a work containing the Program or a portion of it,

either verbatim or with modifications and/or translated into another

language.  (Hereinafter, translation is included without limitation in

the term "modification".)  Each licensee is addressed as "you".

Activities other than copying, distribution and modification are not

covered by this License; they are outside its scope.  The act of

running the Program is not restricted, and the output from the Program

is covered only if its contents constitute a work based on the

Program (independent of having been made by running the Program).

Whether that is true depends on what the Program does.

  1. You may copy and distribute verbatim copies of the Program's

source code as you receive it, in any medium, provided that you

conspicuously and appropriately publish on each copy an appropriate

copyright notice and disclaimer of warranty; keep intact all the

notices that refer to this License and to the absence of any warranty;

and give any other recipients of the Program a copy of this License

along with the Program.

You may charge a fee for the physical act of transferring a copy, and

you may at your option offer warranty protection in exchange for a fee.

  2. You may modify your copy or copies of the Program or any portion

of it, thus forming a work based on the Program, and copy and

distribute such modifications or work under the terms of Section 1

above, provided that you also meet all of these conditions:

    a) You must cause the modified files to carry prominent notices

    stating that you changed the files and the date of any change.

    b) You must cause any work that you distribute or publish, that in

    whole or in part contains or is derived from the Program or any

    part thereof, to be licensed as a whole at no charge to all third

    parties under the terms of this License.

    c) If the modified program normally reads commands interactively

    when run, you must cause it, when started running for such

    interactive use in the most ordinary way, to print or display an

    announcement including an appropriate copyright notice and a

    notice that there is no warranty (or else, saying that you provide

    a warranty) and that users may redistribute the program under

    these conditions, and telling the user how to view a copy of this

    License.  (Exception: if the Program itself is interactive but

    does not normally print such an announcement, your work based on

    the Program is not required to print an announcement.)

These requirements apply to the modified work as a whole.  If

identifiable sections of that work are not derived from the Program,

and can be reasonably considered independent and separate works in

themselves, then this License, and its terms, do not apply to those

sections when you distribute them as separate works.  But when you

distribute the same sections as part of a whole which is a work based

on the Program, the distribution of the whole must be on the terms of

this License, whose permissions for other licensees extend to the

entire whole, and thus to each and every part regardless of who wrote it.

Thus, it is not the intent of this section to claim rights or contest

your rights to work written entirely by you; rather, the intent is to

exercise the right to control the distribution of derivative or

collective works based on the Program.

In addition, mere aggregation of another work not based on the Program

with the Program (or with a work based on the Program) on a volume of

a storage or distribution medium does not bring the other work under

the scope of this License.

  3. You may copy and distribute the Program (or a work based on it,

under Section 2) in object code or executable form under the terms of

Sections 1 and 2 above provided that you also do one of the following:

    a) Accompany it with the complete corresponding machine-readable

    source code, which must be distributed under the terms of Sections

    1 and 2 above on a medium customarily used for software interchange; or,

    b) Accompany it with a written offer, valid for at least three

    years, to give any third party, for a charge no more than your

    cost of physically performing source distribution, a complete

    machine-readable copy of the corresponding source code, to be

    distributed under the terms of Sections 1 and 2 above on a medium

    customarily used for software interchange; or,

    c) Accompany it with the information you received as to the offer

    to distribute corresponding source code.  (This alternative is

    allowed only for noncommercial distribution and only if you

    received the program in object code or executable form with such

    an offer, in accord with Subsection b above.)

The source code for a work means the preferred form of the work for

making modifications to it.  For an executable work, complete source

code means all the source code for all modules it contains, plus any

associated interface definition files, plus the scripts used to

control compilation and installation of the executable.  However, as a

special exception, the source code distributed need not include

anything that is normally distributed (in either source or binary

form) with the major components (compiler, kernel, and so on) of the

operating system on which the executable runs, unless that component

itself accompanies the executable.

If distribution of executable or object code is made by offering

access to copy from a designated place, then offering equivalent

access to copy the source code from the same place counts as

distribution of the source code, even though third parties are not

compelled to copy the source along with the object code.

  4. You may not copy, modify, sublicense, or distribute the Program

except as expressly provided under this License.  Any attempt

otherwise to copy, modify, sublicense or distribute the Program is

void, and will automatically terminate your rights under this License.

However, parties who have received copies, or rights, from you under

this License will not have their licenses terminated so long as such

parties remain in full compliance.

  5. You are not required to accept this License, since you have not

signed it.  However, nothing else grants you permission to modify or

distribute the Program or its derivative works.  These actions are

prohibited by law if you do not accept this License.  Therefore, by

modifying or distributing the Program (or any work based on the

Program), you indicate your acceptance of this License to do so, and

all its terms and conditions for copying, distributing or modifying

the Program or works based on it.

  6. Each time you redistribute the Program (or any work based on the

Program), the recipient automatically receives a license from the

original licensor to copy, distribute or modify the Program subject to

these terms and conditions.  You may not impose any further

restrictions on the recipients' exercise of the rights granted herein.

You are not responsible for enforcing compliance by third parties to

this License.

  7. If, as a consequence of a court judgment or allegation of patent

infringement or for any other reason (not limited to patent issues),

conditions are imposed on you (whether by court order, agreement or

otherwise) that contradict the conditions of this License, they do not

excuse you from the conditions of this License.  If you cannot

distribute so as to satisfy simultaneously your obligations under this

License and any other pertinent obligations, then as a consequence you

may not distribute the Program at all.  For example, if a patent

license would not permit royalty-free redistribution of the Program by

all those who receive copies directly or indirectly through you, then

the only way you could satisfy both it and this License would be to

refrain entirely from distribution of the Program.

If any portion of this section is held invalid or unenforceable under

any particular circumstance, the balance of the section is intended to

apply and the section as a whole is intended to apply in other

circumstances.

It is not the purpose of this section to induce you to infringe any

patents or other property right claims or to contest validity of any

such claims; this section has the sole purpose of protecting the

integrity of the free software distribution system, which is

implemented by public license practices.  Many people have made

generous contributions to the wide range of software distributed

through that system in reliance on consistent application of that

system; it is up to the author/donor to decide if he or she is willing

to distribute software through any other system and a licensee cannot

impose that choice.

This section is intended to make thoroughly clear what is believed to

be a consequence of the rest of this License.

  8. If the distribution and/or use of the Program is restricted in

certain countries either by patents or by copyrighted interfaces, the

original copyright holder who places the Program under this License

may add an explicit geographical distribution limitation excluding

those countries, so that distribution is permitted only in or among

countries not thus excluded.  In such case, this License incorporates

the limitation as if written in the body of this License.

  9. The Free Software Foundation may publish revised and/or new versions

of the General Public License from time to time.  Such new versions will

be similar in spirit to the present version, but may differ in detail to

address new problems or concerns.

Each version is given a distinguishing version number.  If the Program

specifies a version number of this License which applies to it and "any

later version", you have the option of following the terms and conditions

either of that version or of any later version published by the Free

Software Foundation.  If the Program does not specify a version number of

this License, you may choose any version ever published by the Free Software

Foundation.

  10. If you wish to incorporate parts of the Program into other free

programs whose distribution conditions are different, write to the author

to ask for permission.  For software which is copyrighted by the Free

Software Foundation, write to the Free Software Foundation; we sometimes

make exceptions for this.  Our decision will be guided by the two goals

of preserving the free status of all derivatives of our free software and

of promoting the sharing and reuse of software generally.

			    NO WARRANTY

  11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY

FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW.  EXCEPT WHEN

OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES

PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED

OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF

MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  THE ENTIRE RISK AS

TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU.  SHOULD THE

PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING,

REPAIR OR CORRECTION.

  12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING

WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR

REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES,

INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING

OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED

TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY

YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER

PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE

POSSIBILITY OF SUCH DAMAGES.

		     END OF TERMS AND CONDITIONS

	    How to Apply These Terms to Your New Programs

  If you develop a new program, and you want it to be of the greatest

possible use to the public, the best way to achieve this is to make it

free software which everyone can redistribute and change under these terms.

  To do so, attach the following notices to the program.  It is safest

to attach them to the start of each source file to most effectively

convey the exclusion of warranty; and each file should have at least

the "copyright" line and a pointer to where the full notice is found.

    <one line to give the program's name and a brief idea of what it does.>

    Copyright (C) <year>  <name of author>

    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

Also add information on how to contact you by electronic and paper mail.

If the program is interactive, make it output a short notice like this

when it starts in an interactive mode:

    Gnomovision version 69, Copyright (C) year name of author

    Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'.

    This is free software, and you are welcome to redistribute it

    under certain conditions; type `show c' for details.

The hypothetical commands `show w' and `show c' should show the appropriate

parts of the General Public License.  Of course, the commands you use may

be called something other than `show w' and `show c'; they could even be

mouse-clicks or menu items--whatever suits your program.

You should also get your employer (if you work as a programmer) or your

school, if any, to sign a "copyright disclaimer" for the program, if

necessary.  Here is a sample; alter the names:

  Yoyodyne, Inc., hereby disclaims all copyright interest in the program

  `Gnomovision' (which makes passes at compilers) written by James Hacker.

  <signature of Ty Coon>, 1 April 1989

  Ty Coon, President of Vice

This General Public License does not permit incorporating your program into

proprietary programs.  If your program is a subroutine library, you may

consider it more useful to permit linking proprietary applications with the

library.  If this is what you want to do, use the GNU Library General

Public License instead of this License.

#maven.buildNumber.plugin properties file

#Thu May 05 17:07:38 CEST 2011

buildNumber=2025

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. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

* 

* 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., 51 Franklin Street, Fifth Floor, Boston, 

* MA  02110-1301, USA.

* 

*/

/*

* AUTHORS (In addition to CIT):

* 2010 {Prodevelop}   {Task}

*/

package org.gvsig.app.project.documents.layout;

import org.cresques.cts.IProjection;

import org.gvsig.app.ApplicationLocator;

import org.gvsig.app.ApplicationManager;

import org.gvsig.app.project.ProjectManager;

import org.gvsig.tools.ToolsLocator;

import org.gvsig.tools.junit.AbstractLibraryAutoInitTestCase;

import org.gvsig.tools.locator.LocatorException;

import org.gvsig.tools.persistence.PersistentState;

import org.gvsig.tools.persistence.exception.PersistenceClassNotRegistered;

import org.gvsig.tools.persistence.exception.PersistenceException;

import org.gvsig.tools.persistence.exception.PersistenceTypeNotSupportedException;

import org.gvsig.tools.persistence.exception.PersistenceValidateExceptions;

/**

 * @author <a href="mailto:jpiera@gvsig.org">Jorge Piera Llodr&aacute;</a>

 */

public class LayoutDocumentTest extends AbstractLibraryAutoInitTestCase {

	@Override

	protected void doSetUp() throws Exception {

		DefaultLayoutManager.register();

	}

	public void testPersistence() throws PersistenceTypeNotSupportedException, PersistenceClassNotRegistered, PersistenceException, PersistenceValidateExceptions, LocatorException{

		ApplicationManager applicationManager = ApplicationLocator.getManager();

		assertNotNull(applicationManager);

		ProjectManager projectManager = applicationManager.getProjectManager();

		assertNotNull(projectManager);

//		Project project = projectManager.createProject();

//		assertNotNull(project);

		LayoutManager layoutManager = (LayoutManager) projectManager.getDocumentManagers(DefaultLayoutManager.TYPENAME);

    	LayoutDocument layoutDocument1 = (LayoutDocument) layoutManager.createDocument();

    	layoutDocument1.setName("My Layout");

//		project.add(document);

		//Save and load the layout

		PersistentState persistentState = ToolsLocator.getPersistenceManager().getState(layoutDocument1);

		LayoutDocument layoutDocument2 = (LayoutDocument) ToolsLocator.getPersistenceManager().create(persistentState);

		assertEquals(layoutDocument1.getName(), layoutDocument2.getName());

		IProjection projection = null;

	}

}

/* 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 junit.framework.TestCase;

import org.gvsig.gui.beans.Messages;

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 loading of layers using a {@link TabbedPanel TabbedPanel} object

 * and a {@link PanelGroupLoaderFromExtensionPoint

 * PanelGroupLoaderFromExtensionPoint} loader Tests also the managing of the

 * different kind of exceptions which could be launched during this process.

 * </p>

 * 

 * @version 11/12/2007

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

 */

public class Test2ExceptionsUsingTabbedPanel extends TestCase {

	private TabbedPanel panelGroup;

	private PanelGroupManager manager;

	private PanelGroupLoaderFromExtensionPoint loader;

	private String validationText;

	private String localizedMessage;

	/*

	 * (non-Javadoc)

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

	 */

	protected void setUp() throws Exception {

		super.setUp();

		manager = PanelGroupManager.getManager();

		manager.registerPanelGroup(TabbedPanel.class);

		manager.setDefaultType(TabbedPanel.class);

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

	}

	/*

	 * (non-Javadoc)

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

	 */

	protected void tearDown() throws Exception {

		super.tearDown();

		manager.deregisterPanelGroup(TabbedPanel.class);

	}

	/**

	 * <p>Test the 'PanelGroup' exceptions </p>

	 */

	public void test1() {

		Samples_ExtensionPointsOfIPanels.loadSample();

		validationText = Messages.getText("couldnt_add_some_panel_exception") + "\n  " + Messages.getText("couldnt_load_panels_from_extension_point_exception") + "\n  Error cargando un panel: / by zero.";

		try {

			System.out.println("----- Test 1 -----");

			loader = new PanelGroupLoaderFromExtensionPoint(Samples_ExtensionPointsOfIPanels.EXTENSIONPOINT4_NAME);

			// Begin: Test the normal load

			panelGroup.loadPanels(loader);

			// End: Test the normal load

		} catch (BaseException bE) {

			localizedMessage = bE.getLocalizedMessageStack();

			System.out.println(localizedMessage);

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

			assertEquals(localizedMessage, validationText);

			return;

		} catch (Exception e) {

			e.printStackTrace();

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

			fail();

			return;

		}

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

		fail();

	}