| gvSIG desktop 1

import java.io.ByteArrayInputStream;

import java.io.File;

import java.rmi.server.UID;

import java.sql.Connection;

import java.sql.SQLException;

import com.hardcode.driverManager.DriverLoadException;

import com.hardcode.driverManager.DriverManager;

import com.hardcode.driverManager.WriterManager;

import com.hardcode.gdbms.engine.data.db.DBDataSource;

import com.hardcode.gdbms.engine.data.db.DBDataSourceFactory;

import com.hardcode.gdbms.engine.data.db.DBQuerySourceInfo;

	private File tempDir = new File(".");

	private WriterManager wm;

	private Hashtable driversNamesAliases = new Hashtable();

	/**

	 */

	private String getUID() {

		UID uid = new UID();

		String name = "gdbms" + uid.toString().replace(':','_').replace('-','_');

		return name;

	}

	/**

	 * Removes all associations between names and data sources of any layer.

	 */

	 *

	 * @param ds

	 *            Name of the data source to remove

	 * @throws RuntimeException

	 *             If there is no data source registered with that name

	 */

		String name = ds.getName();

		if (tableSource.remove(name) == null) {

	 *

	 * @param ds

	 *            DataSource whose view will be deleted

	 */

		DBTableSourceInfo dbInfo = (DBTableSourceInfo) ds.getSourceInfo();

		String sql = "DROP VIEW " + dbInfo.tableName;

		ds.execute(sql);

	/**

	 * Removes the views created at query delegation

	 */

		Iterator i = sourceInfoServerViewInfo.values().iterator();

		while (i.hasNext()) {

		tableSource.put(name, info);

		nameTable.put(name, tableName);

	}

	/**

	 * A?ade un origen de datos de base de datos al sistema

	 *

		tableSource.put(name, info);

		nameTable.put(name, tableName);

	}

	/**

	 * Fills the info struct with the values passed in the parameters

	 *

		info.connection= conection;

		info.tableName = tableName;

		info.driverName = driverInfo;

	/**

	 * Adds a spatial database data source

	 *

		nameTable.put(name, tableName);

	}

	/**

	 * Adds a spatial database data source

	 *

		info.geometryField = geometryFieldName;

		tableSource.put(name, info);

		nameTable.put(name, tableName);

	/**

	 * Adds a spatial database data source

	 *

		return ret;

	}

	/**

	 * Adds a spatial database data source

	 *

	 * @param connection

	 * @param tableName

	 *            table name

	 * @param geometryFieldName

		return ret;

	}

	/**

	 * A?ade un origen de datos de base de datos al sistema

	 *

		return name;

	}

	/**

	 * A?ade un origen de datos de base de datos al sistema

	 *

		return name;

	}

	/**

	 * A?ade un origen de datos de base de datos al sistema

	 *

		tableSource.put(name, info);

	}

	/**

	 * A?ade un origen de datos de base de datos al sistema

	 *

	 *            Nombre de la tabla con el que se har? referencia en las

	 *            instrucciones

	 * @param connection

	 *            DataSource la usara, pero no la abrira/cerrara)

	 * @param sql

	 *            Instrucci?n SQL que define los datos de la tabla

		info.driverName = driverInfo;

		tableSource.put(name, info);

	}

	/**

	 * A?ade un origen de datos de base de datos al sistema

	 *

		return ret;

	}

	/**

	 * A?ade un origen de datos de base de datos al sistema

	 *

		return ret;

	}

	/**

	 * Cambia el nombre de una fuente de datos. Las consultas SQL que se

	 * ejecuten con el nombre anterior fallar?n

	 *            Nombre de la fuente de datos

	 *

	 * @return DataSource que accede a dicha fuente

	 * @throws DriverLoadException

	 * @throws NoSuchTableException

	 */

	public DataSource createRandomDataSource(String tableName)

		return createRandomDataSource(tableName, tableName, MANUAL_OPENING);

	}

	 *            manually

	 *

	 * @return DataSource que accede a dicha fuente

	 * @throws DriverLoadException

	 * @throws NoSuchTableException

	 */

	public DataSource createRandomDataSource(String tableName, int mode)

		return createRandomDataSource(tableName, tableName, mode);

	}

	 * @return DataSource que accede a dicha fuente de datos si la fuente de

	 *         datos es alfanum?rica o SpatialDataSource si la fuente de datos

	 *         es espacial

	 * @throws NoSuchTableException

	 *             Si no hay una fuente de datos registrada con ese nombre

	 * @throws DriverLoadException

	 *             Si hay alg?n error con el sistema de carga de drivers

	 * @throws RuntimeException

	 *             bug

	 */

	public DataSource createRandomDataSource(String tableName, String tableAlias)

		return createRandomDataSource(tableName, tableAlias, MANUAL_OPENING);

	}

	 * @return DataSource que accede a dicha fuente de datos si la fuente de

	 *         datos es alfanum?rica o SpatialDataSource si la fuente de datos

	 *         es espacial

	 * @throws NoSuchTableException

	 *             Si no hay una fuente de datos registrada con ese nombre

	 * @throws DriverLoadException

	 *             Si hay alg?n error con el sistema de carga de drivers

	 * @throws RuntimeException

	 *             bug

	 */

	public DataSource createRandomDataSource(String tableName,

			String tableAlias, int mode) throws NoSuchTableException,

		Object o = tableSource.get(tableName);

		if (o == null) {

			if (info instanceof FileCreationSourceInfo) {

				FileCreationSourceInfo creationInfo = (FileCreationSourceInfo) info;

					if (!new File(creationInfo.file).exists()) {

						((FileDriver) d).createSource(creationInfo.file,

								creationInfo.fieldNames,

								creationInfo.fieldTypes);

					}

			}

			FileDataSource adapter;

			} catch (NoSuchTableException e) {

				throw new RuntimeException(

						"La informaci?n guardada no es consistente", e);

				throw new RuntimeException(e);

			}

		} else {

			} catch (ParseException e) {

				throw new RuntimeException(

						"La informaci?n guardada no es consistente", e);

			} catch (SemanticException e) {

				throw new RuntimeException(

						"La informaci?n guardada no es consistente", e);

				throw new RuntimeException(

						"La informaci?n guardada no es consistente", e);

				throw new RuntimeException(

						"La informaci?n guardada no es consistente", e);

			}

	 *            opening mode

	 *

	 * @return DataSource que accede a los datos resultado de ejecutar la select

	 * @throws DriverLoadException

	 * @throws SemanticException

	 *             Si la instrucci?n tiene errores sem?nticos

	 * @throws EvaluationException

	 *             If there's an error evaluating any expression

	 */

	public DataSource createRandomDataSource(SelectAdapter instr, int mode)

		return getModedDataSource(getDataSource(instr), mode);

	}

	 *            The SQL query defining the view

	 *

	 * @return Name of the view

	 * @throws DriverException

	 *             If the view cannot be created

	 */

	private String getView(DBDataSource dbds, String sql)

		ServerViewInfo svi = (ServerViewInfo) sourceInfoServerViewInfo.get(dbds

				.getSourceInfo());

	 *            data source info

	 *

	 * @return DataSource

	 */

	private DBDataSource getDataSourceByQuery(String sql,

			AlphanumericDBDriver driver, DBTableSourceInfo dbInfo)

		// Create the adapter

		DBDataSource adapter = DBDataSourceFactory.newDataSourceInstance();

	 *            Instrucci?n select origen del datasource

	 *

	 * @return DataSource que accede a los datos resultado de ejecutar la select

	 * @throws SemanticException

	 * @throws EvaluationException

	 * @throws RuntimeException

	 *             bug

	 */

	private DataSource getDataSource(SelectAdapter instr)

		DataSource[] tables = instr.getTables();

		// Estrategia de delegaci?n de la instrucci?n en el sgbd original de la

				throw new RuntimeException(e);

			} catch (DriverLoadException e) {

				throw new RuntimeException(e);

			}

		}

	 *            DataSources involved in the instruction

	 *

	 * @return The translated sql query

	 * @throws SemanticException

	 *             If the instruction is not semantically correct

	 */

	private String translateInstruction(Adapter instr, DataSource[] tables)

		HashMap instrNameDBName = new HashMap();

		translateFromTables(instr, instrNameDBName);

	 *            tables involved in the search

	 *

	 * @return table name

	 * @throws SemanticException

	 */

	private String guessTableName(String fieldName, DataSource[] tables)

		int tableIndex = -1;

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

	 *            as the values.

	 * @param tables

	 *            tables involved in the instruction

	 * @throws SemanticException

	 *             If the instruction is not semantically correct

	 */

	private void translateColRefs(Adapter adapter, HashMap instrNameDBName,

		if (adapter instanceof ColRefAdapter) {

			ColRefAdapter tra = (ColRefAdapter) adapter;

			SimpleNode s = tra.getEntity();

	 *            opening mode

	 *

	 * @return DataSource

	 * @throws SemanticException

	 *             Si la instrucci?n tiene errores sem?nticos

	 * @throws EvaluationException

	 * @throws ParseException

	 *             If there is a select statement embeeded in the union

	 *             statement and its parse fails

	 */

	public DataSource createRandomDataSource(UnionAdapter instr, int mode)

		return getModedDataSource(getDataSource(instr), mode);

	}

	 *            instrucci?n de union

	 *

	 * @return DataSource

	 * @throws SemanticException

	 *             Si la instrucci?n tiene errores sem?nticos

	 * @throws ParseException

	 *             statement and its parse fails

	 * @throws EvaluationException

	 *             If there's any problem during expresion evaluation

	 */

	private DataSource getDataSource(UnionAdapter instr)

		try {

			Strategy strategy = StrategyManager.getStrategy(instr);

			return ret;

		} catch (DriverLoadException e) {

		}

	}

	 *            opening mode

	 *

	 * @return DataSource con el resultado

	 * @throws ParseException

	 *             Si se produce un error de parse de la instrucci?n

	 * @throws DriverLoadException

	 *             Si no se pueden cargar los drivers

	 * @throws SemanticException

	 *             Si la instrucci?n tiene alg?n error sem?ntico

	 * @throws EvaluationException

	 *             If there's an error evaluating any expression

	 */

	public DataSource executeSQL(String sql, int mode) throws ParseException,

		ByteArrayInputStream bytes = new ByteArrayInputStream(sql.getBytes());

		SQLEngine parser = new SQLEngine(bytes);

	/**

	 * Frees all resources used during execution

	 * @throws SQLException

	 *             If cannot free internal resources

		try {

			clearViews();

		} finally {

			st.close();

			c.close();

		}

	}

	/**

	 * Registra alias de nombres de los drivers

	 * por si ha sido necesario modificar el nombre

	 * de alguno, y se necesita compatibilidad

	 */

	private void fillDriversNamesAliases() {

	}

	private Driver getDriver(String name) {

		if (this.driversNamesAliases.containsKey(name)) {

			name = (String)this.driversNamesAliases.get(name);

		}

		return this.dm.getDriver(name);

	}

	/**

			viewName = name;

		}

	}

}