| gvSIG desktop 1

 * Created on 26-oct-2005

 *

 * 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

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

 */

public class PostGIS {

	private String toEncode;

	/**

	 * Mover esto a IverUtiles

	 * @param val

	 * @return

	 */

	/**

	 * @param dbLayerDef

	 * @param fieldsDescr

	 * @return

	 */

	public String getSqlCreateSpatialTable(DBLayerDefinition dbLayerDef,

			 */

			if (fieldsDescr[i].getFieldName().equalsIgnoreCase("gid"))

				continue;

			resul = resul + ", " + dbLayerDef.getFieldNames()[i] + " "	+ strType;

			j++;

		}

	 * should be a string or a number. To perform an insert strings need quotes

	 * around them, and numbers work fine with quotes, so this method can be

	 * called on unknown objects.

	 * @param value

	 *            The object to add quotes to.

	 * @return a string representation of the object with quotes.

	 */

	protected String addQuotes(Object value) {

				retString = "null";

			else

				retString = "'" + doubleQuote(value) + "'";

		} else {

			retString = "null";

		}

	 * Based in code from JUMP (VividSolutions) and Geotools Things to be aware:

	 * We always will use Spatial Tables with Unique ID. IFeature has the same

	 * field order than dbLayerDef.getFieldNames()

	 * @param dbLayerDef

	 * @param feat

	 * @return

			else

				sqlBuf.append(addQuotes(feat.getAttribute(j)) + ", ");

		}

		sqlBuf.append(" GeometryFromText( '"

				+ feat.getGeometry().toJTSGeometry().toText() + "', "

				+ dbLayerDef.getSRID_EPSG() + ")");

	}

	public String getSqlModifyFeature(DBLayerDefinition dbLayerDef, IFeature feat) {

		 	UPDATE weather

		 	SET temp_hi = temp_hi - 2,  temp_lo = temp_lo - 2

		 	WHERE date > '1994-11-28';

		sqlBuf.deleteCharAt(sqlBuf.lastIndexOf(","));

		if (feat.getGeometry() != null)

		{

			sqlBuf.append(" = ");

			sqlBuf.append(" GeometryFromText( '"

				+ feat.getGeometry().toJTSGeometry().toText() + "', "

	/**

	 * TODO: NECESITAMOS OTRO M?TODO PARA BORRAR CORRECTAMENTE.

	 *	 nos sirve dentro de un writer para modificar y/o borrar entidades

	 *	 Por ahora, cojo el ID del campo que me indica el dbLayerDef

	 * @param dbLayerDef

	public String getSqlDeleteFeature(DBLayerDefinition dbLayerDef, IRow row) {

		// DELETE FROM weather WHERE city = 'Hayward';

		// TODO: NECESITAMOS OTRO M?TODO PARA BORRAR CORRECTAMENTE.

		// nos sirve dentro de un writer para modificar y/o borrar entidades

		// Por ahora, cojo el ID del campo que me indica el dbLayerDev

		StringBuffer sqlBuf = new StringBuffer("DELETE FROM "

	public String getEncoding() {

		return toEncode;

	}

	}

}