org.plasma.text.ddl.MySQLFactory Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of plasma-provisioning Show documentation
Show all versions of plasma-provisioning Show documentation
The Plasma Provisioning Module
/**
* Copyright 2017 TerraMeta Software, Inc.
*
* 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 org.plasma.text.ddl;
import org.plasma.sdo.DataType;
public class MySQLFactory extends DefaultDDLFactory implements DDLFactory {
public String getType(Table table, Column column) {
DataType sdoType = DataType.valueOf(column.getType());
switch (sdoType) {
case String:
case Strings:
case URI:
if (column.getSize() > 0) {
if (column.getSize() > 4000) {
return "TEXT";
} else
return "VARCHAR(" + column.getSize() + ")";
} else
return "VARCHAR(255)"; // FIXME - were does the default for this live ??
case Boolean:
case Byte:
return "NUMERIC(1)";
case Character:
return "VARCHAR(1)";
case Decimal:
return "NUMERIC(22)";
case Double:
return "FLOAT(49)";
case Float:
return "FLOAT(23)";
case Short:
return "SMALLINT";
case Integer:
return "BIGINT";
case Int:
return "INT";
case Long:
return "BIGINT";
case Date:
case DateTime:
return "DATE";
case Time:
return "TIMESTAMP";
case Bytes:
case Object:
case Day:
case Duration:
case Month:
case MonthDay:
case Year:
case YearMonth:
case YearMonthDay:
default:
throw new DDLException("unsupported SDO type, " + sdoType.toString());
}
}
@Override
public String createTable(Schema schema, Table table) {
StringBuilder buf = new StringBuilder();
buf.append("CREATE TABLE ");
buf.append(schema.getName());
buf.append(".");
buf.append(table.getName());
buf.append(" ( ");
int i = 0;
for (Column column : table.getColumns()) {
if (i > 0)
buf.append(", ");
buf.append(column.getName());
buf.append(" ");
if (!isEnumerativeCheck(table, column)) {
buf.append(getType(table, column));
} else {
Check check = getEnumerativeCheck(table, column);
buf.append("ENUM(");
int j = 0;
for (String s : check.getValues()) {
if (j > 0)
buf.append(", ");
buf.append("'");
buf.append(s);
buf.append("'");
j++;
}
buf.append(")");
}
if (!column.isNullable())
buf.append(" NOT NULL");
if (isSequence(table, column))
buf.append(" AUTO_INCREMENT");
i++;
}
if (table.getPk() != null) {
buf.append(", PRIMARY KEY (");
i = 0;
for (On on : table.getPk().getOns()) {
if (i > 0)
buf.append(", ");
buf.append(on.getColumn());
i++;
}
buf.append(" )");
}
buf.append(" );\n");
return buf.toString();
}
@Override
public String createView(Schema schema, Table table, Behavior create) {
return create.getValue();
}
@Override
public String dropView(Schema schema, Table table, Behavior drop) {
return drop.getValue();
}
private boolean isEnumerativeCheck(Table table, Column column) {
for (Check check : table.getChecks()) {
if (column.getName().equals(check.getColumn()))
return true;
}
return false;
}
private Check getEnumerativeCheck(Table table, Column column) {
for (Check check : table.getChecks()) {
if (column.getName().equals(check.getColumn()))
return check;
}
throw new IllegalStateException("could nto find enumerative check on " + table.getName() + "."
+ column.getName());
}
/**
* Returns true if the given column is presumed to be a sequence.
*
* @param table
* the table
* @param column
* the column
* @return true true if the given column is presumed to be a sequence.
*/
private boolean isSequence(Table table, Column column) {
if (isPk(table, column) && !(isFk(table, column))) {
DataType sdoType = DataType.valueOf(column.getType());
switch (sdoType) {
case Int:
case Integer:
case Long:
return true;
}
}
return false;
}
@Override
public String createForeignKeyConstraint(Schema schema, Table table, Fk fk, Table toTable) {
StringBuilder buf = new StringBuilder();
buf.append("ALTER TABLE ");
buf.append(schema.getName());
buf.append(".");
buf.append(table.getName());
buf.append(" ADD CONSTRAINT ");
buf.append(fk.getName());
buf.append(" FOREIGN KEY ( ");
buf.append(fk.getColumn());
buf.append(" ) REFERENCES ");
buf.append(schema.getName());
buf.append(".");
buf.append(toTable.getName());
buf.append(" ( ");
int i = 0;
for (On on : toTable.getPk().getOns()) {
if (i > 0)
buf.append(", ");
buf.append(on.getColumn());
i++;
}
buf.append(" );\n");
return buf.toString();
}
@Override
public String dropForeignKeyConstraint(Schema schema, Table table, Fk fk, Table toTable) {
StringBuilder buf = new StringBuilder();
buf.append("ALTER TABLE ");
buf.append(schema.getName());
buf.append(".");
buf.append(table.getName());
buf.append(" DROP FOREIGN KEY ");
buf.append(fk.getName());
buf.append(";\n");
return buf.toString();
}
public String enableForeignKeyConstraint(Schema schema, Table table, Fk fk, Table toTable,
boolean enable) {
if (enable) {
return createForeignKeyConstraint(schema, table, fk, toTable);
} else {
return dropForeignKeyConstraint(schema, table, fk, toTable);
}
}
@Override
public String createUniqueConstraint(Schema schema, Table table, Unique unique) {
StringBuilder buf = new StringBuilder();
buf.append("ALTER TABLE ");
buf.append(schema.getName());
buf.append(".");
buf.append(table.getName());
buf.append(" ADD CONSTRAINT ");
buf.append(unique.getName());
buf.append(" UNIQUE ( ");
int i = 0;
for (On on : unique.getOns()) {
if (i > 0)
buf.append(", ");
buf.append(on.getColumn());
i++;
}
buf.append(" );\n");
return buf.toString();
}
@Override
public String dropUniqueConstraint(Schema schema, Table table, Unique unique) {
StringBuilder buf = new StringBuilder();
return buf.toString();
}
@Override
public String dropIndex(Schema schema, Table table, Index index) {
StringBuilder buf = new StringBuilder();
buf.append("DROP INDEX ");
buf.append(index.getName());
buf.append(" ON ");
buf.append(schema.getName());
buf.append(".");
buf.append(table.getName());
buf.append(";\n");
return buf.toString();
}
@Override
public String createSequence(Schema schema, Table table) {
return ""; // no sequence facility in MySql
}
@Override
public String dropSequence(Schema schema, Table table) {
return ""; // no sequence facility in MySql
}
@Override
public String createCheckConstraint(Schema schema, Table table, Check check) {
return ""; // implemented with MySql enum
}
@Override
public String dropCheckConstraint(Schema schema, Table table, Check check) {
return ""; // implemented with MySql enum
}
public String enableUniqueConstraint(Schema schema, Table table, Unique unique, boolean enable) {
StringBuilder buf = new StringBuilder();
buf.append("ALTER TABLE ");
buf.append(schema.getName());
buf.append(".");
buf.append(table.getName());
if (enable)
buf.append(" ADD CONSTRAINT ");
else
buf.append(" DROP CONSTRAINT ");
buf.append(unique.getName());
buf.append(";\n");
return buf.toString();
}
}