org.plasma.text.ddl.OracleFactory 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

The Plasma Provisioning Module

There is a newer version: 2.2.1

/**
 * 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 OracleFactory 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 "CLOB";
        } else
          return "VARCHAR2(" + column.getSize() + ")";
      } else
        return "VARCHAR2(255)"; // FIXME - were does the default for this live
                                // ??
    case Boolean:
    case Byte:
      return "NUMBER(1)";
    case Character:
      return "VARCHAR2(1)";
    case Decimal:
      return "NUMBER(22)";
    case Double:
      return "FLOAT(49)";
    case Float:
      return "FLOAT(23)";
    case Short:
      return "NUMBER(6)";
    case Integer:
      return "NUMBER(24)";
    case Int:
    case Long:
      return "NUMBER(10)";
    case Bytes:
    case Object:
    case Date:
    case DateTime:
      return "DATE";
    case Time:
      return "TIMESTAMP";
    case Day:
    case Duration:
    case Month:
    case MonthDay:
    case Year:
    case YearMonth:
    case YearMonthDay:
    default:
      throw new DDLException("unsupported SDO type, " + sdoType.toString());
    }

  }
}