Application: gvSIG desktop

/*

 * Created on 04-mar-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

 *   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

 */

package com.iver.cit.gvsig.fmap.drivers.jdbc.mysql;

import java.awt.geom.Rectangle2D;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.cresques.cts.ICoordTrans;

import com.hardcode.gdbms.engine.data.edition.DataWare;

import com.iver.andami.messages.NotificationManager;

import com.iver.cit.gvsig.fmap.DriverException;

import com.iver.cit.gvsig.fmap.core.IGeometry;

import com.iver.cit.gvsig.fmap.drivers.DefaultDBDriver;

import com.iver.cit.gvsig.fmap.drivers.DriverAttributes;

import com.iver.cit.gvsig.fmap.drivers.IFeatureIterator;

import com.iver.cit.gvsig.fmap.drivers.WKTParser;

import com.iver.cit.gvsig.fmap.drivers.jdbc.WKBParser;

import com.vividsolutions.jts.io.ParseException;

/**

 * @author FJP

 *

 * TODO To change the template for this generated type comment go to

 * Window - Preferences - Java - Code Generation - Code and Comments

 */

public class MySQLDriver extends DefaultDBDriver {

    private WKBParser parser = new WKBParser();

    private WKTParser wktParser = new WKTParser();

    /* private int fetch_min=-1;

    private int fetch_max=-1; */

    private Statement st;

    private Rectangle2D fullExtent = null;

    private String strAux;

    private String strEPSG = "-1";

    private String originalEPSG;

    /**

     * 

     */

    public MySQLDriver() {

    }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.fmap.drivers.VectorialDriver#getDriverAttributes()

     */

    public DriverAttributes getDriverAttributes() {

        return null;

    }

    /* (non-Javadoc)

     * @see com.hardcode.driverManager.Driver#getName()

     */

    public String getName() {

        return "mySQL JDBC Driver";

    }

        /**

         * @see com.iver.cit.gvsig.fmap.layers.ReadableVectorial#getShape(int)

         */

        public IGeometry getShape(int index) {

            IGeometry geom = null;

            boolean resul;

                try {

                    // EL ABSOLUTE NO HACE QUE SE VUELVAN A LEER LAS

                    // FILAS, ASI QUE MONTAMOS ESTA HISTORIA PARA QUE

                    // LO HAGA

                    // System.out.println("getShape " + index);

                    /* if (index < fetch_min)

                    {

                        rs.close();

                            rs = st.executeQuery(sqlOrig);

                        fetch_min = 0;

                        fetch_max = rs.getFetchSize();

                    }

                    while (index >= fetch_max)

                    {

                        rs.last();

                        // forzamos una carga

                        rs.next();

                        fetch_min = fetch_max;

                        fetch_max = fetch_max + rs.getFetchSize();

                        // System.out.println("fetchSize = " + rs.getFetchSize() + " " + fetch_min + "-" + fetch_max);

                    } 

                    rs.absolute(index+1 - fetch_min); */

                    rs.absolute(index+1);

                    // strAux = rs.getString(1);                

                    // geom = parser.read(strAux);

                    byte[] data = rs.getBytes(1);                

                    geom = parser.parse(data);

            } catch (SQLException e) {

                e.printStackTrace();

            }

            return geom;

        }

        /**

         * @param conn

         * @param tableName

         * @param fields OJO: EL PRIMER CAMPO HA DE SER EL DE GEOMETRIA

         * @param whereClause

         */

        /* (non-Javadoc)

         * @see com.iver.cit.gvsig.fmap.drivers.VectorialJDBCDriver#setData(java.sql.Connection, java.lang.String, java.lang.String, java.lang.String, int)

         */

        public void setData(Connection conn, String tableName, String fields, String whereClause, int id_FID_field)

