/**
*
* Copyright (c) 2006-2017, 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.connector.h2.internal;
import com.speedment.common.injector.InjectBundle;
import static com.speedment.common.injector.InjectBundle.of;
import com.speedment.common.injector.annotation.Inject;
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 com.speedment.runtime.core.internal.manager.sql.MySqlSpeedmentPredicateView;
import java.util.Collections;
import java.util.Set;
import java.util.function.Predicate;
import static java.util.stream.Collectors.collectingAndThen;
import static java.util.stream.Collectors.toSet;
import java.util.stream.Stream;
/**
*
* @author Per Minborg
* @author Emil Forslund
*/
public final class H2DbmsType extends AbstractDbmsType {
public static InjectBundle include() {
return of(H2DbmsMetadataHandler.class, H2DbmsOperationHandler.class);
}
private final static FieldPredicateView PREDICATE_VIEW = new MySqlSpeedmentPredicateView();
private final MySqlNamingConvention namingConvention;
private final MySqlConnectionUrlGenerator connectionUrlGenerator;
private @Inject
H2DbmsMetadataHandler metadataHandler;
private @Inject
H2DbmsOperationHandler operationHandler;
private H2DbmsType() {
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 "Just a name";
}
@Override
public String getDriverName() {
return "com.mysql.jdbc.Driver";
}
@Override
public boolean isSupported() {
// make sure we touch new new driver first.
return isSupported("com.mysql.cj.jdbc.Driver") || isSupported(getDriverName());
}
@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 PREDICATE_VIEW;
}
@Override
public String getInitialQuery() {
return "select version() as `MySQL version`";
}
@Override
public DbmsColumnHandler getColumnHandler() {
return new DbmsColumnHandler() {
@Override
public Predicate<Column> excludedInInsertStatement() {
return c -> false; // For MySQL, even autoincrement fields are added to insert statements
}
};
}
private final static class MySqlNamingConvention extends AbstractDatabaseNamingConvention {
private final static String ENCLOSER = "`",
QUOTE = "'";
private final static Set<String> EXCLUDE_SET = Stream.of(
"information_schema"
).collect(collectingAndThen(toSet(), Collections::unmodifiableSet));
@Override
public Set<String> 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 static 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(
"/?useUnicode=true"
+ "&characterEncoding=UTF-8"
+ "&useServerPrepStmts=true"
/* + "&useCursorFetch=true" */ // Fix #190, Needs to be removed for 6.x drivers
+ "&zeroDateTimeBehavior=convertToNull"
+ "&useSSL=false"
+ "&nullNamePatternMatchesAll=true" // Fix #190
+ "&useLegacyDatetimeCode=true" // Fix #190
);
return result.toString();
}
}
}