com.speedment.runtime.connector.mysql.internal.MySqlDbmsType Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of tool-deploy Show documentation
Show all versions of tool-deploy Show documentation
A Speedment bundle that shades all dependencies into one jar. This is
useful when deploying an application on a server.
The newest version!
/*
*
* Copyright (c) 2006-2019, Speedment, Inc. All Rights Reserved.
*
* 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 com.speedment.runtime.connector.mysql.internal;
import com.speedment.common.injector.annotation.Config;
import com.speedment.runtime.config.Column;
import com.speedment.runtime.config.Dbms;
import com.speedment.runtime.core.db.*;
import com.speedment.runtime.core.internal.db.AbstractDatabaseNamingConvention;
import com.speedment.runtime.core.internal.db.AbstractDbmsType;
import java.sql.Driver;
import java.util.Collections;
import java.util.Optional;
import java.util.Set;
import java.util.function.Predicate;
import java.util.stream.Stream;
import static com.speedment.runtime.core.db.SqlPredicateFragment.of;
import static java.util.Objects.requireNonNull;
import static java.util.stream.Collectors.collectingAndThen;
import static java.util.stream.Collectors.toSet;
/**
*
* @author Per Minborg
* @author Emil Forslund
*/
public final class MySqlDbmsType extends AbstractDbmsType {
private static final String OLD_DRIVER = "com.mysql.jdbc.Driver";
private static final String NEW_DRIVER = "com.mysql.cj.jdbc.Driver";
private final MySqlDbmsMetadataHandler metadataHandler;
private final MySqlDbmsOperationHandler operationHandler;
private final MySqlSpeedmentPredicateView fieldPredicateView;
private final String binaryCollationName;
private final MySqlNamingConvention namingConvention;
private final MySqlConnectionUrlGenerator connectionUrlGenerator;
private MySqlDbmsType(
final DriverComponent driverComponent,
final MySqlDbmsMetadataHandler metadataHandler,
final MySqlDbmsOperationHandler operationHandler,
final MySqlSpeedmentPredicateView fieldPredicateView,
@Config(name = "db.mysql.binaryCollationName", value = "utf8_bin")
final String binaryCollationName
) {
super(driverComponent);
this.metadataHandler = requireNonNull(metadataHandler);
this.operationHandler = requireNonNull(operationHandler);
this.fieldPredicateView = requireNonNull(fieldPredicateView);
this.binaryCollationName = requireNonNull(binaryCollationName);
namingConvention = new MySqlNamingConvention();
connectionUrlGenerator = new MySqlConnectionUrlGenerator();
}
@Override
public String getName() {
return "MySQL";
}
@Override
public String getDriverManagerName() {
return "MySQL-AB JDBC Driver";
}
@Override
public int getDefaultPort() {
return 3306;
}
@Override
public String getDbmsNameMeaning() {
return "The name of the MySQL Database.";
}
@Override
public boolean hasSchemaNames() {
return false;
}
@Override
public String getDriverName() {
return isSupported(NEW_DRIVER) ? NEW_DRIVER : OLD_DRIVER;
}
@Override
public boolean isSupported() {
// make sure we touch new new driver first.
return isSupported(NEW_DRIVER) || isSupported(OLD_DRIVER);
}
@Override
public DatabaseNamingConvention getDatabaseNamingConvention() {
return namingConvention;
}
@Override
public DbmsMetadataHandler getMetadataHandler() {
return metadataHandler;
}
@Override
public DbmsOperationHandler getOperationHandler() {
return operationHandler;
}
@Override
public ConnectionUrlGenerator getConnectionUrlGenerator() {
return connectionUrlGenerator;
}
@Override
public FieldPredicateView getFieldPredicateView() {
return fieldPredicateView;
}
@Override
public String getInitialQuery() {
return "select version() as `MySQL version`";
}
@Override
public SqlPredicateFragment getCollateFragment() {
return of(" COLLATE " + binaryCollationName);
}
@Override
public DbmsColumnHandler getColumnHandler() {
return new DbmsColumnHandler() {
@Override
public Predicate excludedInInsertStatement() {
return c -> false; // For MySQL, even autoincrement fields are added to insert statements
}
@Override
public Predicate excludedInUpdateStatement() {
return c -> false;
}
};
}
private final static class MySqlNamingConvention extends AbstractDatabaseNamingConvention {
private final static String ENCLOSER = "`",
QUOTE = "'";
private final static Set EXCLUDE_SET = Stream.of(
"information_schema"
).collect(collectingAndThen(toSet(), Collections::unmodifiableSet));
@Override
public Set getSchemaExcludeSet() {
return EXCLUDE_SET;
}
@Override
protected String getFieldQuoteStart() {
return QUOTE;
}
@Override
protected String getFieldQuoteEnd() {
return QUOTE;
}
@Override
protected String getFieldEncloserStart() {
return ENCLOSER;
}
@Override
protected String getFieldEncloserEnd() {
return ENCLOSER;
}
}
private final class MySqlConnectionUrlGenerator implements ConnectionUrlGenerator {
@Override
public String from(Dbms dbms) {
final StringBuilder result = new StringBuilder()
.append("jdbc:mysql://")
.append(dbms.getIpAddress().orElse(""));
dbms.getPort().ifPresent(p -> result.append(":").append(p));
result/*.append("/").append(dbms.getName())*/ // MySQL treats this as default schema name
.append("?useUnicode=true&characterEncoding=UTF-8")
.append("&useServerPrepStmts=true")
.append("&zeroDateTimeBehavior=")
.append(driverVersion() >= 8 ? "CONVERT_TO_NULL" : "convertToNull")
.append("&nullNamePatternMatchesAll=true") // Fix #190
.append("&useLegacyDatetimeCode=true"); // Fix #190
if (driverVersion() <= 5) {
result.append("&useSSL=false");
} else {
result.append("&serverTimezone=UTC");
}
return result.toString();
}
}
private int driverVersion() {
return
Stream.of(
driver(NEW_DRIVER),
driver(OLD_DRIVER)
)
.filter(Optional::isPresent)
.map(Optional::get)
.mapToInt(Driver::getMajorVersion)
.findFirst()
.orElse(5); // Fallback. There is no driver so we just make up a version
}
}