package org.apache.ddlutils.platform.derby; | |
/* | |
* Licensed to the Apache Software Foundation (ASF) under one | |
* or more contributor license agreements. See the NOTICE file | |
* distributed with this work for additional information | |
* regarding copyright ownership. The ASF licenses this file | |
* to you 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. | |
*/ | |
import java.io.IOException; | |
import java.sql.Types; | |
import org.apache.ddlutils.Platform; | |
import org.apache.ddlutils.model.Column; | |
import org.apache.ddlutils.model.Index; | |
import org.apache.ddlutils.model.Table; | |
import org.apache.ddlutils.model.TypeMap; | |
import org.apache.ddlutils.platform.cloudscape.CloudscapeBuilder; | |
import org.apache.ddlutils.util.Jdbc3Utils; | |
/** | |
* The SQL Builder for Derby. | |
* | |
* @version $Revision: 279413 $ | |
*/ | |
public class DerbyBuilder extends CloudscapeBuilder | |
{ | |
/** | |
* Creates a new builder instance. | |
* | |
* @param platform The plaftform this builder belongs to | |
*/ | |
public DerbyBuilder(Platform platform) | |
{ | |
super(platform); | |
} | |
/** | |
* {@inheritDoc} | |
*/ | |
protected String getNativeDefaultValue(Column column) | |
{ | |
if ((column.getTypeCode() == Types.BIT) || | |
(Jdbc3Utils.supportsJava14JdbcTypes() && (column.getTypeCode() == Jdbc3Utils.determineBooleanTypeCode()))) | |
{ | |
return getDefaultValueHelper().convert(column.getDefaultValue(), column.getTypeCode(), Types.SMALLINT).toString(); | |
} | |
else | |
{ | |
return super.getNativeDefaultValue(column); | |
} | |
} | |
/** | |
* {@inheritDoc} | |
*/ | |
protected void writeColumnAutoIncrementStmt(Table table, Column column) throws IOException | |
{ | |
print("GENERATED BY DEFAULT AS IDENTITY"); | |
} | |
/** | |
* {@inheritDoc} | |
*/ | |
public void dropIndex(Table table, Index index) throws IOException | |
{ | |
// Index names in Derby are unique to a schema and hence Derby does not | |
// use the ON <tablename> clause | |
print("DROP INDEX "); | |
printIdentifier(getIndexName(index)); | |
printEndOfStatement(); | |
} | |
/** | |
* {@inheritDoc} | |
*/ | |
protected void writeCastExpression(Column sourceColumn, Column targetColumn) throws IOException | |
{ | |
String sourceNativeType = getBareNativeType(sourceColumn); | |
String targetNativeType = getBareNativeType(targetColumn); | |
if (sourceNativeType.equals(targetNativeType)) | |
{ | |
printIdentifier(getColumnName(sourceColumn)); | |
} | |
else | |
{ | |
// Derby currently has the limitation that it cannot convert numeric values | |
// to VARCHAR, though it can convert them to CHAR | |
if (TypeMap.isNumericType(sourceColumn.getTypeCode()) && | |
"VARCHAR".equalsIgnoreCase(targetNativeType)) | |
{ | |
targetNativeType = "CHAR"; | |
} | |
print(targetNativeType); | |
print("("); | |
printIdentifier(getColumnName(sourceColumn)); | |
print(")"); | |
} | |
} | |
} |