org.hibernate.spatial.dialect.mysql.MySQLSpatial5InnoDBTimestampDialect Maven / Gradle / Ivy

Go to download
/*
 * Copyright (C) 2012-2020 52°North Initiative for Geospatial Open Source
 * Software GmbH
 *
 * This program is free software; you can redistribute it and/or modify it
 * under the terms of the GNU General Public License version 2 as published
 * by the Free Software Foundation.
 *
 * If the program is linked with libraries which are licensed under one of
 * the following licenses, the combination of the program with the linked
 * library is not considered a "derivative work" of the program:
 *
 *     - Apache License, version 2.0
 *     - Apache Software License, version 1.0
 *     - GNU Lesser General Public License, version 3
 *     - Mozilla Public License, versions 1.0, 1.1 and 2.0
 *     - Common Development and Distribution License (CDDL), version 1.0
 *
 * Therefore the distribution of the program linked with libraries licensed
 * under the aforementioned licenses, is permitted by the copyright holders
 * if the distribution is compliant with both the GNU General Public
 * License version 2 and the aforementioned licenses.
 *
 * 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.
 */
package org.hibernate.spatial.dialect.mysql;

import java.sql.Types;

import org.hibernate.HibernateException;
import org.hibernate.dialect.Dialect;
import org.hibernate.mapping.Index;
import org.n52.sos.ds.datasource.SpatialIndexDialect;

/**
 * Hibernate Spatial {@link Dialect} for MySQL that registers Types.TIMESTAMP to
 * timestampt instead of datetime.
 *
 * @author Carsten Hollmann
 * @since 4.3.0
 *
 */
public class MySQLSpatial5InnoDBTimestampDialect extends MySQL56InnoDBSpatialDialect implements SpatialIndexDialect {

    private static final long serialVersionUID = 4518550802945449263L;

    private static final String TIMESTAMP = "timestamp";

    public MySQLSpatial5InnoDBTimestampDialect() {
        super();
        registerColumnType(Types.TIMESTAMP, TIMESTAMP);
    }

    @Override
    public String getTypeName(int code, long length, int precision, int scale) throws HibernateException {
        if (Types.TIMESTAMP == code) {
            return TIMESTAMP;
        }
        return super.getTypeName(code, length, precision, scale);
    }

    @Override
    public String getTypeName(int code) throws HibernateException {
        if (Types.TIMESTAMP == code) {
            return TIMESTAMP;
        }
        return super.getTypeName(code);
    }

    // https://dev.mysql.com/doc/refman/5.0/en/creating-spatial-indexes.html
    public String buildSqlCreateSpatialIndexString(Index index, String defaultCatalog, String defaultSchema) {

        // only for NOT NULL columns and ENGINE=MyISAM
        // https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html

        // String name = index.getName();
        // Table table = index.getTable();
        // Iterator columns = index.getColumnIterator();
        // java.util.Map columnOrderMap = new HashMap();
        //
        //
        // StringBuilder buf = new StringBuilder( "create" )
        // .append( " spatial index " )
        // .append( this.qualifyIndexName() ?
        // name :
        // StringHelper.unqualify( name ) )
        // .append( " on " )
        // .append( table.getQualifiedName( this, defaultCatalog, defaultSchema
        // ) )
        // .append( " (" );
        // while (columns.hasNext()) {
        // Column column = columns.next();
        // buf.append(column.getQuotedName(this));
        // if (columnOrderMap.containsKey(column)) {
        // buf.append(" ").append(columnOrderMap.get(column));
        // }
        // if (columns.hasNext())
        // buf.append(", ");
        // }
        // buf.append(")");
        // return buf.toString();
        return "";
    }

}