MySQLDB_5_7.java

/*
 * Copyright 2013 Gregory Graham.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package nz.co.gregs.dbvolution.databases;

import java.sql.SQLException;
import java.sql.Statement;
import java.util.regex.Pattern;
import javax.sql.DataSource;
import nz.co.gregs.dbvolution.databases.settingsbuilders.MySQL_5_7SettingsBuilder;
import nz.co.gregs.dbvolution.databases.supports.SupportsPolygonDatatype;
import nz.co.gregs.dbvolution.exceptions.ExceptionDuringDatabaseFeatureSetup;
import nz.co.gregs.dbvolution.internal.mysql.MigrationFunctions;
import nz.co.gregs.dbvolution.internal.query.StatementDetails;

/**
 * A DBDatabase tweaked for MySQL databases
 *
 * @author Gregory Graham
 */
public class MySQLDB_5_7 extends DBDatabaseImplementation implements SupportsPolygonDatatype {

    public final static String MYSQLDRIVERNAME = "com.mysql.jdbc.Driver";
    private static final long serialVersionUID = 1l;
    public static final int DEFAULT_PORT = 3306;
    private final MySQL_5_7SettingsBuilder urlProcessor = new MySQL_5_7SettingsBuilder();

    /**
     * Creates a {@link DBDatabase } instance for the data source.
     *
     * @param ds    ds
     * @throws java.sql.SQLException database errors
     */
    public MySQLDB_5_7(DataSource ds) throws SQLException {
        super(
                new MySQL_5_7SettingsBuilder().setDataSource(ds)
        );
//      super(new MySQLDBDefinition_5_7(), MYSQLDRIVERNAME, ds);
    }
    
    /**
     * Creates a {@link DBDatabase } instance for the data source.
     *
     * @param ds    ds
     * @throws java.sql.SQLException database errors
     */
    public MySQLDB_5_7(MySQL_5_7SettingsBuilder ds) throws SQLException {
        super(ds);
    }

    /**
     * Creates a {@link DBDatabase } instance for the data source.
     *
     * @param dcs the settings required to connect to the database
     * @throws java.sql.SQLException database errors
     */
    public MySQLDB_5_7(DatabaseConnectionSettings dcs) throws SQLException {
        this(new MySQL_5_7SettingsBuilder().fromSettings(dcs));
    }

    /**
     * Creates DBDatabase suitable for use with MySQL attached to the supplied
     * JDBC URL, username, and password.
     *
     * @param jdbcURL jdbcURL
     * @param password password
     * @param username username
     * @throws java.sql.SQLException database errors
     */
    public MySQLDB_5_7(String jdbcURL, String username, String password) throws SQLException {
        this(new MySQL_5_7SettingsBuilder().fromJDBCURL(jdbcURL, username, password));
    }

    /**
     * Creates DBDatabase suitable for use with MySQL attached to the supplied
     * JDBC URL, username, and password.
     *
     * @param server the server to connect to.
     * @param port the port to connect on.
     * @param databaseName the database that is required on the server.
     * @param username the user to login as.
     * @param password the password required to login successfully.
     * @throws java.sql.SQLException database errors
     */
    public MySQLDB_5_7(String server, long port, String databaseName, String username, String password) throws SQLException {
        this(
new MySQL_5_7SettingsBuilder()
                        .setHost(server)
                        .setPort(port)
                        .setDatabaseName(databaseName)
                        .setUsername(username)
                        .setPassword(password)
        //              "jdbc:mysql://" + server + ":" + port + "/" + databaseName + "?createDatabaseIfNotExist=true&useUnicode=yes&characterEncoding=utf8&characterSetResults=utf8&verifyServerCertificate=false&useSSL=true",
        );
    }

    @Override
    public DBDatabase clone() throws CloneNotSupportedException {
        return super.clone(); //To change body of generated methods, choose Tools | Templates.
    }

    @Override
    public void addDatabaseSpecificFeatures(Statement statement) throws ExceptionDuringDatabaseFeatureSetup {
        for (MigrationFunctions fn : MigrationFunctions.values()) {
            fn.add(statement);
        }
    }

    @Override
    public Integer getDefaultPort() {
        return 3306;
    }

    private final static Pattern FUNCTION_DOES_NOT_EXISTS = Pattern.compile("FUNCTION [^ ]* does not exist");
    private final static Pattern TABLE_ALREADY_EXISTS = Pattern.compile("Table '[^']*' already exists");

    @Override
    public ResponseToException addFeatureToFixException(Exception exp, QueryIntention intent, StatementDetails details) throws Exception {
        if (intent.is(QueryIntention.DROP_TABLE) && TABLE_ALREADY_EXISTS.matcher(exp.getMessage()).matches()) {
            return ResponseToException.SKIPQUERY;
        } else if (FUNCTION_DOES_NOT_EXISTS.matcher(exp.getMessage()).matches()) {

        }
        return super.addFeatureToFixException(exp, intent, details);
    }

    @Override
    public MySQL_5_7SettingsBuilder getURLInterpreter() {
        return urlProcessor;
    }

}