    001    //$HeadURL: svn+ssh://mschneider@svn.wald.intevation.org/deegree/base/trunk/src/org/deegree/io/datastore/sql/postgis/PostGISDatastore.java $
    002    /*----------------------------------------------------------------------------
    003     This file is part of deegree, http://deegree.org/
    004     Copyright (C) 2001-2009 by:
    005       Department of Geography, University of Bonn
    006     and
    007       lat/lon GmbH
    008
    009     This library is free software; you can redistribute it and/or modify it under
    010     the terms of the GNU Lesser General Public License as published by the Free
    011     Software Foundation; either version 2.1 of the License, or (at your option)
    012     any later version.
    013     This library is distributed in the hope that it will be useful, but WITHOUT
    014     ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
    015     FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
    016     details.
    017     You should have received a copy of the GNU Lesser General Public License
    018     along with this library; if not, write to the Free Software Foundation, Inc.,
    019     59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
    020
    021     Contact information:
    022
    023     lat/lon GmbH
    024     Aennchenstr. 19, 53177 Bonn
    025     Germany
    026     http://lat-lon.de/
    027
    028     Department of Geography, University of Bonn
    029     Prof. Dr. Klaus Greve
    030     Postfach 1147, 53001 Bonn
    031     Germany
    032     http://www.geographie.uni-bonn.de/deegree/
    033
    034     e-mail: info@deegree.org
    035    ----------------------------------------------------------------------------*/
    036
    037    package org.deegree.io.datastore.sql.mysql;
    038
    039    import java.sql.Connection;
    040    import java.sql.SQLException;
    041
    042    import org.deegree.framework.log.ILogger;
    043    import org.deegree.framework.log.LoggerFactory;
    044    import org.deegree.io.datastore.Datastore;
    045    import org.deegree.io.datastore.DatastoreException;
    046    import org.deegree.io.datastore.schema.MappedFeatureType;
    047    import org.deegree.io.datastore.sql.AbstractSQLDatastore;
    048    import org.deegree.io.datastore.sql.StatementBuffer;
    049    import org.deegree.io.datastore.sql.TableAliasGenerator;
    050    import org.deegree.io.datastore.sql.VirtualContentProvider;
    051    import org.deegree.io.datastore.sql.postgis.PGgeometryAdapter;
    052    import org.deegree.io.datastore.sql.wherebuilder.WhereBuilder;
    053    import org.deegree.model.crs.CoordinateSystem;
    054    import org.deegree.model.filterencoding.Filter;
    055    import org.deegree.model.spatialschema.Geometry;
    056    import org.deegree.model.spatialschema.GeometryException;
    057    import org.deegree.ogcbase.SortProperty;
    058    import org.postgis.PGgeometry;
    059    import org.postgis.binary.BinaryParser;
    060    import org.postgis.binary.BinaryWriter;
    061
    062    /**
    063     * {@link Datastore} implementation for MySQL spatial databases.
    064     *
    065     * @author <a href="mailto:schneider@lat-lon.de">Markus Schneider </a>
    066     * @author last edited by: $Author: aschmitz $
    067     *
    068     * @version $Revision: 12552 $, $Date: 2008-06-26 12:01:34 +0200 (Do, 26 Jun 2008) $
    069     */
    070    public class MySQLDatastore extends AbstractSQLDatastore {
    071
    072        private static final ILogger LOG = LoggerFactory.getLogger( MySQLDatastore.class );
    073
    074        /**
    075         * Returns a specific {@link WhereBuilder} implementation for MySQL.
    076         *
    077         * @param rootFts
    078         *            involved (requested) feature types
    079         * @param aliases
    080         *            aliases for the feature types, may be null
    081         * @param filter
    082         *            filter that restricts the matched features
    083         * @param sortProperties
    084         *            sort criteria for the result, may be null or empty
    085         * @param aliasGenerator
    086         *            used to generate unique table aliases
    087         * @param vcProvider
    088         * @return <code>WhereBuilder</code> implementation for MySQL
    089         * @throws DatastoreException
    090         */
    091        @Override
    092        public MySQLWhereBuilder getWhereBuilder( MappedFeatureType[] rootFts, String[] aliases, Filter filter,
    093                                                  SortProperty[] sortProperties, TableAliasGenerator aliasGenerator,
    094                                                  VirtualContentProvider vcProvider )
    095                                throws DatastoreException {
    096            return new MySQLWhereBuilder( rootFts, aliases, filter, sortProperties, aliasGenerator, vcProvider );
    097        }
    098
    099        /**
    100         * Converts a MySQL specific geometry <code>Object</code> (a byte[] containing WKB) from the <code>ResultSet</code>
    101         * to a deegree <code>Geometry</code>.
    102         *
    103         * @param value
    104         * @param targetCS
    105         * @param conn
    106         * @return corresponding deegree geometry
    107         * @throws SQLException
    108         */
    109        @Override
    110        public Geometry convertDBToDeegreeGeometry( Object value, CoordinateSystem targetCS, Connection conn )
    111                                throws SQLException {
    112            Geometry geometry = null;
    113            if ( value != null && value instanceof byte[] ) {
    114                try {
    115                    LOG.logDebug( "Converting MySQL geometry (WKB byte array) to deegree geometry ('"
    116                                  + targetCS.getIdentifier() + "')" );
    117                    byte[] wkb = (byte[]) value;
    118                    // parsing WKB using PostGIS' binary parser to generate PostGIS' geometry
    119                    org.postgis.Geometry pgGeometry = new BinaryParser().parse( wkb );
    120                    geometry = PGgeometryAdapter.wrap( pgGeometry, targetCS );
    121                } catch ( Exception e ) {
    122                    e.printStackTrace();
    123                    throw new SQLException( "Error converting MySQL geometry to deegree geometry: " + e.getMessage() );
    124                }
    125            }
    126            return geometry;
    127        }
    128
    129        /**
    130         * Converts a deegree <code>Geometry</code> to a MySQL specific geometry object (a byte[] containing WKB).
    131         *
    132         * @param geometry
    133         * @param targetSRS
    134         * @param conn
    135         * @return corresponding PostGIS specific geometry object
    136         * @throws DatastoreException
    137         */
    138        @Override
    139        public byte[] convertDeegreeToDBGeometry( Geometry geometry, int targetSRS, Connection conn )
    140                                throws DatastoreException {
    141            byte[] wkb;
    142            try {
    143                PGgeometry pgGeometry = PGgeometryAdapter.export( geometry, targetSRS );
    144                wkb = new BinaryWriter().writeBinary( pgGeometry.getGeometry() );
    145            } catch ( GeometryException e ) {
    146                throw new DatastoreException( "Error converting deegree geometry to MySQL geometry: " + e.getMessage(), e );
    147            }
    148            return wkb;
    149        }
    150
    151        @Override
    152        public void appendGeometryColumnGet( StatementBuffer query, String tableAlias, String column ) {
    153            query.append( "AsBinary(" );
    154            query.append( tableAlias );
    155            query.append( '.' );
    156            query.append( column );
    157            query.append( ')' );
    158        }
    159    }