Application: gvSIG desktop

package com.iver.cit.gvsig.gui.panels.sqlFormat;

import java.io.ByteArrayInputStream;

import java.io.InputStream;

import javax.swing.JOptionPane;

import com.iver.andami.PluginServices;

import Zql.ParseException;

import Zql.ZExp;

import Zql.ZqlParser;

/* 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

 */

/**

 * This is a version of 'SQLExpressionFormat' that has a modified method that shows a JOptionPane that displays with warning

 *    message if there is an error. 

 *

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

 * @author Jorge Piera Llodr? (piera_jor@gva.es) 

 */

public class SQLExpressionFormatForFilterGUI {

	/**

	 * @see SQLExpressionFormatForFilterGUI#format(String)

	 * 

	 * Returns 'null' if there has been some error

	 */

	public static String validateSQLquery(String query) {

		if (query == null) {

			JOptionPane.showMessageDialog(null, PluginServices.getText(null, "error_coding_filter_query"), PluginServices.getText(null, "error"), JOptionPane.ERROR_MESSAGE);

			return null;

		}

		if (query.trim().compareTo("") == 0)

			return query;

		InputStream is = new ByteArrayInputStream(query.getBytes());

		ZqlParser parser = new ZqlParser();

		parser.initParser(is);

		ZExp exp;

		try {

			exp = parser.readExpression();

			return query;

		} catch (ParseException e) {			

			JOptionPane.showMessageDialog(null, PluginServices.getText(null, "error_validating_sql_filter_query") + ":\n" + e.getMessage(), PluginServices.getText(null, "error"), JOptionPane.ERROR_MESSAGE);

			return null;

		}

	}

}