org.jooq.impl.AlterTableImpl Maven / Gradle / Ivy
/**
* Copyright (c) 2009-2014, Data Geekery GmbH (http://www.datageekery.com)
* All rights reserved.
*
* This work is dual-licensed
* - under the Apache Software License 2.0 (the "ASL")
* - under the jOOQ License and Maintenance Agreement (the "jOOQ License")
* =============================================================================
* You may choose which license applies to you:
*
* - If you're using this work with Open Source databases, you may choose
* either ASL or jOOQ License.
* - If you're using this work with at least one commercial database, you must
* choose jOOQ License
*
* For more information, please visit http://www.jooq.org/licenses
*
* Apache Software License 2.0:
* -----------------------------------------------------------------------------
* 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.
*
* jOOQ License and Maintenance Agreement:
* -----------------------------------------------------------------------------
* Data Geekery grants the Customer the non-exclusive, timely limited and
* non-transferable license to install and use the Software under the terms of
* the jOOQ License and Maintenance Agreement.
*
* This library is distributed with a LIMITED WARRANTY. See the jOOQ License
* and Maintenance Agreement for more details: http://www.jooq.org/licensing
*/
package org.jooq.impl;
import static org.jooq.Clause.ALTER_TABLE;
import static org.jooq.Clause.ALTER_TABLE_ADD;
import static org.jooq.Clause.ALTER_TABLE_ALTER;
import static org.jooq.Clause.ALTER_TABLE_ALTER_DEFAULT;
import static org.jooq.Clause.ALTER_TABLE_DROP;
import static org.jooq.Clause.ALTER_TABLE_TABLE;
import static org.jooq.SQLDialect.FIREBIRD;
// ...
import static org.jooq.impl.DSL.fieldByName;
import static org.jooq.impl.DSL.inline;
import static org.jooq.impl.DSL.queryPart;
import org.jooq.AlterTableAlterStep;
import org.jooq.AlterTableDropStep;
import org.jooq.AlterTableFinalStep;
import org.jooq.AlterTableStep;
import org.jooq.Clause;
import org.jooq.Configuration;
import org.jooq.Context;
import org.jooq.DSLContext;
import org.jooq.DataType;
import org.jooq.Field;
import org.jooq.SQLDialect;
import org.jooq.Table;
/**
* @author Lukas Eder
*/
@SuppressWarnings({ "rawtypes", "unchecked" })
class AlterTableImpl extends AbstractQuery implements
// Cascading interface implementations for ALTER TABLE behaviour
AlterTableStep,
AlterTableDropStep,
AlterTableAlterStep {
/**
* Generated UID
*/
private static final long serialVersionUID = 8904572826501186329L;
private static final Clause[] CLAUSES = { ALTER_TABLE };
private final Table table;
private Field add;
private DataType addType;
private Field alter;
private DataType alterType;
private Field alterDefault;
private Field drop;
private boolean dropCascade;
AlterTableImpl(Configuration configuration, Table table) {
super(configuration);
this.table = table;
}
// ------------------------------------------------------------------------
// XXX: DSL API
// ------------------------------------------------------------------------
@Override
public final AlterTableImpl add(String field, DataType type) {
return add((Field) fieldByName(type, field), type);
}
@Override
public final AlterTableImpl add(Field field, DataType type) {
add = field;
addType = type;
return this;
}
@Override
public final AlterTableImpl alter(String field) {
return alter(fieldByName(field));
}
@Override
public final AlterTableImpl alter(Field field) {
alter = field;
return this;
}
@Override
public final AlterTableImpl set(DataType type) {
alterType = type;
return this;
}
@Override
public final AlterTableImpl defaultValue(Object literal) {
return defaultValue(inline(literal));
}
@Override
public final AlterTableImpl defaultValue(Field expression) {
alterDefault = expression;
return this;
}
@Override
public final AlterTableImpl drop(String field) {
return drop(fieldByName(field));
}
@Override
public final AlterTableImpl drop(Field field) {
drop = field;
return this;
}
@Override
public final AlterTableFinalStep cascade() {
dropCascade = true;
return this;
}
@Override
public final AlterTableFinalStep restrict() {
dropCascade = false;
return this;
}
// ------------------------------------------------------------------------
// XXX: QueryPart API
// ------------------------------------------------------------------------
@Override
public final void accept(Context ctx) {
SQLDialect family = ctx.configuration().dialect().family();
/* [pro] xx
xx xxx xxxxxx xxxxxxx xxxxxx xxxxx xx xxxxx xxxxxxx xxxxxxx xxx xx xxx xxx x xxxxx xxxxxx xx xx xxxx
xx xxxxxxx xx xxxxxxxxx xx xxxxxxxxxxxx xx xxxxx x
xxxxxxxxxxxxxxxxxxxxxxxxxxx
x
xxxx
xx [/pro] */
{
accept0(ctx);
}
}
private final void accept0(Context ctx) {
SQLDialect family = ctx.configuration().dialect().family();
ctx.start(ALTER_TABLE_TABLE)
.keyword("alter table").sql(" ").visit(table)
.end(ALTER_TABLE_TABLE);
if (add != null) {
ctx.start(ALTER_TABLE_ADD)
.sql(" ").keyword("add").sql(" ")
.qualify(false)
.visit(add).sql(" ")
.qualify(true)
// [#3341] This is currently incorrect for MySQL and MariaDB
.keyword(addType.getCastTypeName(ctx.configuration()));
if (!addType.nullable()) {
ctx.sql(" ").keyword("not null");
}
// Some databases default to NOT NULL, so explicitly setting columns to NULL is mostly required here
// [#3400] ... but not in Firebird
else if (family != FIREBIRD) {
ctx.sql(" ").keyword("null");
}
ctx.end(ALTER_TABLE_ADD);
}
else if (alter != null) {
ctx.start(ALTER_TABLE_ALTER);
switch (family) {
/* [pro] xx
xxxx xxxxxxxxx
xxxx xxxxxxx
xxxxxxxxx xxxxxxxxxxxxxxxxxxxxx
xxxxxx
xxxx xxxxxxxxxx
xxxxxxxxx xxxxxxxxxxxxxxxxx xxxxxxxxx
xxxxxx
xx [/pro] */
case MARIADB:
case MYSQL:
// MySQL's CHANGE COLUMN clause has a mandatory RENAMING syntax...
ctx.sql(" ").keyword("change column")
.sql(" ").qualify(false).visit(alter).qualify(true);
break;
default:
ctx.sql(" ").keyword("alter");
break;
}
ctx.sql(" ")
.qualify(false)
.visit(alter)
.qualify(true);
if (alterType != null) {
switch (family) {
/* [pro] xx
xxxx xxxx
xxxxxxxxx xxxxxxxxxxxxxxx xxxx xxxxxxx
xxxxxx
xx [/pro] */
case POSTGRES:
ctx.sql(" ").keyword("type");
break;
}
// [#3341] This is currently incorrect for MySQL and MariaDB
ctx.sql(" ").keyword(alterType.getCastTypeName(ctx.configuration()));
if (!alterType.nullable()) {
ctx.sql(" ").keyword("not null");
}
}
else if (alterDefault != null) {
ctx.start(ALTER_TABLE_ALTER_DEFAULT);
switch (family) {
/* [pro] xx
xxxx xxxxxxx
xxxxxxxxx xxxxxxxxxxxxxxxxxxxxxx
xxxxxx
xx [/pro] */
default:
ctx.sql(" ").keyword("set default");
break;
}
ctx.sql(" ").visit(alterDefault)
.end(ALTER_TABLE_ALTER_DEFAULT);
}
ctx.end(ALTER_TABLE_ALTER);
}
else if (drop != null) {
ctx.start(ALTER_TABLE_DROP);
switch (family) {
/* [pro] xx
xxxx xxxxxxx
xxxx xxxxxxxxxx
xxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxx
xxxxxx
xx [/pro] */
default:
ctx.sql(" ").keyword("drop");
break;
}
ctx.sql(" ")
.qualify(false)
.visit(drop)
.qualify(true);
if (dropCascade) {
ctx.sql(" ").keyword("cascade");
}
ctx.end(ALTER_TABLE_DROP);
}
}
/* [pro] xx
xxxxxxx xxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxx x
xxxxxxxxxx xxxxxx x xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxx xxxxxxxxxxxx x xxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxx xxxxxxxxxxxx x xxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxx xxxxxxxxxxxxxxxxxxx x xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xx xxxxxxx xxxxx xxxxxxxxxxx xxxx xxx xxxxxx xx x xxxxxxxxxxx xxxx xxx xxx xxxxxx
xx xxxxxxxxxx xxxxxxxxx xx xxxx xx
xxxxxxxxxxxxxxxxxxxx
xxxxxxxx xxxxxxxxxxx xxxxxxxxxxxxxxx
x xxxxxxxxxx xxxxxxxx xxxxxxxxxxxxxxx
x xxxx
x xxxxxxxxx xxxxxxxxxxx x xxxxx
x xxxxxxx xxxxxxxxxxxxxxxxxxxxxxxx
x xxxxxxxx xxxxxxxxxxxxxxxx x xxxxxxxxxxxx x xxxxxxxxxxxx x xxxx
x xxxxxx xxxxxxxxxxxxxxxx x xxxxxxxxxxxxxxxxxxxxxxxxxxx x xxxxxxxxxxxx x xxxx xx x xxxxxxxxxxxx x xxx xxxxxxxxxxxxx
x xxxx
x xxxxx xxxxxxxxxxx xx xxx xxxxx
x xxxxxxxxx
x xxx xxx xxxxxxxx x xxxxxx xxxxx x x xxxxxxxxxxxx x x xxxx xxxxxxxxxx x x xxxxxxxxxxxx
x xxx xxxxxxx xxxxxxxxxxxxx xxxxxxxxx
x xxxx
x xxx xxx xxxxxxxx x xxxxxx xxxxx x x xxxxxxxxxxxx x x xxx xxxxxxxxxx x x xxxxxxxxxxx x x xxxxxxx xx x xxxxxxxxxxxxxxxxxxx x xx xxx x x xxxxxxxxxxxx x xxx
x xxx xxxxxxx xxxxxxxxxxxxx xxxxxxxxx
x xxxxxxx
x xxxxxxxx
x xxxxxxxxx
x xxx xxx xxxxxxxx x xxxxxx xxxxx x x xxxxxxxxxxxx x x xxx xxxxxxx xx x xxxxxxxxxxxxxxxxxxx x xx xxx x x xxxxxxxxxxxx x xxx
x xxx xxxxxxx xxxxxxxxxxxxx xxxxxxxxx
x xxxxxxx
xxx
x
xx [/pro] */
@Override
public final Clause[] clauses(Context ctx) {
return CLAUSES;
}
}