org.jaxdb.sqlx.OracleCompiler Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sqlx Show documentation

SQLx is a vendor-agnostic, XML-based SQL data definition standard that offers the power of XML validation for your static SQL data. The SQLx framework utilizes a strongly-typed DDLx file to generate a XML Schema document that translates DDLx constructs into the XSD language. With the SQLx XSLT, the SQLx tool leverages the power of XML Schema Validation and provides a cohesive structured model to define SQL data (that conforms to your SQL schema, defined in a DDLx file).

There is a newer version: 0.6.0

Show newest version

/* Copyright (c) 2017 JAX-DB
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * You should have received a copy of The MIT License (MIT) along with this
 * program. If not, see .
 */

package org.jaxdb.sqlx;

import org.jaxdb.ddlx.dt;
import org.jaxdb.vendor.DBVendor;
import org.libj.util.Hexadecimal;

final class OracleCompiler extends Compiler {
  @Override
  protected DBVendor getVendor() {
    return DBVendor.ORACLE;
  }

  @Override
  protected String compile(final dt.BINARY value) {
    return "HEXTORAW('" + new Hexadecimal(value.get()) + "')";
  }

  @Override
  protected String compile(final dt.BLOB value) {
    return "HEXTORAW('" + new Hexadecimal(value.get()) + "')";
  }

  @Override
  protected String compile(final dt.BOOLEAN value) {
    return value.get() ? "1" : "0";
  }

  @Override
  protected String compile(final dt.CHAR value) {
    final String string = value.get().replace("'", "''");
    return string.length() == 0 || string.charAt(0) == ' ' ? "' " + string + "'" : "'" + string + "'";
  }

  @Override
  protected String compile(final dt.DATE value) {
    return "TO_DATE('" + value + "','YYYY-MM-DD')";
  }

  @Override
  protected String compile(final dt.DATETIME value) {
    return "TO_TIMESTAMP('" + value + "', 'YYYY-MM-DD HH24:MI:SS.FF')";
  }

  @Override
  protected String compile(final dt.TIME value) {
    return "'0 " + value + "'";
  }
}