        {

            this.conn = conn;            

            this.tableName = tableName;

            this.fields = fields;

            this.whereClause = whereClause;

            this.sqlOrig = "SELECT " + fields + " FROM " + tableName + " " + whereClause;

        this.idFID_FieldName = id_FID_field;

            try {

            // NO ESTA LISTO ESTO AUN EN mySQL, o no s? usuarlo getTableEPSG();

                st = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);

            String sqlAux = getCompoundWhere(workingArea, strEPSG);

            System.out.println("mySQL: setData con sql=" + sqlAux);

                rs = st.executeQuery(sqlAux);

            metaData = rs.getMetaData();

            // Le pegamos un primera pasada para poder relacionar

            // un campo de identificador ?nico (parecido al OID en

            // postgresql) con el ?ndice dentro del recordset.

            // Esto cuando haya ediciones, no es v?lido, y hay

            // que refrescarlo.

            doRelateID_FID();

        } catch (SQLException e) {

            NotificationManager.addError("Error al conectar a la base de datos.",e);

            e.printStackTrace();

        }

        }

        /**

         * @see com.iver.cit.gvsig.fmap.layers.ReadableVectorial#getFullExtent()

         */

        public Rectangle2D getFullExtent(){

        /*

         * NO SE PUEDE HACER AS?. DA EL EXTENT PARA CADA GEOMETRIA,

         * NO DA EL GLOBAL. HABR? QUE ESPERAR A QUE LO PONGAN.

         *  if (fullExtent == null)

        {

            try

            {

                Statement s = conn.createStatement();   

                ResultSet r = s.executeQuery("SELECT AsText(Envelope(ogc_geom)) AS FullExtent FROM " + tableName);

                r.next();

                String strAux = r.getString(1);

                System.out.println("fullExtent = " + strAux);

                // byte[] data = rs.getBytes(1);           

                // IGeometry geom = parser.parse(data);

                IGeometry geom = wktParser.read(strAux);

                fullExtent = geom.getBounds2D();                    

            }

            catch (SQLException e)

            {

                System.err.println(e.getMessage());

            } catch (ParseException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

        }

        return fullExtent;

        */

            if (fullExtent == null)

            {

                try

            {

                    IFeatureIterator itGeom = getFeatureIterator("SELECT ASBINARY(ogc_geom) AS the_geom FROM " + tableName);

                    IGeometry geom;

                    int cont = 0;

                    while (itGeom.hasNext())

                    {

                        geom = itGeom.next().getGeometry();

                        if (cont==0)

                            fullExtent = geom.getBounds2D();

                        else

                            fullExtent.add(geom.getBounds2D());

                        cont++;

                    }

            }

                catch (SQLException e)

                {

                    System.err.println(e.getMessage());

                } catch (DriverException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

            }

            return fullExtent;

        }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.fmap.drivers.VectorialDatabaseDriver#getGeometryIterator(java.lang.String)

     */

    public IFeatureIterator getFeatureIterator(String sql) throws com.iver.cit.gvsig.fmap.DriverException {

        Statement st;

        MySqlFeatureIterator geomIterator = null;

        try {

            st = conn.createStatement();

            // st.setFetchSize(2000);

            ResultSet rs = st.executeQuery(sql);

            geomIterator = new MySqlFeatureIterator(rs);

        } catch (SQLException e) {

            e.printStackTrace();

            throw new com.iver.cit.gvsig.fmap.DriverException(e);

        }

        return geomIterator;

    }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.fmap.drivers.VectorialDatabaseDriver#getGeometryIterator(java.awt.geom.Rectangle2D)

     */

    public IFeatureIterator getFeatureIterator(Rectangle2D r, String strEPSG) throws DriverException {

        if (workingArea != null)

        r = r.createIntersection(workingArea);

        String sqlAux = getCompoundWhere(r, strEPSG);

        return getFeatureIterator(sqlAux);

    }

    /**

     * Le pasas el rect?ngulo que quieres pedir. La primera

     * vez es el workingArea, y las siguientes una interseccion

     * de este rectangulo con el workingArea

     * @param r

     * @param strEPSG

     * @return

     */

    private String getCompoundWhere(Rectangle2D r, String strEPSG) {

        if (r==null)

            return this.sqlOrig;

        double xMin = r.getMinX();

        double yMin = r.getMinY();

        double xMax = r.getMaxX();

        double yMax = r.getMaxY();

        String wktBox = "GeomFromText('LINESTRING(" + xMin + " " + yMin + ", "

        + xMax + " " + yMin + ", "

        + xMax + " " + yMax + ", "

        + xMin + " " + yMax + ")', "

        + strEPSG + ")";

        String sqlAux;

        if (getWhereClause().startsWith("WHERE")) 

            sqlAux = sqlOrig + " MBRIntersects(" + wktBox + ",ogc_geom);" ;

        else

            sqlAux = sqlOrig + "WHERE MBRIntersects(" + wktBox + ",ogc_geom);" ;

        return sqlAux;

    }

    public void open() {

        // TODO Auto-generated method stub

    }

        /**

         * @see com.iver.cit.gvsig.fmap.drivers.VectorialDatabaseDriver#getConnectionStringBeginning()

         */

        public String getConnectionStringBeginning() {

                return "jdbc:mysql:";

        }

    static{

            try {

                        Class.forName("com.mysql.jdbc.Driver");

                } catch (ClassNotFoundException e) {

                        throw new RuntimeException(e);

                }

    }

        /**

         * @see com.iver.cit.gvsig.fmap.drivers.VectorialDatabaseDriver#getGeometryField(java.lang.String)

         */

        public String getGeometryField(String fieldName) {

                return "ASBINARY(" + fieldName +")";

        }

    /**

     * @see com.hardcode.gdbms.engine.data.driver.ObjectDriver#getPrimaryKeys()

     */

    public int[] getPrimaryKeys() throws com.hardcode.gdbms.engine.data.driver.DriverException {

        return new int[]{idFID_FieldName - 2};

    }

    /**

     * @see com.iver.cit.gvsig.fmap.drivers.VectorialJDBCDriver#getDefaultPort()

     */

    public int getDefaultPort() {

        return 3306;

    }

    /**

     * @see com.hardcode.gdbms.engine.data.driver.ObjectDriver#write(com.hardcode.gdbms.engine.data.edition.DataWare)

     */

    public void write(DataWare arg0) throws com.hardcode.gdbms.engine.data.driver.DriverException {

        // TODO Auto-generated method stub

    }

    private void getTableEPSG()

    {

        try {

            Statement stAux = conn.createStatement();

            String sql = "SELECT SRID(ogc_geom) FROM " + 

                getTableName() + " LIMIT 1;";

            ResultSet rs = stAux.executeQuery(sql);

            rs.next();

            originalEPSG = "" + rs.getInt(1);

            rs.close();

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }

}